Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BICC: How to find current run extracts

Received Response
12
Views
1
Comments

Summary:

I an trying to submit BICC extracts through esswebservice. I see extracts are being submitted and completed without any issues.

However, when I check UCM for the extracts, I notice that three files are created as expected.

MANIFEST.MF

EXTRACT_STATUS_DATA_SCHEDULE_3965079_REQUEST_3965079.JSON

file_fscmtopmodelam_finextractam_arbiccextractam_transactiondistributionextractpvo-batch1384881482-20241219_013109.zip

CenterLargeAccessibilityDelete

Unfortunately, aside from the json/log file, none of the other files seem to have any references to ESS request ID.

I assume, MANIFEST.MFfile is only source to know list of BICC extracts generated for current run

PLV_KEY=FUSION_13_0file_fscmtopmodelam_finextractam_arbiccextractam_transactiondistributionextractpvo-batch1384881482-20241219_013109.zip;4045475;ef8ab7a9ddce5f2977cbf61b55b6c35e

But this is a common file that gets created for all extracts. So, I am facing hard time to find the extracts generated for current/latest runs. So, I am looking for some guidance or suggestions to determine which extracts were generated for the current run?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Answers

  • Skolli-Oracle
    Skolli-Oracle Rank 4 - Community Specialist

    Extracts submitted via essWebService can be found in "Manage Extract Schedules".
    Expand Search and use the checkbox for "Show Stateless Schedules" to see the extracts submitted via essWebService.