APP-SQLAP-10000: ORA-01403: no data found occurred in  with parameters (Term id = Sequence num = 1)

ERROR

Unable to validate invoice where the item line has a withholding tax group due to:

APP-SQLAP-10000: ORA-01403: no data found occurred in with parameters (Term id = Sequence num = 1) while performing the following operation: &DEBUG_INFO the following error occurs.

SOLUTION

Step 1. Navigate to Supplier form through Payables > Suppliers > Entry

Step 2. Query the Supplier  linked to the withholding group.

Step 3. Click Update for updating the Supplier.

Step 4. Select the Key Payment Setup tab.

Step 5. Scroll to the Payment terms section and add a Payment Term to the Tax Authority for that Vendor Site.

Step 6. Retest the issue.