Assignment Supervisor Flexfield is not visible in Manage Employment page though it has been configured in the Oracle HCM Cloud environment

Assignment Supervisor Flexfield is not visible in Manage Employment page though it has been configured in the Oracle HCM Cloud environment

----------------------------------------------------------------------------------------------------------

As per Oracle documentation (Doc ID 2424558.1), the below DFFs are not enabled on any UI. They are obsolete and will be removed in the coming release from the setup UI:

PER_ASG_GRADE_STEPS_LEG_DDF
PER_ASG_SUPERVISOR_DF
PER_ASG_WORK_MEASURES_DF

Configuration Lookup Details in Oracle HCM Cloud environment

 

1> Manager Type : PER_SUPERVISOR_TYPE

How to load Country and Country Geography Hierarchy in Oracle HCM Cloud environment through File Import Process

Please follow the below steps to load a country and country geography structure using File Import process in Oracle HCM Cloud system :

Country Load :

Step 1 : Create a text file in the below format to load country as per your requirement. Sample file below.

CountryCode,LevelNumber,GeographyType,GeographyTypeName

IN,1,COUNTRY,Country

IN,2,STATE,State

IN,3,CITY,City

 

Step 2 : Steps to load Country Structure in Cloud :

Navigate to Home --> Setup and Maintenance --> Tasks --> Manage File Import Activities

 

Step 3 : Now under Manage Import Activities, click on the '+' button. Enter a name and for Object select Country Structure.

Leave file Type as Text with File section as specific file. Upload your text file from local with Data Type as csv header included.

 

Step 4 : Now click next and in the Map fields region, set the Object to ImpGeoStructureLevel. Set the Attribute with the correspondingColumn Header

Step 5: Now click next and schedule the Import process.

Country Geography Hierarchy Load :

Step 1 : Create a text file in the below format to load country hierarchy as per your requirement. Sample file below.

RecordTypeCode,GeographyType,PrimaryGeographyName,CountryCode,LevelNumber,SourceId,ParentSourceId,PrimaryGeograpgyCode
0,COUNTRY,Colombia,CO,1,1,,
1,STATE,ANTIOQUIA,CO,2,2,1,05
1,CITY,ABEJORRAL,CO,3,3,2,013

 

Step 2 : Steps to load Country Hierarchy in Cloud :

Navigate to Home --> Setup and Maintenance --> Tasks --> Manage File Import Activities

 

Step 3 : Now under Manage Import Activities, click on the '+' button. Enter a name and for Object select Geography.

Leave file Type as Text with File section as specific file. Upload your text file from local with Data Type as csv header included.

 

Step 4 : Now click next and in the Map fields region, set the Object to ImpGeoStructureLevel. Set the Attribute with the correspondingColumn Header

Step 5: Now click next and schedule the Import process.

How to perform Payroll Process Configuration in Oracle HCM Cloud environment

How to perform Payroll Process Configuration in Oracle HCM Cloud environment : 

Navigate to Home —> My Client Groups.

Click on “Show More” under “QUICK ACTIONS” option.

Search for “Payroll Process Configuration” and navigate to “Payroll Process Configuration” page.

Click on the “+” button under Configuration Groups.

Create a Configuration Group.

Under Configuration Group Details, provide the below details :

1> 

a> Parameter Name : Threads Determines the total number of subprocesses that run under the concurrent  

                                                   manager. Default 1; minimum:1.

b> Default Value :

c> Override Value : 16

2> 

a> Parameter Name : Chunk Size Number of relationship actions that should process together in chunks
                                     during the main processing phase. Default: 20; maximum: 16000; minimum: 1.

b> Default Value :

c> Override Value : 500

3>

a> Parameter Name : BI output size This is to set the size of reports in BI.

b> Default Value :

c> Override Value : 999999999999

Some of the useful ESS Process names in Oracle HCM Cloud environment

Please use the ESS processes accordingly as per Business requirement :

Navigation : Home --> Tools -> Scheduled Processes

1> Delete Master Geography Data for the Selected Country

Deletes master geography data for a selected country if the country data is not associated with the territory setup

2> Run Convert Pending Workers Automatically Process

PWKConversionJob

Schedules or runs process that automatically quick converts pending workers matching the conversion criteria

3> ESS process for value set values upload

4> Retrieve Latest LDAP Changes

SyncRolesJob

Synchronizes users, roles and role grants with definitions in LDAP

5> Import User and Role Application Security Data

AseImportUsersAndRolesJob

Import user and role data from LDAP and store in Applications Security tables

6> Import User Login History

AseInactiveUsersDataLoadJob

Imports information that the Inactive Users Report uses to identify inactive users

7> Regenerate Data Security Grants

RegenDataSecurityGrants

Manages processes to create or update grants for job, data and abstract roles

8> Regenerate Data Security Profiles

Regenerates all security profiles or a set of security profiles based on a selected security profile type

