Creating Payment Schedules Lines Manually Fails With FRM-40735: POST-QUERY Error (Doc ID 1342066.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to create Payment Schedules Lines manually, the following error occurs.

ERROR

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.

STEPS

- Invoices (using a customized folder ' Payables - invoices'):
Invoice num = <>
Validated
Accounted
No Paid

Payment Method = Electronic (in Header)

- Scheduled Payments tab:
Gross Amount = 100.000,00
Changed it to 30.000,00

and adding a new second line for the rest of gross amount (70.000,00)

delete this second line

saved

- Getting error:
Forms:
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.

They can see the Total gross amount as 100.000,00 instead of 30.000,00