How can I get the attachment details of the files uploaded for a Document Record?
SELECT papf.person_number ,ppnf.full_name ,fdv.file_name ,fdv.dm_document_id ,hdpr.date_from ,hdpr.date_to FROM per_periods_of_service ppos
Overview of Learning Community
A learning community is a place where learning can be grouped around a certain topic or area of interest and shared with or given to a specific group of people, who are called community members. The goal of a community can range from a
Get the List of username, person no, role name, role code, department
select distinct papf.person_number,pu.username,prdt.role_name Role_Name,prd.role_common_name ,dept.name Department from per_All_people_F papf, PER_USER_ROLES pur, per_users pu,
Get the count of person records those who don't have work email id
select COUNT(1) FROM PER_ALL_PEOPLE_F papf where papf.person_id in ( SELECT ppos.person_id FROM per_periods_of_service ppos )
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
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
- 01. Common for all modules
- 02. Questionnaire For Client
- Absence Management (DEFINITION)
- Absence Management (HDL Templates)
- Absence Management (ISSUES)
- Absence Management (REQUIREMENT)
- Benefit Management (DEFINITION)
- Compensation Management (DEFINITION)
- Compensation Management (FAQ)
- Compensation Management (ISSUES)
- Fast Formulas (FF)
- Global Human Resource (DEFINITIONS)
- Global Human Resource (FAQ)
- Global Human Resource (HDL Templates)
- Global Human Resource (ISSUES)
- HDL Templates (Data Loader)
- Human Resource Helpdesk (DEFINITION)
- Journeys (FAQ)
- Oracle Learning Cloud (DEFINITION)
- Oracle Learning Cloud (FAQ)
- Oracle Learning Cloud (HDL Templates)
- Oracle Learning Cloud (ISSUES)
- Oracle Payroll Cloud (HDL Template)
- Oracle Recruiting Cloud (DEFINITION)
- Oracle Recruiting Cloud (FAQ)
- Oracle Recruiting Cloud (ISSUES)
- Oracle Time and Labor (DEFINITION)
- Oracle Time and Labor (ISSUES)
- OTBI Report
- Redwood_Visual Build Studio_RWPHT (DEFINITION)
- Redwood_Visual Build Studio_RWPHT (FAQ)
- Redwood_Visual Build Studio_RWPHT (ISSUES)
- Spreadsheet Loaders (HSDL)
- SQL Queries (SQLQ)
- SQL Queries + HDL Template
- Talent Management (DEFINITION)
- Talent Management (FAQ)
- Talent Management (HDL Templates)
- Talent Management (ISSUES)
- Technical Contents (DEFINITION)
- Touchpoints (DEFINITION)
- Touchpoints (FAQ)