Thursday 23 November 2017

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

https://aporaclepayables.blogspot.com/2017/11/app-sqlap-10000-ora-01403-no-data-found.html

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.

1 comment: