Install Base and Asset Tracking - EBS (MOSC)

MOSC Banner

Can i use the below datafix script to post the material transaction to IB

edited Apr 10, 2014 12:00PM in Install Base and Asset Tracking - EBS (MOSC) 5 commentsAnswered

Hi All,

An item was intially non IB trackable and some material transactions were done against the item/serial. Now it is made IB trackable, so we want to push all the material transactions against this item into IB. Can anyone suggest a script or can we use the below script to post the transactions to IB.

How to Publish Missing Inventory Transactions to the SFM Event Queue (Doc ID 1630893.1)

Script:

DECLARE 

  CURSOR mtl_txn_cur IS

     SELECT transaction_id

       FROM mtl_material_transactions

     WHERE transaction_id in (&transaction_id1,&transacton_id2, ect );

   l_header_id      NUMBER;

   l_mtl_txn_id     NUMBER ;

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