R12 AP/IBY: Patch Failed At ibyrenda.ldt and ibychlda.ldt Due To PLS-00201: identifier 'IBY_SERVICE_LEVELS_PKG.TRANSLATE_ROW' must be declared (Doc ID 2111509.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


Error at ibychlda.ldt and ibyrenda.ldt while applying patch 19941321:R12.AP.B


ERRORS


*-- adpatch log file:

FAILED: file ibychlda.ldt on worker 2.
FAILED: file ibyrenda.ldt on worker 3.

*-- worker 3 log file:

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @IBY:patch/115/import/ibyfdstp.lct @IBY:patch/115/import/US/ibyrenda.ldt -
Connecting to APPS......Connected successfully.
Calling FNDLOAD function.
Returned from FNDLOAD function.
Log file: /u01/oracle/PFC1U/apps/apps_st/appl/admin/PFC1U/log/US_ibyrenda_ldt.log
Error calling FNDLOAD function.

*-- detailed log file ( ibyrenda.ldt ) :

Uploading from the data file /u01/oracle/PFC1U/apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibyrenda.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/oracle/PFC1U/apps/apps_st/appl/iby/12.0.0/patch/115/import/ibyfdstp.lct(120.12.12010000.5), /u01/oracle/PFC1U/apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibyrenda.ldt) to staging tables
Dumping LCT file /u01/oracle/PFC1U/apps/apps_st/appl/iby/12.0.0/patch/115/import/ibyfdstp.lct(120.12.12010000.5) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/oracle/PFC1U/apps/apps_st/appl/iby/12.0.0/patch/115/import/US/ibyrenda.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (IBY_PAYMENT_REASONS NL_2_2 , IBY_PAYMENT_REASONS NWCH ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error during uploading. ORA-06550: line 264, column 9:
PLS-00201: identifier 'IBY_SERVICE_LEVELS_PKG.TRANSLATE_ROW' must be declared
ORA-06550: line 264, column 9:
PL/SQL: Statement ignored
ORA-06550: line 271, column 9:
PLS-00201: identifier 'IBY_SERVICE_LEVELS_PKG.LOAD_SEED_ROW' must be declared
ORA-06550: line 271, column 9:
PL/SQL: Statement ignored

 

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