本文主要是介绍Oracle Applications DBA 基础(第二期)Week 07 exercise,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
fnd_concurrent_requests
--EOF--
FNDLIBR
--EOF--
Please see below screenshot.
--EOF--
4. 建立一个新的 concurrent program (用 shell 做) , 可以参考 视频上的定义。
1. create a shell script with the suffix of ".prog" in $FND_TOP/bin, and make a symbolic link without the suffix of ".prog" to $FND_TOP/bin/fndcpesr.
-bash-3.2$ pwd
/u01/tm12/apps/apps_st/appl/fnd/12.0.0/bin
-bash-3.2$ cat HOSTLIAO.prog
#!/bin/bash
2>/dev/null . /u01/tm12/inst/apps/tm12_prcsgidb1/appl/admin/tm12_prcsgidb1.xml
echo Script name:$0
echo APPS/appspwd:$1
echo Application user_id:$2
echo Application user_name:$3
echo Request ID:$4
echo Request Parameter 1:$5
echo "--BEGIN--"
echo "Hello, $5 ! "
echo "--END--"
exit 0;
-bash-3.2$ ln -s /u01/tm12/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr HOSTLIAO
-bash-3.2$ chmod +x HOSTLIAO.prog
-bash-3.2$ ls -l HOSTLIAO*
lrwxrwxrwx 1 aptm12 dba 51 Mar 20 18:10 HOSTLIAO -> /u01/tm12/apps/apps_st/appl/fnd/12.0.0/bin/fndcpesr
-rwxr-xr-x 1 aptm12 dba 297 Mar 20 19:14 HOSTLIAO.prog
-bash-3.2$
2. define executable
3. define concurrent program
4. add program to request group
5. submit the request
6. check request log
--EOF--
这篇关于Oracle Applications DBA 基础(第二期)Week 07 exercise的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!