Showing posts with label Host Program. Show all posts
Showing posts with label Host Program. Show all posts

Friday, 5 August 2016

How to create soft link for host program

Kindly create shell script xxcust_test_shell_script and save it as .prog. Then transfer it to XXCUST_TOP/bin folder by using putty/winscp.

How to find XXCUST_TOP folder path?

a)By using Putty : 
simply write below command you will get path.
> echo $xxcust_top
app01(erpdev) /product/appl/apps/apps_st/appl/xxcust

b)By using SQL query:

select variable_name, value
from fnd_env_context 
where variable_name like 'XXCUST%';

Step to create soft link for host program:

Step 1:Go to the custom top as below:
>cd $XXCUST_TOP/bin
app01(erpdev)/product/appl/apps/apps_st/appl/xxcust/12.0.0/bin

Step 2: Use 'fndcpesr' command to create soft link

$pwd
app01(erpdev) /product/appl/apps/apps_st/appl/xxcust/12.0.0/bin

$ln -s $FND_TOP/bin/fndcpesr xxcust_test_shell_script

Note: Kindly mentioned only file name without extension (.prog) while creating soft link.

Once this command executed you can see new xxcust_test_shell_script link file got created. kindly refresh winscp XXCUST_TOP/bin folder to view new file.

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...