What Are the Differences in Table Structures and Corresponding Synonym Structures for MTL_TRANSACTION_TYPES and MTL_TXN_SOURCE_TYPES?
(Doc ID 2935929.1)
Last updated on APRIL 20, 2023
Applies to:Oracle Inventory Management - Version 12.2.11 and later
Information in this document applies to any platform.
There are differences in table Structures and the corresponding Synonym Structures for MTL_TRANSACTION_TYPES and MTL_TXN_SOURCE_TYPES.
Per EBS Standards, the Synonym apps.MTL_TRANSACTION_TYPES should be based the table inv.MTL_TRANSACTION_TYPES but after Upgrade to R12.2.11, it is observed that
the Synonym APPS.MTL_TRANSACTION_TYPES is based on View INV.MTL_TRANSACTION_TYPES_V and not on the table inv.MTL_TRANSACTION_TYPES, because of this there is a difference in the number of column for table INV.MTL_TRANSACTION_TYPES Vs synonym APPS.MTL_TRANSACTION_TYPES. Similar case for MTL_TXN_SOURCE_TYPES.
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