R12: AR to GL Reconciliation Report Finishes With Warning For The Version In Spanish (Doc ID 725983.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Receivables - Version 12.0.2 and later
Information in this document applies to any platform.
ARGLRECR


Symptoms

When running the AR to GL Reconciliation Report, the report completes successfully with warning but yet shows the following error message

Program Name : ARGLRECR
java.sql.SQLException: ORA-20001: Error de Oracle 100: Se detect ORA-01403: no data found en
xla.plsql.XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME.
ORA-06512: at "APPS.XLA_MO_REPORTING_API", line 32
ORA-06512: at "APPS.XLA_MO_REPORTING_API", line 222
ORA-06512: at "APPS.ARP_RECON_REP", line 2535
ORA-06512: at line 1

Also, when running the report, the following error message appears:

APP-FND-806: El valor por defecto Entidad Legal es invalido para el segmento Reporting Level.
El valor por defecto sera ignorado. Informe al administrador del sistema que:


Translation:
--------------
APP-FND-806: The default value [Ledger] is invalid for the [REPORTING_LEVEL] segment.
Your default value will be ignored. Please inform your system administrator that:

Then, the parameter entry form will open and the parameter Mayor (Ledger in English) is Null and Disabled.
Now if user runs the report, it will complete as warning as debug log shows error    

"No Data Found en xla.plsql.XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME"

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms