ASSIGNMENT EXTENSIBLE FLEXFIELDS (EFF) IN ADDITIONAL ASSIGNMENT INFO PAGE

ASSIGNMENT EXTENSIBLE FLEX FIELDS (EFF) IN ADDITIONAL ASSIGNMENT INFO PAGE

In 19 D Oracle provided the ability of users to manage and view the additional assignment information (assignment extensible flex field).

Navigation :
My Teams --> My Teams --> Click on Actions (3 horizontal dots) of any employee --> Additional Assignment Info

My client groups --> quick Actions (show more) --> Additional Assignment Info

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

HOW TO RUN THE BIP REPORT BY INITIATING SOAP “SCHEDULE PROCESS”?

How to run the BIP report by Initiating Soap “schedule process”?

1. Create the BIP Report.
2. Attach the report to the custom schedule process.
3. Run the Custom schedule process using the SOAP WebService(ess/esswebservice?WSDL)

Create an BIP report for the below SQL:

SELECT PAPF.person_number,  ABS_PLAN.NAME Plan_Name, Bal_Entrie.end_bal balance

FROM per_all_people_f PAPF,per_all_assignments_f PAAF, anc_absence_plans_f_tl ABS_PLAN, anc_absence_plans_f aapf, anc_per_accrual_entries Bal_Entrie

