Updating Supplier Applicability Form Errors - FRM-40735 ORA-01403 ORA-28115
Last updated on APRIL 13, 2018
Applies to:
Oracle Financials for the Americas - Version 12.1.1 and laterInformation 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