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

Last updated on FEBRUARY 17, 2021

Applies to:

Symptoms

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.

Cause

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