12.2 E-Business Suite System Profile Values Form Fails To Open With Error 'ORA-01403: no data found' and 'FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-01722'

(Doc ID 2194298.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Application Object Library - Version 12.2 and later
Oracle Applications Technology Stack - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications DBA, Issues with the Functionality of AD Utilities

 

 

When opening the form "Profile System Values" the below 'ORA-01403: no data found' error is received:

Push "OK" button. You get the message "ORA-01403: no data found" and "FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-01722".

Push OK button. You get the message "You cannot go to the System Profile Values window because you haven't populated it with the Find System Profile Values window yet.".

Changes

 The value for profile option "MO: Set Client_Info for Debugging" was recently changed to 'Yes'.

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