Sample Delete HDL / HSDL file to delete Ethnicity in Oracle HCM Cloud environment

 

Sample Delete HDL file details to delete Ethnicity in Oracle HCM Cloud environment

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

SET ENABLE_INCREMENTAL_LOAD_EVENTS Y

METADATA|PersonEthnicity|EthnicityId|PersonId|PersonNumber|LegislationCode|DeclarerId|DeclarerPersonNumber|Ethnicity|PrimaryFlag|SourceSystemOwner|SourceSystemId|GUID

DELETE|PersonEthnicity|||E1222222|US|||5|N|||

Sample Delete HSDL file details to delete Ethnicity in 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

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

How to enable assignment level security in Oracle HCM Cloud environment

 

Steps to enable assignment level security in Oracle HCM Cloud environment :

Note : This is a new Feature from 20D onwards.  All the images have been taken from Oracle.

Business Benefits : 

1> Using this feature, security can be locked down to Assignment level.

2> Using this feature Manager and Organizations can see information that is within the Area Of Responsibility.

How to enable this feature :

1> To secure the access for the workers with multiple assignments, we have to enable the profile option called

“ORA_PER_ASSIGNMENT_LEVEL_DATA_SECURITY_ENABLED”.

2> Then we have to run the “Regenerate Data Security Profiles and Grants” ESS job to set and update person security grants and data roles.

3> To enable assignment level security in the employment contract, we must run the Migrate Employment Data process by selecting this run mode: Enhance contract data to enable its use in the responsive pages.

Once the Assignment Security is enabled, you can navigate as per below and can validate.

Implementation Considerations : 

Part 1

Part 2

Part 3

How to create a local File connection (Local FTP Agent) in Oracle Integration Cloud environment

Local FTP Agent can be used to read or write files in Local desktop.

Please follow the below steps to achieve the same.

Step 1: login to OIC environment and navigate to Integration tab.

Step 2: Now click on the Agents tab

Step 3: Under Agents tab click on the button Create Agent Group

Step 4: Put the details as below or can be changes as required and click on the Create button.

In this step the Agent will be created.

Step 5: Now navigate to Agent tab again and download the Agent details as below.

Step 6: Put the zip file in your local drive anywhere (for my case in Desktop/OIC2 folder) and unzip it.

Step 7: Now open the InstallerProfile.cfg file and edit as below and then save it.

In the oic_URL, pass the OIC environment URL

In the agent_GROUP_IDENTIFIER name, pass the Identifier code, which was put while creating the agent in OIC.

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

# Required Parameters

# oic_URL format should be https://hostname:sslPort

oic_URL=https://*****************/*****/

agent_GROUP_IDENTIFIER=SM_TEST_DEV_AGENT

 

# Proxy Parameters

proxy_HOST=

proxy_PORT=

proxy_USER=

proxy_PASSWORD=

proxy_NON_PROXY_HOSTS=

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

Step 8: Open Terminal or Command Prompt and check whether jdk is installed or not. If not, please install jdk.

 Command to check Java version:

java -version 

Step 9: Now navigate to the connectivity agent folder (in local machine where it is downloaded or kept) using Terminal or Command Prompt to run the connectivityagent.jar file.

 Command 1 to change directory:

cd Desktop/OIC2/oic_connectivity_agent

 Command 2 to run the connectivity agent jar:

java -jar connectivityagent.jar

It will ask for Login Username and Password. Please provide accordingly.

a>

b>

c>

How to configure SQL Developer to connect with ATP(Autonomous Transaction Processing) Database for Oracle Integration Cloud environment

 

Assumption : You already have the wallet zip for the Database Connection. If not, please check with your administrator.

Please follow the below steps :

Step 1: Navigate to google.com and search for free download sql developer.

                Select the link from oracle.com. Click the below link.

Step 2: Download from below link.

Step 3: Click on the Download button

 

Step 4: Download the setup

Step 5: It will ask for Oracle login credentials.

 

 

 

 

 

Step 6: Save the zip file in your local machine

 

Step 7: Once the zip file is downloaded it will look like below

Step 8: Unzip the zip file

