R12: Unable To Extract 4 CSV's Out Of One Data Model And ZIP It
Last updated on JANUARY 01, 2018
Applies to:Oracle Fusion Enterprise Contracts Management Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Analytics
Unable to Extract 4 CSV's out of one data model and ZIP it
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.
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.
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?
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