Errors ORA-01403 FRM-40735 When Opening Order Organizer Form (Doc ID 1106104.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.
Occurs in:Quick Sales Order Form
Order Organizer and Sales Order Form
***Checked for relevance on 16-AUG-2012***
***Checked for relevance on 28-JAN-2014***

Symptoms

When the Quick Sales Order form or Order Organizer form is opened, the following error occurs:

ORA-01403: No data found
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06510.

User may also see:

ksedmp: internal or fatal error
ORA-01403: no data found
Current SQL statement for this session:
begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :s
ecurity_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_requ
est, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID',
:org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profil
e.put('APPS_MAINTENANCE_MODE', :amm); end;

Changes

One-off patches 9400633 and 9259355 were applied for AP and now OM forms error.

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