FRM-40833 AND FRM-40735 ERRORS WHEN TRYING TO OPEN ANY FORMS AFTER UPGRADE FROM 12.2.4 TO 12.2.8

[mohammedskhan]

FRM-40833 AND FRM-40735 ERRORS WHEN TRYING TO OPEN ANY FORMS AFTER UPGRADE FROM 12.2.4 TO 12.2.8

Tried to recompile the forms and pll files using adadmin adn found the errors multiple times below in all the adworkers logs.
The following Oracle Forms objects did not generate successfully:

fa      forms/AR        FAXLPEAP.fmx
fa      forms/AR        FAXLSDET.fmx
pa      forms/AR        PAXINBGR.fmx
pa      forms/AR        PAXREDRL.fmx
pa      forms/AR        PAXINRVW.fmx
pa      forms/AR        PAXTRAPE.fmx
pa      forms/AR        PAXPREPR.fmx
per     forms/AR        PERJPDEP.fmx
pay     forms/AR        PAYAUSOE.fmx
pay     forms/AR        PAYKRYER.fmx
pay     forms/AR        PAYKRTAX.fmx
pay     forms/AR        PAYKRYEA.fmx
pay     forms/AR        PAYWSLEE.fmx
pay     forms/AR        PAYWSDPG.fmx
inv     forms/AR        INVKBPSQ.fmx
inv     forms/AR        INVRSVF1.fmx
inv     forms/AR        INVTVPTX.fmx
inv     forms/AR        INVIDITM.fmx
eng     forms/AR        ENGFDECN.fmx
cs      forms/AR        CSXSRHIS.fmx
cs      forms/AR        CSXSRTAB.fmx
ce      forms/AR        CESTAND.fmx
ce      forms/AR        CEXTRXCD.fmx
ce      forms/AR        CEXCABMR.fmx
je      forms/AR        JEITAPXL.fmx
ja      forms/AR        JAINTDST.fmx
cs      forms/AR        CSXSRISR.fmx
gmd     forms/AR        GMDQPLAN.fmx
gmd     forms/AR        GMDSPDSH.fmx
ast     forms/AR        ASTRCALL.fmx
csc     forms/AR        CSCCCCRC.fmx

*********************************************************
Generating Oracle Forms files...

  Temporarily resetting FORMS_PATH to:
  "D:\oracle\TEST\fs1\EBSapps\appl\au\12.0.0\resource;D:\oracle\TEST\fs1\EBSapps\appl\au\12.0.0\forms\AR;D:\oracle\TEST\fs1\EBSapps\appl\au\12.0.0\resource\AR"

Generating form "forms\AR\CSCCCCRC.fmx" with command:

D:\oracle\TEST\fs1\EBSapps\10.1.2\bin\frmcmp.exe module=D:\oracle\TEST\fs1\EBSapps\appl\au\12.0.0\forms\AR\CSCCCCRC.fmb output_file=D:\oracle\TEST\fs1\EBSapps\appl\csc\12.0.0\forms\AR\CSCCCCRC.fmx module_type=form batch=yes compile_all=special

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.
ERROR generating form "forms\AR\CSCCCCRC.fmx" from input file
D:\oracle\TEST\fs1\EBSapps\appl\au\12.0.0\forms\AR\CSCCCCRC.fmb

*********************************************************

Compiling POST-INSERT trigger on B_REF_DESIG data block...
Compilation error on POST-INSERT trigger on B_REF_DESIG data block:
PL/SQL ERROR 306 at line 5, column 1
wrong number or types of arguments in call to 'INSERT_RELATED_REF_DESG'
PL/SQL ERROR 0 at line 5, column 1
Statement ignored

Need support to resolve the issue below, Have an Oracle SEV 1 SR open for over a month now but still not able to reslove the issue.

Thank you
Khan

[ErmanArslansOracleBlog]

It seems like your fmb code is inconsistent with the db code..
It is obvious actually.. We have a "wrong number or types of arguments in call" .. This makes me directly think that..

What is the version of the fmb-fmx --CSCCCCRC

Also run the following command manually and send me the output;

D:\oracle\TEST\fs1\EBSapps\10.1.2\bin\frmcmp.exe module=D:\oracle\TEST\fs1\EBSapps\appl\au\12.0.0\forms\AR\CSCCCCRC.fmb output_file=D:\oracle\TEST\fs1\EBSapps\appl\csc\12.0.0\forms\AR\CSCCCCRC.fmx module_type=form batch=yes compile_all=special

Also send me description/spec of INSERT_RELATED_REF_DESG ...

[mohammedskhan]

Running the command below, opened the oracle forms compiler application with different prompts and nothing happened.

Screenshots attached.

[mohammedskhan]

[mohammedskhan]

$Header: CSCCCCRC.fmb 120.85.12020000.12 level:1 2013/11/28 02:00:07 pkm ship

[ErmanArslansOracleBlog]

Well, this is not documented but these type of CS related errors are usually fixed by applying patches.
It may be useful to check the code of the stored procedure that the fmx is calling incorrectly, but you didn't send me that..

Anyways, consider applying 12.2.6-12.2.8 :BUG FIXES FOR CS:MAY'19 RUP ...