Unable To Correct The Quantity Accepted Due to Negative Parent Quantity Accept (Doc ID 1970690.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Oracle Quality - Version 12.0.0 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

When profile QA:PO Inspection is set to "Oracle Quality",  Negative quantity can be accepted in Receiving Transactions so it shows an error while trying to do correction.


Steps :


. Receiving > Receiving transactions RCVTXERT
Enter PO number/receipt number> Click on Find button
Enter positive quantity > tick in check box near quantity > click on Inspect button.
It is possible to enter Negative Quantity accepted .

. Find Corrections form RCVTXECO
Search for Purchase Order 
There are some transactions available to be corrected for item 
Transaction Type  Parent Qty
Reject                 0
Accept                -5
Deliver                 0
Accept                 0
Receive               10
 
. When attempting to correct Accept transaction to 5
Transaction Type = Accept
Parent Qty = -5
Parent type Accept
Get Error
 
. Rcv11i output shows There is negative accept transaction in RCV_TRANSACTIONS table with
TRANSACTION_ID 187301495
TRANSACTION_TYPE ACCEPT
QUANTITY -5
DESTINATION_TYPE_CODE RECEIVING
PARENT_TRANSACTION_ID 187301492
QA_COLLECTION_ID 11958679

. As customer wants in fact to have quantity received = 0  and quantity accepted = 0 and quantity delivered = 0, a Return to Supplier for quantity 5 has been done.

. Now RCV11i output shows in purchasing tables that quantities are correctly to 0 but there are 2 records in mtl_supply and rcv_supply table with receiving supply that should be removed:

1: po_headers_all
PO_HEADER_ID 569972
SEGMENT1 9121500187
ORG_ID 86

3: po_line_locations_all
LINE_LOCATION_ID 2091925
PO_HEADER_ID 569972
PO_LINE_ID 780389
QUANTITY 5
QUANTITY_RECEIVED 0
QUANTITY_ACCEPTED -5
QUANTITY_REJECTED 0
SHIP_TO_ORGANIZATION_ID 166
RECEIVING_ROUTING_ID 2

4: po_distributions_all
PO_DISTRIBUTION_ID 2223691
PO_HEADER_ID 569972
PO_LINE_ID 780389
LINE_LOCATION_ID 2091925
QUANTITY_ORDERED 5
QUANTITY_DELIVERED 0

11: rcv_shipment_headers
SHIPMENT_HEADER_ID 112413748
RECEIPT_SOURCE_CODE VENDOR
RECEIPT_NUM 9131500324
SHIP_TO_ORG_ID 166

12: rcv_shipment_lines
SHIPMENT_LINE_ID 152434472
SHIPMENT_HEADER_ID 112413748
QUANTITY_SHIPPED 5
QUANTITY_RECEIVED 0
UNIT_OF_MEASURE Nos
ITEM_ID 4198395
SHIPMENT_LINE_STATUS_CODE  EXPECTED
SOURCE_DOCUMENT_CODE PO
PO_HEADER_ID 569972
PO_LINE_ID 780389
PO_LINE_LOCATION_ID 2091925
TO_ORGANIZATION_ID 166

13: rcv_transactions
TRANSACTION_ID TRANSACTION_TYPE QUANTITY DESTINATION_TYPE_CODE PARENT_TRANSACTION_ID INSPECTION_STATUS_CODE QA_COLLECTION_ID
187301493 DELIVER                           5            EXPENSE                          187301492                      ACCEPTED
187301494 CORRECT                        -5            EXPENSE                          187301493                      ACCEPTED
187301491 RECEIVE                           5            RECEIVING                      -1                                   NOT INSPECTED
187301492 ACCEPT                            5            RECEIVING                       187301491                     ACCEPTED                           11958674
187301495 ACCEPT                           -5            RECEIVING                       187301492                     ACCEPTED                           11958679
187301496 REJECT                           10            RECEIVING                       187301492                     REJECTED                            11958682
187301497 CORRECT                      -10            RECEIVING                       187301496                     REJECTED
187301498 CORRECT                      -10            RECEIVING                       187301492                     ACCEPTED
187302475 RETURN TO VENDOR          5             RECEIVING                      187301491                     NOT INSPECTED
 

14: mtl_supply
SUPPLY_TYPE_CODE SUPPLY_SOURCE_ID  PO_HEADER_ID SHIPMENT_HEADER_ID SHIPMENT_LINE_ID RCV_TRANSACTION_ID ITEM_ID    QUANTITY  UNIT_OF_MEASURE DESTINATION_TYPE_CODE TO_ORGANIZATION_ID
PO                         2223691                  569972                                                                                                       4198395    5             Nos                      EXPENSE                          166
RECEIVING              187301491              569972            112413748                152434472             187301491               4198395    5             Nos                      EXPENSE                          166
RECEIVING              187301495              569972            112413748                152434472             187301495               4198395     -5           Nos                      EXPENSE                          166

PO supply for quantity = 5

In total receiving supply for QUANTITY =0

SUPPLY_TYPE_CODE RECEIVING
SUPPLY_SOURCE_ID 187301495 --- Negative accept transaction
SHIPMENT_LINE_ID 152434472
RCV_TRANSACTION_ID 187301495
ITEM_ID 4198395
QUANTITY -5
UNIT_OF_MEASURE Nos
DESTINATION_TYPE_CODE EXPENSE
TO_ORGANIZATION_ID 166

and
SUPPLY_TYPE_CODE RECEIVING
SUPPLY_SOURCE_ID 187301491 --receive txn (for 5)
SHIPMENT_LINE_ID 152434472
RCV_TRANSACTION_ID 187301491
ITEM_ID 4198395
QUANTITY 10
UNIT_OF_MEASURE Nos
DESTINATION_TYPE_CODE EXPENSE
TO_ORGANIZATION_ID 166

15: rcv_supply
same records

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms