Oracle Workflow : Oracle Workflow upload and download and access level

 

    Oracle workflow has 3 kinds of levels.  Customization /access / Protection levels 

               A numeric value ranging from 0 to 1000. Every workflow user operates at specific access level. The access level defines whether the user can modify certain workflow data. You can only modify data that is protected at a level equal to or higher than your access level. 

                        You can change protection and customization level using options, once you have checked preserve customization then you can not do customization in workflow. once you have checkbox for lock at the access level . The protection level can change with existing access level  and access level has decide with oracle workflow access level .

                    Suppose I want to do customization in std workflow, I do not want to override my customized objects in workflow , then you have must to understand access level concept, each std oracle workflow design with 20 access level , It has checked range between customization  and  protection level, In std workflow , you have observed that range 0 - 20  0 as customization and 20 as protection level our access level is 20 , those item or objects has level 20 then once oracle patch has applied it will override existing definition.

case 1 -- Need to modify items of std workflow       

                 In such case existing oracle workflow process gets great out you can not modify because exiting std process access level is 20, you can modify up-to 20 access level only , if you want modify std workflow then you have to set access level less than 20 , it is not right practice.

                   Customization      access level    protection level

                           0                            18                      20   

   here now access level is between 0-20 range so you can modify change.

Case 2 :-   New custom process called in std workflow and not to modify  override custom process once Oracle patch applied

                While create new custom process, please update access level as 100.   and update protection level as 100 

             Customization    access level   protection level

                         0                 100                100

       access level 100 is range between customization  (0) and protection level (100), you can modify custom process.  you can not modify std process , it will be get grad out.  you can called custom process in std workflow

         Oracle Workflow Upload and Download

Oracle workflow always store in oracle database .  Oracle workflow is workflow flat file with extension .wft.  you can download workflow .wft file from database and after modification  you can upload wft file into database.  for upload and download , we have used oracle workflow utility , called as WFLOAD

   YOU HAVE TO RUN BELOW COMMAND ON UNIX     

sysntax

         WFLOAD   apps/<pwd>@EBSDEV  0 Y UPLOAD  <name.wft>

        WFLOAD   apps/<pwd>@EBSDEV  0 Y UPGRADE  <name.wft>

        WFLOAD   apps/<pwd>@EBSDEV  0 Y  FORCE  <name.wft>

    UPLOAD ---- it will be check Customization and protection level , Access level should be in range between customization and protection level

FORCE  -- It will ignore any customization and protection level.

UPGRADE -- 

      WFLOAD   apps/<pwd>@EBSDEV  0 Y DOWNLOAD < NAME.WFT>  NAME

      WFLOAD   apps/<pwd>@EBSDEV  0 Y DOWNLOAD   POAPPRV.wft POAPPRV