Total Pageviews

Saturday, August 24, 2019

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


Monday, June 3, 2019

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

Sunday, May 26, 2019

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.




Thursday, May 16, 2019

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.



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)





Important Schedule process List

Some of the important Schedule process List:


Post-Conversion Processing: (1-5)
After an initial or incremental load of person records, you run a set of processes to complete data setup in the Oracle Fusion HCM environment. This is done to either create indexes or additional data based on the conversion you just did. Please ensure you are running these programs after conversion and also evaluate post go-live activities to see if you should schedule these programs to run on a daily basis.

1.      Update Person Search Keywords
 
Copies attributes of person, employment, and profile records that are used as search keywords to the PER_KEYWORDS table, where they're indexed to improve search performance. The process updates the entire PER_KEYWORDS table.

2.      Synchronize Person Records

Communicates changes to person and assignment records that have occurred since the last data load to consuming applications, such as Oracle Fusion Trading Community Model and Oracle Identity Management (OIM).

3.      Calculate Relationship Strength

Updates stored relationship-strength information. In the Person Gallery, search results can appear in order of the strength of the relationship between the person performing the search and each person in the search results. The stronger the relationship, the nearer to the top of the results a person's assignment appears.

4.      Refresh Manager Hierarchy

Populates the denormalized manager hierarchy tables with latest information after each data load. For performance reasons, the complete manager hierarchy for each person is extracted from live data tables and stored in a separate manager-hierarchy table, known as the denormalized manager hierarchy

USER AND ROLE PROVISIONING PROCESSES: (5-8)

SCHEDULING THE PROCESSES
You should run one user and role provisioning process at a time. These processes should not overlap. Please make sure your schedule allows time for the process to complete before you schedule another provisioning process.

5.      Send Pending LDAP Requests (Daily Ad Hoc): Bulk processing of user and role provisioning requests.

Sends bulk requests to OIM immediately to create (and also suspend or re-enable) user accounts, as appropriate. When you load person records, the application automatically creates user-account requests by default and provisions roles to users in accordance with role provisioning rules.
Important
Before you run this process, review your data conversion fully and confirm its accuracy. If you need to purge your data and repeat the conversion, it will take much longer if you've created user accounts and notified users of their sign-in details. You can control aspects of the
provisioning process for the enterprise by setting the User and Role Provisioning options on the Manage Enterprise HCM Information page. For example, you can suppress the automatic creation of user accounts.

This process sends to the LDAP directory the requests related to user account provisioning as well as the requests for adding and removing user roles. You typically use this to process the provisioning requests created by bulk processes as well as to process future dated requests.

This job should be scheduled at least once per day to handle any bulk or future-dated user or role provisioning requests.
This job should also be run after loading workers or users in bulk using HCM Data Loader.


6.      Autoprovision Roles for All Users (Ad Hoc Rarely): Evaluates roles membership for all users, including inactive.

This process evaluates all users in the system against the role provisioning rules. This process may have heavy performance impact on your environment if you run it regularly. You should run this process occasionally, only when role-provisioning rules are added or updated.

Should be run only when role mapping rules have been added or changed, and these rules apply to the entire user population.
This job does not need to be regularly scheduled as automatic role provisioning happens as part of user creation.
Never expected to be used frequently on daily basis.


7.      Send Personal Data for Multiple Users to LDAP(Ad Hoc Rarely): Reconciles personal information changes in Oracle HCM Cloud with LDAP directory

This process synchronizes changes performed in bulk on Oracle HCM Cloud person records with the LDAP directory records. The following fields are synchronized: First Name, Last Name, Email, and Manager. You typically run this process after loading person data in bulk. You can also run this process to update the manager hierarchy in the LDAP directory.

This job is only needed after changing personal data (name, manager, email) via a bulk process such as HCM Data Loader imports.
This job should be scheduled to run once after the bulk load is complete.

8.      Retrieve Latest LDAP Changes (Very rarely): Updates Oracle HCM Cloud person records with data coming from LDAP directory.

