How to Compile CUSTOM.pll in 11i and R12? FRM-40735: ON-ERROR trigger unhandled exception ORA-06508

Location
--------------
CUSTOM.pll is under $AU_TOP/resource


Use following Command as per your environment

For R12
frmcmp_batch module=CUSTOM.pll userid=apps/<apps_password> output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special

For 11i
f60gen module=$AU_TOP/resource/CUSTOM.pll userid=apps/apps
module_type=LIBRARY module_access=FILE
compile_all=YES output_file=$AU_TOP/resource/CUSTOM.plx

Issue -     FRM-40735: ON-ERROR trigger unhandled exception ORA-06508

Cause -      CUSTOM.pll is changed or got corrupted 

Solution -
1. Change the directory to $AU_TOP/resource
2. Restore the last Working CUSTOM.pll and compile it using the above mentioned command.
3. It will generate CUSTOM.plx (Both should be under $AU_TOP/resource)
4. Retest the issue.

FNDLOAD Usage in R12

FORM Definition download in R12

========================================================================

Download

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt> FUNCTION FUNCTION_NAME="xx_function_name"

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <xxaoa_file_name.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt FUNCTION FUNCTION_NAME=<function_name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt FORM FORM_NAME=<form_name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <xxaoa_file_name.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>

Upload (with force mode)
$FND_TOP/bin/FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt> - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Upload (normal mode)
$FND_TOP/bin/FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt>

FORM Compilation in R12.2/R12

========================================================================

frmcmp.sh module=<form.fmb> userid=<userid>/<password> module_type=form batch=yes compile_all=yes

OR

frmcmp_batch module=<form.fmb> userid=<userid>/<password> module_type=form batch=yes compile_all=yes

Menu Definition Download in R12

========================================================================

Download
FNDLOAD <userid>/<password>@TEST 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt> MENU MENU_NAME="INV_NAVIGATE"

Upload
FNDLOAD <userid>/<password>@UAT 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt>

REQUEST GROUPS

========================================================================

Download
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <xxaoa_file_name.ldt> REQUEST_GROUP REQUEST_GROUP_NAME='HMC SHRMS Benefit Admin Reps'

Upload
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <xxaoa_file_name.ldt>

BI PUBLISHER

========================================================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=hostname.domain)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=hostname) (INSTANCE_NAME=SID)))' -LOB_TYPE TEMPLATE -LOB_CODE <xx_code> -APPS_SHORT_NAME PER -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE log.txt

CONCURRENT PROGRAM

========================================================================

Download
FNDLOAD <userid>/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <xx_conc.ldt> PROGRAM APPLICATION_SHORT_NAME='PER' CONCURRENT_PROGRAM_NAME='<xx_conc>'

Upload
FNDLOAD <userid>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <xx_conc.ldt>

LOOKUP

========================================================================

Download
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct <xx_lookup.ldt> FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='AU' LOOKUP_TYPE='XX_LOOKUP'

Upload
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct <xx_lookup.ldt>

========================================================================

ORA -28040 no matching authentication protocol

Effect - JDeveloper/FormBuilber/ReportBuilder are not able to connect database(12c only)

Solution -

1) cd $ORACLE_HOME (Database)

2) cd network/%SID%/admin

3) vi sqlnet.ora

add following parameters
SQLNET.ALLOWED_LOGON_VERSION_server=8
SQLNET.ALLOWED_LOGON_VERSION_client=8

4) Retest the issue