My Oracle Support Banner

Incorrect Line And Tax Amount Is Appearing At Order Level In India Tax Details Form After Splitting (Doc ID 2397032.1)

Last updated on MAY 10, 2018

Applies to:

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

Symptoms

On : 12.X.X version, GST Order Management

PROBLEM STATEMENT

-------------------------

Scenario is like the following:-
================================

1. User attaches one config item with 0 unit price (quantity 5 for example) to the sales order and attaches tax category to the item in India Tax Details form.

Line     Unit Price
=====================
1.1         0

2. User comes back to sales order line form and click 'Configurator' button to configure the item. Select few lines and then click 'Done'. After that, 7 new lines get created like the following:-

Line     Unit Price
=====================
1.1.1        0
1.1.2        0
1.1.3     161908
1.1.4        0
1.1.5     169400
1.1.6        0
1.1.7      77000

3. Right click on line 1.1 > progress order > Create Configuration - Eligible.
4. One new item line got generated with line number 1.1..0. This is the item whose status has become supply eligible.
5. Now when user is moving to India Tax Details form, he finds that unit price of line 1.1..0 has become 408308 correctly which is total of all lines (from 1.1.1 to 1.1.7)
6. Total order line amount becomes (408308*qty)=(408308*5)=2041540.
7. Come back to sales order line and split line 1.1 to two quantity e.g. 2 & 3.
8. After splitting, another set of lines got generated whose supply eligible line is 1.2..0
9. Go to India Tax details form. there, for

A) line number 1.1..0 for qty 2, unit price has become 1020770 i,e (total order line amount/split qty of 1.1..0) whereas it should remain 408308.

B) for line number 1.2..0 for qty 3, unit price is showing NULL i.e no unit price is appearing for this line.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot maintain correct tax amount at order level which will create audit compliance issue.

Changes

 

Cause

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.