gscc.pll and custom forms files

[Linda]

Hi Erman!

Again me :)
Checking custom files with GSCC : *sql, *rdf  etc went fine
But what about forms files : fmb/fmx ?
I cannot check those:
=======
File: ../XX/12.0.0/forms/US/XXOEXXX.fmb

Configuration Errors (1):
   N/A
      0 - File conversion failed for
../XX/12.0.0/forms/US/XXOEXXX.fmb
        using the command line
frmf2xml.sh OVERWRITE=YES XXOEXXX.fmb
====
The problem is that i dont have  this script frmf2xml.sh. In metalink there is reference to the iff2xml90.sh, but I dont have it either  in the 12.2 code ...
(Batch Script for FMB to XML and XML to FMB(Doc ID 266576.1))

I did not find any info about that ? Do you have suggestion as always to redirect me to right direction :) ?

Thank you,Linda

[ErmanArslansOracleBlog]

It is not there. (For earlier releases as well..)
However, you should be able to use it on your client. ( I mean a client on which Forms Builder installed)

[ErmanArslansOracleBlog]

How did you get this error?
Send me the exact command that you have used along with the output of it.

[ErmanArslansOracleBlog]

Also where did you find this info? I mean using gscc.pl for checking the custom form files?
The instructions in document 1531121.1 are only about executing sql scripts..
The definition of gscc.pl is written in the readme of GSCC , but in the document, there is no instructions or command for using gscc.pl directly. What the document 1531121.1 instructs is executing sqls which are delivered with gscc.

So, please update me accordingly.

[Linda]

Hi Erman!
In the readme there is the instructions how to check the custom files . We need to check those in custom top.
For example customized  reports -> scaned those and  found like that couple of violations -> developers fixed that in those reports.
Now we have custom forms -> run gscc.pl on those and I have that error for that script, so first need to convert the fmb to xml file ..

Br,Linda

From the same note1531121.1  or readme of the patch:
=====
Using GSCC
==========

The Global Standards Compliance Checker (GSCC) delivered in this patch consists
of the main, engine script $FND_TOP/bin/gscc.pl and a variety of standards
enforcement code (EFC) modules in $FND_TOP/perl/GSCC/OpenEFC/ that check for
common standards issues.

After applying this patch to install the GSCC code, source the applications
environment file and then run the GSCC on a set files under a directory tree
like this:

cd /home/yourdir
$FND_TOP/bin/gscc.pl -f '/home/yourdir/your-code/*'

In this example, gscc.pl will check all of the files located under the
your-code/ directory using the EFC modules located in
$FND_TOP/perl/GSCC/OpenEFC/ and generate a report named gscc-out.log in the
current working directory (/home/yourdir/ in this example). Invoking
gscc.pl without arguments will print a usage message with additional
information.

[ErmanArslansOracleBlog]

Yes i m talking about the same readme. The info given there is really from the surface. But what is the full command that is failing? Send me the exact command and gscc out/log please

22 Kas 2016 17:19 tarihinde "Linda [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi Erman!
In the readme there is the instructions how to check the custom files . We need to check those in custom top.
For example customized  reports -> scaned those and  found like that couple of violations -> developers fixed that in those reports.
Now we have custom forms -> run gscc.pl on those and I have that error for that script, so first need to convert the fmb to xml file ..

Br,Linda

From the same note1531121.1  or readme of the patch:
=====
Using GSCC
==========

The Global Standards Compliance Checker (GSCC) delivered in this patch consists
of the main, engine script $FND_TOP/bin/gscc.pl and a variety of standards
enforcement code (EFC) modules in $FND_TOP/perl/GSCC/OpenEFC/ that check for
common standards issues.

After applying this patch to install the GSCC code, source the applications
environment file and then run the GSCC on a set files under a directory tree
like this:

cd /home/yourdir
$FND_TOP/bin/gscc.pl -f '/home/yourdir/your-code/*'

In this example, gscc.pl will check all of the files located under the
your-code/ directory using the EFC modules located in
$FND_TOP/perl/GSCC/OpenEFC/ and generate a report named gscc-out.log in the
current working directory (/home/yourdir/ in this example). Invoking
gscc.pl without arguments will print a usage message with additional
information.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gscc-pll-and-custom-forms-files-tp1586p1590.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Linda]

Error is this, because there is NO script frmf2xml.sh anywhere in EBS 12.2 .
So, I asked developer to check now their local istall on pc of dev suite if there is the file..

=======
File: ../XX/12.0.0/forms/US/XXOEXXX.fmb

Configuration Errors (1):
   N/A
      0 - File conversion failed for
../XX/12.0.0/forms/US/XXOEXXX.fmb
        using the command line
frmf2xml.sh OVERWRITE=YES XXOEXXX.fmb
=======

[ErmanArslansOracleBlog]

Yes. I understand. Please send me the gscc command that you use and the log file..

Note that, in your developer's windows Client, the suffix may be .bat (not .sh)

