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

Last updated on MAY 13, 2022

Applies to:

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

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