Unix Concurrent Program, tips

There are many alias readily available in Unix Prog file. You no need to write addition SQLs/Code to retrieve those information.

1)      $FCP_OUT , holds the output file of concurrent program.

2)      $FCP_IN, holds the input file of concurrent program.

3)      $FCP_LOGIN, connection strip.

4)      $APPLTMP, holds the application instance temporary directory.

Default four parameters in Unix Concurrent Program in Oracle Apps.

1 à Connection String

2 à FND user id

3 à FND User Name

4 à Concurrent Program Request ID

To access double digit parameter value in unix program you need to use following syntax.

=${<Parameter Number>}

How to pass value from SQL Plus to  Unix Variable.

FCP_DATA_FILE_NAME=`sqlplus -s <<EOSQL

$ FCP_LOGIN ---Connection string

SET SERVEROUTPUT ON SIZE 1000000

SET FEEDBACK     OFF

SET LINESIZE 10000

Declare

<Variable Declaration>

Begin

<Business Logic>

Dbms_output.put_line(“<Value to be assigned>”);

End;

/

EXIT :exit_status

EOSQL`

How to set Unix Concurrent Program Status

set_completion_status()

{

sqlplus -s << EOSQL

  $APPSLOGIN

  WHENEVER SQLERROR EXIT SQL.SQLCODE

  SET FEEDBACK OFF

  DECLARE

    l_stat BOOLEAN;

    l_session_id NUMBER;   

  BEGIN

    fnd_global.initialize(session_id => l_session_id

                        , user_id => fnd_global.user_id

                        , resp_id => fnd_global.resp_id

                        , resp_appl_id => fnd_global.resp_appl_id

                        , security_group_id => null

                        , site_id => null

                        , login_id => null

                        , conc_login_id => null

                        , prog_appl_id => null

                        , conc_program_id => null

                        , conc_request_id => $FCP_REQID

                        , conc_priority_request => null);

           

IF( <Condition>)

THEN

    l_stat := fnd_concurrent.set_completion_status('NORMAL','Normal Completion.  ');

ELSE  

    l_stat := fnd_concurrent.set_completion_status('WARNING','Completed in Warning ');

END IF;

    COMMIT;

END;

/

EXIT;

EOSQL

}