My Oracle Support Banner

IBY_BPEL_EBSR121PAYMENTAUTH Invalid: Fails With PLS-00302: Component 'Retaildata_rec_type' Must Be Declared (Doc ID 800975.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Payments - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

When applying AP CPC Patch 7665691, it results in following invalid packages:


OWNER OBJECT_TYPE OBJECT_NAME
------------ ---------------- ----------------------------------------
APPS PACKAGE IBY_BPEL_EBSR121PAYMENTAUTH
APPS PACKAGE BODY IBY_BPEL_EBSR121PAYMENTAUTH

2 rows selected.
alter PACKAGE APPS.IBY_BPEL_EBSR121PAYMENTAUTH compile body;
Warning: Package altered with compilation errors.
17:34:36 SQL>
Warning: Package Body altered with compilation errors.
17:34:36 SQL> sho errors
Errors for PACKAGE BODY APPS.IBY_BPEL_EBSR121PAYMENTAUTH:
PL/SQL: Compilation unit analysis terminated
1/14
PLS-00304: cannot compile body of 'IBY_BPEL_EBSR121PAYMENTAUTH' without its specification
1/14
PLS-00905: object APPS.IBY_BPEL_EBSR121PAYMENTAUTH is invalid
17:34:47 SQL> alter PACKAGE APPS.IBY_BPEL_EBSR121PAYMENTAUTH compile ;
Warning: Package altered with compilation errors.
17:34:59 SQL> sho errors
Errors for PACKAGE APPS.IBY_BPEL_EBSR121PAYMENTAUTH:
67/1
PL/SQL: Declaration ignored
67/56
PLS-00302: component 'RETAILDATA_REC_TYPE' must be declared
70/1
PL/SQL: Declaration ignored
71/32
PLS-00302: component 'RETAILDATA_REC_TYPE' must be declared

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
References

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