API to Populate India GST Tax Lines over Receiving Transactions in EBS R12

 /*API to Populate India GST Tax Lines over Receiving Transactions*/

DECLARE
    l_rcv_trx         rcv_transactions%ROWTYPE;
    l_process_status  VARCHAR2(1000);
    l_process_message VARCHAR2(4000);
BEGIN
    

-- Fetch the transaction record
    SELECT *
    INTO   l_rcv_trx
    FROM   rcv_transactions
    WHERE  transaction_id = 32159578; --Transaction_Id;
    

-- Call the tax generation procedure
    jai_rcv_tax_det_pkg.Generate_rcv_tax(pr_rcv_trx => l_rcv_trx,
    pv_process_status => l_process_status,
    pv_process_message => l_process_message);

    

-- Output the result
    dbms_output.Put_line('Status  : '
                         || l_process_status);

    dbms_output.Put_line('Message : '
                         || l_process_message);
EXCEPTION
    WHEN OTHERS THEN
      dbms_output.Put_line('Error: '
                           || SQLERRM);
END; 

After generating Tax-Lines over India Localization Form, make sure the accounting should be done. For Accounting, we can use API "jai_rcv_tax_det_pkg.process_batch" or run the concurrent request "India - Receiving Transaction Processing".

After this activity, lines should be populated over "GL_INTERFACE" table :

SELECT *
FROM   gl_interface
WHERE  user_je_source_name = 'Financials India'
       AND reference23 = '47206567' --DET_FACTOR_ID
ORDER  BY date_created DESC;