assignment category lookup in fusion hcm

Assignment Category and Worker Category Table in Oracle Fusion HCM

• Post author: Oracle Cloud Hub
• Post last modified: 26 February 2024

Below Query will help us fetch the Assignment Category and Worker Category for a given assignment.

Above code will return the below output

Navigate to the assignment details screen to view data from UI

You Might Also Like

Query to Fetch the Payroll Assigned to a Person in Oracle Fusion HCM

Query to get FTE in Oracle Fusion HCM Cloud

Fast Formula Types based on modules in Oracle Fusion HCM Cloud

• Configuring and Extending HCM Using Autocomplete Rules

Attributes for Worker Assignment

This table lists the main attributes of the Worker Assignment object and exceptions for any attribute, if any.

Digital Engineering & Experience

Data, automation & ai, oracle cloud.

• Cloud Enhancement & Managed Services

Mastek "iConniX" - Generative AI Portfolio

• Products Platforms & Innovation icxPro - Intelligent Part Assistant iLeaseFinPro Vehicle Leasing Software Warehouse 360 Enterprise Workforce Scheduler Connected Enterprise

Oracle Cloud & Enterprise Apps

Salesforce cloud & industry solutions, platforms & innovation.

• INDUSTRIES Public Sector & Government Healthcare & Life Sciences Retail & Consumer Manufacturing & Technology Financial Services Higher Education Construction & Engineering Hospitality Transportation & Logistics High Tech Media & Entertainment
• PARTNERS About Partnerships Oracle Partner Salesforce Partner AWS Partner Microsoft Partner Snowflake Premier Partner UiPath Partner ServiceNow Partner
• Insights News Press Releases Blog Resources Webinars & Events
• MST SOLUTIONS
• BIZANALYTICA
• Digital Engineering & Experience Cloud Migration Cloud Engineering Low Code DevSecOps Quality Engineering MACH Platform Engineering
• Data, Automation & AI Cloud Data Modernization Data Management Data Governance Business Intelligence & Analytics Intelligent Automation Decision Sciences & ML, AI Basecamp
• Oracle Cloud Oracle Cloud Applications Glide 4.0 Oracle E-Business Suite Oracle Consulting AdvantEdge IaaS SAP to Cloud Migration PeopleSoft to Cloud Migration Oracle Analytics Cloud Oracle Cloud Infrastructure Oracle Autonomous Data Warehouse
• Salesforce MuleSoft Experience Cloud Sales Cloud Servide Cloud Marketing Cloud Industry Cloud Commerce Cloud Data Cloud CRM
• Platforms & Innovation
• icxPro – Intelligent Part Assistant
• iLeaseFinPro Vehicle Leasing Software
• Warehouse 360
• Enterprise Workforce Scheduler
• Connected Enterprise
• Public Sector & Government
• Healthcare & Life Sciences
• Retail & Consumer
• Manufacturing & Technology
• Financial Services
• Higher Education
• Construction & Engineering
• Hospitality
• Transportation & Logistics
• Media & Entertainment
• About Partnerships
• Oracle Partner
• Salesforce Partner
• AWS Partner
• Microsoft Partner
• Snowflake Premier Partner
• UiPath Partner
• ServiceNow Partner
• Press Releases
• Webinars & Events

Mastek Blog

Understanding common lookups in oracle hcm.

04-Oct-2021 02:33:00 / by Nilesh Pawar

The HR department has to maintain personal, legislation-specific, and organization-related data for all employees in their HR applications. It is crucial to properly manage and store this data as it will be used for reporting. Furthermore, this data will also be used by other applications like payroll and outbound interfaces.

Oracle HCM Cloud   offers all such data fields and their values out of the box, which helps customers adhere to the legislative rules and properly maintain the data. Oracle offers its customers the flexibility to manage values for these data fields by using the functionality of lookups.

Lookups hold a list of values that appear for various fields within an application.

There are three categories of lookups:

1. Standard lookups

2. Common lookups

3. Set-enabled lookups

What are the Common Lookups in Oracle HCM?

Here are some essential details about common lookups.

Common lookups are predefined lookups that allow users to add new values or enable/disable existing values. These are generally maintained by admin users.

To enter a value for the fields within the application, a user can select any one of the values from the available list. There are predefined lookup types available for various fields in the application.

