How to get the list of contexts for each formula type?

The below query can be used to find out the different contexts that are available to be used within a fast formula. Change the formula type as required.

select t.base_formula_type_name
,      ttl.formula_type_name
,      ttl.description
,      c.base_context_name
from   ff_formula_types_b t
,      ff_formula_types_tl ttl
,      ff_ftype_context_usages u
,      ff_contexts_b c
where  t.formula_type_id = u.formula_type_id
and    ttl.formula_type_id = t.formula_type_id
and    ttl.language = userenv('LANG')
and    ttl.formula_type_name like 'Oracle%Payroll%'
and    c.context_id = u.context_id

Payroll Batch Loader(PBL) for Payroll Relationship Group related Data Load

Task Name: Object Groups

Task Action Name: Add Payroll Relationship Inclusions and Exclusions

Name : Object Group Name

Employment Level : Payroll Relationship

Employment Number: Payroll Relationship Number

Inclusion Status: Include/Exclude

Data Migration Flow

Difference between Abstract role and Job Role

Abstract Roles
Abstract roles represent a worker's functions in the enterprise independently of the job they do.
Abstract roles permit users to perform functions that span across the different jobs in the enterprise. For example, users who are employees must be provisioned with the Employee abstract role, so they can update their employee profiles and pictures.

Job Role
Job roles provide users with the permissions they need to perform activities specific to their jobs. You can assign job roles directly to users. You can also create custom job roles.
So Job Roles are the one that actually let a user perform actions inside Oracle Cloud.

Termination Date database item for oracle payroll fast formula (For element defined at payroll relationship level)

PER_EXT_WORK_REL_MAX_TERMINATION_DATE - is used 

Termination Date database item for oracle payroll fast formula (For element defined at payroll relationship level)

Query to find out ESS job history for a report

When a report is run throough ESS or when we run it by clicking Schedule option, then below query can be used to find out the job history.


SELECT (CASE
              WHEN state = 1 THEN 'Wait'
              WHEN state = 2 THEN 'Ready'
              WHEN state = 3 THEN 'Running'
              WHEN state = 4 THEN 'Completed'
              WHEN state = 9 THEN 'Cancelled'
              WHEN state = 10 THEN 'Error'
              WHEN state = 12 THEN 'Succeeded'
              WHEN state = 13 THEN 'Paused'
              ELSE TO_CHAR (state)
          END)
             request_state,
         erh.*
    FROM fusion.ess_request_history erh, fusion.ess_request_property erp
   WHERE     1 = 1
         AND erh.requestid = erp.requestid
         AND erp.name = 'report_url'
         AND erp.VALUE LIKE '/Custom/Financials/XX AP Payment Information Email Notification Report.xdo'
ORDER BY erh.requestid DESC