My Oracle Support Banner

Standard Concurrent Argentine Monotributistas Billing Vs. Threshold Verification Report Fail - ORA-01403 Applicability / Function: No Data Found (Doc ID 1475144.1)

Last updated on APRIL 13, 2018

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.