My Oracle Support Banner

POXDOFDO - Forward Documents for Requisition Gets FRM-40735: ON-COMMIT (Doc ID 2382971.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Purchasing - Version 12.2 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Approvals - Req, PO


Requisition Forwarding(POXDOFDO - Forward Documents)

When a Requsition is being forwarded for approval by the PO Super user, the user is getting an error

Error: FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-20002.

ERROR
-----------------------
FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-20002

FRM-40654: Record has been updated. Requery block to see change

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Logon to PO SuperUser
2) Navigate ->Management->Forward Documents
3) Enter Approver, select line that is wanting to be forwarded
4) Click on Save error occurs: FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-20002
5) Then the next dialog pops up: Please acknowledge
6) Click OK
7) Then another dialog pops up:FRM-40654: Record has been updated. Requery block to see change
8) The document is not forwarded

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.