My Oracle Support Banner

Application Of Patch 34407526:R12.BOM.D Creates Invalid Object "INVENTORY_TRANSACTION_ID": invalid identifier (Doc ID 2960073.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Oracle Cost Management - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

Patch 34407526:R12.BOM.D creates object name CST_ACCRUAL_LOAD with status invalid

 When compiling the following errors arise

SQL> alter package CST_ACCRUAL_LOAD compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY CST_ACCRUAL_LOAD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4396/3 PL/SQL: SQL Statement ignored
4409/5 PL/SQL: ORA-00904: "INVENTORY_TRANSACTION_ID": invalid identifier
4617/3 PL/SQL: SQL Statement ignored
4630/5 PL/SQL: ORA-00904: "INVENTORY_TRANSACTION_ID": invalid identifier
5118/11 PL/SQL: SQL Statement ignored
5161/7 PL/SQL: ORA-00904: "GTT"."INVENTORY_TRANSACTION_ID": invalid
identifier

Solution

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
Goal
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.