Rate Of Duty In Invoice Calculated Wrong If Matchd Invoice(s) Has NULL Rate Of Duty (Doc ID 2155573.1)

Last updated on JULY 07, 2016

Applies to:

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

Symptoms

On :  12.1.3 version, Excise - Order to Cash Cycle

ACTUAL BEHAVIOR  
---------------
Incorrect Excise Percentage getting updated in RG23D table whenever a receipt is partly matched to an invoice.the Excise_duty_rate populated in JAI_CMN_RG_23D_TRXS is sometimes as high as 600% and sometimes 0%.
Although the Invoice Amount is correctly calculated and greater than zero.

EXPECTED BEHAVIOR
-----------------------
The Excise Duty Rate must be calculated correctly in synchronous with the invoice amount.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Created Sales order
2) Launched Pick release
3) Receipt of Item  in RG23D from Trading Organization
4) Matching receipt
4) Checking in the JAI_CMN_RG_23D_TRXS

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
As per the user this can lead to imprisonment as the Excise Duty Rate is calculated very high.

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