For example, 'Assignment Category' is one of the fields on the employee's assignment screen that contains a list of values. The list of values that appear for this field comes from lookup. The lookup type for this is 'EMP_CAT'.

Duplicate lookup codes are not allowed in the lookup type.

Lookup Customization

Oracle Fusion contains certain predefined lookups that you cannot disable values for or add new values to. However, there are a few lookups that allow you to disable values and also add some new values. So, it all depends on the lookup configuration level, as it helps you check what level of customization is possible for a lookup type.

There are three different types of common lookups available in Oracle Fusion that decide the customization for the lookup:

1. User lookup   – This is a flexible type of lookup; you can add new values and enable/disable the existing values to it.

2. Extensible lookup   – In this type of lookup, you can add new values but cannot disable the existing values.

3. System lookup   – System lookup does not allow you to add or disable the existing values.

Lookup Type and Its Components

Lookup Type   – Here, you can add values to the lookup. Note that this field name will appear on the setup screen and not on the application screen, where users usually make an entry into the application.

Meaning   – This is the name of the field that users will see on the screen, where they will add the value.

Module   – This is the name of the module to which this lookup belongs. It might be named as HR or Absence.

Lookup Configuration level   – As explained in the above section, lookup configuration has three values:

We can add values, known as lookup codes, in each lookup type.

The lookup codes consist of:

Lookup Code   – This signifies the value of each code that we have added. It is not visible to the users but it is used to uniquely identify values added to the lookup type.

Display Sequence   – This is used to mention the sequence of values they should appear in, for the users to select. It can be 1, 2, 3, etc.

Enabled   – The Checkbox helps you to enable or disable any particular lookup code.

Start Date and End Date   – You can specify a date range for each lookup code to make it available only within that range for users to select. If this is left blank, then it is always available for users.

Meaning   – This term will appear in the list of values on the UI for a specific field, which the user can see and select from the drop-down menu. It is associated with the lookup code.

Tag   – Tag is used for localizing the lookup code. For example, if we put +GB as Tag then this value will appear only for Great Britain localization; and if we put –GB, then it will not appear for Great Britain. If we leave this blank, it will appear for all areas.

You can create a new lookup type or enable/disable values by using the task under Setup and Maintenance -> Manage Common Lookups

Here is an example for lookup type 'EMP_CAT':

Business Case

If any customer based in GB wants to enable the 'Transgender' value for 'Gender', which is already present in the lookup type, they can navigate to the Manage Common lookups task. Since the lookup type for Gender is 'Sex', select the value 'Transgender' in the lookup codes section, and in the tag column enter '+GB'. Click on Save and Close.

To get all the details of lookups in the application, simply use the below query:

Select * from hcm_lookups;

So, this is how common lookups in Oracle HCM capture information for employees and provide the flexibility to manage value in these data fields.

Topics: Oracle , hcm

Written by Nilesh Pawar

Oracle Fusion HCM Consultant

Subscribe to Email Updates

Lists by topic.

