CSTPDPPC Periodic Cost Distributions Processor is failing raising error Error CSTPALPC.dyn_proc_call : Error Calling Package

(Doc ID 1170383.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Cost Management - Version 12.0.0 to 12.1.2 [Release 12 to 12.1]
Information in this document applies to any platform.
.
***Checked ON Relevance 28-SET-2016***

Symptoms

CSTPDPPC Periodic Cost Distributions Processor is failing raising error:

CSTPALPC.dyn_proc_call : Error Calling Package

Periodic period end process ends with error with no meaningful information's in the log file

However the error can be captured  in the FND log file

<<<
Failed calculating aacrual amount against the Shipment id :
Create_Per_End_Ae_Lines >>>
FND
CSTPALPC.dyn_proc_call : Error Calling Package
Create_Acct_Entry >>>
CSTPDPPC.dyn_proc_call : Error Calling Package
FND
Period end process failed for Periodic Costing. api_close_period >>>

Other errors:

100CLL_F032_APBR_PKG.inv_cost_txn40ORA-01403: no data found (Brazilian localization)

Note: If the error is raised only when having localized pac accounting library set, please transfer the SR to Brazilian Localizations Team, Product id: 1671 > Brazil > Costing

OR


100CSTPAPBR.inv_cost_txn40ORA-01403: no data found (Standard code)

--------------------

FND log file can be obtained by setting the following profile options (system profiles)
FND: Debug Log Enabled -- Yes
FND: Debug Log Level -- Statement
FND: Debug Log Module -- %

Rerun the concurrent reqeust

Run the following query from the backend

SELECT log_sequence, message_text,substr(module,1,100)
FROM fnd_log_messages msg
, fnd_log_transaction_context tcon
WHERE msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID
AND tcon.TRANSACTION_ID= /*Give the request id of request ending in error request*/
ORDER BY LOG_SEQUENCE


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