Category Archives for Uncategorized
Oracle Mobile Supply Chain Applications
Mobile Supply Chain Applications allows you to perform common warehouse and shop floor transactions from any location in the manufacturing facility through the use of handheld devices. These include PDAs, handheld Radio Frequency (RF) units etc. This Application enables real-time interfaces to Oracle Applications through user interfaces. You can access the system from anywhere RF […]
Read MoreDeploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
Introduction This document describes the steps needed to replace the use of Oracle JInitiator with the Sun JRE Native Client in Oracle E-Business Suite 11i. This document also covers the procedure to upgrade the version of the Sun JRE Native Client being used in Oracle E-Business Suite 11i. Prerequisites JRE native plug-in is […]
Read MoreJinitiator 1.3 to be desupported for 11i on July 2009
As of July 31, 2009 Error Correction Support for JInitiator 1.3 will end. In other words, the Oracle Forms group will no longer issue bug fixes via new versions of JInitiator 1.3.x as of July 31, 2009. Metalink notes to upgrade You need to start the upgrade process for your end-users’ desktops to the native […]
Read MoreOracle Apex Architecture and configure Apex using embedded PL/SQL gateway
Apex (Application Express / earlier HTMLDB) : is web application development tool for Oracle Database. Components in Apex : Oracle Database, tables and PL/SQL code in database, Apex Engine, Oracle HTTP Server (optional from 11.1 database), PL/SQL gateway (from 10g EX or 11.1 and higher only) in place of Oracle HTTP Server Request flow in Apex […]
Read MoreIntegrate Oracle BI Server with LDAP Server (OID – Oracle Internet Directory)
In this post we are going to cover steps to integrate OBIEE with OID. By default BI users are stored locally and authenticate against BI Server. OBIEE support authentication via LDAP Server (OID, iPlanet, openldap server). . Integration of OBIEE with OID is required if 1. You wish to use OID as user repository for […]
Read MoreInterview Questions for Oracle Apps DBA’s (11i/R12) – Part 9
Few more Interview questions for Apps DBA’s Q. I am applying database patch using opatch. I don’t have oraInventory, can I apply database patch ? No, you can’t apply a database patch using opatch if Inventory is missing. Register ORACLE_HOME with global Inventory (in case inventory is missing) using steps mentioned here “3.6.2 Creating the Central […]
Read MoreUser Management in OBIEE using BI Administration Tool
This post covers managing users in Oracle Business Intelligence Server (OBIEE) using Security Manager in BI Administration Tool Security Manager – is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access. User Accounts can […]
Read MoreMigrating Oracle Applications 11i
Platform Migration of Oracle Applications Migrate Platforms with Oracle Applications 11i to Linux platform While migrating to a new platform, we must make sure that the new platform is certified/supported by Oracle for both the database and the Apps tiers, if migrating both. If migrating just one of the tier to the new platform, then […]
Read More
OBIEE – Step by Step Installation
On request from readers, I am posting step by step installation of Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.X on windows (you can use same steps to install OBIEE on Linux) . Things good to know about OBIEE Installation i) Siebel Analytics from Siebel (acquired by Oracle) is now called as OBIEE (Oracle Business Intelligence […]
Read MoreHow to generate FRD trace
The steps I have followed :- 1. Login as oracle application user 2. Go to $FND_TOP/secure 3. java oracle.apps.fnd.security.AdminAppServer apps/ \AUTHENTICATION ON DBC= Please check the below example :- 4. java oracle.apps.fnd.security.AdminAppServer apps/ffdev21 \AUTHENTICATION ON DBC=ffus.com_ffus.dbc Output will be :- AUTHENTICATION ON executed successfully – ffus.com_ffus.dbc 5. In the command prompt echo $FORMS60_TRACE_PATH It will […]
Read More