Invalid Objects PL/SQL: ORA-00904: "PRE_EXPLODED_FLAG": Invalid Identifier (Doc ID 2318110.1)

Last updated on AUGUST 11, 2022

Applies to:

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

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