Oracle Analytics and AI

G.Balaji

Hi Team,

we have requirement where all projects data storing into ATP DB staging table using BICC approach.
for this created the OIC Integration and submitted the request to run job in BICC. Upon completion of job, event will be triggered in BICC and OIC Integration created with callback option and expected to receive instance when job completed in BICC.

But after completion of job in BICC, no event is triggered or instance is not created in OIC.

I tried to find solutions and docs for BICC and callback details in community but didn't find any information.

Nathan CCC

Hi,

If you use web service

Oracle Enterprise Scheduler Service (ESS) Web Services Description Language (WSDL) Extended Markup Language (XML) /bi/ess/esswebservice?wsdl

When you invoke you have a boolean option

Do you want to configure this as a callback invoke? No or Yes

Inside your flat wsdl file you have 2 services ESSWebService and ESSWebServiceCallback

in ESSWebService

you have operation submitRequest

to call a job schedule using job definition BICloudConnectorJobDefinition

in application oracle.biacm package oracle.apps.ess.bicc

and you have operation getCompletionStatus

and in ESSWebServiceCallback

you have operation onJobCompletion

For more information see

Simple Object Access Protocol (SOAP) SOAP Application Programming Interface (API)
Oracle® Cloud Using the SOAP Adapter with Oracle Integration 3 F45611-07 January 2024
https://docs.oracle.com/en/cloud/paas/application-integration/soap-adapter/index.html#Oracle%C2%AE-Cloud

Oracle® Fusion Middleware Developing Applications for Oracle Enterprise Scheduler 12c (12.2.1.4.0) E95457-03 August 2020
https://docs.oracle.com/en/middleware/soa-suite/enterprise-scheduler/12.2.1.4/develop-scheduler/using-oracle-enterprise-scheduler-web-service.html#GUID-E492A7E5-19A7-473A-B30D-60199DDA52D5

Setting Web Service Addressing Headers for getCompletionStatus() Operation

As shown in the ESSWebservice WSDL, if clients want to be notified asynchronously on job completion they can invoke the getCompletionStatus() operation. Upon job completion, Oracle Enterprise Scheduler invokes the callback operation onJobCompletion() following ws-addressing where ESSWebservice captures the caller's address in the incoming call. Clients should be capable of receiving the callback at any arbitrary time in the future. Such a callback depends entirely upon the time required to complete the job. This is similar to the Oracle Enterprise Scheduler functionality for invoking a client's listener (that implements the Oracle Enterprise Scheduler EventListener contract) upon job completion.

When you use getCompletionStatus() clients must include certain required web service addressing headers (in particular the wsa:MessageID and wsa:ReplyTo headers). This allows the Oracle Enterprise Scheduler runtime to asynchronously notify the job completion status be sent to the correct ReplyTo address. When you use getCompletionStatus() from a BPEL process the SOA runtime automatically adds the required headers. When using getCompletionStatus() programmatically on the client side, using the web service proxies, the web service client must set these addressing headers.