XML Publisher Reports Aren't Submitted From The Forms, But Are Submitted Normally From The Web Interface (Doc ID 1522587.1)

Last updated on JUNE 21, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Just upgraded from EBS 11i to EBS 12.1.3 and noticed that XML publisher Reports can't be submitted from the forms, but can be submitted normally from the web interface.
When one tries to submitt an XML publisher request from the Core Application forms screen (report with XML or pdf output), one is getting the following errors and the request is not submitted:

ORA-01403: no data found
--------------------------------------------------------------
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04062

Although, when running the same request from system administration (web interface), the request is submitted, completes normal, and produces the PDF output successfully.

Changes

 Upgrade from EBS 11i to EBS 12.1.3

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