My Oracle Support Banner

GST: Receipt accounting posted to Adjustment / adj period instead of current open period (Doc ID 2572349.1)

Last updated on AUGUST 01, 2019

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.

Symptoms

ACTUAL BEHAVIOR
---------------
Data with wrong period_name was sent to gl_interface on accounting a receipt with GST taxes.
This is observed for the case when receipt is created on the last day of the calendar month.

Consider the below example:

Lets assume that receipt is created over the last date of month then period name field having wrong value in GL_Interface and JAI_TAX_JOURNAL_ENTRIES tables . 
Receipt created 30-JUL-2019 .Complete the deliver event and on accounting find that in GL_interface table and JAI_TAX_JOURNAL_ENTRIES table then Period name is "Adj-JUL-20" instead of "JUL-19".

Note :The current period i.e. JULY 2019 is opened.


EXPECTED BEHAVIOR
-----------------------
Expects that the accounting entry should be posted to the correct period.
Considering the above example, these entries shouldn't be posted under ADJ / Adjustment month , rather to be current month.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a receipt with GST taxes on  last date of month and account it then period name field having wrong value in gl_interface and JAI_TAX_JOURNAL_ENTRIES tables . 
2. It is posting that receipt entry into adj period.
3. This is observed for all receipts which are created on the last day of the month,

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot account the transaction correctly over the current month.

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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.