Periodic Cost Distributions Processor Error On Repetitive Schedule WIP Completion Txn (Doc ID 2001525.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Inventory Costing

When attempting to run Periodic Cost Distributions Processor, errors occur for Repetitive Schedule WIP Complete transaction(PAC)


ERROR
-----------------------
CSTPAPBR.insert_account: 80: return >>
-1422CSTPAPBR.offset_accounts58ORA-01422: exact fetch returns more than requested number of rows
CSTPALPC.dyn_proc_call : Error Calling Package
-1422CSTPAPBR.offset_accounts58ORA-01422: exact fetch returns more than requested number of rows: CSTPALPC.create_dist_entry : 40
Create_Acct_Entry >>>
CSTPDPPC.dyn_proc_call : Error Calling Package
-1422CSTPAPBR.offset_accounts58ORA-01422: exact fetch returns more than requested number of rows: CSTPALPC.create_dist_entry : 40

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create new repetitive Schedule
2. WIP Issue the material
3. Completion Transaction & Enable "Final Completion"
4. Run PAC " Launch Periodic Acquisition Cost Processor" is OK
5. Run PAC" Launch Periodic Cost Processor" is OK
6. Run PAC " Launch Periodic Distribution Processor" is error. 
 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms