My Oracle Support Banner

Get Operation For Import SOAP Service Does Not Return All The Batch Statues (Doc ID 2556207.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Goal

Qn1:Is there any way where a web service call can get all batch id's status for an import activity as these imports are done via scheduling the imports through UCM server?
Qn2:How To Query And See List Of Batch IDs For A Given Activity Identifier?
 
Qn3:Need SQL Query to get all fields below:

1) Import Activity Identifier: This field is required to show import activity id of a submitted import job for each batch id.
2) Name:- This field is required to show the import name of the submitted import job for each batch id.
3) Status:- This field is required to show the import status of the submitted import job for each batch id.
4) Start Time:- This field is required to show when the import activity was started for each batch id.
5) End Time:- This field is required to show when the import activity was ended for each batch id.
6) Read Successfully:- This field is required to show how many records are read by an import activity for each batch id.
7) Successfully Loaded:- This field is required to show total number of records successfully loaded into the system by an import activity for each batch id.
8) Errors Reported:- This field is required to show count of records which had errors while processing by an import activity for each batch id.
9) Warnings Reported:- This field is required to show count of records which had errors while processing by an import activity for each batch id.
10) Submitted By:- This field is required to show who submitted the import job for each batch id.
 
Qn4:Will PARENT_TASK_ID always be not null for standard import management / EDLC?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.