The “India – Accrual Reconciliation Load Run” Program Is Loading Third-Party Tax Amounts Into the CST_AP_PO_RECONCILIATION Table for the Purchase Order(PO) Receipts Leading to Reconciliation Issues. (Doc ID 3004429.1)

Last updated on FEBRUARY 20, 2024

Applies to:

Symptoms

The "India - Accrual Reconciliation Load Run" program is populating third-party tax amounts in the CST_AP_PO_RECONCILIATION table for the PO receipts.
The program should not populate the third-party tax amount in the CST_AP_PO_RECONCILIATION table as it will lead to accrual reconciliation issues between Receipt and Invoice.

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Purchasing responsibility.
2. Purchase Orders-> Purchase Orders.
3. Enter a new PO, and click on Tools-> India Tax Details, apply normal and third-party taxes on it.
4. Approve the PO.
5. Go to Receiving-> Receipts.
6. Enter a new receipt against the purchase order.
7. Click on Tools-> India Tax Details, and confirm taxes.
8. Save the receipt. The system generates Third-party invoices for the third-party taxes applied on receipt.
9. Submit the Create Accounting- Receiving program to generate accounting entries for the Receive event.
10. Navigate to the India Local Payables responsibility.
11. Invoices-> Entry-> Invoices.
12. Enter a new invoice and match it with the receipt.
13. Validate the invoice and run create Accounting for it.
14. Submit the "India - Accrual Reconciliation Load Run" program and check data in the CST_AP_PO_RECONCILIATION table.
15. The Third party tax amount is populated for the PO receipt. However, for the standard invoice the third party tax amount is not populate because a separate invoice is already generated for the third party tax amount.

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.