Exception occured in Acquisition_cost_adj_processor : -1427 CSTPPACQ.acq_cost_processor(81):ORA-01427: Single-row subquery returns more than one row

(Doc ID 2064189.1)

Last updated on AUGUST 19, 2017

Applies to:

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


On : 12.1.3 version, Costing Transaction Errors

When attempting to run the Periodic Acquisition Cost Adjustment Processor,
the following error occurs.


The issue can be reproduced at will with the following steps:
1. Cost Management - SLA > Submit the Periodic Acquisition Cost Adjustment Processor
2. The request ends in error
3. Review the log file > Observe the issue


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