How to get the report output using SOAP Services?

Run and get the report output using the SOAP Service

To test the SOAP services we need the SOAP UI. To download the SOAP UI : https://www.soapui.org/downloads/soapui/

Soap Service to access the reports : /services/ExternalReportWSSService?wsdl (or) /services/PublicReportService?wsdl

Example: 

https://abcd-test.fa.em4.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl

In SOAP UI create a project with Project Name and use the above WSDL URL.

 

Authentication:

Expand the runReport and double click on Request, then the XML file will open.

Prepare the load in XML file and run the service.

Sample load with one parameter to run the report:

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">

   <soap:Header/>

   <soap:Body>

      <pub:runReport>

         <pub:reportRequest>

         <pub:parameterNameValues>

               <pub:item>

                  <pub:name>candnumber</pub:name>

                  <pub:values>

                     <pub:item>57636</pub:item>

                  </pub:values>

               </pub:item>

            </pub:parameterNameValues>

            <pub:reportAbsolutePath>/Custom/Human Capital Management/Extra_Info_Data.xdo</pub:reportAbsolutePath>

            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>

         </pub:reportRequest>

      </pub:runReport>

   </soap:Body>

</soap:Envelope>

Parameter and report path are highlighted in XML file.

After we run the report ,output of the report is in base64 format, we need to decode the output.

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

ASSIGNMENT EXTENSIBLE FLEXFIELDS (EFF) IN ADDITIONAL ASSIGNMENT INFO PAGE

ASSIGNMENT EXTENSIBLE FLEX FIELDS (EFF) IN ADDITIONAL ASSIGNMENT INFO PAGE

In 19 D Oracle provided the ability of users to manage and view the additional assignment information (assignment extensible flex field).

Navigation :
My Teams --> My Teams --> Click on Actions (3 horizontal dots) of any employee --> Additional Assignment Info

My client groups --> quick Actions (show more) --> Additional Assignment Info

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

HOW TO RUN THE BIP REPORT BY INITIATING SOAP “SCHEDULE PROCESS”?

How to run the BIP report by Initiating Soap “schedule process”?

1. Create the BIP Report.
2. Attach the report to the custom schedule process.
3. Run the Custom schedule process using the SOAP WebService(ess/esswebservice?WSDL)

Create an BIP report for the below SQL:

SELECT PAPF.person_number,  ABS_PLAN.NAME Plan_Name, Bal_Entrie.end_bal balance

FROM per_all_people_f PAPF,per_all_assignments_f PAAF, anc_absence_plans_f_tl ABS_PLAN, anc_absence_plans_f aapf, anc_per_accrual_entries Bal_Entrie

