My Oracle Support Banner

CSTPDPPC - Periodic Cost Distributions Processor: error CSTPAPBR.create_acct_lines : 60:ORA-01422 (Doc ID 2657809.1)

Last updated on APRIL 12, 2020

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, the following error occurs.

ERROR
-----------------------
Transaction: 58129389
Transaction Type:
Calling Package CSTPAPBR.create_acct_lines ...
CSTPAPBR.Create_acct_lines <<
i_transaction_id: 58129389
Event type: 18-27-1
Operating Unit: 99
CSTPAPBR.create_acct_lines : 60:ORA-01422: exact fetch returns more than requested number of rows
CSTPALPC.dyn_proc_call : Error Calling Package
CSTPAPBR.create_acct_lines : 60:ORA-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
CSTPAPBR.create_acct_lines : 60:ORA-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. Run Periodic Cost Distributions Processor
2. Review log file

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.