Invalid M4R_7B1_WSM_IN Column Transaction_id Missing From WSM_STARTING_LOTS_INTERFACE
(Doc ID 789653.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Shop Floor Management - Version 11.5.10.0 and laterOracle Supply Chain Trading Connector - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Symptoms
On Release 12:
When attempting to compile invalids after 12.0.4 upgrade the following error occurs:
ERROR:
Errors for PACKAGE BODY M4R_7B1_WSM_IN:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1742/22 PL/SQL: SQL Statement ignored
1744/57 PL/SQL: ORA-00904: "TRANSACTION_ID": invalid identifier
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. try to recompile PACKAGE BODY M4R_7B1_WSM_IN
Changes
Fresh install on Release 12. (possible in 11.5.10 too)
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |