Query to get the List of Legal Employer and Legal employer Organization id
SELECT hauft.organization_id, hauft.NAME, houcf.classification_code FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf,
Query to get the List of Business Units and Business Unit id
SELECT hauft.organization_id business_unit_id, hauft.NAME, houcf.classification_code FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft
Query to get the list of departments with department (organization id)
SELECT hauft.organization_id, hauft.NAME FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID AND haouf.ORGANIZATION_ID = hauft.ORGANIZATION_ID
Can we search the employee by using the worker number in the system
No, we cannot search, we can search the employee by using person number.
What is Vertex?
The vertex is the 3rd party company that provides the geographic data for us and Canada, for other countries it is GBQ Loqate.
Access Succession Plan and Talent related functions privileges
Function Security Policies · Create Succession Plan for Worker · Manage Succession Plan · Manage Succession Plan Candidate
Sample HDL file for Organization (Classification - Department)
Dat file name - Organization.dat METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationCode| LocationSetCode|SourceSystemOwner|SourceSystemId
Load Metadata File for Position Creation using HDL
Dat file name - Position.dat METADATA|Position|EffectiveStartDate|EffectiveEndDate|BusinessUnitName|PositionCode|Name| DepartmentName|JobSetCode|JobCode|LocationCode|EntryGradeCode|ActiveStatus|FTE|HiringStatus| HeadCount|OverlapAllowedFlag|WorkingHours|Frequency|FullPartTime|PositionType|FLEX:PER_POSITIONS_DFF| dbsCheckRequired(PER_POSITIONS_DFF=Global Data Elements)|dbsFrequency(PER_POSITIONS_DFF=Global Data Elements)|SourceSystemOwner|SourceSystemId
Sample HDL file for Location creation
Dat file name - Location.dat METADATA|Location|EffectiveStartDate|EffectiveEndDate|LocationCode|SetCode|ActiveStatus| LocationName|AddressLine1|AddressLine2|Country|PostalCode|TownOrCity|SourceSystemOwner| SourceSystemId
Sample HDL file for Job creation
Dat file name - Job.dat METADATA|Job|EffectiveStartDate|EffectiveEndDate|JobCode|SetCode|Name|JobFamilyName| ActiveStatus|SourceSystemOwner|SourceSystemId|ApprovalAuthority
How to setup Career Outlook
Background A client wants to set up the career outlook so that employees can find the next career opportunities
Overview of Reverse Legal Employer
Background HR Specialist did the global transfer and now he wants to reserve the employee again in the previous legal employer.
How to enabled Web Clock for an Employee
We need to add some Function security policies in order to get the web clock access. Please add the below Function security policies
Not getting the learning content items
If we are not getting the learning contents created, then we need to run the below schedule processes · Rebuild Learning Item Indexes
How to identify in which environment rich media is enable by using SQL Query
select * from FUSION.ASK_DEPLOYED_APPLICATIONS where NAME in ('ORA_VIDSTORAGESERVICEAPP' ,'ORA_VIDTRANSCODINGSERVICEAPP', 'ORA_STREAMINGCONTENTDELIVERYAPP',
How to access sandbox without assigning Application Implementation Consultant Role
If you don’t want to assign the Application Implementation Consultant role to access the sandbox, then create a sample job role with the below privileges and assign it to the required user. With this job role, the role user will be able to access the sandbox without assigning the Application Implementation Consultant role.
How to Enable Global Search
STEPS TO ENABLE Enable the profile option FUSION_APPS_SEARCH_ENABLED using these steps: Navigate to the Setup and Maintenance work area.
How to get the compensation plan id and option id using SQL Query
Go to Tools a Reports and Analytics a Click on Browse Catalog a Click on New a Select Data Model a click on + icon a select SQL Query a enter any name a select ApplicationDB_HCM a write the query in the SQL Query box a click on OK
Enable Candidate Security Profile
STEPS TO ENABLE Enable the profile option ORA_IRC_CANDIDATE_SECURITY_ENABLED using these steps: Navigate to the Setup and Maintenance work area. Search for and click the Manage Administrator Profile Values task.
How to get the active employees using SQL Query
Solution/Workaround We need to run the below query to get the require data
Categories
- All Posts
- Absence Management
- Absence Management - Issues
- Benefit Management
- Common for all modules
- Compensation Management
- Compensation Management - Issues
- Global Human Resource
- Global Human Resource - Issues
- Human Resource Helpdesk
- Oracle Learning Cloud
- Oracle Learning Cloud - Issues
- Oracle Recruiting Cloud
- Oracle Recruiting Cloud - Issues
- Talent Management
- Talent Management - Issues
- Technical Contents
- Technical Contents - Fast Formula
- Technical Contents - HDL Templates
- Technical Contents - OTBI Reports
- Technical Contents - Spreadsheet Loader
- Technical Contents - SQL Query
- Technical Contents - SQL-HDL
- Time and Labor
- Time and Labor - Issues