GST India Period Ending Process Is Not Updating REPORTING_STATUS_FLAG After Applied Prepayment (Doc ID 2261336.1)

Last updated on MAY 02, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Tax Deducted at Source-Payables

India Period ending Process is not updating REPORTING_STATUS_FLAG after applied Prepayment .
On Running India - Period end process concurrent , no records are updated in.

From the fnd debug log, observed the below error.

ERROR
-----------------------
JAI.PLSQL.JAI_RGM_RECOVERY_PKG.INSERT_RECOVERY_LINES JAI_RGM_RECOVERY_PKG:INSERT_RECOVERY_LINES.BEGIN()+
JAI.PLSQL.JAI_RGM_RECOVERY_PKG.INSERT_RECOVERY_LINES Unexcepted exception: ORA-01400: cannot insert NULL into ("JA"."JAI_RGM_RECOVERY_LINES"."ORGANIZATION_ID")
JAI.PLSQL.JAI_TAX_ACCOUNTING_PKG.populate_repository JAI_TAX_ACCOUNTING_PKG:pv_process_status,UE
JAI.PLSQL.JAI_TAX_ACCOUNTING_PKG.populate_repository Unexcepted exception: ORA-01400: cannot insert NULL into ("JA"."JAI_RGM_RECOVERY_LINES"."ORGANIZATION_ID")

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Raise prepayment with reverse charge taxes
2. raise standard invoice with same taxes / same hsn code details and on applying prepayment on standard invoice
find that the actual final entries for repository / accounting are not generated in.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the accounting hit.

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