oracle fusion assignment types

ASSIGNMENT_TYPE from PER_ALL_ASSIGNMENTS_M

Our employment model is 2 Tier - Single Assignment. Possible Values in ASSIGNMENT_TYPE field in PER_ALL_ASSIGNMENTS_M record - P, PT, E & ET.

Curious to know what does each of them implies. I believe E refers 'employee'.

Even if I query latest row for an active employee, it returns two rows - one with E and one with ET. Wonder where is ET coming from.

• Configuration
• Workforce Directory

Howdy, Stranger!

To view full details, sign in.

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

• Tables and Views for HCM

PER_ASSIGNMENT_STATUS_TYPES

This table holds pre-defined and user defined status types (for Assignments or Sets of Employment/Placement Terms). Current seeded values will have to be revisited to ensure we remove obsolete values and incorporate Enterprise statuses.

Schema: FUSION

Object owner: PER

Object type: TABLE

Tablespace: REFERENCE

Primary Key

• Manage VIP Account
• Register for VIP Plan
• VIP Member-Only Content
• HCM Data Loader
• HCM Extract
• BI Publisher
• Fast Formula
• OTBI Analytics
• Personalizations
• Scheduled Processes
• Absence Management
• Performance Management
• Talent Management
• Time & Labor
• HCM Extracts Questions
• HCM Data Loader Questions
• BI Reports Questions
• Report Issues/suggestions
• Your Feedback counts
• Write for Us
• Privacy Policy
• Join Telegram Group
• Join LinkedIn Group
• Join Facebook Page

Assignment Type and its importance in HCM Cloud

• Post category: Core HR
• Post comments: 0 Comments
• Post last modified: July 1, 2021
• Reading time: 4 mins read

In this article, we will look into the Assignment Types available in HCM Cloud and how to use them in the reports.

Each worker type is denoted by its alphabet value in the ASSIGNMENT_TYPE and PERIOD_TYPE columns of the PER_ALL_ASSIGNMENTS_M and PER_PERIODS_OF_SERVICE tables respectively. Both ASSIGNMENT_TYPE and PERIOD_TYPE should have the same values for the given work terms record.

For example, pending worker is denoted by P, employee by E, contingent worker by C, nonworker by N, and offer by O.

Both Assignment and Work Terms information will be stored in PER_ALL_ASSIGNMENTS_M table with a different ASSIGNMENT_TYPE.

Now, if you are building reports based on the Assignment table, we should use the right Assignment types.

If we have to pull Employees only, we need to use ASSIGNMENT_TYPE = ‘E’. If you use ASSIGNMENT_TYPE <>’ET’ then this query might work if you ONLY have Employees in the client POD without any contingent workers and pending workers, else it will pull additional employees on the report.

I have seen many cases where the developers used ASSIGNMENT_TYPE NOT IN (‘ET’,’CT’).. In this case, it will pull Employees, Contingent Workers, Non-Workers, and Offers. Instead of writing like this, it is better to rewrite it as ASSIGNMENT_TYPE IN (‘E’,’C’) if there is a need for pulling Employees and Contingent Workers.

You Might Also Like

How to attach Requisition Templates to Positions in bulk?

How to Purge Person Data from Non-Prod Instances?

How to modify the Person Number after hiring the employee?

Session expired

Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.

Assignment Types in Oracle Fusion HCM

In Oracle Fusion HCM, “Assignment Types” are used to categorize different types of employment assignments or job roles that employees can have within the organization. Assignment Types help organizations define and manage various employment scenarios and roles for their workforce.

Here are the key characteristics and functionalities of Assignment Types in Oracle Fusion HCM:

• Configuration:  HR administrators can configure Assignment Types in the system based on the organization’s job structures and requirements. Each Assignment Type is associated with specific settings, such as employment category, worker type, pay basis, work hours, and other relevant attributes.
• Employment Categories:  Assignment Types are often linked to specific employment categories, such as regular employee, contingent worker, contractor, intern, etc. Each employment category may have its own set of rules and entitlements.
• Worker Types:  Different worker types may be associated with various Assignment Types, such as full-time employees, part-time employees, temporary workers, seasonal workers, and more.
• Pay Basis:  Assignment Types can be linked to different pay bases, such as hourly, salaried, or commission-based, to define how employees are compensated.
• Work Hours:  Some Assignment Types may have predefined work hours, such as standard hours per week or flexible work hours.
• Termination Rules:  Each Assignment Type may have specific termination rules that dictate how employment is ended for employees in that category.
• Leave and Absence Rules:  Assignment Types may also influence leave entitlements and absence policies for employees with different employment scenarios.
• Integration with Core HR:  Assignment Types are closely related to Core HR data and play a significant role in defining employee records and job assignments.

Oracle Fusion HCM Training Demo Day 1 Video:

