You are browsing the archive for Concurrent Requests & Reports.

Purge GSP Transactions in Staging Table

 

NAME: Purge GSP Transactions in Staging Table
SHORT CODE: PQHGSPUR
MODULE: Oracle Public Sector HR

Description: Purging GSP Transactions in Staging Area
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_alias : Master Table alias name
  • paramname1 : Short Name
  • paramvalue1 : Value for Short Name
  • paramname2 : Status
  • paramvalue2 : Value for Status
  • paramname3 : Start Action Date
  • paramvalue3 : Value of Start Date
  • paramname4 : End Action Date
  • paramvalue4 : Value of End Date
  • paramname5 :
  • paramvalue5 :
  • p_effective_date : Effective Date for Datetracked data

 

Process Employees Progressed Manually

 

NAME: Process Employees Progressed Manually
SHORT CODE: PQHGSPPRCSAUI
MODULE: Oracle Public Sector HR

Description: Process Employees Approved / rejected using Approval UI
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_EFFECTIVE_DATE : Effective date as of which employees are to be processed
  • P_APPROVAL_STATUS_CD : Approval Status Cd to Identify approvals (PQH_GSP_A) and rejections (PQH_GSP_R)
  • P_ELIG_PER_ELCTBL_CHC_ID : Electable Choice Id

 

Enroll GSP Rate Sync Life Event with Grade Ladders

 

NAME: Enroll GSP Rate Sync Life Event with Grade Ladders
SHORT CODE: PQHGSPENRGSRSLE
MODULE: Oracle Public Sector HR

Description: Enroll GSP Rate Sync Life Event with Grade Ladders
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_effective_date : Effective Date
  • p_business_group_id : Business Group id
  • p_pgm_id : Program Id