My Oracle Support Banner

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

Last updated on SEPTEMBER 06, 2016

Applies to:

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


On 12.1.3 in Production:
When attempting to create Payment Schedules Lines manually , the following error occurs.

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

The issue can be reproduced at will with the following steps:
- Invoices (using a customized folder ' Payables - invoices'):
Invoice num = EU/01
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


- Getting error:
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

The issue has the following business impact:
Due to this issue, users cannot create Payment Schedules Lines manually.


To view full details, 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 a vibrant support community of peers and Oracle experts.