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!

Tables getting affected in P2P Cycle

Discussion in 'Oracle Apps Technical' started by wasim.patel123, Mar 12, 2010.

  1. wasim.patel123

    wasim.patel123 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello All,

    I m new top oracle apps . I want to know wat r the tables that get affected (insertion /updation) in p to p cycle
    from my knowledge the tables are as follows.

    [TABLE]During| Table Name
    Purchase Requisition |po_requisition_headers_all
    |po_requisitions_lines_all
    |po_req_distributions_all

    RFQ |po_requisition_headers_all
    |po_requisitions_lines_all
    |po_req_distributions_all

    Purchase Order |po_headers_all
    |po_lines_all

    Recieving |rcv_shipment_headers
    |rcv_shipment_lines
    |rcv_transactions

    Inventory |mtl_material_transactions
    |mtl_on_hand_quantity[/TABLE]​

    :confused:

    What are the more tables that gets affected ??? and if i m wrong in above pls correct me!!!!!!!!
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Well to begin with, this is not the right approach. What you should do is track tables by transactions. So you should first identify which are the transactions that happen during a P2P cycle, for example, creation of requisition, PO, receiving in inventory etc. Then you should try to track the tables that get affected at each of this stages. You have several stages missing. Besides you haven't considered payment side at all.
     
  3. wasim.patel123

    wasim.patel123 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Yes Bhai u are right actually i had understood the transaction but i dont know the tables from Inv, AP and GL which gets affected in p2p cycle
    I want to know that ..
    Thanks for ur prompt replyy