R12: Unable To Extract 4 CSV's Out Of One Data Model And ZIP It

(Doc ID 2299446.1)

Last updated on JANUARY 01, 2018

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Analytics

Unable to Extract 4 CSV's out of one data model and ZIP it

Customer requirement
---------------------------
Customer wants to integrate Sourcing and Contract modules when a negotiation line is awarded and automatically create a contract with that supplier in fusion contacts module.
For this integration they are trying two approaches :

They tried importing contracts manually using four seeded CSV templates successfully.

Now they want a BI Extract which will have 4 CSV's zipped together and should be scheduled and sent to UCM automatically at specific scheduled date and time, so that, from there they can select that zip and import contract.

Below are the challenges with this approach :
1) Unable to Extract 4 CSV's out of one data model and ZIP it and send it to UCM at scheduled date and time automatically from BI.
and
2) Another way they are trying is Extracting awarded line and supplier details using BI Report in XML format. But they are unsuccessful while Contract import in Fusion contracts Module using that Extracted XML.

Customer question
-----------------------
How to extract 4 csv's out of one data model, zip it and send it to UCM at scheduled date and time automatically from BI.

The question can be broke up into parts:
Qn 1) How to extract 4 csv's out of one data model?
Qn 2) How to schedule the extracts?
Qn 3) How to zip 4 csv's and upload to UCM?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms