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!

Wrong Inventory Receiving

Discussion in 'Oracle SCM & Manufacturing' started by AHS30, Jun 21, 2010.

  1. AHS30

    AHS30 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,
    We are working in oracle applications 11i. Oracle Inventory module user has complained that she has received a PO that have 5 lines twice and entered. I am not sure what went wrong. But I have found in the rcv_transactions table 14 records of that PO with transaction types: 3 DELIVER, 7 RECEIVE and 4 TRANSFER.

    From the applications Transactions-> Receiving->Receiving Transactions: for that PO I have found 4 records 2 of them (quantities 15 and 7) with destination type Expense with the parent type transfer and the same 2 lines (again 15&17) with Transation Type Multiple within line 15 i have 3 lines each with a quantity 5, all 3 of them with destination type Expense and parent type Transfer. and within the second line with quantity 7 I have 2 line with quantities 4 and three and destination type expenses.

    Please, I need someone to guide me to the problem as I cannot figure out what's wrong.
     
  2. AHS30

    AHS30 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I'll try to elaborate more.

    The PO 1295 has 5 lines:
    line 1 quantity is 15
    line 2 quantity is 7
    line 3 quantity is 2
    line 4 quantity is 1
    line 5 quantity is 1

    This PO has 2 receipts 1311 and 1316

    receipt 1311 transactions are :
    receive and transfer for line 1 -15
    receive and transfer for line 2 -7
    receive and deliver for line 3
    receive and deliver for line 4
    receive and deliver for line 5

    receipt no 1316 transactions are :
    receive and transfer for line 1again 15
    receive and transfer for line 2 again 7

    now, our problem is with the first two lines:
    I don't know how the user made a receive and transfer transaction and I want to reverse it (may be twice) and do a receive deliver transaction

    What shall I do?
     
  3. Rayoons

    Rayoons Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Dear Ahs30,

    I faced same problem before but in RMA not in PO and i solved this problem from inventory resp...

    ** Did you try to return this line to Supplier ?