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.

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

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.

Error In Payables Open Interface Import : PA Flexbuild Failed

https://aporaclepayables.blogspot.com/2017/10/error-in-payables-open-interface-import.html

ERROR

(v_check_line_project_info 4) Call pa_flexbuild
(PA Flexbuild 1) Check for PA installation and Project Info
(PA Flexbuild 1) Get User Id


(PA Flexbuild 1) PA_TRANSACTIONS_PUB.VALIDATE_TRANSACTION
(PA Flexbuild 1) PA_TRANSACTIONS_PUB.VALIDATE_TRANSACTION Failed :Insert Rejecti
on
PA_PROJECT_NOT_VALID
(Insert Rejections 1) Insert into AP_INTERFACE_REJECTIONS, REJECT CODE:PA FLEXBU
ILD FAILED


SOLUTION

To implement the solution, please perform the below steps in a TEST instance:

Step 1. Validate the record in the interface table before running the import program

Step 2. Remove any records in the interface that are related to end dated/invalid Projects

Step 3. Re-run Payables Open Interface Import

Step 4. If the issue is resolved, migrate the solution to the required instance