Invalid Objects PL/SQL: ORA-00904: "PRE_EXPLODED_FLAG": Invalid Identifier

(Doc ID 2318110.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Entry

When attempting to enter sales order,
the following error occurs.

ERROR
-----------------------
ORA-06508 PL/SQL Could Not Find Program Unit Being Called in package oe_Order_PVT Procedure Lines and
ORA-06508 PL/SQL Could Not Find Program Unit Being Called in package oe_oe_form_header

Found following invalids objects, and re-compile do not resolve the error:

OE_CONFIG_UTIL OEXUCFGB.pls 120.33.12010000.7 BODY INVALID

Errors for PACKAGE BODY OE_CONFIG_UTIL

PL/SQL: ORA-00904: "PRE_EXPLODED_FLAG": invalid identifier
PL/SQL: SQL Statement ignored

OE_CREDIT_CHECK_UTIL OEXUCRCB.pls 120.17.12010000.12 BODY INVALID

Errors for PACKAGE BODY OE_CREDIT_CHECK_UTIL

PL/SQL: ORA-00904: "CREDIT_PROFILE_LEVEL": invalid identifier
PL/SQL: SQL Statement ignored

OE_LINE_UTIL OEXULINB.pls 120.67.12010000.77 BODY INVALID

Errors for PACKAGE BODY OE_LINE_UTIL

PL/SQL: ORA-00904: "PRE_EXPLODED_FLAG": identificador no valido
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "PRE_EXPLODED_FLAG": identificador no valido
PL/SQL: SQL Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. OM Super User responsibility
2. Navigate to Sales Order form
3. Enter order

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