You are browsing the archive for Oracle Application Object Library.

Workflow Definitions Loader

 

NAME: Workflow Definitions Loader
SHORT CODE: FNDWFLOAD
MODULE: Oracle Application Object Library

Description: Workflow loader to transfer data between files and database
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Mode : Upload or upgrade to database, download to file
  • File : Filepath
  • Item Type : Item type to download

 

Workflow Directory Services User/Role Validation

 

NAME: Workflow Directory Services User/Role Validation
SHORT CODE: FNDWFDSURV
MODULE: Oracle Application Object Library

Description: Validates the user/role information in Workflow Directory Services
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_BatchSize : Number of records that will be processed per transaction
  • p_UserName : Name of the user to run the validation for
  • p_RoleName : Name of the role to run the validation for
  • p_Check_Dangling : Checks for and removes user/role references where the user and/or the role does
  • p_Check_Missing_URA : Checks for user/role assignments that are present in WF_LOCAL_USER_ROLES but absent in WF_USER_ROLE_ASSIGNMENTS and adds them to WF_USER_ROLE_ASSIGNMENTS
  • p_UpdateWho : Determines if WHO columns should be updated when corrupt records are processed
  • p_parallel_processes : Number of parallel processes to be used to execute this program

 

Workflow Role Hierarchy Propagation

 

NAME: Workflow Role Hierarchy Propagation
SHORT CODE: FNDWFDSRHP
MODULE: Oracle Application Object Library

Description: Propagates changes in the Workflow Role Hierarchy to WF_LOCAL_USER_ROLES
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_RELATIONSHIP_ID : Relationship ID of the hierarchy relationship being propagated.