Unable To View The Entry In India Local Receipts Error POST-QUERY trigger raised unhandled exception (Doc ID 2146081.1)

Last updated on SEPTEMBER 01, 2016

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, India Inventory Localizations

ACTUAL BEHAVIOR
---------------
Customer is unable to see receipt lines for receipt.

EXPECTED BEHAVIOR
-----------------------
Customer should be able to see receipt lines for receipt.

ERROR MESSAGE

------------------------

JAINPORE, 17, Prog Unit, Exit, 340886366, /JAINPORE-3/RECEIPT_LINES/FETCH_DETAILS

Unhandled Exception ORA-06502
State Delta:

Error Message: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502.

ON-ERROR Trigger Fired:
Form: JAINPORE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to India local purchasing resp
2. Create a india local receipt .
3. check the receipt

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot check the receipt line for India localization and cannot apply taxes.

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