How to compile fast formula from the server (via FFXBCP)

Oracle Human Resources
Oracle Payroll


Run the executable FFXBCP (from $FF_TOP/bin) with the following syntax:

1. To compile all formula
FFXBCP apps/ 0 Y %% %%

2. To compile all formula for a certain class i.e PAYMENT
FFXBCP apps/ 0 Y '' %%

3. To compile a specific formula
FFXBCP apps/ 0 Y %% ''

4. To compile all UNCOMPILED formula
FFXBCP apps/ 0 Y -U %% %%

How To Find Out Which Responsibility Was Granted To A Specific User

Run the following sql when prompted enter username

SELECT frvl.RESPONSIBILITY_NAME
FROM FND_USER_RESP_GROUPS_DIRECT furgd,
FND_RESPONSIBILITY_VL frvl, FND_USER fu
WHERE furgd.responsibility_id = frvl.responsibility_id AND
fu.user_id = furgd.user_id AND
( to_char(furgd.end_date) IS NULL
OR furgd.end_date > sysdate )
AND fu.user_name = '&user' ;

How to create database link in Oracle 9i

CREATE PUBLIC DATABASE LINK "RAF"
CONNECT TO "APPS"
IDENTIFIED BY "APPS"
USING '(description=(address=(protocol=TCP)
(host=server1)(port=1521))(connect_data=(sid=DEV)))'


Run the following from sqlplus to test your dblink
SELECT SYSDATE FROM DUAL@RAF

Fndload command for migrating fnd_users from one instance to another

Fndload command for migrating fnd_users from one instance to another

How to migrate users from one instance to another instance using FNDLOAD utility, steps to be run pre and post the clone process.

Download
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct /tmp/userlist.ldt FND_USER USER_NAME="RAF"

Upload

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct /tmp/userlist.ldt

If same user is not present in another instance then FNDLOAD will not migrate same password instead
user password will be changed to 'welcome'.
If same user is present in another instance then FNDLOAD will migrate same password.

Change your Oracle 11i apps password using FNDCPASS

Source your apps environment

Issue

FNDCPASS apps/test 0 Y system/manager SYSTEM APPLSYS apps


vi the following file and the change the password in there as well.

/ora111/dev/devora/iAS/Apache/modplsql/cfg/wdbsvr.app

Run the following script to see Database growth per month for last year

set pagesize 50000
"Database growth per month for last year"

select to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024 "Growth in Meg"
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month')
/

How to set Concurrent Report Access Level

Under SysAdmin > Profile > System
Find System Profile under Responsiblity. Enter the responsiblity name and check the box to the left. Click 'FIND'.
Scroll to Concurrent Report Access Level, Click on the field under responsiblity col., click on the LUV - it should give you 2 choices(user or responsiblity), click on responsibility. All users having that resposnibility will then be able to see ALL requests run under that responsibility instead of just their own.