Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Sev1: Invalid objects after application of patch 16715991

edited Dec 11, 2013 7:16AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 10 commentsAnswered ✓

Hi,
Apps 12.1.3

Two invalid objects not compiling after patch 16715991:R12.POS.B
POS_BATCH_IMPORT_PKG
POS_BULKLOAD_ENTITIES

SQL> alter package apps.POS_BULKLOAD_ENTITIES compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.POS_BULKLOAD_ENTITIES:

LINE/COL ERROR
-------- -----------------------------------------------------------------
663/17   PL/SQL: SQL Statement ignored
677/19   PL/SQL: ORA-00904: "BATCH_ID": invalid identifier
700/17   PL/SQL: SQL Statement ignored
715/19   PL/SQL: ORA-00904: "BATCH_ID": invalid identifier
735/17   PL/SQL: SQL Statement ignored
751/11   PL/SQL: ORA-00904: "BATCH_ID": invalid identifier
SQL> alter package apps.POS_BATCH_IMPORT_PKG compile body;

Warning: Package Body altered with compilation errors.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center