Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

ERROR CODE : Transaction processor error WHEN INTERFACE TRANSACTIONS

edited Apr 19, 2019 2:48AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered

code inseret data 
Insert into mtl_transactions_interface

                                    (

                                        TRANSACTION_HEADER_ID,

                                        LAST_UPDATE_DATE,

                                        LAST_UPDATED_BY,

                                        CREATION_DATE,

                                        CREATED_BY,

                                        INVENTORY_ITEM_ID,

                                        ORGANIZATION_ID,

                                        SUBINVENTORY_CODE,

                                        LOCATOR_ID,

                                        TRANSACTION_TYPE_ID,

                                        TRANSACTION_ACTION_ID,

                                        TRANSACTION_SOURCE_TYPE_ID,

                                        TRANSACTION_SOURCE_ID,

                                        TRANSACTION_QUANTITY,

                                        TRANSACTION_UOM,

                                        PRIMARY_QUANTITY,

                                        TRANSACTION_DATE,

                                        TRX_SOURCE_LINE_ID,

                                        TRANSFER_ORGANIZATION,

                                        TRANSFER_SUBINVENTORY,

                                        SOURCE_CODE,

                                        SOURCE_HEADER_ID,

                                        SOURCE_LINE_ID,

                                        COST_GROUP_ID,

                                        TRANSFER_COST_GROUP_ID,

                                        PROCESS_FLAG,

                                        TRANSACTION_MODE,

                                        LOCK_FLAG

                                    )

                                    (

                                        select

                                                TRANSACT_HEADER_ID,

                                                        SYSDATE,

                                                        a.CREATED_BY,

                                                        SYSDATE,

                                                        a.CREATED_BY,

                                                        b.INVENTORY_ITEM_ID,

                                                        b.ORGANIZATION_ID,

                                                        B.FROM_SUBINVENTORY_CODE,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center