Skip to main content

Posts

Showing posts with the label Oracle E-Business Suite

Oracle E-Business Suite Password Management using FNDCPASS

Oracle E-Business Suite Password Management: Before changing the APPS password using the FNDCPASS utility: Take backup of table FND_USER and FND_ORACLE_USERID . " alter user " command is not supported and should not be used for changing the apps password in any case. Always use FNDCPASS to change the APPS password. Check FNDCPASS log for any kind of error. If there is any error in the FNDCPASS log, then DO NOT run autoconfig or try to change configuration file manually. Until and unless FNDCPASS log has no error,  do not run autoconfig as you will get problem while logging in oracle application. If there is and error in the FNDCPASS log, then either restore table  FND_USER and FND_ORACLE_USERID to log into Applications or open SR to support with the FNDCPASS log. If you are on Oracle E-Business Suite Release 12.1 or 12.2 , ensure that your sqlnet_ifile.ora has the line SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter SEC_CASE_SEN...
Post a Comment
Read more

Oracle E-Business Suite Scripts

Oracle E-Business Suite scripts: AutoConfig Scope and Components: 1. In Release 12.2 application tier is AutoConfig-enabled. 2. Applications context file location - INST_TOP as <INST_TOP>/appl/admin/<CONTEXT_NAME>.xml 3. The Release 12.2 database tier created via Rapid Install is also AutoConfig-enabled. 4. Database context file location - RDBMS ORACLE_HOME as <RDBMS_ORACLE_HOME>/appsutil/<CONTEXT_NAME>.xml AutoConfig components: Applications context - An XML repository located in the INST_TOP that contains information specific to the APPL_TOP.  Database context - An XML repository located in the RDBMS ORACLE_HOME that contains information specific to that database tier.  AutoConfig template files - Files containing named tags that are replaced with instance-specific information from the appropriate context, in the process of instantiation.  AutoConfig driver files - Every Oracle E-Business Suite product maintains ...
Post a Comment
Read more

Oracle E-Business Suite

Oracle E-Business Suite technology layer include: Oracle Applications DBA (AD) Oracle Application Object Library (FND) Oracle Applications Utilities (AU) Oracle Common Modules (AK) Oracle Workflow (WF) Oracle Alert (ALR) Oracle Application Framework (FWK) Oracle XML Publisher (XDO) E-Business Suite Services - Concurrent Managers and Workflow Mailers. Services are composed of one or more processes that must be kept running for the proper functioning of the applications. With Service Management , the Internal Concurrent Manager (ICM) manages the various service processes across multiple hosts. Service processes are very much like concurrent manager and transaction manager processes. Oracle Applications Manager can be used for a wide variety of tasks such as administering services including concurrent managers, examining system configuration, managing Oracle workflow, examining applied patches, and measuring system usage. E-business suite Concurrent programs: 01. Executes programs in b...
Post a Comment
Read more

Oracle E-Business Suite Patching using adop

Following description about Oracle E-Business Suite is high level and from documentation https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm#5281339 for in depth and detail description refer it.   E- Business Suite patching: Oracle E- Business Suite technology layer include: AD - Oracle Applications DBA (AD) FND - Oracle Application Object Library (FND) AU - Oracle Applications Utilities (AU) AK - Oracle Common Modules (AK) WF - Oracle Workflow (WF) ALR - Oracle Alert (ALR) FWK - Oracle Application Framework (FWK) XDO - Oracle XML Publisher (XDO) RUP - Release update pack (RUP) TXK - EBS 12.2 technology stack (TXK) and Applications Database (AD) components CPU - Critical Patch Updates PSUs - Patch set updates ATG - Application technology group PAA - Oracle Patch Application Assistant OAM - Oracle Applications Manager Patch files Structures: The README.txt or README.html file describes what the patch does. Driver File - u<patchnum>.drv, contains...
Post a Comment
Read more

Oracle E-Business Suite Daily SQL Statements

