FRM-40833 AND FRM-40735 ERRORS WHEN TRYING TO OPEN ANY FORMS AFTER UPGRADE FROM 12.2.4 TO 12.2.8
Posted by mohammedskhan on Aug 09, 2021; 8:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/FRM-40833-AND-FRM-40735-ERRORS-WHEN-TRYING-TO-OPEN-ANY-FORMS-AFTER-UPGRADE-FROM-12-2-4-TO-12-2-8-tp10060.html
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