Periodic Acquisition Cost Adjustment Processor Failed Due to CSTPPACQ.compute_acq_cost_adj(65):ORA-01403: No Data Found (Doc ID 2181106.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Cost Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Periodic Acquisition Cost Adjustment Processor(CSTPACAP) failed and the following error message is shown on a concurrent log file.

ERROR
Exception occured in Acquisition_cost_adj_processor : 1 CSTPPACQ.compute_acq_cost_adj(65):ORA-01403: no data found : There was an error in calculating the Acquisition Cost.

STEPS
The issue can be reproduced at will with the following steps:
1. Run Periodic Acquisition Cost Adjustment Processor.

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