VijOraAppsDBA: Form compilation error While Performing Compilation for CLL product 1213

As the CLL product version is out of date, the recommendation is to upgrade to the latest version - CLL.D.4. This would probably correct all CLL forms pointed out with errors.

Please let me know if an upgrade is not in the short-term plans that I will be reviewing the objects pointed out with a compilation error for the forms, compare them with their current versions, and indicate the next action plans for treatment.

Otherwise, refer to Doc ID 2413397.1 - "LAD Add-on Localizations - R12.1: CLL Minipack D.4 installation Instructions", to have a guide of the technical installation procedures of the CLL products actions.

-----------------------------------------------------

now form was compiled without error.

Created form file /u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/forms/US/CLLUPRSG.fmx

ACTION PLAN
============
1. Connect into application tier as APPLMGR ID and execute:

cd $CLL_TOP/sql
sqlplus apps/<apps_password>
@CLLTUPSS.pls
@CLLTUPSB.pls

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource/US

frmcmp_batch module=$AU_TOP/forms/US/CLLUPRSG.fmb userid=apps/<apps_password> module_type=form batch=no compile_all=special output_file=$CLL_TOP/forms/US/CLLUPRSG.fmx

cp $CLL_TOP/forms/US/CLLUPRSG.fmx $CLL_TOP/forms/ZHS/CLLUPRSG.fmx

-----------------------

==> form_comp2.txt:

================

Sequence CLL_F406_RESG_MIN_AMOUNT_S does not exist in CLL schema.

Creating the Sequence in schema CLL.

Creating synonym CLL_F406_RESG_MIN_AMOUNT_S for CLL.CLL_F406_RESG_MIN_AMOUNT_S

Synonym created

Sequence CLL_F406_RESG_PARAMETERS_S does not exist in CLL schema.

Creating the Sequence in schema CLL.

Creating synonym CLL_F406_RESG_PARAMETERS_S for CLL.CLL_F406_RESG_PARAMETERS_S

Synonym created

----------------------------------------------------

1. Connect into application tier as APPLMGR ID and execute:

[ please, replace <apps_password> and <hostname>:<DB_Port>:<SID> ]

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> sequence $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf $FND_TOP/patch/115/xdf/xsl

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> sequence $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf $FND_TOP/patch/115/xdf/xsl

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource/US

frmcmp_batch module=$AU_TOP/forms/US/CLLUPRSG.fmb userid=apps/<apps_password> module_type=form batch=no compile_all=special output_file=$CLL_TOP/forms/US/CLLUPRSG.fmx

cp $CLL_TOP/forms/US/CLLUPRSG.fmx $CLL_TOP/forms/ZHS/CLLUPRSG.fmx

-----------------------------------------

/* SQL 007 - sequences*/
select owner, object_name, object_type, status
from dba_objects
where object_name in ('CLL_F406_RESG_MIN_AMOUNT_S','CLL_F406_RESG_PARAMETERS_S');

no rows selected

===========

1. Connect into application tier as APPLMGR ID and execute:

[ please, replace <apps_password> and <hostname>:<DB_Port>:<SID> ]

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> table $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf $FND_TOP/patch/115/xdf/xsl

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource/US

frmcmp_batch module=$AU_TOP/forms/US/CLLUPRSG.fmb userid=apps/<apps_password> module_type=form batch=no compile_all=special output_file=$CLL_TOP/forms/US/CLLUPRSG.fmx

cp $CLL_TOP/forms/US/CLLUPRSG.fmx $CLL_TOP/forms/ZHS/CLLUPRSG.fmx

--------------------------------------------------------------------

1. Connect into application tier as APPLMGR ID and execute:

adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf

adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf

/u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/patch/115/xdf/cll_f406_resguardo_min_amount.xdf:
$Header cll_f406_resguardo_min_amount.xdf 120.0 2017/11/08 22:18:31 fmaurici noship $

$ adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf
/u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/patch/115/xdf/cll_f406_resguardo_parameters.xdf:
$Header cll_f406_resguardo_parameters.xdf 120.0 2017/11/08 22:19:35 fmaurici noship $
adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf

2. Connect into database as APPS ID, execute the SQLs and send us the results:

/* SQL 005 - cll_f406_resguardo_min_amount */
select owner, object_name, object_type, status
from dba_objects
where object_name = 'CLL_F406_RESGUARDO_MIN_AMOUNT';

no rows selected

/* SQL 006 - cll_f406_resguardo_parameters*/
select owner, object_name, object_type, status
from dba_objects
where object_name = 'CLL_F406_RESGUARDO_PARAMETERS';

no rows selected

----------------------------------------------------

adident Header $AU_TOP/forms/US/CLLUPRSG.fmb

/u01/oracle/SID/apps/apps_st/appl/au/12.0.0/forms/US/CLLUPRSG.fmb:
$Header CLLUPRSG.fmb 120.2 2017/11/09 16:33 fmaurici ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header CLLUPRSG.fmb 120.2 2017/11/09 16:33 fmaurici ship $
$Header CLLUPRSG.fmb 120.2 2017/11/09 16:33 fmaurici ship $

