CSTPDPPC Periodic Cost Distributions Processor is failing raising error Error CSTPALPC.dyn_proc_call : Error Calling Package (Doc ID 1170383.1)

Last updated on NOVEMBER 25, 2021

Applies to:

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

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