9> User Role Membership Report

Lists roles assigned to each user.

What is the Connection Pool command for accessing Direct Database Query in OTBI in Oracle HCM Cloud environment

Please pass the below details in Connection Pool :

"HCM_OLTP"."Connection Pool"



Note : As of now, by default this option is hidden in the latest release (I think from 19B).

How to compile Fast Formulas in bulk mode in Oracle HCM Cloud environment

Step 1 : Navigate to Home --> Payroll --> Checklist

Step 2 : In the right hand side, click on the Task pane and under "Payroll Flows" section,
             click on the link called "Submit a Process or Report"

Step 3 : Now select the "Legislative Data Group" as "US Legislative Data Group" and under
             "Process or Report" search text box, search the process "Compile Formula".

Step 4 : Select the process and click Next.

Step 5 : Now provide the details as below :
             a> Payroll Flow : pass the value accordingly to identify the process run. It can be anything.
             b> Formula : Pass the Fast Formula name here. If we want to compile multiple Fast
                  Formulas  at once, we can use wild character like '%'.example : there are 3 Fast Formulas
                  which starts with "SM". So to compile the 3 Fast Formulas at once, we can pass
                  "SM%" in the Formulas value.
             c> Formula Type : Pass the Fast Formula type value here. If all the Fast Formulas are HCM
                  Extract rule type,then we have to pass as "Extract Rule". Pass this value accordingly.

Step 6 : Submit the process. Once the process is successful, you can validate the compilation of the
              Fast Formulas from the below navigation :
              Setup and Maintenance --> Tasks --> Fast Formulas


Note : If you are not able to see the process "Compile Formula" under Payroll Checklist, then you should assign Payroll Manager data role in your User profile.

How to configure the FTP in Oracle HCM Cloud environment

Step 1 : Navigate to Home --> Tools --> Reports and Analytics --> Browse Catalog

Step 2 : Once we are in the Oracle BI Publisher, please click on the Oracle BI
              Administration  link(you should have BI Admin role assigned to your User Profile)

Step 3 : Then search for the BI Publisher section and click on the "Manage BI Publisher" link.

Step 4 : Once we are inside "Manage BI Publisher" link, search for the section called "Delivery"
              and  click on the "FTP" link.

Step 5 : You will see the option called "Add Server". Click on it.

Step 6 : Put the details accordingly.

How to load Value Set values using File Import/Export or ESS process in Oracle HCM Cloud environment

Step 1 : Create a text file (example : ABC_Value_Set_Value_Load.txt) with the details as below :
Note : 1st line below is the Header and next line onwards (Data Lines) pass the details of the values for the Value Set Code. File details are as below :

ValueSerCode|Value|TranslatedValue|Description|EnabledFlag|StartDateActive|EndDateActive|SortOrder
ABC|9999 9999 9999 9999||Test ABC1|N|1901-01-01|4712-12-31|1
ABC|9999 9999 9999 9998||Test ABC2|N|1901-01-01|4712-12-31|2
ABC|9999 9999 9999 9997||Test ABC3|N|1901-01-01|4712-12-31|3

Step 2 : Now navigate to Home --> Tools --> File Import and Export

Step 3 : Under the Search Results section click on the "+" button and the Upload File popup will appear.

Step 4 : In the popup, click on the "Choose File" button and select the Value Set value file (ABC_Value_Set_Value_Load.txt) from the correct location.

Step 5 : In the popup, click on the "Account" dropdown and select the UCM location where the file should be uploaded.
         Generally I select "hcm/dataloader/import" location as we are going to import the values in our HCM Cloud environment.

Step 6 : Once the file and the Account details have been selected, click on "Save and Close" button.

Step 7 : Now we have 2 options to load the Value Set values in our HCM Cloud environment.

Option 1 : Using ESS process
 a> Navigate to Home --> Tools --> Scheduled Processes
 b> Click on the "Schedule New Process" button and search for the ESS job named "ESS process for value set values upload".
 c> Select the process and click on "OK" button. Then you will find 2 input parameters.
  1> File Name : Pass the name of the file has been uploaded in UCM (ABC_Value_Set_Value_Load.txt)
  2> Account : Pass the name of the Account of the UCM (hcm/dataloader/import)
 d> Now click on the "Submit" button to submit the process.
 e> Once the process is completed, please check the log file for the load details.

Option 2 : Using "Manage Value Sets" navigation
 a> Navigate to Setup and Maintenance --> Tasks --> Manage Value Sets
 b> Under the "Search Results" section, click on the "Action" button.
 c> Once the "Action" button is clicked, click on the "Import" button.
 d> Pass the File Name (ABC_Value_Set_Value_Load.txt) and Account information (hcm/dataloader/import) as requested.
    Then click the "Upload" button.
 e> Now the import process will start and once the process is completed, check the log file for load details.