Unable To Assign Vendors To Exceptional Threshold Setup Due To Error is "ORA-00904: "THRESHOLD_EXCEPTION_ID": invalid identifier (Doc ID 1911585.1)

Last updated on AUGUST 23, 2016

Applies to:

Oracle Financials for India - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Tax Deducted at Source-Payables

When attempting to assign the vendor in  exception threshold setup
the following error occurs.

ERROR
-----------------------
Error is "ORA-00904: "THRESHOLD_EXCEPTION_ID": invalid identifier

--------------------------------------------------------------
FRM-40505: ORACLE error: unable to perform query."


STEPS
-----------------------
1) Navigate to India Local Payable
2) Open the threshold setup form
3) Do the exceptional threshold setup
4)Assign the Vendor

BUSINESS IMPACT
-----------------------
Unable to complete the threshold setup

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