Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036186Openbravo ERP05. Production managementpublic2017-06-06 17:262017-06-30 14:40
Reportercollazoandy4 
Assigned Toplatform 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036186: MA_PRODUCTION_COST procedure can not be call from OB in oracle instance using CallStoredProcedure
DescriptionThe problem is CostingAlgorithm class when call the storage procedure MA_PRODUCTION_COST an exception is raise
Steps To Reproduce Go to Product window and create a new record:
   Search Key/Name: Consume
   Check Production field
   Create a new record in Costing tab:
     Cost Type: Standard
     Cost: 10
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
    Create a new record in Costing tab:
     Cost Type: Average
     Cost: 20
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
    Create a new record in Costing tab:
     Cost Type: Average
     Cost: 30
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
  In Product window create a new record:
    Search Key/Name: Produced
    Check Production field
    Create a new record in Manufacturing tab:
      Storage Bin: Rn-0-0-0
  Go to Physical Inventory and create a new record:
    Movement Date: Today
    Create a new record in Lines tab:
      Product: Consume
      Quantity count: 500
    Process inventory count
  Go to Manufacturing Cost Center and create a new record:
    Search Key/Name: Issue Cost Center
    Create a new record in Version tab:
      Valid From Date: First month date
  Go to Activity window and create a new record:
    Search Key/Name: Issue Activity
    Cost Center: Issue Cost Center
  Go to Process Plan window and create a new record:
    Search Key/Name: Issue Plan
    Create a new record in Version Tab:
      Starting Date: 01-05-2017
      Ending Date: 01-05-2099
      Create a new record in Operation tab:
        Search Key/Name: Issue Operation
        Activity: Issue Activity
        Create a new record in I/O Products tab:
          Product: Consume
          Production Type: Product use (P-)
          Quantity: 5
        Create a new record in I/O Products tab:
          Product: Produced
          Production Type: Product Production (P+)
          Quantity: 1
  Go to Work Requirement window and create a new record:
      Process Plan: Issue Plan
      Starting Date: 01-05-2017
    Ending Date: 01-05-2099
    Quantity: 50
    Process the requirement
    Clic on Create a Work Effort button
      Date: Today
  Go to Production Run window and edit the previous production created:
    Completed Quantity: 1
    Clic on Create Standard button
  Go to Work Effort window and validate the previous one created
  Launch the Costing Background Process and check an error is shown and no cost is calculated
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of design defect 0028875 acknowledged Triage Platform Base Class "CallStoredProcedure" does not support parameters of type out 
related to defect 00212773.0MP15 closed marvintm CallStoredProcedure do not support procedures that do not return a value 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-06-06 17:26collazoandy4New Issue
2017-06-06 17:26collazoandy4Assigned To => Triage Finance
2017-06-06 17:26collazoandy4Modules => Core
2017-06-06 17:26collazoandy4Triggers an Emergency Pack => No
2017-06-06 17:36aferrazAssigned ToTriage Finance => collazoandy4
2017-06-09 21:15collazoandy4Statusnew => scheduled
2017-06-09 23:50collazoandy4Note Added: 0097300
2017-06-09 23:51collazoandy4Steps to Reproduce Updatedbug_revision_view_page.php?rev_id=15320#r15320
2017-06-13 18:34aferrazRelationship addedrelated to 0021277
2017-06-16 14:29aferrazStatusscheduled => feedback
2017-06-16 14:29aferrazStatusfeedback => new
2017-06-16 14:33aferrazNote Added: 0097446
2017-06-16 14:34aferrazAssigned Tocollazoandy4 => platform
2017-06-30 14:39caristuTypedefect => design defect
2017-06-30 14:39caristuSummaryMA_PRODUCTION_COST procedure can not be call from OB in oracle instance => MA_PRODUCTION_COST procedure can not be call from OB in oracle instance using CallStoredProcedure
2017-06-30 14:40caristuReview Assigned To => caristu
2017-06-30 14:40caristuRelationship addedduplicate of 0028875
2017-06-30 14:40caristuStatusnew => closed
2017-06-30 14:40caristuResolutionopen => duplicate

Notes
(0097300)
collazoandy4   
2017-06-09 23:50   
Test Plan
 Go to Product window and create a new record:
   Search Key/Name: Consume
   Check Production field
   Create a new record in Costing tab:
     Cost Type: Standard
     Cost: 10
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
    Create a new record in Costing tab:
     Cost Type: Average
     Cost: 20
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
    Create a new record in Costing tab:
     Cost Type: Average
     Cost: 30
     Manual: Y
     Starting Date: 01-05-2017
     Ending Date: 01-05-2099
  In Product window create a new record:
    Search Key/Name: Produced
    Check Production field
    Create a new record in Manufacturing tab:
      Storage Bin: Rn-0-0-0
  Go to Physical Inventory and create a new record:
    Movement Date: Today
    Create a new record in Lines tab:
      Product: Consume
      Quantity count: 500
    Process inventory count
  Go to Manufacturing Cost Center and create a new record:
    Search Key/Name: Issue Cost Center
    Create a new record in Version tab:
      Valid From Date: First month date
  Go to Activity window and create a new record:
    Search Key/Name: Issue Activity
    Cost Center: Issue Cost Center
  Go to Process Plan window and create a new record:
    Search Key/Name: Issue Plan
    Create a new record in Version Tab:
      Starting Date: 01-05-2017
      Ending Date: 01-05-2099
      Create a new record in Operation tab:
        Search Key/Name: Issue Operation
        Activity: Issue Activity
        Create a new record in I/O Products tab:
          Product: Consume
          Production Type: Product use (P-)
          Quantity: 5
        Create a new record in I/O Products tab:
          Product: Produced
          Production Type: Product Production (P+)
          Quantity: 1
  Go to Work Requirement window and create a new record:
      Process Plan: Issue Plan
      Starting Date: 01-05-2017
    Ending Date: 01-05-2099
    Quantity: 50
    Process the requirement
    Clic on Create a Work Effort button
      Date: Today
  Go to Production Run window and edit the previous production created:
    Completed Quantity: 1
    Clic on Create Standard button
  Go to Work Effort window and validate the previous one created
  Launch the Costing Background Process and check that a cost is calculated
(0097446)
aferraz   
2017-06-16 14:33   
MA_PRODUCTION_COST is a procedure with two IN parameters and another OUT parameter.

When calling it using CallStoredProcedure in PG we need to add two parameters. If we add a third one following error is raised: ERROR: function ma_production_cost(character varying, character varying, character varying) does not exist

When calling it using CallStoredProcedure in Oracle we need to add three parameters. If we add only two parameters following error is raised: ORA-06553: PLS-306: wrong number or types of arguments in call to 'MA_PRODUCTION_COST'