Category Archives: Oracle Apps Basics

Some times we see a message “Low-level Diagnostic Logging is turned on. This may temporarily reduce performance” which slow downs the application response time. This is due to enabling low level logging profile option feature to debug some issue. We can disable the profile option with below steps : 1. Navigate to System Administrator responsibility… Read More »

Before reading this post, if you are new to Multi Org and MOAC then read: MOAC – Oracle Apps ORG_ID, Multi Org Concept What is MO_GLOBAL.INIT ? MO_GLOBAL.INIT will read the “MO: Operating Unit” and “MO: Security Profile” profile option values from the current context (responsibility/user) and will initialize access to Multiple Organizations. How does… Read More »

It would be tiresome for most of us to debug issues especially in extensions when we have no clue of flow of process execution and also the values of variables in intermittent stages. Debugging becomes more complex when most of custom logic is in huge pl/sql scripts. Today in this article I will show how… Read More »

Who is a Functional Consultant? A role of functional consultant involves in understanding the client’s business process, requirements and mapping to the Oracle EBS system as best as possible. If gaps are identified between the requirements and Oracle EBS system, the functional consultant with the help of Technical architect should suggest solutions. Role of a… Read More »

We can find values of System global values using FND_PROFILE and FND_GLOBAL FND_PROFILE To manipulate values stored in client and server user profile caches.Any changes you make to profile option values using these routines affect only the run-time environment. The effect of these settings end when the program ends, because the database session (which holds… Read More »

AIM (Application Implementation Methodology) Documents Oracle A.I.M. Methodology encompasses a project management methodology with documentation templates that support the life cycle of an implementation. The life cycle methodology and documentation templates allows A.I.M. to be a very useful tool for managing implementation projects successfully. MD50, MD70 and MD120 are part of AIM documents. MD50: This… Read More »

We can use the same fnd_request.submit_request API which we use to submit a program for scheduling a program too. The only difference is the value passed to the parameter “start_time“. Usually while submitting a concurrent program form backend we pass ‘sysdate’ as value to the parameter “start_time” but to schedule a program we just need… Read More »

This is yet another post for Oracle Apps beginners! Difference 1 Value sets can be attached to parameters of a concurrent program or to a DFF segments where as Lookups are attached only to the fields of a Form/Page Difference 2 Lookups can be maintained by end users where as Value Sets are almost never… Read More »

This is a common question for a every fresher. To help them, here in this post I have summarized in few points which I am aware of. Role of a Technical Consultant in a Support Project: Triage tickets, if it is related to you, take it to your queue and update it with necessary information… Read More »