My Oracle Support Banner

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

Last updated on APRIL 04, 2021

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.


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.

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.

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,

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




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

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