IBY_TRXN_EXTENSIONS_V Invalid with ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X' (Doc ID 1322631.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

On R12.0.6, multiple patches have been applied to upgrade the database to 11g.

While attempting to open the Order Organizer or a Sales Order, the following error is seen:

ORA-4063: Package body APPS.OE_PAYMENT_TRXN_UTIL has errors

Further investigations show that OE_PAYMENT_TRXN_UTIL is invalid because IBY_TRXN_EXTENSIONS_V is invalid.

Errors for PACKAGE BODY OE_PAYMENT_TRXN_UTIL:
PL/SQL: ORA-04063: view "APPS.IBY_TRXN_EXTENSIONS_V" has errors
PL/SQL: SQL Statement ignored

The view IBY_TRXN_EXTENSIONS_V is invalid with the following compilation error:

ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'

Further research shows that IBY_TRXN_EXTENSIONS_V is invalid due to invalid IBY_FNDCPT_TRXN_PUB. Compilation errors for IBY_FNDCPT_TRXN_PUB are the same as those from bug 12335720, i.e.

Errors for PACKAGE BODY IBY_FNDCPT_TRXN_PUB

PLS-00905: object APPS.IBY_TRXN_EXTENSIONS_V is invalid
PL/SQL: Item ignored
PLS-00905: object APPS.IBY_TRXN_EXTENSIONS_V is invalid
PL/SQL: Item ignored
PLS-00201: identifier 'L_DBG_MOD' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'C_INSTR_ASSIGNS' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'C_INSTR_EXTENSIONS' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'L_INSTR_REQ' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'L_INSTR_REQ' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'L_INSTR_REQ' must be declared
PL/SQL: Statement ignored
PLS-00201: identifier 'C_INSTR_ASSIGNS' must be declared
PL/SQL: SQL Statement ignored
PLS-00201: identifier 'C_INSTR_ASSIGNS' must be declared
PL/SQL: SQL Statement ignored

Customer has the following file versions:
OEXUPTXB.pls version 120.27.12000000.3 (OE_PAYMENT_TRXN_UTIL)
ibyextv.odf 120.0.12000000.11 (IBY_TRXN_EXTENSIONS_V)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigate to Order Management Responsibility --> Sales Order or Order Organizer

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