Showing posts with label AOL. Show all posts
Showing posts with label AOL. Show all posts

How to Upload Data into FND_LOOKUP_VALUES Using Oracle R12 API

›
SET SERVEROUTPUT ON SIZE 1000000 SET ECHO OFF SET VERIFY OFF SET DEFINE "~" SET ESCAPE ON DECLARE XROW     ROWID;  --You cant dire...

Oracle EBS R12: Insert Lookup Data into FND_LOOKUP_VALUES with API

›
SET SERVEROUTPUT ON SIZE 1000000 SET ECHO OFF SET VERIFY OFF SET DEFINE "~" SET ESCAPE ON DECLARE XROW     ROWID;  --You cant dire...

Oracle R12 Profile Option for Responsibility Level Query

›
 Select *  from (SELECT  decode(a.level_id, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, ...

Oracle R12 EBS Profile option extract query

›
 select p.profile_option_name SHORT_NAME,   n.user_profile_option_name NAME,   decode(v.level_id,   10001, 'Site',   10002, 'App...

How To Enable The DFF For LOOKUP Oracle R12

›
Create a DFF on Lookup  STEPS: Login to System Administrator Application -> Flexfield -> Descriptive -> Segments  Search for Applic...

How to Create Display field in DFF (using Special Value Set)

›
Create a DFF with Read only or Non Editable field: Click on Segments: Crate a Value Set:  Validation Type : Special Click On Edit Informatio...

Find the custom top path in Oracle EBS

›
Find the custom top name and path in Oracle EBS   SELECT variable_name top_name, value top_path     FROM fnd_env_context    WHERE variable_n...

Oracle EBS Application name and Short name

›
Oracle EBS Module List Application Oracle Username Application Object Library APPLSYS System Administration ...

Oracle Forms Personlization list with Condition

›
SELECT DISTINCT a.form_name, a.enabled, c.user_form_name, d.application_name,                 a.trigger_event, a.trigger_object, a.conditi...

Oracle Apps CUSTOM.PLL

›
CUSTOM.PLL IN ORACLE APPLICATION Custom Library (custom.pll) allows to extend/customize Oracle Applications form(Oracle Form) without chan...

How to find personalizations in which form

›
--Query 1. Simple list of form personalizations, ordered by form SELECT form_name Form, function_name Function, description Description, ...

Find the Concurrent Program Execution Method

›
Spawned : Your concurrent program is a stand-alone program in C or Pro*C. Host : Your concurrent program is written in a script for yo...

FNDLOAD Script for AOL and WebADI objects.

›
Before run FNDLOAD check the Set environment variables (.env) . $APPL_TOP/custom< CONTEXT_NAME >.env (e.g. APPSICEBSDEV.env ) Followi...

How to find Scheduled concurrent program or request will be runing ?

›
SELECT r.request_id, u.user_name requestor, pt.user_concurrent_program_name,        r.phase_code, r.status_code, r.priority_request_id, r....

How to add a Concurrent Program to Responsibility (Request Group) using API

›
Example 1. Custom Responsibility (Request Group) BEGIN apps.fnd_program.add_to_group(         PROGRAM_SHORT_NAME  => 'XXCONA_JG...

How to enable the Default Operating Unit in R12

›
1. Login into application with  System Administration  responsibility after then  Concurrent -> Programs 2. Query for short name o...