GST Recovery Form Not Opening

(Doc ID 2394307.1)

Last updated on MAY 22, 2018

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, GST Payables

ACTUAL BEHAVIOR
---------------
When trying to search for the records in the process claim form ,the form is
hanging indefinitely . especially when trying to search with invoices.

Process claim form has performance issue.
when performing process claim for invoice again it is hanging and user is
unable to supplier name and site ,status .

The costliest query is

SELECT jrs.DOCUMENT_ID,jrs.DOCUMENT_NUMBER,jrs.TAX_TYPE_ID,jrs.TAX_TYPE_NAME,
  jrs.TAX_TYPE,jrs.RECOVERABLE_AMOUNT,jrs.RECOVERED_AMOUNT
FROM
 jai_recovery_summary_v jrs WHERE EXISTS (SELECT 1 FROM jai_tax_types jtt
  WHERE jtt.tax_type_id = jrs.tax_type_id AND nvl(jtt.self_assessed_flag
,'N')
  = 'N') and (jrs.DOCUMENT_ID=:1)


EXPECTED BEHAVIOR
-----------------------
Form is not to be hanged and the records are to be shown in reasonable time
without any delay

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to Oracle Financials for India responsibility
2. Navigate to process recovery form
3. Query the data and check the performance

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot do process claim in time

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