My Oracle Support Banner

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

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