Upgrade to EBS 12.2 - Using GSCC.pl

[ANIETO]

Hi Erman. I hope you are very well.

In our upgrade 12.1.3 to 12.2.10

We are using GSCC.pl with frmcmp_batch to check our filesystem objects (forms, reports etc..) for ensuring that they are compatible with the new EBS release, but frmcmp_batch does not generate (in .fmt)  the content of triggers and program units. In your experience, what other option do we have?

Other question is What is the best alternative to perform mass replacement of strings in forms and reports?

Thanks for your help.

[ErmanArslansOracleBlog]

1)If you can't generate fmt files, please check frmcmp?  -- currently I can not check it on my own system due to some connection problems..

frmcmp module=<form_name> userid=<username>/<password>@<DBalias> parse=YES batch=yes window_state=minimize

References:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/gscc-pll-and-custom-forms-files-td1586.html
How to Generate the Contents of Forms Modules in Text Format (Doc ID 2288249.1)
Batch Compile Script for Forms, Libraries, Menus, Reports and Conversion between Binary and Text (Doc ID 955143.1)

2)As for mass replacement of strings, you need write a good script.. But first, you need to be sure that the things that you want to update is in place , reachable for you..
Try with frmf2xml... That xml format may help you... I mean, if you can see the things that you need in the generated xml file, then you can write a script for the replacement and recompilation..

Programming is required in any case ..

Also check -> frmjdapi

Sample Code JDAPI: change Font for all Items, Prompts, Boilerplates, Frames (Doc ID 452705.1)
How to Change Maxlength and Datatype of a the Same Forms Item in Multiple Oracle Forms Using the JDAPI (Doc ID 1554061.1)
https://stackoverflow.com/questions/37465186/oracle-11g-reports-and-forms-properties-mass-updates

Note that, we are going in the Oracle Forms world (leaving the EBS world in these type of works, so you may push the limits a little bit :)

Sample Code JDAPI: change Font for all Items, Prompts, Boilerplates, Frames (Doc ID 452705.1)

[ANIETO]

Thank you Erman, you are great.