Payments Workbench Error: "FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-04063" when saving payment in (APXPAWKB.FMB) (Doc ID 1570271.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle General Ledger - Version 12.1.3 and later
Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Pmt PayReports PBatch & Prepay

Payments Workbench Error: ORA-04063 Post-Query Trigger (APXPAWKB.FMB)

Payment work bench for errors with FRM-40735 ON-Commit Trigger raised unhandled exception ORA-04063

Unabale to process payments

Error started after Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit and moving to RHEL 6 on and 10.1.3.5 on a new server.

Loss of ability to process payments.



ERROR
-----------------------

FRM-40735: ON-COMMIT trigger raised unhandled exception ORA-04063

 In addition, when trying to open GL Period, following error occurred:

Missing Subscriber or Invalid Rule Set that results in the Periods within the Calendar to be out of sync.
OR
The rule set WF_DEFERRED_R is invalid.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payment Workbench
2. Choose the Invoice
3. Save
4. Error raised

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create payment.

Changes

 Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit and moving to RHEL 6 on and 10.1.3.5 on a new server.

 

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