WHERE 1=1 AND PAAF.person_id = PAPF.person_id AND Bal_Entrie.person_id = PAPF.person_id AND Bal_Entrie.prd_of_svc_id = PAAF.period_of_service_id AND ABS_PLAN.absence_plan_id = aapf.absence_plan_id AND Bal_Entrie.plan_id = aapf.absence_plan_id AND Bal_Entrie.accrual_period = (SELECT MAX (Bal_Entrie1.accrual_period) FROM anc_per_accrual_entries Bal_Entrie1 WHERE 1 = 1 and Bal_Entrie1.accrual_period <= trunc(sysdate) AND Bal_Entrie1.person_id = Bal_Entrie.person_id AND Bal_Entrie1.prd_of_svc_id = Bal_Entrie.prd_of_svc_id AND Bal_Entrie1.plan_id = Bal_Entrie.plan_id) AND PAAF.primary_flag = 'Y' AND PAAF.assignment_type ='E' AND PAAF.assignment_status_type = 'ACTIVE' AND aapf.plan_status = 'A' AND ABS_PLAN.LANGUAGE = 'US' AND TRUNC (SYSDATE) BETWEEN PAPF.effective_start_date AND PAPF.effective_end_date AND TRUNC (SYSDATE) BETWEEN PAAF.effective_start_date AND PAAF.effective_end_date AND TRUNC (SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_date AND TRUNC (SYSDATE) BETWEEN ABS_PLAN.effective_start_date AND ABS_PLAN.effective_end_date AND PAPF.person_number = nvl(:person_number,PAPF.person_number) order by PAPF.person_number,ABS_PLAN.name

Setup and Maintenance à Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications

 In Manage Job Definition à create the New job (+)

Navigator à Tools à Schedule Process à Search the custom Job

Oracle doc link : https://docs.oracle.com/en/cloud/saas/supply-chain-management/20a/faicf/enterprise-scheduler-job-definitions-and-job-sets.html#FAICF2383281

Run the custom schedule process using the SOAP Service:

http://xyz-test.fa.em6.oraclecloud.com/ess/esswebservice?WSDL

SAOP Service:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sch="http://xmlns.oracle.com/scheduler" xmlns:typ="http://xmlns.oracle.com/scheduler/types">

   <soapenv:Header/>

   <soapenv:Body>

      <sch:submitRequest>

         <sch:description>Get Employee Absence Plan Balance</sch:description>

         <sch:jobDefinitionId>

            <!--Optional:-->

            <typ:name>GET_EMPLOYEE_ABSENCE_PLAN_BALANCE</typ:name>

            <!--Optional:-->

            <typ:packageName>/oracle/apps/ess/custom/absence</typ:packageName>

            <!--Optional:-->

            <typ:type>JOB_DEFINITION</typ:type>

         </sch:jobDefinitionId>

         <sch:application>EarHcmEss</sch:application>

         <sch:requestedStartTime>2020-05-26T13:12:32.825Z</sch:requestedStartTime>

         <sch:requestParameters>

            <!--0 to 1000 repetitions:-->

            <typ:parameter>

               <!--Optional:-->

               <typ:dataType>STRING</typ:dataType>

               <!--Optional:-->

               <typ:name>submit.argument1</typ:name>

               <!--Optional:-->

               <typ:value>1675</typ:value>

            </typ:parameter>

         </sch:requestParameters>

      </sch:submitRequest>  </soapenv:Body>

</soapenv:Envelope>

Useful SQL’s to fill the payload details:
SQL to gather job definition and application runtime details:
select DEFINITION, APPLICATION
from FUSION.ESS_REQUEST_HISTORY
where requestid=138848
DEFINITION APPLICATION
JobDefinition://oracle/apps/ess/custom/absence/GET_EMPLOYEE_ABSENCE_PLAN_BALANCE EarHcmEss

SQL to gather runtime job parameters details:

select NAME,DATATYPE,VALUE
from FUSION.ESS_REQUEST_PROPERTY
where requestid=138848
and name like 'submit%'
NAME DATATYPE VALUE
submit.argument1 String 1675


SQL to gather notification parameter details
select NAME, DATATYPE, VALUE
from FUSION.ESS_REQUEST_PROPERTY
where requestid=138848
and name like 'pp%'
NAME DATATYPE VALUE
pp.1.argument1 String USER
pp.1.argument2 String MyRecipientUserToBeNotified
pp.1.description String Notify


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

User Password Change Audit report

                                      User Change password Audit report

To Run this report User should have the  ASE_USER_PASSWORD_CHANGES_AUDIT_REPORT_PRIV or IT security Manger Job Role.

This is a schedule process, to run this process :

Tools => Schedule Process =>  Schedule New Process => select User Password Change Audit Report and run this process by giving the parameters.

Example:

1. Go to security console which is under tools.
2. select the Users tab and search any user.

 3. Under Actions select the Reset password.

 4. Change the password and click on reset password.

5. Tools => Schedule Process =>  Click Schedule New Process

6. Select the Job : User Password Change Audit Report

7. In User Pattern We can select the All Users or specific user or the User Name with some pattern

 8.  Select the start date and end date that we want a report. Click on submit.

 9. After the process succeeded, Click on attachments.

10. We can download the report in CSV or XML formats that we need.

 11. The report will be like this:

Here Updated By is the user who reset the password.

Here Updated Types can be three:

1. ADMIN: Line Manager or security Manager.
2. SELF_SERVICE : User Made the change in set preferences or reset the password.
3. FORGOT_PASSWORD : User click on forgot password to reset the password.

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