22 Kas 2016 17:46 tarihinde "Linda [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Error is this, because there is NO script frmf2xml.sh anywhere in EBS 12.2 .
So, I asked developer to check now their local istall on pc of dev suite if there is the file..

=======
File: ../XX/12.0.0/forms/US/XXOEXXX.fmb

Configuration Errors (1):
   N/A
      0 - File conversion failed for
../XX/12.0.0/forms/US/XXOEXXX.fmb
        using the command line
frmf2xml.sh OVERWRITE=YES XXOEXXX.fmb
=======

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gscc-pll-and-custom-forms-files-tp1586p1592.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Linda]

Hi again :)

cd $XX_TOP/forms/US
$FND_TOP/bin/gscc.pl -f  XXOEXXX.fmb

The log file is :
more gscc-out.log

-------------------------------------------------------------------------------
GSCC Compliance Test Results:
-------------------------------------------------------------------------------
File: XXOEXXX.fmb

Configuration Errors (1):
   N/A
      0 - File conversion failed for
XXOEXXX.fmb
        using the command line
frmf2xml.sh OVERWRITE=YES XXOEXXX.fmb

-------------------------------------------------------------------------------
GSCC Totals:
  Passes:      0
  Fails:       0
  Warnings:    0
  Under Review: 0
  GSCC Errors: 1

--* GSCC Compliance Test: Configuration Error *--


So, no that file frmf2xml.sh in EBS12.2:) I am trying to get it from somewhere :)
gscc.pl works fine for reports etc files..

Thanks,Linda

[ErmanArslansOracleBlog]

I dont think that gscc document is accurate. (At least not for fmb files).

Could you find the frmr2xml on the client, which has forms installed?

22 Kas 2016 23:32 tarihinde "Linda [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi again :)

cd $XX_TOP/forms/US
$FND_TOP/bin/gscc.pl -f  XXOEXXX.fmb

The log file is :
more gscc-out.log

-------------------------------------------------------------------------------
GSCC Compliance Test Results:
-------------------------------------------------------------------------------
File: XXOEXXX.fmb

Configuration Errors (1):
   N/A
      0 - File conversion failed for
XXOEXXX.fmb
        using the command line
frmf2xml.sh OVERWRITE=YES XXOEXXX.fmb

-------------------------------------------------------------------------------
GSCC Totals:
  Passes:      0
  Fails:       0
  Warnings:    0
  Under Review: 0
  GSCC Errors: 1

--* GSCC Compliance Test: Configuration Error *--


So, no that file frmf2xml.sh in EBS12.2:) I am trying to get it from somewhere :)
gscc.pl works fine for reports etc files..

Thanks,Linda

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gscc-pll-and-custom-forms-files-tp1586p1597.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Linda]

Hi Erman!

Update :
I got file  frmf2xml.bat for Windows :)
and inside there is called this : java -classpathjava oracle.forms.util.xmltools.Forms2XML  

So, i created for unix verion:
================
export PATH=$PATH:$ORACLE_HOME/bin
. $ORACLE_HOME/SID_host.env

export  FORMS_API_TK_BYPASS=true
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/forms/java/frmxmltools.jar:$ORACLE_HOME/forms/java/frmjdapi.jar:$ORACLE_HOME/lib/xmlparserv2.jar:
$ORACLE_HOME/10.1.2/lib/xschema.jar

for i in 'ls *.fmb'
do
java oracle.forms.util.xmltools.Forms2XML  OVERWRITE=yes $i
done
========
and run in the  custom top $XX_TOP/forms/US
Got those xml files created .

Then on those *xml  (not *fmb) files run the gscc.pl sript for checking...
and found 2 violations of rule.. -> Will ask developers to fix

 have you analyzed the CUSTOM_TOP files like reports etc for your upgrade projects ?
Isnt that nesserary for the Online patching compliance :)

Br,Linda

[ErmanArslansOracleBlog]

Hi Linda,

Very good :) So it is there in your clients and you take it from there and deployed (manually) to EBS :) That 's cool.

In our projects, we do these stuff manually. But gscc is a better way ofcourse.

Can you send me an example vialation that gscc has reported for one of your custom fmb files?

Thanks

2016-11-23 0:41 GMT+03:00 Linda [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi Erman!

Update :
I got file  frmf2xml.bat for Windows :)
and inside there is called this : java -classpathjava oracle.forms.util.xmltools.Forms2XML  

So, i created for unix verion:
================
export PATH=$PATH:$ORACLE_HOME/bin
. $ORACLE_HOME/SID_host.env

export  FORMS_API_TK_BYPASS=true
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/forms/java/frmxmltools.jar:$ORACLE_HOME/forms/java/frmjdapi.jar:$ORACLE_HOME/lib/xmlparserv2.jar:
$ORACLE_HOME/10.1.2/lib/xschema.jar

for i in 'ls *.fmb'
do
java oracle.forms.util.xmltools.Forms2XML  OVERWRITE=yes $i
done
========
and run in the  custom top $XX_TOP/forms/US
Got those xml files created .

