My Oracle Support Banner

Distribution Account Not Getting Automatically Populated for TDS Credit Memo (Doc ID 1474569.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On : 12.1.3 version, Tax Deducted at Source-Payables

During threshold transition the credit memo for the first invoice is created with no amount and distribution account.
Also the AP_INVOICE_INTERFACE , AP_INVOICE_LINE_INTERFACE and AP_INVOICE_REJECTIONS tables the vendor_id, vendor_site_id and dist_code_combination_id
fields are null.

Amount and distribution account should get populated automatically for the first CM invoice that is automatically created by the sytem

The issue can be reproduced at will with the following steps:

1. Create Invoice 1: CAM-1 , Value = 10,000 (Validated - TDS @ 10.25)
2. Create Invoice 2: CAM-2 , Value = 30,000 (Validated - TDS @ 10.25)

 Result: On validation of CAM-2 invoice the following invoices got created...

 CAM-2-TDS-SI-12084, Value = 3075 -- Distribution account available
 CAM-2--CM-12085, Value = -- No distribution account available
 CAM-2-TDS-CM-12084, Value = -- Distribution account available

The issue has the following business impact:
Due to this issue, users cannot pay the tax authority.


To view full details, 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 a vibrant support community of peers and Oracle experts.