EBS Customizations (MOSC)

MOSC Banner

APP_STANDARD.EVENT throwing FRM-40735: WHEN-NEW-RECORD-INSTANCE unhandled exception ORA-06502

edited Feb 17, 2010 2:08AM in EBS Customizations (MOSC) 8 commentsAnswered
 Problem Description: In one of our custom forms, the WHEN-NEW-RECORD-INSTANCE trigger raises an unhandled exception ORA-06502 when it is calling the standard package APP_STANDARD.EVENT('WHEN-NEW-RECORD-INSTANCE').

If this line is commented in the trigger, then the form is fine.

This error happens when we query records and everytime we go to a new record.

It seems to be happening for records with a column name called ORG_ID(VARCHAR2(15)) having character values. For records having ORG_ID as a numeric value, the form performs fine.

We have upgraded from 11.5.10 to 12.1.2

The form version, the table behind the form are all the same as they were in 11i before upgrade.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center