Total Pageviews

Tuesday, February 19, 2019

HDL Automation using Oracle delivered JAR file


HDL Automation using Oracle delivered JAR file:

Steps:

1. Prepare any business object i.e .dat (Example : Worker.dat) file and zip that file. Example: Worker.zip
2. Then load that zip file in to content server using below java command.

Save the below script with .bat extension :
------------------------------------------------------------------------------------------------------------------------
Java -classpath "C:\My Data\HDLAutomation\oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client.UploadTool url="https://htyup-test.fa.ap1.oraclecloud.com/cs/idcplg" username="Admin" password="Admin1234" primaryFile="C:\My Data\HDLAutomation\Worker.zip" dDocTitle="Worker" dDocName="UCMFA000180556"   dDocAccount="hcm/dataloader/import" http.proxyHost="proxyhost.com" http.proxyPort="8080" log_file_name="C:\My Data\HDLAutomation\Log.out"
-------------------------------------------------------------------------------------------------------------------------

Explanation of above command:

java -classpath

"C:\My Data\HDLAutomation \oracle.ucm.fa_client_11.1.1.jar"   --> jar file location in our local system

oracle.ucm.client.UploadTool url="https://htyup-test.fa.ap1.oraclecloud.com/cs/idcplg" --> Instance Url concate with /cs/idcplg

username="Admin"  --> UserName

password="Admin1234"   --> password

primaryFile="C:\My Data\HDLAutomation\Worker.zip"  --> zip file location in our local system

dDocTitle="Worker"  --> we can give any Name

dDocName="UCMFA000180556"   --> we can give any value but it should be unique and use prefix - UCMFA

dDocAccount="hcm/dataloader/import" http.proxyHost="proxyhost.com"  --> Constant value

http.proxyPort="8080" log_file_name="C:\My Data\HDLAutomation\Log.out"  --> Log File location

To download Jar file of UCM : 
https://blogs.oracle.com/fusionhcmcoe/installing-oracle-webcenter-content-document-transfer-utility

After command successfully ran the we can see the file in content server as shown below:

Example: https://htyup-test.fa.ap1.oraclecloud.com/cs    (URL concatenated with /cs)

3. Then schedule a process in Oracle cloud HCM  using schedule process to import and load that file in to fusion main tables. 


schedule process Name: Import and Load HCM Data File

Note: Run this process by giving the content Id.

After that go to Data Exchange --> Tasks --> Import and Load --> search with the content Id.

 To download oracle.ucm.fa_client_11.1.1.jar file please refer below link:
https://blogs.oracle.com/fusionhcmcoe/installing-oracle-webcenter-content-document-transfer-utility


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

Thanks,
Sainath

1 comment:

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 ...