1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to move quantities from sub inventory to its rework operations?

Discussion in 'Oracle SCM & Manufacturing' started by Salik, May 12, 2016.

  1. Salik

    Salik Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Karachi
    Hello,
    We are working with Oracle EBS with 12g database. What we want to do is to move job quantities from sub inventory they are being produced to one of its rework operations. Can someone please guide me how can this be achieved through query and not oracle forms?

    Regards
     
  2. Rabih

    Rabih Premium Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Riyadh, Saudi Arabia
    Each module in Oracle EBS has interface tables. Manufacturing has many. These are some tables that you may want to work with to create the rework operation:

    ORACLE MANUFACTURING - MASTER SCHEDULING/MRP
    MRP_FORECAST_INTERFACE
    MRP_SCHEDULE_INTERFACE

    ORACLE MANUFACTURING - WORK IN PROCESS
    WIP_MOVE_TXN_INTERFACE
    CST_COMP_SNAP_INTERFACE
    WIP_COST_TXN_INTERFACE
    WIP_JOB_SCHEDULE_INTERFACE
    WIP_JOB_DTLS_INTERFACE

    ORACLE MANUFACTURING - SHOP FLOOR MANAGEMENT
    WSM_LOT_JOB_INTERFACE
    WSM_STARTING_LOTS_INTERFACE
    WSM_LOT_MOVE_TXN_INTERFACE

    All other WIP related tables can be found here:

    http://www.oracleappsquery.com/?q=oracle-apps-R12-WIP-Work-in-Process-tables-views
     
  3. Rabih

    Rabih Premium Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Riyadh, Saudi Arabia
    So I'm guessing you will need to use the WIP_MOVE_TXN_INTERFACE to move WIP from one location to another. For a move transaction, insert into the wip_move_txn_interface table and then do a FND_REQUEST.SUBMIT_REQUEST. If you need to actually create a rework operation for that inventory item, you can populate master schedules using the Open Master Schedule Interface. You must first define your items, organizations, and master schedule names. Then, load your data into the table MRP_ SCHEDULE_INTERFACE. Required data includes

    • INVENTORY_ITEM_ID
    • SCHEDULE_DESIGNATOR
    • ORGANIZATION_ID
    • SCHEDULE_DATE
    • SCHEDULE_QUANTITY
    • PROCESS_STATUS
    Set the PROCESS_STATUS to 2 to designate data waiting to be processed. This process is also controlled by the Planning Manager; it periodically checks the MRP_SCHEDULE_INTERFACE table and launches the Master Schedule Interface Load Program to process new data it detects. The load program validates the data in the interface table and loads valid data into the specified master schedule. Errors are handled just like the Open Forecast Interface; the load program sets the PROCESS_ STATUS to 4 and enters a text message in the ERROR_MESSAGE column in the interface table. View and correct invalid data with SQL*Plus or a custom program.

    Hope that helps.
    Rabih