Standard Concurrent Argentine Monotributistas Billing Vs. Threshold Verification Report Fail - ORA-01403 Applicability / Function: No Data Found
(Doc ID 1475144.1)
Last updated on FEBRUARY 24, 2019
Oracle Financials for the Americas - Version 12.1.3 and later Information in this document applies to any platform.
On : 12.1.3 version, Argentine AP Localizations
Attempting to run the Argentine Monotributistas Billing vs. Threshold Verification Report, the following error occurs.
Error: AN ERROR IS CHANGING WHILE SUPPLIER Encountered ORA-01403 100ERROR Applicability: No Data Found IS AN ERROR IN BEFORE REPORT Encountered ORA-01403 100ERROR FUNCTION: No Data Found
The issue can be reproduced at will with the following steps:
Responsibility: Oracle Payables - 12.1.3 Argentina globalization JL_ZZ_AP_MONOTRIB_AWT_PKG jlarmtbb.pls 1120.0.12010000.11 Navigation: Invoices > Entry > Invoices 3. Create a MONOTRIBUTISTA SUPPLIER Invoice, then exceeds the Threshold. Navigation: Other > Requests > Run 3. Execute the Concurrent Argentine Monotributistas Billing vs. Threshold Verification Report (JLARMTBT_XMLP) The report fails or The report does not update the AWT codes when the report Mode Parameter is in List, Verify and Update option in order to add the withholding tax to all the invoices that are not paid of this supplier.
The issue is in the JL_ZZ_AP_MONOTRIB_AWT_PKG package, in this part of code:
AP_TAX_CODES_ALL data correspond to various organizations, however AP_TAX_CODES data is one of the company in execution. Having different dates It does not find data for the company in execution.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!