R12 PAXCPGAL PRC: Generate Asset Lines Errors with ORA-01422 (Doc ID 1281503.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Project Costing - Version 12.0.4 and later
Information in this document applies to any platform.
Report:PAXCPGAL.RDF - PRC: Generate Asset Lines for a Range of Projects
ConcurrentProgram:PAXCPGAL_SINGLE - PRC: Generate Asset Lines for a Single Project


Symptoms

The process PRC: Generate Asset Lines fails with the error below:

MSG-00001: Inside get_asset_category_id, x_doc_header_id = 14134 x_doc_line_num = 1 x_doc_dist_id = 68392 x_transaction_source = AP ERV
MSG-00001: summarize_proj: Exception Generated By Oracle Error:ORA-01422: exact fetch returns more than requested number of rows
MSG-00001: summarize_proj: Skipping This project......

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