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

    

                   

Oracle Workflow : Oracle Workflow Introduction

  Oracle workflow is complete workflow management system that facilities business process re engineering  Oracle workflow automatically process information and route from one place to other according business rules, you can easily change to any person inside or outside enterprise.

 Components of oracle workflow

1. Workflow Builder
2. Workflow Definition Loader
3. Workflow Notification system
4. Workflow engine.
5. workflow monitor.
6. Workflow Directory Services.

Oracle Workflow builder is graphical tool which help to design oracle workflow

Workflow Definition Loader is utility which help download and upload workflow definition between database and flat files.

Workflow notification  system handle send and receive response notification 

Workflow engine embedded in E-business Suite and it helps to monitors workflow status and coordinates  routing activities of process. 

        Workflow 

1. Attributes             =>  It is variable of oracle workflow
2. Process               ==>  Business process is combination activities
3. Notifications         =>  Define notification
4. functions              ==> PL\SQL functions
5. events                  ==>  Trigger
6. messages             ==> Define message for notifications
7. Lookup types        ==>  It is used display button in notification and list of values

  What are the item type attributes available in workflow?

          -Text

          -Number

          -Date

          -Lookup 

          -Form

          -URL

          -Document

          -Role

          -Attribute

        Oracle Workflow builder access level should be 100 for customization any workflow 

             Version 2.6.3.5

Access  level  : 100

Check box  which allowed modification of customized objects

I will explain about check box and access level  in next chapter.