Step 9: Open the unzipped folder and launch the exe file name sql developer

Step 10: The Sql Developer will be launched and create a new connection.

Step 11: In the Connection Type drop down select the option "Cloud Wallet"

Step 12: Provide the details as per credentials received from Administrator and test the connection first and then connect to the Database environment.

 

 

 

 

 

 

Some Useful Document ids or urls for Oracle Analytics Cloud

 

Oracle Document Ids and urls below :

1> 

OAC-OM: Error On Dataset After Migration: "Invalid connection details were supplied. Please enter the correct details and try again" (Doc ID 2746590.1) (3-25201003721)

Getting "[JDSError : 43] Invalid connection/authentication details" When Running A Dataflow From Oracle Analytics Desktop (Doc ID 2688461.1)

Error Saving Existing Fusion Application Storage Connections after upgrade to OAC5.8 (Doc ID 2717191.1)

Solution 1:

The workaround is below. This is a bug from Oracle end. The fix will be coming in version 6.0 as per Oracle's comment. Issue identified in version 5.9 and lower.

After you log on to OAC instance, you need to enable browser developer tools window and switch to console table.

In the console tab, paste the following line and hit enter.

require('obitech-application/bootstrap').getApplicationInstance().getService("obitech.featureManager").setFeatureSupport("supportsBISConnection", false);

Solution 2:

When exporting the Data Flows or Sequence from the source environment, the user could select the option to include the connection credentials and after Importing to the target environment, user can correct the credentials.

Configuration Lookup Details in Oracle HCM Cloud environment

 

1> Manager Type : PER_SUPERVISOR_TYPE

SQL for getting Business Unit details and Reference Data Set in Oracle HCM Cloud environment

Sample SQL Query (You can modify as required):

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

SELECT

         'BUSINESS_UNIT' AS TYPE

,HAUFT.NAME AS CODE

,HAUFT.NAME AS DESCRIPTION

,HOUCF.LEGISLATION_CODE AS COUNTRY

,TO_CHAR(HAUFT.EFFECTIVE_START_DATE,'YYYY/MM/DD')

AS EFFECTIVE_START_DATE

,TO_CHAR(HAUFT.EFFECTIVE_END_DATE,'YYYY/MM/DD')

AS EFFECTIVE_END_DATE

,HOUCF.STATUS AS STATUS

,HOIF.ORG_INFORMATION4 AS ORG_INFORMATION4

,FS.SET_ID AS SET_ID

,FS.SET_CODE AS SET_CODE

,FS.SET_NAME AS SET_NAME

,HAUFT.LAST_UPDATED_BY AS LAST_UPDATED_BY

,TO_CHAR(HAUFT.LAST_UPDATE_DATE,'YYYY/MM/DD')

AS LAST_UPDATE_DATE

FROM HR_ORG_UNIT_CLASSIFICATIONS_F HOUCF

, HR_ALL_ORGANIZATION_UNITS_F HAOUF

, HR_ORGANIZATION_UNITS_F_TL HAUFT

, HR_ORGANIZATION_INFORMATION_F HOIF

,(SELECT SET_ID, SET_CODE, SET_NAME FROM FND_SETID_SETS_VL) FS

WHERE HAOUF.ORGANIZATION_ID = HOUCF.ORGANIZATION_ID

AND HAOUF.ORGANIZATION_ID = HAUFT.ORGANIZATION_ID

AND HAOUF.ORGANIZATION_ID = HOIF.ORGANIZATION_ID

AND HAOUF.EFFECTIVE_START_DATE BETWEEN HOUCF.EFFECTIVE_START_DATE AND HOUCF.EFFECTIVE_END_DATE

AND HAUFT.LANGUAGE = 'US'

AND HAUFT.EFFECTIVE_START_DATE = HAOUF.EFFECTIVE_START_DATE

AND HAUFT.EFFECTIVE_END_DATE     = HAOUF.EFFECTIVE_END_DATE

AND FS.SET_ID (+)                = HOIF.ORG_INFORMATION4

AND HOUCF.CLASSIFICATION_CODE    = 'FUN_BUSINESS_UNIT'