OFI-GST: Third Party Registration Reporting Code Error: FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-04062

(Doc ID 2409573.1)

Last updated on JUNE 11, 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

When attempting to add the Reporting Code value in 3rd Party Registration Form,
the following error occurs.

ERROR
-----------------------
FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-04062


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N)->Oracle Financials for India.
2. Party Registrations -> Third Party Registrations
3. Query the 3rd Party Registration details of a Supplier.
4. Try to enter the value of Reporting code details.

Observe the error message.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
1. User cannot associate the vendor type code value to the vendor thereby affecting the TDS functionality

Changes

 

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