This job updates the Oracle Cloud Applications Security tables with data coming from the LDAP directory. You should run this process once after the product update is completed. For example, after you upgrade from 18C to 19A.

Never expected to be used frequently on daily basis.

9.      Synchronize Bell Notifications (Every 2 hours): Bell Notifications to synchronize with the BPM Worklist

To move the already approved notifications from bell, there is an ESS job definition which can be scheduled to run periodically. Privilege Needed to Schedule/Execute this Job Definition is : FND_MANAGE_SCHEDULED_JOB_DEFINITION_PRIV ( This privilege rolls up to all the Family Admin Job Roles).
They will be marked as Read/moved from Pending Notifications to All Notifications immediately once the user reads them as there are no pending actions on them.

The Synchronize Bell Notifications  should be scheduled  for every 2 hrs. and is restricted by Development to update  500 records at a time.

10.  Calculate Seniority Dates(Adhoc): To calculate the seniority dates for workers based on the seniority rules configured in the application

Parameters:
Person Number: Enter person number
Seniority Date Code List: ORA_ESD_P,ORA_LESD_W( This values may be different based on the customer configurations--See the configuration setup data table for this information) (ORA_ESD_P,ORA_LESD_W,ORA_POSITION_SD_A)
Exclude terminated Workers: Yes
Operation: Clean And Repopulate

Setup and Maintenance > Manage Common Lookups using the Lookup
Type ORA_PER_SENIORITY_ITEMS

11.  Synchronize Transaction Workflow Status(Daily once and Adhoc):

This process ensures that the workflow status is updated correctly in SOA and Oracle Fusion Applications

12.   Import User and Role Application Security Data (Daily Once) : To set up and maintain the Security Console

It copies users, roles, privileges, and data security policies from the LDAP directory, policy store, and Applications Core Grants schema to Oracle Fusion Applications Security tables. IT Security Manager : this role must to run this process.

13.  Importing User Login History (Daily Once) :This task runs a process that imports information about user access to Oracle Fusion Applications to the Oracle Fusion Applications Security tables

This information is required by the Inactive Users Report, which reports on users who have been inactive for a specified period.

14.  Optimize Person Search Keywords (Daily at times of low activity):

Optimize Person Search Keywords Index process to identify the fragmented indexes and help improve the overall search performance.

The Update Person Search Keywords process first and then the Optimize Person Search Keywords process. We cannot schedule both processes simultaneously. If you schedule them at the same time, the second process will wait for the first process to complete before it starts.

15.  Process and Reassign Inactive User Accounts(Daily Once):

Process that identifies inactive user accounts and removes them from their teams. It also sends notifications to members reassigned as the new team leads.

16.   To reflect the Flex Fields in OTBI then we need to run the below process in sequence:
A.      Create Rules XML File for BI Extender Automation
B.      Import Oracle Fusion Data Extension For Transactional Business Intelligence

Note: Should check the BI Enabled check box while creating the segments and should deploy the Flex fields.

17.  Generate Flexfield Database Items: (EFF / EIT only):

We should run this process after creating the flex fields and deploy successfully. Then only the Flex Fields DBI's will available in  Fast Formulas and HCM Extracts.

Note: Navigator --> Payroll Checklist --> Tasks --> Submit a process or Report --> search Generate Flexfield Database Items --> run this wi out selecting any LDG.

18.  Run Reassign Pending Approvals for Terminations and Correct Invalid Supervisor Assignments Process (Daily Once):

This process automatically reassigns the direct line reports. All direct reports are reassigned to the transferring manager's manger as of the date following the transfer.
Reassign the line reports manually to the transferring manager's manager during the global transfer transaction or terminated.


Enable Advanced Edit in HCM Extracts- After 24A update

 Enable Advanced Edit in HCM Extracts- After 24A update After 24A update Oracle deprecated the advanced edit in HCM Extracts. To Enable the ...