R12 AP: APINVAPR.ldt Fails in Patch 24690690 With APINVAPR, DOCUMENT_APPROVAL_MSG, #HDR_TOTAL_FORMATTED, ORA-01403: no data found (Doc ID 2334778.1)

Last updated on DECEMBER 04, 2019

Applies to:

Symptoms

APINVAPR.ldt Errors While Applying 12.2.7 RUP Patch 24690690

** ADPATCH LOG FILE

ATTENTION: All workers either have failed or are waiting:

FAILED: file APINVAPR.ldt on worker 2.

** WORKER LOG FILE

Loading data using FNDLOAD function.
**** Reseting package states in the current session ****

FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/wfwlsvcs.lct @SQLAP:patch/115/import/US/APINVAPR.ldt -

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /xx/xx/xx/log/adop/xxx/xxxx/apply/xxx/xxxxx/log/US_APINVAPR_ldt.log
Error calling FNDLOAD function.

** LOG FILE

Uploading from the data file /XXXX/XXX/XXX/appl/ap/12.0.0/patch/115/import/US/APINVAPR.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/XXXX/XXX1/XXXX/appl/fnd/12.0.0/patch/115/import/wfwlsvcs.lct(120.0.12020000.32), /XXXX/XXX/XXXX/appl/ap/12.0.0/patch/115/import/US/APINVAPR.ldt) to staging tables
Dumping LCT file /XXXX/XXX1/XXXX/appl/fnd/12.0.0/patch/115/import/wfwlsvcs.lct(120.0.12020000.32) into FND_SEED_STAGE_CONFIG
Dumping LDT file /XXXX/XXX1/XXXX/appl/ap/12.0.0/patch/115/import/US/APINVAPR.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (ITEM_TYPE APINVAPR , WF_WL_VIEW_ATTRIBUTES ToEmail ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for WF_MESSAGE_ATTRIBUTES: NAME = APINVAPR, MESSAGE_NAME = DOCUMENT_APPROVAL_MSG, ATTRIBUTE_NAME = #HDR_TOTAL_FORMATTED, ORA-01403: no data found

Cause

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