Oracle Cloud Fusion HCM Solutions

SELECT     papf.person_number,     paaf.assignment_number,     pasgf.time_card_req FROM     per_all_people_f           papf,     per_periods_of_service     ppos,     per_all_assignments_f      paaf,     pay_payroll_assignments    ppa,     pay_pay_relationships_dn   pprd,     pay_assigned_payrolls_dn   papd,     pay_assigned_payrolls_f    pasgf WHERE     ppos.person_id = papf.person_id     AND paaf.person_id = ppos.person_id     AND paaf.period_of_service_id = ppos.period_of_service_id     AND paaf.assignment_id = ppa.hr_assignment_id     AND papd.payroll_term_id (+) = ppa.payroll_term_id     AND ppa.payroll_relationship_id = pprd.payroll_relationship_id     AND paaf.work_terms_assignment_id = ppa.hr...

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

In this article we will focus on understanding how to use conditions in request payload of SOAP Web Service. In this example, we will use Worker service and operation findWorker to understand the concepts. Case 1: How to check existence of any field value Request:       <typ:findWorker>          <typ:findCriteria>             <typ1:fetchStart>0</typ1:fetchStart>             <typ1:fetchSize>-1</typ1:fetchSize>             <typ1:filter>                <typ1:group>                   <typ1:conjunction>And</typ1:conjunction>                   <typ1:upperCaseCompare>true</typ1:upperCaseCompare>                 ...

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

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