All posts by Masroof Ahmad

Fonts Demystified in Oracle Application 11i

“Your technical team is reporting that the report they developed in one font, when generated from oracle Applications automatically converts to another font.” The most common architecture which is deployed at customer place is the Oracle Applications server runs on UNIX flavours whereas client machine operates with Windows flavour. Generally developer uses windows machine installed […]

Read More

Oracle Adaptive Access Manager 10g R3 – Released, New Features

Oracle on 20th Oct. released new version (10g R3 /10.1.4.5) of Oracle Adaptive Access Manager  (Why OAAM version 10.1.4.5 is called as OAAM 10g R3 ?) A. Oracle Adaptive Access Manager (OAAM) is product for web access real-time fraud detection and multifactor online authentication. Main Functionality of OAAM is to protect against – Phishing – […]

Read More

How to update Workflow Administrator Role in Oracle Applications 11i/R12

If you want to see workflow details (owned by other users) or status diagram in Oracle Applications 11i/R12 then you should belong to one of responsibilities/user listed under WF_ADMIN_ROLE. By default (in 11i & R12) this role is set to user sysadmin (In old versions 11.5.8 or prior, it used to set to *) If […]

Read More

Recover an accidentally deleted file when the database is still open.

On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd . In the following example, we use […]

Read More

RAC Storage

Storage Options for RAC CFS (Cluster File System) – Easy to manage but only available on some platforms.  Does not address striping and mirroring. RAW – Available on all platforms but difficult to manage. Does not address striping and mirroring. NFS – Easy to manage but only available on some platforms.  Does not address striping […]

Read More

Custom Look and Feel (CLAF) in Apps 11i (Framework Pages)

This post covers overview of Custom Look and Feel (CLAF) in Self Service Pages (Oracle Apps 11i) and steps to troubleshoot look & feel related issues. . Custom Look and Feel functionality in 11i  Framework Pages 1.User type in username/password to login to Apps 11i 2. System checks value of profile option Oracle Applications Look and […]

Read More

Once again about MWA/MCSA

Well, this will be my start. Initally I planned a different topic for my first post. But with the recent talks about MWA/MCSA applications I can’t miss a chance to add my five cents to the subject. Autoconfig. In autoconfig-enbled environment configuration file mwa.cfg is written by autoconfig. So it would be good to modify […]

Read More

Embedding SQL in Shell

Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script. This is an example of how to pass database values into shell variables, and to make shell scripts more dynamic. This will help DBA to automate certain DBA tasks, also to setup some automation using […]

Read More

Oracle DB Vault Certified with E-Biz 11i

Oracle DBV with Apps 11i Oracle Database Vault restricts highly privileged users’ access and enforces separation of duty for Oracle EBusiness Suite environments. Regulations such as SarbanesOxley (SOX), Payment Card Industry (PCI), and the Healthcare Insurance Portability and Accountability Act (HIPAA) require strong internal controls to protect sensitive information such as financial, healthcare, and credit […]

Read More

R12 Changes from 11i

Overview of R12 Tech Stack Changes:- The mid tier technology had a boost up in R12, continual improvement with changing technology.  Here are the conversion of tech stack from 11i to R12. Application Server: 1.0    —->    10.1 Servlet Container: Jserv    —->    OC4J Apache: 1.3.19    —->    1.3.31 (or 2.0) Forms: 6    —->    10 What’s new in […]

Read More