R12: PAXCPGAL_SINGLE: PRC: Generate Asset Lines for a Single Project Errors with ORA-01403 in create_alc_asset_line_details (Doc ID 2244735.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PAXCPGAL_SINGLE: PRC: Generate Asset Lines for a Single Project errors with the following in the log file:
+---------------------------------------------------------------------------+
Current system time is 02-MAR-2017 14:40:32
+------------------------------------------------------------------------

MSG-00001: Inside get_asset_category_id, x_doc_header_id = 8377355
x_doc_line_num = 7 x_doc_dist_id = 43971422 x_transaction_source = AP NRTAX
MSG-00001: generate_proj_asset_lines: . Processing Expenditure Item Id= 5796498
CDL num = 1cip_ccid: 1852489
MSG-00001: generate_proj_asset_lines: . x_asset_id returned is: 729087
MSG-00001: get_asset_attributes: .for x_project_asset_id: 729087the
x_depreciation_expense_ccid is: 73266
MSG-00001: create_proj_asset_line_details: . x_expenditure_item_id:
5796498x_line_num: 1
MSG-00001: create_alc_asset_line_details: Create ALC Project Asset Line details
MSG-00001: summarize_proj: Exception Generated By Oracle Error:ORA-01403: no
data found
ORA-01403: no data found
MSG-00001: summarize_proj: Skipping This project......
REP-1419: 'afterreport': PL/SQL program aborted.

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