Query to find invoices unmatched to purchase order select * from ap_invoices_all ...
Post
Oraask Latest Articles
Post
Oracle XML Publisher – Complete guide
Oracle XML Publisher – Complete guide
1 mins read
Oracle XML Publisher – Complete guide this guide will help you to know the basics of xml publisher and how to use it ...
Post
Query to get all employees which has supervisors only
Query to get all employees which has supervisors only
1 mins read
Query To get all Employees which has Supervisors only select ppf.full_name emp_name, ppf1.full_name supervisor_name from per_all_people_f ppf, per_all_assignments_f paaf, per_all_people_f ...
Post
where can use $FLEX$ and $PROFILES$ ? What the benefits from ? many examples
where can use $FLEX$ and $PROFILES$ ? What the benefits from ? many examples
5 mins read
What is $FLEX$ and $PROFILES$ ? Where are they used? many examples :
$FLEX$ and $PROFILES$ are Special Variables in oracle Apps environment and are used to hold values at runtime.
Every Oracle Apps technical consultant will be familiar with the term $FLEX$ and $PROFILES$. Whenever we are working with value sets, we will be using both of these for modifying the data fetched, for basing the values of a parameter on the other parameter and also fetching the Profile Option values
You may also interested in article How to Create Profile Option in Oracle APPS.
To segregate this based on the functionality
$FLEX$: Used for basing the value of a parameter on another parameter.
$PROFILES$: used for fetching the data stored in the specified profile option value which is currently active.
Where is it used?
Post
Using FND_GLOBAL.APPS_INITIALIZE to initializing session in Oracle EBS
Using FND_GLOBAL.APPS_INITIALIZE to initializing session in Oracle EBS
1 mins read
FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API's in Oracle E-business Suite. ...
Post
AIM Documents (MD50, MD70 and MD120) Templates – Download now
AIM Documents (MD50, MD70 and MD120) Templates – Download now
1 mins read
AIM (Application Implementation Methodology) Documents MD50, MD70 and MD120 are part of AIM documents. Set of principles and guidelines ...
Post
FND_GLOBAL and FND_PROFILE: Import List of System Global values
FND_GLOBAL and FND_PROFILE: Import List of System Global values
3 mins read
We can find values of System global values using FND_PROFILE and FND_GLOBAL
FND_PROFILETo 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 the profile cache) is terminated.
FND_PROFILETo 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 the profile cache) is terminated.
Post
The List Of Oracle Ebs HRMS Tables
The List Of Oracle Ebs HRMS Tables
1 mins read
The List Of Oracle Ebs HRMS Tables : ================ FlexField Information Tables :
Post
Query to get all employees and their supervisors (id,name)
Query to get all employees and their supervisors (id,name)
1 mins read
Query to get all employees and their supervisors (id,name) : select distinct papf1.full_name emp_name ...
Post
Query to Get User name and related assigned responsibilities with applications can access
Query to Get User name and related assigned responsibilities with applications can access
1 mins read
Query to Get User name and related assigned responsibilities with applications can access : select distinct ...