To look at the source code a formula function i.e. if you want to determine the logic used to return the value concerned you can do the following 1. Establish the defintion name held in the...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
This tutorial shows you how to identify sensitive data, select appropriate mask formats for the sensitive fields, apply the mask and then replace the sensitive fields in the production version. Time...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
here are some tables in oracle apps (AD tables especially) involved when applying patches. Some of them are very useful when we need specific information about patch already applied. I will show the...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
We have 2 types of audit in Oracle Applications : 1) Audit users who sign on to Oracle Applications 2) Audit changed data in database In this post I’m going to write about the first audit and...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
The AuditTrail enable us to know who, when and what was changed on each table we would like to audit. For example: Some of the profiles in Oracle Applications are very critical and important for...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Almost every website that uses username & password have a "forget password" functionality to retrieve users passwords, and so also the Oracle E-Business Suite. This is a very useful...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
This process can be used to trace any action, anywhere in Oracle Applications and be very useful for the Self-Service Web Applications as there is no utility defined like in the Forms. a. First make...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
1. Create UNIX Shell script using naming convention filename.prog 2. Place in the custom PRODUCT_TOP/bin directory- 3. Set protection on the Host Program 4. Link with program fndcpesr: Ex: link -s...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Use the Transfer Alert Definitions window to transfer an alert definition to another database, or make a copy of an existing alert. To transfer or copy an alert definition, first using Alert Manager...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
What does the Account Generator process do? The Account Generator process builds charge, budget, accrual, and variance accounts for each purchase order, release, and requisition distribution based on...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]