Updating Supplier Applicability Form Errors - FRM-40735 ORA-01403 ORA-28115

(Doc ID 1593998.1)

Last updated on APRIL 13, 2018

Applies to:

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

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

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