Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036186
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 05. Production managementmajoralways2017-06-06 17:262017-06-30 14:40
Reportercollazoandy4View Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036186: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of design defect 0028875 acknowledgedTriage Platform Base Class "CallStoredProcedure" does not support parameters of type out 
related to defect 00212773.0MP15 closedmarvintm CallStoredProcedure do not support procedures that do not return a value 

-  Notes
(0097300)
collazoandy4 (reporter)
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 (manager)
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'

- Issue History
Date Modified Username Field Change
2017-06-06 17:26 collazoandy4 New Issue
2017-06-06 17:26 collazoandy4 Assigned To => Triage Finance
2017-06-06 17:26 collazoandy4 Modules => Core
2017-06-06 17:26 collazoandy4 Triggers an Emergency Pack => No
2017-06-06 17:36 aferraz Assigned To Triage Finance => collazoandy4
2017-06-09 21:15 collazoandy4 Status new => scheduled
2017-06-09 23:50 collazoandy4 Note Added: 0097300
2017-06-09 23:51 collazoandy4 Steps to Reproduce Updated View Revisions
2017-06-13 18:34 aferraz Relationship added related to 0021277
2017-06-16 14:29 aferraz Status scheduled => feedback
2017-06-16 14:29 aferraz Status feedback => new
2017-06-16 14:33 aferraz Note Added: 0097446
2017-06-16 14:34 aferraz Assigned To collazoandy4 => platform
2017-06-30 14:39 caristu Type defect => design defect
2017-06-30 14:39 caristu Summary MA_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:40 caristu Review Assigned To => caristu
2017-06-30 14:40 caristu Relationship added duplicate of 0028875
2017-06-30 14:40 caristu Status new => closed
2017-06-30 14:40 caristu Resolution open => duplicate

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker