How to use WebCenter Content Document Transfer Utility


In the previous article, we learnt about "How to Upload/Download files to/from Oracle WebCenter Content Server (UCM)". In this article, we are going to learn how to use WebCenter Content Document Transfer Utility.

We need to download WebCenter Content Document Transfer Utility from OTN and save in local machine.

Steps to Upload Files to UCM

i.                     Unzip 150521-REL10-oracle.ucm.fa_client_11.1.1.zip file.

ii.                   Open command prompt. Set JAVA HOME to point the Jdk 1.7.
C:\Users\XXX_ADMIN>set JAVA_HOME=C:\oracle\products\jdk1.7.0_76
C:\Users\XXX_ADMIN>SET PATH=%JAVA_HOME%\bin;%PATH%
C:\Users\XXX_ADMIN>java -fullversion
java full version "1.7.0_76-b13"

iii.                 Go to the directory in your command prompt.

C:\Users\XXX_ADMIN>cd C:\WebCenter Content Document Transfer Utility\150521-REL10-oracle.ucm.fa_client_11.1.1\ridc

iv.                 Place your data file ( zip file for HDL) in your local machine and issue below command.

java -cp "oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client.Upload Tool --url="https://hostname:port/cs/idcplg" --username="*****" --password="*********" primaryFile="Worker_UCM_Upload_Test.zip" --dDocAccount="hcm/dataloader/import"


url: https://<Instance host:port>/cs/idcplg
username:  Application User Name
password: Application Password
primaryFile: Path where file is placed along with file name (In above example file was placed under WebCenter Content Document Transfer Utility\150521-REL10-oracle.ucm.fa_client_11.1.1\ridc )
dDocAccount: hcm/dataloader/import


Example:

C:\WebCenter Content Document Transfer Utility\150521-REL10-oracle.ucm.fa_client
_11.1.1\ridc>java -cp "oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client.Upload
Tool --url="https://xxx.oraclecloud.com/cs/idcplg" --username="xxxx" --password="******" primaryFile="Worker_UCM_Upload_Test.
zip" --dDocAccount="hcm/dataloader/import"
Oracle WebCenter Content Document Transfer Utility
Oracle Fusion Applications

 * "dDocTitle" option not set; defaulting option to value "Worker_UCM_Upload_Tes
t.zip".
Performing upload (CHECKIN_UNIVERSAL) ...
Upload successful.
[dID=4169 | dDocName=UCMFA004169]

This returns UCM Content ID (dDocName) upon success.

Steps to Download Files from UCM

i.                     Set JAVA HOME as mentioned earlier.

ii.                   Issue below command from command prompt.

C:\WebCenter Content Document Transfer Utility\150521-REL10-oracle.ucm.fa_client
_11.1.1\ridc>java -classpath "oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client
.DownloadTool url=https://xxx.oraclecloud.com/cs/idcplg username=xxxx password=******** dID=4169 outputFile="C:\temp\Worker_UCM
_Upload_Test.zip"
Oracle WebCenter Content Document Transfer Utility
Oracle Fusion Applications
Performing download (GET_FILE) ...
Download successful.
Wrote file "C:\temp\Worker_UCM_Upload_Test.zip".

This will download the file to the location mentioned in your command.


How to Search Files in UCM

java -classpath "oracle.ucm.fa_client_11.1.1.jar" oracle.ucm.client.SearchTool url=https://xxx.oraclecloud.com/cs/idcplg username=xxxx password=*****  dDocName%=PERS SortField=dID SortOrder=DESC


Same concepts can be applied in Oracle Fusion Middleware (SOA/SOA-CS/ICS) or any other platform for automation of Oracle Cloud Fusion Application interfaces using this tool. 




Comments

Post a Comment

Popular posts from this blog

SQL to get Payroll Balances in Oracle Fusion HCM

SELECT DISTINCT     papf.person_number,     pni.national_identifier_number,     prb.balance_value,     ppa.effective_date,     pbtv.balance_name,     pbd.base_dimension_name FROM     per_all_people_f           papf,     per_national_identifiers   pni,     per_periods_of_service     ppos,     per_all_assignments_f      paaf,     pay_payroll_assignments    ppasg,     pay_pay_relationships_dn   pprd,     pay_payroll_rel_actions    ppra,     pay_run_results            prr,     pay_run_result_values      prrv,     pay_input_values_f         pivf,     pay_balance_feeds_f        pbf,     pay_balance_types_v...
Read more

User Account in Oracle Fusion HCM

Image
Configuration for User Account: 1.        Set up for automatic User Account Creation. Go to FSM --> Manage Enterprise HCM Information --> This set up will ensure that user accounts are created automatically for person. 1.        User Name generation method. This set up is done in Security Console. Go to Tools -->  Security Console -->  User Categories This will ensure if work email address is there in the Worker.dat file while loading worker information – this will create user account by default which is same as the person’s work email address. However, this will be pending status as we need to Send Pending LDAP Requests to reflect the user name. Post successful completion of ESS job “Send Pending LDAP Requests” the user account will be reflected as person’s work email address. In case there is no work email addre...
Read more

Using Generic SOAP Port Webservice to Upload file to UCM

Image
In this article, we will learn about how to use SOAP Service to upload files to UCM. This is used for automation of interfaces in Oracle Cloud Fusion HCM. In this example, we will use SOAP UI to test the service. Same concepts can be applied in Fusion Middleware or any other platform to invoke Web Service to upload files to UCM. You can upload the file by Base64 encoding the binary content of the file, in the Content tag as below: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM"> <soapenv:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"> <wsa:Action>urn:GenericSoap/GenericSoapOperation</wsa:Action> </soapenv:Header> <soapenv:Body> <ucm:GenericRequest webKey="cs"> <ucm:Service IdcService="CHECKIN_NEW"> <ucm:Document> <ucm:Field name="dUser">imp</ucm:Field> <ucm:Field name=...
Read more