Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner

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

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

Syed Saad Ali June 25, 2017 Accounts Payables, Errors/Workarounds-AP, Oracle Functional Leave a comment 2,351 Views

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.

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

An Introduction to Financial Statement Generator (FSG)

An Introduction to Financial Statement Generator (FSG) Financial Statement Generator The Financial Statement Generator (FSG) …