FRM-41045:CANNOT FIND ITEM. INVALID ID WHEN ALTERING EFFECTIVE DATE

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=970799.1

Cause

APPSTAND.fmb latest version 12.0.6.12010000.2 (which supports non-Gregorian calendar) exists in 12.1.1. 
But Alter Effective Date form (DTXCGDAT) got complied with the old version 120.6 and that is causing the issue.

The following bug was logged for the customer

Bug 9080326 - !FRM-41045:CANNOT FIND ITEM. INVALID ID WHEN ALTERING EFFECTIVE DATE

Solution

 Please follow below steps and verify the issue:
 1) Connect to the instance using telnet or putty where the issue is  reproducible.
 .
 2) Take a backup of $DT_TOP/forms/US/DTXCGDAT.fmx and $DT_TOP/forms/AR/DTXCGDAT.fmx
 .
 3) Compile DTXCGDAT.fmb using the latest version of APPSTAND.fmb 
 (12.0.6.12010000.2) and copy this new DTXCGDAT.fmx to  $DT_TOP/forms/US/
 . 
 cd $AU_TOP/forms/AR
   frmcmp_batch.sh userid=apps/apps module=DTXCGDAT.fmb output_file=$DT_TOP/forms/AR/DTXCGDAT.fmx module_type=form batch=no compile_all=yes
cd $AU_TOP/forms/US/
   frmcmp_batch.sh userid=apps/apps module=DTXCGDAT.fmb output_file=$DT_TOP/forms/US/DTXCGDAT.fmx module_type=form batch=no compile_all=yes

 4) Bounce the apache and verify the issue.



Issue : 
when running : 

 frmcmp_batch.sh userid=apps/apps module=$AU_TOP/forms/AR/DTXCGDAT.fmb output_file=$DT_TOP/forms/AR/DTXCGDAT.fmx module_type=form batch=no compile_all=yes

if u get :

ORA-12154 TNS could not resolve the connect identifier specified - while compiling manually forms

sol : 

http://viniciuspapadba.blogspot.com/2012/10/ora-12154-tns-could-not-resolve-connect.html

if u get : 

FRM-18108: Failed to load the following objects.  Source Module:APPSTAND.fmb   Source Object: WHEN-NEW-ITEM-INSTANCE

sol : 

cd $AU_TOP/forms/AR/

and run : 

frmcmp_batch.sh userid=apps/apps module=$AU_TOP/forms/US/DTXCGDAT.fmb output_file=$DT_TOP/forms/US/DTXCGDAT.fmx module_type=form batch=no compile_all=yes