Find Installed Modules in Oracle E-Business Suite R12

Using SQL Query:

SELECT a.application_name,a.product_code, DECODE (b.status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘N/A’) status,patch_level FROM apps.fnd_application_vl a, apps.fnd_product_installations b WHERE a.application_id = b.application_id and b.status=’I’ order by product_code asc;

Fatal Error: TXK Install Service occurred on rapidwiz install R12.2 start CD 51 at step-1 of the database install

SYMPTOMS:

On Oracle Applications 12.2, the following: Fatal Error: TXK Install Service occurred on rapidwiz install R12.2 start CD 51 at step-1 of the database install:

Fatal Error: TXK Install Service

oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=253 See log for details. CMD= /u01/stage/stage_R122_51/TechInstallMedia/database/examples/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent -responseFile /u01/ora_prod/PROD/12.1.0/temp/PROD_erpnode1/cfgHome/response/DB_HOME/txkDB12cR1_12102_examples.rsp

  at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:160)

  at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)

  at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)

  at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)

  at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)

  at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)

  at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)

  at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)

  at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)

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

In logfile:

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

INFO: -----------------------------------------------

INFO: Verification Result for Node:erpnode1

INFO: Expected Value:x86_64

INFO: Actual Value:x86_64

INFO: -----------------------------------------------

INFO: *********************************************

INFO: OS Kernel Version: This is a prerequisite condition to test whether the system kernel version is at least "2.6.39".

INFO: Severity:CRITICAL

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -----------------------------------------------

INFO: Verification Result for Node:erpnode1

INFO: Expected Value:2.6.39

INFO: Actual Value:2.6.32-100.34.1.el6uek.x86_64

INFO: Error Message:Kernel of proper version is not found on node "erpnode1" [Expected = "2.6.39" ; Found = "2.6.32-100.34.1.el6uek.x86_64"]

INFO: Cause:Cause Of Problem Not Available

INFO: Action:User Action Not Available

INFO: -----------------------------------------------

SOLUTION:

1. Edit both staging files for database:

 - Oracle RDBMS

location: <stage_area>/TechInstallMedia/database/database/stage/cvu/cvu_prereq.xml

 - Oracle Examples

location:<stage_area>/TechInstallMedia/database/examples/stage/cvu/cvu_prereq.xml

2. Modify the value of kernel value in prerequisites check file from 2.6.39 to 2.6.32 and save.

3. Retry the installation.

Reference Doc: Rapidwiz Install R12.2 Start CD 51 Fails With Fatal Error: TXK Install Service in Database Pre-install Checks (Doc ID 2155494.1)