R12.2: TDS is Deducted on Service Tax & Prepayment is not getting Applied when Invoice is Having Item as well Service Tax Lines (Doc ID 2000307.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for India - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, India AP Localizations

When attempting to apply prepayment to standard invoice,
the following error occurs.

Issue 1
---------

ERROR
-----------------------
APP-SQLAP-10000: occurred in Apply_Prepay_Line
Issue 2
----------
TDS is getting Deducted on Service Tax Lines if the Tax category contains TDS as well as WCT

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Issue 1:
1. Create a prepayment with TDS and WCT. Validate and Pay
2. Create standard invoice on which Service tax is applied
3. On item line apply TDS and WCT category and on Service Tax line Apply only WCT Category
4. Validate the invoice
5. Try Applying the prepayment. Observe error

Issue 2:
1. Create Standard invoice on which Service tax is applied
2. On item line and service tax line apply category having TDS & WCT
3. Validate the invoice
4. Observe TDS is getting generated on service tax line even though section code is not registered under look up JAI_TDS_SECTION_SERVICE


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply prepayment to standard invoice

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