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 AUGUST 20, 2021

Applies to:

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 = <doc_header_id>
x_doc_line_num = 7 x_doc_dist_id = <doc_dist_id> x_transaction_source = AP NRTAX
MSG-00001: generate_proj_asset_lines: . Processing Expenditure Item Id= <exp_item_id>
CDL num = 1cip_ccid: <ccid>
MSG-00001: generate_proj_asset_lines: . x_asset_id returned is:
MSG-00001: get_asset_attributes: .for x_project_asset_id: <proj_asset_id> 7the
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

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