Oracle E-Business Suite Daily SQL: Current version: SELECT RELEASE_NAME FROM APPS.FND_PRODUCT_GROUPS; Find out application server information from database server:   column name format a20 SELECT NAME, NODE_ID, SERVER_TYPE FROM APPS.FND_APP_SERVERS; NAME                                     NODE_ID       SERVER_TYPE --------------------                      ----------          ------------------------------ <hostname>_EBSDEV_APPS      10113            APPS <hostname>_EBSDEV_DB          10112...
Post a Comment
Read more

Oracle E-Business Suite FND Application Tables

Oracle E-Business Suite Application Tables: APPLSYS FND_APPLICATION APPLSYS FND_APP_SERVERS_U2 APPLSYS FND_APPLICATION_S APPLSYS FND_APPLICATION_SERVERS APPLSYS FND_APPLICATION_SERVERS# APPLSYS FND_APPLICATION_SERVERS_U1 APPLSYS FND_APPLICATION_SERVERS_U2 APPLSYS FND_APPLICATION_TL APPLSYS FND_APPLICATION_TL# APPLSYS FND_APPLICATION_TL_U1 APPLSYS FND_APPLICATION_TL_U2 APPLSYS FND_APPLICATION_U1 APPLSYS FND_APPLICATION_U3 APPLSYS FND_APPL_SESSIONS APPLSYS FND_APPL_SESSIONS# APPLSYS FND_APPL_SESSIONS_N1 APPLSYS FND_APPL_SESSIONS_N2 APPLSYS FND_APPL_TOPS APPLSYS FND_APPL_TOPS# APPLSYS FND_APPL_TOPS_U1 APPLSYS FND_APPL_TOPS_U2 APPLSYS FND_APPS_SYSTEM APPLSYS FND_APPS_SYSTEM# APPLSYS FND_APPS_SYSTEM_U1 APPLSYS FND_APPS_SYSTEM_U2 APPLSYS FND_APP_SERVERS APPLSYS FND_APP_SERVERS# APPLSYS FND_APP_SERVERS_U1 APPLSYS FND_APPLICATION# APPLSYSPUB FND_APPLICATION APPLSYSPUB FND_APPLICATION_TL APPLSYSPUB FND_APPLICATION_VL APPS FND_APPFLDR APPS FND_APPLICATION_TL= APPS FND_APPLET_LAUNCHER APPS FND_AP...
Post a Comment
Read more

Oracle E-Business Suite FND product tables

Oracle E-Business Suite FND product tables: APPLSYS FND_PRODUCT_DEPENDENCIES APPLSYS FND_PRODUCT_DEPENDENCIES# APPLSYS FND_PRODUCT_INSTALLATIONS_PK APPLSYS FND_PRODUCT_INSTALLATIONS# APPLSYS FND_PRODUCT_INSTALLATIONS APPLSYS FND_PRODUCT_INIT_DEPENDENCY_U1 APPLSYS FND_PRODUCT_INIT_DEPENDENCY# APPLSYS FND_PRODUCT_INIT_DEPENDENCY APPLSYS FND_PRODUCT_INIT_CONDITION_U1 APPLSYS FND_PRODUCT_INIT_CONDITION# APPLSYS FND_PRODUCT_INIT_CONDITION APPLSYS FND_PRODUCT_INITIALIZATION_U1 APPLSYS FND_PRODUCT_INITIALIZATION# APPLSYS FND_PRODUCT_INITIALIZATION APPLSYS FND_PRODUCT_GROUPS# APPLSYS FND_PRODUCT_GROUPS APPLSYS FND_PRODUCT_DEPENDENCIES_U1 APPLSYSPUB FND_PRODUCT_GROUPS APPLSYSPUB FND_PRODUCT_INSTALLATIONS APPS FND_PRODUCT_INIT_DEPENDENCY APPS FND_PRODUCT_INIT_CONDITION= APPS FND_PRODUCT_INIT_CONDITION+ APPS FND_PRODUCT_INIT_CONDITION APPS FND_PRODUCT_INITIALIZATION_PKG APPS FND_PRODUCT_INITIALIZATION_PKG APPS FND_PRODUCT_INITIALIZATION= APPS FND_PRODUCT_INITIALIZATION+ APPS FND_PRODUCT_INITIALIZ...
Post a Comment
Read more