Document: Oracle
E-Business Suite Release 12.2.9 Readme
(Doc ID 2495027.1)
Solutions of Errors 12.2.9 Patch
############################ ERROR############################
ERROR at line 1: ORA-06501: PL/SQL: program error ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891 ORA-06512: at line 1
################### SOLUTION 1 ########################
Patch 24354016: APPS.HR_API_USER_HOOKS_UTILITY ERRORS DURING UPGRADE TO 12.2.0
Peaddasd.sql error when applying 21900901 (Doc ID 2301823.1)
SR: Provide the Solution Skipe this worker.
[oracle@upgebs ~]$ cd /u01/applmgr/upg/
[oracle@upgebs upg]$ source EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/applmgr/upg/fs1/EBSapps/appl
PATCH File System : /u01/applmgr/upg/fs2/EBSapps/appl
Non-Editioned File System : /u01/applmgr/upg/fs_ne
DB Host: upgebs.hinopak.com Service/SID: DELL
Sourcing the RUN File System ...
[oracle@upgebs sql]$ sqlplus apps/apps
SQL> BEGIN hr_api_user_hooks_utility.clear_hook_report; END;
2 /
PL/SQL procedure successfully completed.
##################### SOLUTION 2 ##################
##### Peaddasd.sql error when applying 21900901 (Doc ID 2301823.1) #####
1. The job can be skipped by using hidden option 8 in adctrl to skip the failed worker
2. Once the patch is applied, please check if the package HR_PERSON_ADDRESS_BK3 is valid.
select owner,object_name, object_type,status from dba_objects
where object_name = 'HR_PERSON_ADDRESS_BK3';
3. Run peaddasd.sql manually.
$ cd $PER_TOP/patch/115/sql/
$ sqlplus apps/apps
SQL> @peaddasd.sql
####################### ERROR #####################
[oracle@upgebs collect]$ /u01/applmgr/upg/fs1/EBSapps/appl/fnd/12.0.0/bin/fdfcmp apps 0 Y K N
ORACLE Password:
Log filename : L484721.log
Report filename : O484721.out
[oracle@upgebs collect]$ vi O484721.out
[oracle@upgebs collect]$ vi L484721.log
ADWORKER001.log
---------------------------------------------------------
Application Id: 800
Short Name: PER
Name: Human Resources
Flexfield Code: CMP
Name: Competence Flexfield
Structure Num: 50370
Code: PENSION_COMPTENCE_FLEXFIELD
Name: Pension Competence Flexfield
Compilation aborted for current key flexfield...
APP-FND-00668: The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = CMP and Structure number = 50370 (APPID=800)
FDFBKS: REQUIRED constraint specified for the Default Attribute qualifier is not satisfied
######################### SOLUTION##########################
How To Solve Compiling Competence Flexfield APP-FND-00668 Error ? (Doc ID 473554.1)
Unable to add segments to Competence flexfield - Error "APP-FND-00668: The data that defines the flexfield on this field may be inconsistent" (Doc ID 2571696.1)
Solution from SR request:
To implement the solution, please execute the following steps:
1. Skip the Failed worker
2. After the upgrade completes:
SELECT ID_FLEX_STRUCTURE_CODE from fnd_id_flex_structures
where ID_FLEX_NUM= 50370
3. Navigation: System Administrator
4. > Application > Flexfield > Key > Segments > Competence Flexfield
Unfreeze your structure and set the attribute "Default Attribute" for one segment.
5.. Retest the issue.
6 Migrate the solution as appropriate to other environments. (suggestion is to make the flexfield correction prior to upgrade to avoid the error)
Note: Must Fix Before Apply 12.2.9 RUB Patch.
Step -1 Source the run edition applications environment
$ cd /u01/applmgr/upg/
$ source EBSapps.env run
Step -2 Stop Oracle WebLogic Server's Admin Server and Node Manager Services.
Note: To apply a patch in downtime mode, you must shut down all application tier services, including the Oracle WebLogic Server Admin Server and Node Manager.
A- Stop the Oracle WebLogic Server Admin Server on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
Enter the WebLogic Admin password: Oracle_123
Enter the APPS Schema password: apps
B- Stop the Oracle WebLogic Server Node Manager Service on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Enter the WebLogic Admin password: Oracle_123
C- OR we can stop all application serveries
$ sh $ADMIN_SCRIPTS_HOME/adstpall.sh
Enter the APPS username: apps
Enter the APPS password: apps
Enter the WebLogic Server password: Oracle_123
Step -3 Apply Oracle E-Business Suite 12.2.9 Release Update Pack Patch 28840850 on the run edition application environment, using downtime mode.
$ adop phase=apply apply_mode=downtime patches=28840850
Enter the APPS password: apps
Enter the SYSTEM password: manager
Enter the WebLogic Server password: Oracle_123
Step -4 Start all application tier services on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
Enter the APPS username: apps
Enter the APPS password: apps
Enter the WebLogic Server password: Oracle_123
Step -5 Perform adop cleanup action.
$ adop phase=cleanup
Enter the APPS password: apps
Enter the SYSTEM password: manager
Enter the WLSADMIN password: Oracle_123
Step -6 Synchronize file systems
Note: Synchronize the file systems using the command shown below. This action will copy the new run edition code and configuration to the other file system, to ensure that both file systems are in sync before applying patches using the regular adop cycle on the other file system.
$ adop phase=fs_clone
Enter the APPS password: apps
Enter the SYSTEM password: manager
Enter the WLSADMIN password: Oracle_123
Step -7 Post-Update Steps
$ adop
phase=apply patches=28840900 hotpatch=yes
Enter the APPS password: apps
Enter the SYSTEM password: manager
Enter the WebLogic Server password: Oracle_123
No comments:
Post a Comment