Sales order tax invoice sequence picked for normal receipts (Doc ID 2851504.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Problem Statement
----------------------
Observed that if the trx id is same for PO receipts and sales order (ISO) transactions it is causing tax invoice number to be populated on PO receipts deriving from sales order document sequence defined.
Ideally, sales order sequence cannot be populated for normal inventory receipts.
This is equally observed if the trx_id of the RCM invoice matches with the sales order trx_id.

Steps for replication
-----------------------
Issue cannot be replicated at will as one cannot control the generation of trx id.
Explaining with below example.

1) Create a PO receipt. And apply GST taxes.
2) Create Sales Order. Apply GST taxes. Save.
3) Launch Pick Release and perform ship confirm.
4) If the PO receipt trx_id is same as the trx_id of the sales order shipment, then this is observed.
5) Concurrent "India - Check Delivery OM/INV Interface" triggered and completed successfully.
6) Query PO receipt created in step 1 and the shipment/delivery created in step 3.
7) Found tax_invoice_num and tax_invoice_date values are updated in both trx.
    This can be identified via below query  
     select det_factor_id, trx_id, trx_number, entity_code, tax_invoice_num, tax_invoice_date
       from jai_tax_det_factors
     where application_id = 707
         and det_factor_id in (:PO_receipt_det_factor_id)
           or det_factor_id in (:Sales_order) ;

8) Open the receipt and navigate to tools - India tax details menu where we find that the
    Supplier Invoice number and Supplier Invoice fields are populated.
    These details are picked from the document sequence setup defined for order as Sales order.

Expected Behavior 
---------------------
Though the trx_id being same, it should not populate the supplier tax invoice number and date fields as the transaction and document sequence setups are different.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.