• Digital Transformation (61)
• Salesforce (29)
• Oracle (25)
• Healthcare (21)
• Retail (17)
• Artificial Intelligence (15)
• Gen AI (13)
• Retail Tech (13)
• Cloud migration (10)
• Customer Experience (10)
• Health Cloud (10)
• Public Sector (8)
• UK Public Sector (8)
• data analysis (8)
• Cloud Technology (7)
• Digital Service Design (7)
• Managed Services (7)
• oracle HCM (7)
• Business Process Automation (6)
• Cloud Enhancement Services (6)
• Government (6)
• Machine Learning (6)
• customer data platforms (6)
• retail operations (6)
• Data Security (5)
• Financial Services (5)
• UK Central Government (5)
• data modernisation (5)
• research (5)
• thoughtleadership (5)
• Cloud-based AI (4)
• Digital Workforce (4)
• Digital commerce (4)
• Future Tech (4)
• Intelligent Automation (4)
• Manufacturing (4)
• Oracle Cloud Application (4)
• Oracle Partner (4)
• Supply Chain (4)
• Testing (4)
• Transformation (4)
• cloud implementation (4)
• data governance (4)
• edge computing (4)
• leadership (4)
• mortgages (4)
• mulesoft (4)
• workplace (4)
• AI Strategy (3)
• Data management (3)
• Government Digital services (3)
• IT service management (ITSM) (3)
• Intelligent Automation vs RPA (3)
• Oracle ERP Cloud (3)
• RPA Implementation (3)
• Robotic Automation (3)
• business outcomes (3)
• consumer market (3)
• human resources (3)
• metaverse (3)
• strategy (3)
• work management (3)
• AI technologies (2)
• Automation Testing (2)
• Cloud Adoption (2)
• Customer Engagement (2)
• Customer Insight (2)
• Data Science (2)
• DevOps culture (2)
• Government Tech (2)
• Identity & Access Management (2)
• Innovation (2)
• Intelligent Automation tools (2)
• Intelligent Process Automation (2)
• Mobile Testing (2)
• Operational Resilience (2)
• Oracle ERP (2)
• Security (2)
• Technology (2)
• automating systems and processes (2)
• business acceleration (2)
• business analysis (2)
• business uncertainty (2)
• cybersecurity (2)
• data integration (2)
• data migration (2)
• data modernization (2)
• data protection (2)
• data quality (2)
• data-driven intelligence (2)
• diversity and inclusion (2)
• ecommmerce (2)
• erp cloud implementation (2)
• erp consultant (2)
• governance (2)
• post pandemic (2)
• snowflake (2)
• work from home (2)
• #DevSecOps #SecOps #IAST #DAST #SAST #RASP (1)
• AI Algorithms (1)
• AI in the social sector (1)
• Agile BI (1)
• Agile Testing (1)
• Agile with GDS (1)
• Automated Testing (1)
• Automation (1)
• BizAnalytica (1)
• CEO Insight (1)
• CRM transformation (1)
• Chat Bots (1)
• Cognitive RPA (1)
• Cognitive Technologies (1)
• Compatibility Testing (1)
• Continous Delivery (1)
• DART Framework (1)
• Data Storage (1)
• Data Virtualisation (1)
• Data Visualisation (1)
• Data availability (1)
• DataGenius (1)
• DataOps (1)
• Deep Learning (1)
• DevSecOps (1)
• EPM Cloud (1)
• Education (1)
• Engineering colleges in Mumbai (1)
• Financial Consolidation and Close (1)
• Graduate Programme (1)
• IT consulting (1)
• Low-Code (1)
• MOT Framework (1)
• Mobile Content (1)
• Natural Language Processing (1)
• Oracle EPBCS (1)
• Oracle Field Service Cloud (1)
• Oracle SCM (1)
• Project Deep Blue (1)
• Project Management (1)
• Recovery Testing (1)
• SAP ECC (1)
• Salesforce Lightning (1)
• Scalability (1)
• Scaling AI (1)
• Semiconductor (1)
• Serverless Cloud Architectures (1)
• Service Management (1)
• TalentGenius (1)
• Tech consultant (1)
• TechNovation (1)
• Test Maturity (1)
• Trends in Testing (1)
• Workers Compensation (1)
• analytics (1)
• analytics practice (1)
• biometrics (1)
• branding (1)
• careers decomplexed (1)
• cloud modernization (1)
• connected enterprise (1)
• data modelling (1)
• data table (1)
• decomplexify (1)
• development (1)
• employee engagement (1)
• employee experience (1)
• financial crime (1)
• healthcare data (1)
• higher education (1)
• industrial iot (1)
• inhouse (1)
• intelligent job connect (1)
• intelligent parts assistant (1)
• inventory management (1)
• jobconnect (1)
• logistics (1)
• magento (1)
• marketing (1)
• outsource (1)
• outsystems (1)
• planning and budgeting (1)
• predective analytics (1)
• productivity (1)
• provider (1)
• public safety (1)
• talent acquisition (1)
• testing partnership (1)
• time management (1)
• zero touch operations (1)

Posts by Topic

Recent posts.

How to extract assignment category if employee has multiple active assignments

Employee A has multiple active assignments, when submitting absence for this employee, there's one option to select for which assignment/job/ID it's submitting for. But when it comes to absence entry valdiation fast formula, its assignment contexts is always the second assignment. Is there a way to extract the first assignment id / assignment category as well? Thanks in advance.

The DBI I used is PER_ASG_EMPLOYMENT_CATEGORY. 

Code Snippet

• Absence Management

Howdy, Stranger!

To view full details, sign in.

Don't have an account? Click here to get started!