Then on those *xml  (not *fmb) files run the gscc.pl sript for checking...
and found 2 violations of rule.. -> Will ask developers to fix

 have you analyzed the CUSTOM_TOP files like reports etc for your upgrade projects ?
Isnt that nesserary for the Online patching compliance :)

Br,Linda

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gscc-pll-and-custom-forms-files-tp1586p1599.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Linda]

Hi Erman!
Here you go.. Thanks for the hint looking for file in the Forms builder :) Oracle should have inluded in that Online patching GSCC utility..
Have a nice week! :)
Br,Linda
The common example for violations in custom  forms  are like this:
======
-------------------------------------------------------------------------------
File: XXXXX_fmb.xml

Errors (1):
   File.Gen.41 (Code Reviewers: CODE_REVIEWER)
      516 - Potential standards violation found in Query/DML. Please check whether
         apps.xx_12_api_interface&
         is a direct table reference. If so, change it to use the APPS synonym.
      516 - Potential standards violation found in Query/DML. Please check whether
         apps.xx_12_api_log&
         is a direct table reference. If so, change it to use the APPS synonym.

-------------------------------------------------------------------------------
File: XXXX_fmb.xml

Errors (1):
   File.Gen.41 (Code Reviewers: CODE_REVIEWER)
      814 - Potential standards violation found in Query/DML. Please check whether
         inv.org_freight
         is a direct table reference. If so, change it to use the APPS synonym.

[ErmanArslansOracleBlog]

Excellent!
So the utility works well and coded appropriately, but the tool for converting frm to xml is missing.
That's right. Oracle should have included it, but I m not surprised, because I see lots of inaccurate documentation and addons nowadays..
Have a nice week too.

[Linda]

Hi Erman!
Just FYI:
Arghh... I could do it much more simpler way... Java 'likes' to crash when too big form to convert to XML.

frmcmp_batch module=XX.fmb userid=apps/apps  Script=YES Forms_Doc=YES module_type=FORM

This way convert all all those in the 'for i in' and then gscc.pl on the outputs... And it worked  as a charm!

Also gscc.pl -f '*.rdf' not working for rdf  , works for other types.   It worked one by one /did a script :)

Have a nice day!
Br,Linda

[ErmanArslansOracleBlog]

Cool. frmcrp_batch is really a good idea and works like a charm as you said Linda.

Here is a script from me then :)  this can be modified for using with the other types(such as rdf) as well;
It processes the filesystem objects one by one.. It produces one final gscc_log which includes all the gscc checks for fmbs.

for i in $(ls *.fmb);
do
echo $i
frmcmp_batch module=$i userid=apps/apps  Script=YES Forms_Doc=YES module_type=FORM
$FND_TOP/bin/gscc.pl -f `echo $i | sed  '{s/.fmb/.txt/g; }'` -o gscc_`echo $i | sed  '{s/.fmb/.log/g; }'`
done
echo "GENERATING GSCC OUTPUT --all FMBs together" > gscc_log
for i in $(ls *.log);
do
echo ---- GSCC OUTPUT FOR  $i ----- >> gscc_log
cat $i >> gscc_log
done

[Stefan]

Hi Erman,

Do you have any experience with the frmxml2f.bat file ?

When converting a large/complicated (libraries attached, object groups,...) form, I get the following:


Oracle Forms 11.1 XML to Forms Tool
Copyright(c) 2001, 2011, Oracle and/or its affiliates.  All rights reserved.

Processing XML module CREMB001_fmb.xml
ERROR - an exception has been encountered:
null

C:\>

When converting a simple form (on table EMP) , it works.

Any idea?

Thanks

Stefan

[ErmanArslansOracleBlog]

Hi Stefan,

it seems there are no clues.. only a "null"

Send me the bat file, so that I can check it. Maybe I can modify it in a way to produce a debug output when it is executed.

2016-12-07 16:06 GMT+03:00 Stefan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi Erman,

Do you have any experience with the frmxml2f.bat file ?

When converting a large/complicated (libraries attached, object groups,...) form, I get the following:


Oracle Forms 11.1 XML to Forms Tool
Copyright(c) 2001, 2011, Oracle and/or its affiliates.  All rights reserved.

Processing XML module CREMB001_fmb.xml
ERROR - an exception has been encountered:
null

C:\>

When converting a simple form (on table EMP) , it works.

Any idea?

Thanks

Stefan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gscc-pll-and-custom-forms-files-tp1586p1697.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Stefan]

CONTENTS DELETED

The author has deleted this message.

[ErmanArslansOracleBlog]

Hi
I think your issue is caused by the Bug 4235887. At least the error produced becauase of that bug is similar to the error you are getting.
This bug is fixed in Forms 11.1.2.0

References:
Bug 4235887 : ERROR - AN EXCEPTION HAS BEEN ENCOUNTERED WITH IFXML2F90
Converting XML to FMB Fails When Subclassing Propertyclass Object Directly At the Form Module Level (Doc ID 311734.1)

So, can you try frmxml2f with Forms 11.1.2.0 or a higher Forms version..