My Oracle Support Banner

CLL_F189_OPEN_PROCESSES_PUB: ORA-00904: "RECI"."DOLLAR_OTHER_VAL_NOT_ICMS": (Doc ID 2042447.1)

Last updated on MARCH 20, 2019

Applies to:

LAD Add-on Localizations - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Brazil Consulting Localizations


There are invalid objects

CLL_F189_OPEN_PROCESSES_PUB: ORA-00904: "RECI"."DOLLAR_OTHER_VAL_NOT_ICMS":

Package body CLL_F189_OPEN_PROCESSES_PUB and CLL_F189_OPEN_INSERT_TMP_PUB are INVALID.

ERROR
-----------------------

SQL Command: package CLL_F189_OPEN_PROCESSES_PUB
Failed: Warning: execution completed with warning
package CLL_F189_OPEN_PROCESSES_PUB altered.
293/12 PL/SQL: ORA-00904: "RECI"."DOLLAR_OTHER_VAL_NOT_ICMS": invalid identifier
82/5 PL/SQL: SQL Statement ignored
593/12 PLS-00364: loop index variable 'R_INVOICE_HEADER' use is invalid


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
ALTER PACKAGE CLL_F189_OPEN_PROCESSES_PUB COMPILE BODY
Error report -
SQL Command: package CLL_F189_OPEN_PROCESSES_PUB
Failed: Warning: execution completed with warning
package CLL_F189_OPEN_PROCESSES_PUB altered.
293/12 PL/SQL: ORA-00904: "RECI"."DOLLAR_OTHER_VAL_NOT_ICMS": invalid identifier
82/5 PL/SQL: SQL Statement ignored
593/12 PLS-00364: loop index variable 'R_INVOICE_HEADER' use is invalid



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.