adident Header $AU_TOP/forms/ZHS/CLLUPRSG.fmb
/u01/oracle/SID/apps/apps_st/appl/au/12.0.0/forms/ZHS/CLLUPRSG.fmb:
$Header CLLUPRSG.fmb 120.2 level:-99999 2018/12/14 03:55:58 pkm ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header CLLUPRSG.fmb 120.2 level:-99999 2018/12/14 03:55:58 pkm ship $
$Header CLLUPRSG.fmb 120.2 level:-99999 2018/12/14 03:55:58 pkm ship $

frmcmp_batch userid=apps/*** module=/u01/oracle/SID/apps/apps_st/appl/au/12.0.0/forms/ZHS/CLLUPRSG.fmb output_file=/u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/forms/ZHS/CLLUPRSG.fmx

==> CLL_FORMS_ERROR.xls:
========================
OBJECT_NAME TYPE File Version Sequence Line Position Error Text
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 1 380 17 PL/SQL: ORA-00904: "SUB_FAMILY_CODE": invalid identifier
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 3 500 36 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 5 501 38 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 7 517 54 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 9 535 60 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 11 582 118 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 13 583 64 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 15 666 37 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 16 666 50 PL/SQL: ORA-00984: column not allowed here

CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 17 650 22 PL/SQL: SQL Statement ignored

--------------------------------------

1. Connect into database as APPS ID, execute the SQLs and send us the results:

/* SQL 001 - EBS version */
select release_name release
from apps.fnd_product_groups;

RELEASE
--------------------------------------------------
12.1.3

/* SQL 002 - DB version */
select instance_name, host_name, version
from v$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION
-----------------
instancename
hostname
19.0.0.0.0

/* SQL 003 - CLL product */
SELECT patch_level
FROM fnd_product_installations
WHERE patch_level LIKE '%CLL%';

PATCH_LEVEL
------------------------------
R12.CLL.D.2

/* SQL 004 - Invalid objects */ =====> please, upload the results of this SQL in spreadsheet (.xls) format:
SELECT a.object_name,
decode(a.object_type,
'PACKAGE', 'Package Spec',
'PACKAGE BODY', 'Package Body',
a.object_type) type,
(
SELECT ltrim(rtrim(substr(substr(c.text, instr(c.text,'Header: ')),
instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 1),
instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 2) -
instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 1)
))) || ' - ' ||
ltrim(rtrim(substr(substr(c.text, instr(c.text,'Header: ')),
instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 2),
instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 3) -
instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 2)
)))
FROM dba_source c
WHERE c.owner = a.owner
AND c.name = a.object_name
AND c.type = a.object_type
AND c.line = 2
AND c.text like '%$Header%'
) "File Version",
b.sequence "Sequence",
b.line "Line",
b.position "Position",
b.text "Error Text"
FROM dba_objects a,
dba_errors b
WHERE a.object_name = b.name(+)
AND a.object_type = b.type(+)
AND a.owner IN ('APPS','CLL')
AND a.status = 'INVALID'
ORDER BY 1, 4, 5;

-------------------Error--------------------------------

Form compilation error While Performing Compilation for CLL product

Problem Description
---------------------------------------------------
ERROR:-

Compiling package body CLL_F406_RESG_MIN_AMOUNT_V...
Compilation error on package body CLL_F406_RESG_MIN_AMOUNT_V:
PL/SQL ERROR 201 at line 10, column 18
identifier 'CLL_F406_RESGUARDO_MIN_AMOUNT' must be declared
PL/SQL ERROR 0 at line 10, column 18

-------------------------- Error----------------------

compilation failed with below error.Attached complete log.

Compiling package body CLL_F406_RESG_MIN_AMOUNT_V...
Compilation error on package body CLL_F406_RESG_MIN_AMOUNT_V:
PL/SQL ERROR 201 at line 146, column 18
identifier 'CLL_F406_RESG_MIN_AMOUNT_S.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 146, column 11
SQL Statement ignored
PL/SQL ERROR 201 at line 175, column 7
identifier 'CLL_F406_RESGUARDO_PKG.DML_CLL_F406_RESG_MIN_AMOUNT_P' must be declared
PL/SQL ERROR 0 at line 175, column 7
Statement ignored

Compiling package specification CLL_F406_RESG_PARAMETERS_V...
No compilation errors.

Compiling package body CLL_F406_RESG_PARAMETERS_V...
Compilation error on package body CLL_F406_RESG_PARAMETERS_V:
PL/SQL ERROR 201 at line 120, column 18
identifier 'CLL_F406_RESG_PARAMETERS_S.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 120, column 11
SQL Statement ignored
PL/SQL ERROR 201 at line 148, column 7
identifier 'CLL_F406_RESGUARDO_PKG.DML_CLL_F406_RESG_PARAMETERS_P' must be declared
PL/SQL ERROR 0 at line 148, column 7
Statement ignored

Compiling package specification CLL_F406_RESG...
No compilation errors.

Compiling package body CLL_F406_RESG...
No compilation errors.

Compiling package specification CTRL...
No compilation errors.

Compiling package body CTRL...
No compilation errors.

Compilation errors have occurred.

VijOraAppsDBA

Sunday, 11 April 2021

Form compilation error While Performing Compilation for CLL product 1213

No comments:

Post a Comment

SQL Shared Area - BIND MISMATCH

Search This Blog