How to download /upload WorkFlow

WorkFlow Commands and Instructions:

WorkFlow Commands and Instructions:
------------
The workflow definitions are stored into the database. The standard workflow files (wft) files are in
the $PA_TOP/patch/115/import/US/ and $PO_TOP/patch/115/import/US. The custom files are located in
$PA_TOP/patch/115/import and $PO_TOP/patch/115/import respectively.

When ever any patch is applied that impacts the workflow customizations, follow the below steps to
reapply the customizations.

1) Log on to the environment on which the customizations need to be applied.
2) Set the environment.
Ex: ./oracle/devl/app/prodappl/APPSDEVL_mmpsodevl.env
3) Fire the workflow definition download command to download the workflow definition from the database

How to Download Workflow from Oracle Applications?

DOWNLOAD WORKFLOW:

WFLOAD apps/apps 0 Y DOWNLOAD $HOME/PAAPINVW.wft PAAPINVW

WFLOAD apps/apps 0 Y DOWNLOAD $HOME/poxwfpag.wft POWFPOAG

The above commands creates the workflow definition files (wft) in the local directory $HOME/

4) Verify whether the workflow changes are intact.

5) If the workflow definitions are overwritten then apply the custom workflow definitions from the
mentioned directory.


How to Download Workflow from Oracle Applications?
UPLOAD WORKFLOW:

WFLOAD apps/apps 0 Y UPLOAD $PA_TOP/patch/115/import/PAAPINVW.wft

WFLOAD apps/apps 0 Y UPLOAD $PO_TOP/patch/115/import/poxwfpag.wft

verify the log and output file for any errors.

Note: If the customizations needed to be appended to the standard workflow then, modify the standard
workflow and add the customizations on top of it.

HOW TO load raw data in table using SQL LOADER (SQLLDR)

AIM--->>
"we have need to load data into TABLE from ".CSV" file using "sql loader".
Basically this kind of operation is need when client want to load "RAW Data" in his databse manually,
that time this technic is used.
Actually there are lots of s/w which is used for this operation but use of this method is  a sign of
standard programming.
------------------------------------------------------------------------------------------------------
TASK--->>
load the data of "abc.csv" file into table "abc" using "abc.ctl"
---------------------------------------------------
create table "abc" in databse.
ex-
create table abc(
id number,
name varchar2(25)
);

----------------abc.ctl----------------------------
OPTIONS ( SKIP=1)
LOAD DATA
INFILE '/u02/dev/abc.csv'
APPEND
INTO TABLE abc
fields terminated by ';' TRAILING NULLCOLS
( id,
  name
)
--------------------------------------------------
--------abc.csv contain following data------------
ID;NAME
1;aaa
2;rohit
3;rat
4;rani
---------------------------------------------------------------

How to execute--->
1-go on Putty.
2-type following command
SQLLDR apps/apps abc.ctl

syntax--> Sqlldr username/password(of database) ".ctl_file_name"

Here my database username=apps
                            password=apps


After executing this command see the table "ABC" you will find all data of "abc.csv "file in that table.
ex    --select * from abc
o/p
id name

1  aaa
2  rohit
3  rat
4  rani
------------------------------------------------------------
in above all exmple i usesame name for each file..means..abc.ctl,,abc.csv, table name is abc....
so it is not necessory to use same name u can use diff names......

----------------------------------------------------------------

Delete Concurrent program from back end

****Script TO DELETE registered concurrent program FROM back END******
**NOTE Never delet it from base table directly***********

BEGIN
      fnd_program.delete_program('Concurrent_prog_SHORTNAME','APPLICATION_short name');
      fnd_program.delete_executable('Concurrent_prog_SHORTNAME','APPLICATION_short name');
END;

****Script TO DELETE registered REQUEST SET FROM back END******

BEGIN

   FND_SET.DELETE_SET ('req_set_shortName','application_short_name');

END;