![]() ![]() Navigate to System Administrator > Concurrent > Program > Define. Next, define the custom concurrent program. Ensure you enter the correct application and execution method (SQL*Plus), and then click Save. The Concurrent Program Executable form appears. ![]() To set up a new concurrent program executable, navigate to System Administrator > Concurrent > Program > Executable. You must first set up the concurrent program executable, and then define the concurrent program. In this example, the custom concurrent program will be run from General Ledger, so the SQL script must be placed in the $GL_TOP/sql (%GL_TOP%\sql) directory. You must determine the application under which you are going to run the concurrent program and then place the SQL script in that location. For example: and default_effective_date between to_date('&1','yyyy-mm-dd hh24:mi:ss')Īnd to_date('&2','yyyy-mm-dd hh24:mi:ss') In the Concurrent Program parameter setup, set the Value Set as FND_STANDARD_DATE.įirstly, in the SQL script that you wish to set up as the concurrent program, the date parameters must be correctly formatted. and format it using ‘yyyy-mm-dd hh24:mi:ss’ in the SQL program (i.e. Problem: I want to create a custom concurrent program based on a SQL script, but do not know how to pass date parameters to the concurrent program. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |