My Oracle Support Banner

Updating Supplier Applicability Form Errors - FRM-40735 ORA-01403 ORA-28115 (Doc ID 1593998.1)

Last updated on FEBRUARY 17, 2021

Applies to:

Oracle Financials for the Americas - Version 12.1.1 and later
Information in this document applies to any platform.


On : 12.1.1 version, Colombian Payables

Attempting to update the Supplier Withholding Applicability and receive the following error:

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403
ORA-28115: polity with check option violation.

Steps to Reproduce:
Responsibility: Oracle Payables - Colombia Localization
Navigation:  Colombia Localization > Supplier Withholding Applicability
Query a supplier
Try to update the supplier
The error occurs.

The error occurs trying to update the supplier with tax codes for two different operating units.
Going to second line and click on Withholding tax codes, the tax codes entered earlier are not visible.

On saving the two tax codes, getting the below error and while closing the form:

ORA-28115: polity with check option violation.

There is no workaround.

All supplier payments are impacted and the users are not able to process invoices in production.
Entire Colombia invoices amounting to millions of dollars got impacted.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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