Conclusion:.

Unogeeks is the No.1 Training Institute for Fusion HCM Training. Anyone Disagree? Please drop in a comment

You can check out our Oracle Fusion HCM Training details here Oracle Fusion HCM Training

You can check out our other latest blogs on Oracle Fusion HCM Training in this Oracle Fusion HCM Blogs

———————————-

For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at: [email protected]

Our Website ➜  https://unogeeks.com

Instagram:  https://www.instagram.com/unogeeks

Facebook:  https://www.facebook.com/UnogeeksSoftwareTrainingInstitute

Twitter:  https://twitter.com/unogeeks

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

• Skip to content
• Accessibility Policy
• Oracle blogs
• Lorem ipsum dolor
• Oracle Fusion Analytics ,

Implementing Custom Security Context in Oracle Fusion Data Intelligence (FDI)

An organization leverages Oracle Fusion Data Intelligence (FDI)'s limited availability feature , Configurable Security Context , to implement custom, granular data access controls. This feature allows the organization to restrict data visibility based on cost segments and balancing segments, ensuring users can only access financial data relevant to their assigned segments within the FDI reporting environment. By implementing custom security contexts, the organization can maintain precise control over financial data access at a departmental level.

Configurable Security Context

This Limited Availability feature enables security administrators to define custom security contexts. These contexts are applied to custom application roles.

1. Feature Enablement

• Enable the Configurable Security Context feature (Limited Availability feature).
• Verify the Security Configuration tab is accessible in the application role settings.

2. Custom Role Creation

Create two custom application roles:

• CustomCostSegment: For controlling access based on cost center
• CustomSecBalSegmentRole: For controlling access based on balancing segments

3. Security Context Configuration

For both the roles, set up Security Configurations. This tab is enabled only when the Configurable Security Context feature is enabled.

• Provide the Name of the custom context.
• Select the attribute on this context that should work. (Expand the subject areas and   then folders to select the particular attribute)
• Mention the fact which needs to be secured.

For CustomCostSegment:

• Context Name: CustomCostSegmentContext
• Attribute Selection: Cost Center attributes from subject areas
• Secured Facts: Relevant financial metrics

For CustomSecBalSegmentRole:

• Context Name: BalancingSegment_SecCont
• Attribute Selection: Balancing Segment attributes

Functional group:  This is an optional field. By choosing the functional groups associated with  each security filter, you can control how the filters are combined using the OR and AND  operators. All the filters in the same functional group are combined using the OR  operator and all sets of filters in different functional groups are combined using the AND  operator.

4. Group Management

• Create security group Config_Sec
• Add relevant users to the group
• Map custom application roles to the group:
•    CustomCostSegment
•    CustomSecBalSegmentRole

Security Assignments

In the drop down, now it shows the custom contexts created in the previous steps. Select the BalancingSegment_SecCont context and select the balancing segment code which should be visible to that user.

For BalancingSegment_SecCont:

• Assign specific balancing segment codes (e.g., 305,403)
• Configure security values for data access

For CustomCostSegmentContext:

• Assign specific cost center codes (e.g., 000)
• Configure associated security values

Under the user tab, select the user, and check the security assignments of the group.

In this example, Balancing Segment 305, 403, and Cost Center 000 are assigned to this user. Note that this user must have the required duty roles to access these subject areas. See  these documents for more details.

1. Log in using the user which is included in the custom group.

2. Verify user has required duty roles

3. Create sample reports to validate:

• Data should only show transactions for cost center 000
• Data should only show transactions for balancing segment 305 and 403
• If functional groups are not selected, full outer join results are shown

Call to Action

Take action now to enhance your data security with the Configurable Security Context feature limited availability feature in Oracle Fusion Data Intelligence (FDI). By enabling this feature, creating custom roles, configuring security contexts, and setting up proper user group mappings, you can ensure precise control over data access based on cost segments and balancing segments. Implement this solution to strengthen your organization's security while maintaining operational efficiency.  Now that you've read this article, try it yourself and let us know your results in the Oracle Analytics Community , where you can also ask questions and post ideas.

Girish Achutha

Previous Post

Seamless Salesforce Integration with FDI for Enhanced Data Analytics

• Analyst Reports
• Cloud Economics
• Corporate Responsibility
• Diversity and Inclusion
• Security Practices
• What is Customer Service?
• What is ERP?
• What is Marketing Automation?
• What is Procurement?
• What is Talent Management?
• What is VM?
• Try Oracle Cloud Free Tier
• Oracle Sustainability
• Oracle COVID-19 Response
• Oracle and SailGP
• Oracle and Premier League
• Oracle and Red Bull Racing Honda
• US Sales 1.800.633.0738
• How can we help?
• Subscribe to Oracle Content
• © 2024 Oracle
• Privacy / Do Not Sell My Info