Category Archives for Uncategorized
How to create user for Read only responsibilites in frontend apps
Steps mentioned below are to create User with Read Only Responsibility and require fair amount of development knowledge 1. Go to $Au_TOP/resource. 2. Copy CUSTOM.pll and open the file in Form builder. 3. If you will open the package body of CUSTOM.pll in the forms builder then you will find the like below : procedure […]
Read MoreVerify CBO stats and Database initalization parameters for 11i
In order to get better performace of the database , we usually schedule Apps Gather schema . Oracle provide very important tool/script to verify the CBO stats . bde_last_analyzed.sql :-verifies the CBO statistics in the data dictionary for all tables, indexes, and partitions. It also validates the statistics on tables and indexes owned by ‘SYS’. This […]
Read MoreStarting Concurent Managers
While teaching in class students told me that they have posted journal entries and the transaction still remains pending even though i have run script ‘./adstrall.sh’ which by default start all the application tier. drilling down i notice that some concurent managers were not started. to solve this ask my student to Alternatively try the […]
Read MoreClient System Analyzer for Oracle E-Business Suit
In my last post i did not cover about this tool(CSA) , i found this tool is very interseting and trying to share some of the points. Performance issues and other problems can arise if your computer is not optimally configured. To enable the diagnosis (and prevention) of such problems, the Client System Analyzer allows […]
Read MoreOracle E-business Suit Network Utilities
Performance issue is one of the most frustrating things in any application . Being a DBA if anything regarding to perfomrace, it comes to us . It is one of the critical task for DBA to make sure that Application is performing as per end users expectation. It is really very complicated to reslove those […]
Read MoreOracle 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 MoreCustom 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 MoreMobile Web Application Tips
With reference to the article in our web site about Mobile Supply chain , I am trying to nail down some of the problem and configuration about MWA , which take care by DBA . This tips can be followed Mobile apllication Server version 11.5.5 to 11.5.10.X One of the important configuration file for the […]
Read MoreOracle 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 MoreOracle Application Management Pack for Oracle E-Business Suite, Release 2.0
Oracle E-Business Suite Application Technology Group (ATG) is pleased to announce the availability of the Application Management Pack for Oracle E-Business Suite (EBS) version 2.0.2 Rollup update. Oracle strongly recommends that you apply the latest release, 2.0.2. Oracle application Management Pack 2.0.2 Application Management Pack 2.0.2 (Patch 6809246 ) is an OPatch rollup update […]
Read More