Sales Order Form Error FRM-40735, ORA-06508. Recently Moved From HP To Linux Platform (Doc ID 2266150.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Version:12.1.3

PROBLEM STATEMENT
-----------------------
When attempting to review order line from Order form (OEXOEORD) the following error occurs,
and its not allowing to move any other tabs/fields.
After changing the HW from Unix HP server to new Linux Operating system and Server.

ERROR
-----------------------
ORA-1403: no data found

FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-06508


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Sales Order
2. Go to line

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot move their production Hardware to new Hardware.

 

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