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