Showing posts with label Oracle Apps. Show all posts
Showing posts with label Oracle Apps. Show all posts
Thursday, May 21, 2015

How To Disable/End Date/ Delete Responsibilities of a User from Backend/API

›
Below is the query. Please not Responsibilities cannot be deleted in Oracle Apps from a User. It can only be Disabled or End Dated. BEG...
Wednesday, May 13, 2015

FND DEBUG / FND LOG MESSAGES

›
What is FND Debug Log ? It helps you pinpoint the cause of error in standard Oracle Code, by making debug messages to appear in a centra...
Friday, April 3, 2015

How to send Concurrent Program output as an Email

›
There are two Methods to send Concurrent Program Output as Email Method 1: The printer styles have to be configured to execute a shell s...
1 comment:
Wednesday, September 17, 2014

FNDLOAD Commands for Migration

›
The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file.The loa...
Friday, September 5, 2014

Status Codes and Phase Codes of a Concurrent Request : Oracle EBS R12

›
Concurrent Request Status Codes :  SELECT LOOKUP_CODE, MEANING   FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'CP_STATUS_CODE'  ...
Sunday, June 15, 2014

Code for Generic SQL Loader program in Oracle Apps

›
Save the below code as .prog Make sure to create a symbolic link from your script to $FND_TOP/bin/fndcpesr Ex: ln -s $FND_TOP/bin/fndcpes...
Saturday, May 17, 2014

Request Set of a Concurrent Program

›
Provide Concurrent Program name to the following query. It lists all the Request Sets which are created with the Concurrent Program given....

Programs in a Request Set

›
Provide the Request Set name to the following query. It lists all concurrent programs of this Request Set. SELECT USER_CONCURRENT_PROGRA...

Query to find ORG_ID attached to a responsibility

›
SELECT * --fpov.profile_option_value              FROM applsys.fnd_profile_option_values fpov                 , applsys.fnd_profile_optio...
1 comment:

Examples of XMLCONCAT in PLSQL

›
SET serveroutput ON size 300000; DECLARE   LV_PAYMENT_TYPE_XML XMLTYPE;   l_string VARCHAR2(1000); BEGIN   SELECT XMLCONCAT(xmlelement...

Oracle Workflow Important Tables

›
Workflow Tables --Two classification of tables --Definition and Setup --if we have item key it is instance specific SELECT *...

Tables used in Defining Request Sets Oracle R12

›
REQUEST SETS: • FND_REQUEST_SETS • FND_REQUEST_SETS_TL REQUEST SET – STAGES: • FND_REQUEST_SET_STAGES • FND_REQUEST_SET_...
1 comment:

Query to find responsibilities attached to a user in Oracle R12

›
SELECT * FROM FND_USER WHERE user_name LIKE 'DAVIDEVANS'; SELECT *   FROM FND_USER_RESP_GROUPS  WHERE user_id=1180; --user_id i...

Concurrent Program to Executable Name Drill Down Oracle R12

›
SELECT fcpv.concurrent_program_name,   fcpv.user_concurrent_program_name,   fefv.executable_name,   fefv.execution_file_name,   fefv.ex...