23/1/2028, 15:55 ‘What is Host Program? How to create Host Program? and Whats Prog fle? | OracleAnpsDNA DNA C What is Host Program? How to create Host Program? and What is .Prog file? by Shailender Thallam / January 26, 2017 Executable Short Name XX HOST_PROG_TEST Application (Custom Development Description XXOADNA Host Program Test Execution Method Execution Fle Name ‘Subroutine Name Execution Fle Path Stage Function Parameters To run a unix based shell script as a concurrent program, the executable of the concurrent program should be registered as a ‘Host’ program. The execution file name of the host program should end with .prog extension and a soft link should be created for the .prog file. Here is an example of creation of host program with one parameter: Step 1: Create a prog file XX_TEST HOST_PROG.prog as shown below ¥ # Program + XX_TEST_HOST_PROG. prog # Description : Host program example to print $0 to $4 paraneter # Author Shailender Thallam t # Parameters @ to 4 are default parameters and values are passed from Concurrent manager # echo "@ Shell script name along with Path " $f} echo "1 Oracle Apps User Name and Password " $0} -ntps:[Link]/2017/01 what s-host-program-how-to-create-hostprogran-and-whatis-prog-el wr29/1202, 15:55 ‘What is Host Program? How to create Host Program? and What is Prog fle? | OracleAnpsDNA echo "2 Application user_id from FNO_USER 2" $2} echo "3 Application user_name from FND_USER $3} echo "4 Concurrent Program Request 1D 2" $a} # Parameters from 5 are concurrent program parameter # echo" * echo" " echo "5 Concurrent Program Parameter 1 2" $(5} End of script Step 2: Upload the .prog file to the bin folder of respective application top and give necessary file permissions bin +80 GMOS WFind Files % ~~ 52 Download i Uf Edit i Gs Properties | [i w go el Name [Link] “ 4/20/2016 8:47:49 PM | 7/18/2016 8:34:01 PM | EDOCTEST HOST PROG prog 1 KB. 1/26/2017 5:27:42 PM Step 3: Create Soft Link: In -s $FND_TOP/bin/fndcpesr _XX_TEST_HOST_PROG Soft link will be created against fndcpesr so that concurrent manager will recoganize as host program. bin +@M GAAS Find Files % e- [@ Download tit Uf Edit % <4 Properties |&2 Lt Name Size Changed Grane Sraceappstescom be 4/20/2016 8:47:43 PM. J Training 7/18/2016 8:34:01 PM la XX TEST HOST [Link] 1KB 1/26/2017 5:27:42 PM TO BOCTEST HOST PROG 1 KB 1/26/2017 5:23:12 eM Step 4: Create Executable and Concurrent Program -ntps:[Link]/2017I0 | hats-host-program-now-to-create-hostprogran-and-whats-prog-e!29/1202, 15:55 ‘What is Host Program? How to create Host Program? and What is Prog fe? | OracleAnpsDNA rcodibe [OCHOSTPROSTEST SS Short Name _XX_HOST_PROG_TEST Application Custom Development Description XXOADNA Host Program Test Execution Method emma esToaesg eS Execution Fie Path | ‘Stage Function Parameters Corets Domain ‘secur Group | a i eserpton erie TL feet - vaiaton abe Set FRG_EHARGIO Desert Bad cavers, onaind Oat pe eta abe ‘ Beaued mabe Seeuty ange 4 *Dioay spay Soe Deteroen See 5 ‘Coneateratd Dessrpon Sue Prompt Param esen| Run the Host Program -ntps:[Link]/2017I0 | hats-host-program-now-to-create-hostprogran-and-whats-prog-e!23/1/2028, 15:55 ‘What is Host Program? How to create Host Program? and What is Prog fe? | OracleAnpsDNA Cl ane pwn at pena ee ‘Attn, Param! Hello OracteAppsDNA\t| © ganado ma) om) vo Lae i ney Print to noprint bad 66) sit i Program Output Why should we create host program executable file with .prog extension? We can even a create the executable file with .sh extension but the concurrent manager will not pass any default parameters. Concurrent manager will pass default parameters only to the host program executable with prog extension, Below are 5 default parameters of a host program, whose values are passed by concurrent manager The first five parameters refer to the following: $0: The shell script to be executed $1: Oracle user/password $2: Applications user_id -ntps:[Link]/2017/01hwhals-host-program-how-to-create-hostprogran-and-whatis-prog-elzayva029, 1655 \Winatis Host Program’ Howto create Hos Program? and Wat is. Prog fe? | OracleAnpsDNA $3: Application user_name $4: Concurrent program request_id The parameters which we have on the concurrent program can be accessed from $5 Note: /t is always suggestible to access parameters in this format ${0} rather than $0. The reason behind this is, the shell script wont recognize double-digit parameter when accessed in this format $10, so we need to use ${10} For Further Reading 1. PL/SQL Script to Create a Concurrent Program Parameter from backend 2. How to Generate Trace for a Seeded or Custom Conct Program/Report? te Concurrent Program and Executable 4, PL/SQL Script to Create a Concurrent Program from backend 5. How to Schedule a concurrent program from Backend 6. SQL Query to findout Executable, Concurrent Program and its Parameters information 7. PL/SQL Script to Create an Executable from backend Host Program -ntps:[Link]/2017/01hwhals-host-program-how-to-create-hostprogran-and-whatis-prog-el\What is Host Program? How to create Hast Program? and Whats Prog fle? | OracleAppsDNA 0 Comments. ® Loginv G start the iscussion.. Loc in wir ‘oR SIGN UP WITH Disqus (@) Name 9 Share Best Newest Oldest Be the first to comment, Subscribe Privacy Do Not Sell My Data Search on this Site Search Popular Questions Asked What is the difference between XML publisher and BI Publisher? asked by Questions Master What is the difference between CASE and DECODE? asked by Questions Master. What are the different types of Sales Orders in Order Management? asked by Questions Master How to display the names of the employees who earn highest salary in their respective departments? asked by Questions Master Can you have multiple layout templates for a singe data template? asked by Questions Master -ntps:[Link]/2017/01hwhals-host-program-how-to-create-hostprogran-and-whatis-prog-el23/1/2028, 15:55 \What is Host Program? How to create Hast Program? and Whats Prog fle? | OracleAppsDNA Categories Select Category v Recent Posts Oracle ERP Cloud Instance Clone/Refresh Guidelines ESS Request History with Time took to Run Payload to Update AR Invoice DFF in Oracle ERP Cloud Emails generated by Oracle ERP are delivered to customer/Supplier with from email address as “no-reply@[Link]’ instead of no- reply@[Link] Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier -ntps:[Link]/2017/01hwhals-host-program-how-to-create-hostprogran-and-whatis-prog-el uw