My Oracle Support Banner

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 JANUARY 16, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.