Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Re-Process the mtl_material_transactions_temp and MTL_TRANSACTIONS_INTERFACE

edited Jul 18, 2017 8:29AM in Discrete Manufacturing - EBS (MOSC) 3 commentsAnswered

I am trying to Re-Process the mtl_material_transactions_temp and MTL_TRANSACTIONS_INTERFACE error data's using PLSQL

Following activities are performed

1. Update the mtl_material_transactions_temp

UPDATE apps.mtl_material_transactions_temp

         SET process_flag      = 'Y',

             lock_flag         = NULL ,

             Transaction_mode  = 3 ,

             Error_code        = NULL ,

             Error_explanation = NULL

2. Update the MTL_TRANSACTIONS_INTERFACE

UPDATE apps.mtl_transactions_interface

          SET process_flag      = 1,

              lock_flag         = NULL ,

              Transaction_mode  = 3 ,

              Error_code        = NULL ,

              Error_explanation = NULL

3. Create the concurrent request to execute the process "Process transaction interface"

APPS.FND_REQUEST.SUBMIT_REQUEST('INV',

                                                           'INCTCM',

                                                            null,

                                                            null,

                                                            FALSE);

Still I having the same error data's in mtl_material_transactions_temp and MTL_TRANSACTIONS_INTERFACE tables. Can you please anybody explain to me how to re-process the interfaces errors in Inventory module.

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