GST: Peformance issue with Interface Trip Stop for Completion

(Doc ID 2400890.1)

Last updated on MAY 19, 2018

Applies to:

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

Symptoms

 GST :Order Management
 
 Reported Issue
 ---------------
 Interface trip stop is taking long time for completion.
 This is categorized as performance issue.

 Expected Behavior
 ------------------
 Interface Trip Stop is expected to get completed within reasonable time.

 Observation
 --------------
 Most expensive query picking up from tkprof is
 SELECT JTL_RECEIPT.*
 FROM
 JAI_ADVANCE_RECEIPT_V JAR, JAI_TAX_LINES_V JTL_RECEIPT WHERE JAR.TRX_ID =  :B2 AND JAR.ENTITY_CODE = 'RECEIPTS' AND JTL_RECEIPT.ENTITY_CODE =
 'RECEIPTS' AND JAR.DET_FACTOR_ID = JTL_RECEIPT.DET_FACTOR_ID AND JTL_RECEIPT.TAX_RATE_ID = :B1

 Business criticality
 ------------------
 Due to this order are taking longer time delaying shipments.

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