WHERE 1=1 AND PAAF.person_id = PAPF.person_id AND Bal_Entrie.person_id = PAPF.person_id AND Bal_Entrie.prd_of_svc_id = PAAF.period_of_service_id AND ABS_PLAN.absence_plan_id = aapf.absence_plan_id AND Bal_Entrie.plan_id = aapf.absence_plan_id AND Bal_Entrie.accrual_period = (SELECT MAX (Bal_Entrie1.accrual_period) FROM anc_per_accrual_entries Bal_Entrie1 WHERE 1 = 1 and Bal_Entrie1.accrual_period <= trunc(sysdate) AND Bal_Entrie1.person_id = Bal_Entrie.person_id AND Bal_Entrie1.prd_of_svc_id = Bal_Entrie.prd_of_svc_id AND Bal_Entrie1.plan_id = Bal_Entrie.plan_id) AND PAAF.primary_flag = 'Y' AND PAAF.assignment_type ='E' AND PAAF.assignment_status_type = 'ACTIVE' AND aapf.plan_status = 'A' AND ABS_PLAN.LANGUAGE = 'US' AND TRUNC (SYSDATE) BETWEEN PAPF.effective_start_date AND PAPF.effective_end_date AND TRUNC (SYSDATE) BETWEEN PAAF.effective_start_date AND PAAF.effective_end_date AND TRUNC (SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_date AND TRUNC (SYSDATE) BETWEEN ABS_PLAN.effective_start_date AND ABS_PLAN.effective_end_date AND PAPF.person_number = nvl(:person_number,PAPF.person_number) order by PAPF.person_number,ABS_PLAN.name

Setup and Maintenance à Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications

 In Manage Job Definition à create the New job (+)

Navigator à Tools à Schedule Process à Search the custom Job

Oracle doc link : https://docs.oracle.com/en/cloud/saas/supply-chain-management/20a/faicf/enterprise-scheduler-job-definitions-and-job-sets.html#FAICF2383281

Run the custom schedule process using the SOAP Service:

http://xyz-test.fa.em6.oraclecloud.com/ess/esswebservice?WSDL

SAOP Service:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sch="http://xmlns.oracle.com/scheduler" xmlns:typ="http://xmlns.oracle.com/scheduler/types">

   <soapenv:Header/>

   <soapenv:Body>

      <sch:submitRequest>

         <sch:description>Get Employee Absence Plan Balance</sch:description>

         <sch:jobDefinitionId>

            <!--Optional:-->

            <typ:name>GET_EMPLOYEE_ABSENCE_PLAN_BALANCE</typ:name>

            <!--Optional:-->

            <typ:packageName>/oracle/apps/ess/custom/absence</typ:packageName>

            <!--Optional:-->

            <typ:type>JOB_DEFINITION</typ:type>

         </sch:jobDefinitionId>

         <sch:application>EarHcmEss</sch:application>

         <sch:requestedStartTime>2020-05-26T13:12:32.825Z</sch:requestedStartTime>

         <sch:requestParameters>

            <!--0 to 1000 repetitions:-->

            <typ:parameter>

               <!--Optional:-->

               <typ:dataType>STRING</typ:dataType>

               <!--Optional:-->

               <typ:name>submit.argument1</typ:name>

               <!--Optional:-->

               <typ:value>1675</typ:value>

            </typ:parameter>

         </sch:requestParameters>

      </sch:submitRequest>  </soapenv:Body>

</soapenv:Envelope>

Useful SQL’s to fill the payload details:
SQL to gather job definition and application runtime details:
select DEFINITION, APPLICATION
from FUSION.ESS_REQUEST_HISTORY
where requestid=138848
DEFINITION APPLICATION
JobDefinition://oracle/apps/ess/custom/absence/GET_EMPLOYEE_ABSENCE_PLAN_BALANCE EarHcmEss

SQL to gather runtime job parameters details:

select NAME,DATATYPE,VALUE
from FUSION.ESS_REQUEST_PROPERTY
where requestid=138848
and name like 'submit%'
NAME DATATYPE VALUE
submit.argument1 String 1675


SQL to gather notification parameter details
select NAME, DATATYPE, VALUE
from FUSION.ESS_REQUEST_PROPERTY
where requestid=138848
and name like 'pp%'
NAME DATATYPE VALUE
pp.1.argument1 String USER
pp.1.argument2 String MyRecipientUserToBeNotified
pp.1.description String Notify


It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

User Password Change Audit report

                                      User Change password Audit report

To Run this report User should have the  ASE_USER_PASSWORD_CHANGES_AUDIT_REPORT_PRIV or IT security Manger Job Role.

This is a schedule process, to run this process :

Tools => Schedule Process =>  Schedule New Process => select User Password Change Audit Report and run this process by giving the parameters.

Example:

1. Go to security console which is under tools.
2. select the Users tab and search any user.

 3. Under Actions select the Reset password.

 4. Change the password and click on reset password.

5. Tools => Schedule Process =>  Click Schedule New Process

6. Select the Job : User Password Change Audit Report

7. In User Pattern We can select the All Users or specific user or the User Name with some pattern

 8.  Select the start date and end date that we want a report. Click on submit.

 9. After the process succeeded, Click on attachments.

10. We can download the report in CSV or XML formats that we need.

 11. The report will be like this:

Here Updated By is the user who reset the password.

Here Updated Types can be three:

1. ADMIN: Line Manager or security Manager.
2. SELF_SERVICE : User Made the change in set preferences or reset the password.
3. FORGOT_PASSWORD : User click on forgot password to reset the password.

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

Delete a future dated record using HDL:

To delete we have to use SET PURGE FUTURE CHANGES Y and update the end date for the prior record

For example for employee with person number Test001, there is future date change from 2018/12/01 like below

METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|WorkerType|BusinessUnitShortCode|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y|2018/11/30|ASG_CHANGE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/12/01|1|Y||ASG_CHANGE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS

METADATA|Assignment|AssignmentNumber|WorkTermsNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|BusinessUnitShortCode|WorkerType|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y|2018/11/30|ASG_CHANGE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/12/01|1|Y||ASG_CHANGE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS


To delete the future dated change, include SET PURGE FUTURE CHANGES Y

SET PURGE FUTURE CHANGES Y
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|WorkerType|BusinessUnitShortCode|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y||ASG_CHANGE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 


METADATA|Assignment|AssignmentNumber|WorkTermsNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|BusinessUnitShortCode|WorkerType|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y||ASG_CHANGE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

Authentication Information of REST API's

Authentication Information of REST API's:
REST API Links:


https://yyyy.hcm.ap8.oraclecloud.com:443/hcmRestApi/resources/11.13.18.05/emps

or

https://yyyy.fa.ap8.oraclecloud.com:443/hcmRestApi/resources/11.13.18.05/emps

Note: Earlier oracle is using hcm (Human capital Management) servers now they changed it to fa (Fusion Application) servers. Now both are working but recommend one is fa .

We can Post data through using API without authorization:

Oracle REST API Authentication:
Authentication policy enforces the following authentication mechanisms, based on the token a client uses:
•    Basic authentication (Should have the UserName and Password)
•    SAML (Security Assertion Markup Language) 2.0 Bearer token (Passwords are handle in configuration file)
•    JWT (JSON Web Token) token (Passwords are handle in configuration file)

SAML (Security Assertion Markup Language) :
XML-based framework for authentication and authorization between Service Provider and an Identity Provider. SAML is a standard single sign-on (SSO) format. Authentication information is exchanged through digitally signed XML documents. With SAML, you do not have to worry about typing in authentication credentials or remembering and resetting passwords.

JWT token :
This is also similar like SAML but encoded as a JSON object that is digitally signed using JSON Web Signature. Here also no need to worry about typing in authentication credentials or remembering and resetting    passwords.

Note:
If We reset the SSO (Single sign On) password or Oracle Cloud application password then we should have to run three process. The process should have to run in the following mentioned order:
1.    Send Pending LDAP Requests
2.    Retrieve Latest LDAP Changes
3.    Import User and Role Application Security Data

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

How to use the Deeplinks

How to use the Deeplinks:

Create the sandbox. And click on Deep Links which is under Tools.

The available deep links list it will show.

Select the deep link what you want and copy the highlighted one which is in brackets.

Then go to structure which is under configuration.

Create the page entry.

Use the below one and give the object that you selected earlier.

deeplink?objType=

examples:

1.       deeplink?objType=MANAGE_ABSENCE_RECORDS

2.       deeplink?objType=ADD_ASSIGNMENT&action=EDIT

3.       deeplink?objType=UPDATE_PHOTO&action=NONE

Give the created deep link in viewID and select the web application as ORA_HCM_UI as shown below.

Save and close and do testing. After testing publish the sandbox.

After clicking the icon it will directly navigate to the Absence Records.

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

How to enable HCM Experience Design Studio:

Transaction Design Studio:

The Transaction Design Studio (TDS) is available within the HCM Experience Design Studio. It is in Beta phase, so the features and actions are limited at this time. For more functionality we must wait for new releases.

TDS allows to create rules to configure transactions and pages in the responsive user designed pages. We can change how sections and fields are displayed, based on the user's role and the employee's business unit or legal employer. we can create one or more rules for any page available in the TDS. We can control the visibility of attributes within a page or region or section. And control the availability of questionnaire pages. We can change the required status of the attributes using TDS.

For example:

We can make the fields visible and required in the New Hire page for the employees in the US and employees in other countries.

We can hide the some of sections like salary for the US employees who got promotion and visible for other countries. Depends on legal employer we can hide the fields like Ethnicity and religion fields from the personal Details page. We can still modify the person spotlight and upload images for pages that use the HCM landing page design.

How to Enable the Transaction Design Studio:

1.      User should have the Application Administrator role.

The delivered Human Capital Management Application Administrator inherits the privilege Access HCM Transaction Configurator (HRC_ACCESS_HCM_TRANSACTION_CONFIGURATOR) which gives access to the Transaction Design Studio in the HCM Experience Design Studio.

1.      Enable the responsive pages.

Manage Administrator profile values --> serach HCM Responsive Pages Enabled  --> set profile value to Y

  Enable Quick Actions.

By selecting News Feed

 My client groups --> click more under Quick Actions 

Note: All these can be done by activating sandbox and edit the pages on site level.

Trick: HCM Transaction studio still shows error like activate sandbox and edit the pages on site level then click on edit pages on the page where you are getting error and then go to dashboard page and come back to the HCM transaction design studio page. This will definitely work.

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath

Parameters that are available from 19A that can be used in value sets for Flex fileds:

The below attributes can be used in value sets as parameters:

The following attributes have been enabled for the Assignment (PER_ASG_DF) Flexfield:

Action (ACTION_CODE)

Action Reason (REASON_CODE)

Assignment Category (EMPLOYMENT_CATEGORY)

Assignment Status (ASSIGNMENT_STATUS_TYPE)

Assignment Status ID (ASSIGNMENT_STATUS_TYPE_ID)

Bargaining Unit (BARGAINING_UNIT_CODE)

Business Unit (BUSINESS_UNIT_ID)

Collective Agreement (COLLECTIVE_AGREEMENT_ID)

Department (ORGANIZATION_ID)

Effective End Date (EFFECTIVE_END_DATE)

Effective Start Date (EFFECTIVE_START_DATE)

Grade (GRADE_ID)

Job (JOB_ID)

Legal Employer (LEGAL_ENTITY_ID)

Legislation (LEGISLATION_CODE)

Legislation (LEGISLATION_CODE_VALUE)

Location (LOCATION_ID)

Person ID (PERSON_ID)

Person Type (PERSON_TYPE_ID)

Primary Assignment Flag (PRIMARY_ASSIGNMENT_FLAG)

Primary Flag (PRIMARY_FLAG)

Union (UNION_ID)

Worker Category (EMPLOYEE_CATEGORY)

Worker Type (SYSTEM_PERSON_TYPE)

The following attributes have been enabled for the Work Relationship (PER_PPS_DF) Flexfield:

Legal Employer (LEGAL_ENTITY_ID)

Legislation (LEGISLATION_CODE)

Period of Service ID (PERIOD_OF_SERVICE_ID)

Period Type (PERIOD_TYPE)

Person ID (PERSON_ID)

Primary Flag (PRIMARY_FLAG)

Start Date (DATE_START)

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath