R12: Unable To Extract 4 CSV's Out Of One Data Model And ZIP It
(Doc ID 2299446.1)
Last updated on MARCH 24, 2019
Applies to:Oracle Fusion Enterprise Contracts Management Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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?
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