Category 222-2
Discussion List
-
How to use group by for more than one elementSummary: How to use group by for more than one element Content (required): Hi Expert, I am trying to get unique record and for that i want to group by two element .Below… -
What is best solution if the BI Report Output is more than 10MBSummary: Content (required): Hi Expert, We have a requirement for reading BI report where the file size is more than 10 MB ,what would be the best approach to read the f…
-
NameSpace remove from OIC MappingSummary: Hi Team, Source mapper is contains the xmlns namespace along with element(ReferenceTransmissionNo), below is the example: -
OIC pass null to destination attributeSummary: Content (required): I am using OIC for interface between Oracle EBS and SF. Which value should I pass to destination attribute in order the reset/clear the valu… -
Value is not getting reassigned in For eachSummary: Value is not getting reassigned in For each Content (required): I am reading a file using Read File in Segments and using a for each to iterate the records of R…
-
How do I configure custom three-legged security policy in REST connection in OIC?Summary: Content (required): Salesforce developed a process to generate PDFs in Salesforce. The process requires data from an Oracle database with OIC sending data to Sa… -
Unable to download the files from UCM. the error says access denied.Summary: Unable to download the files from fusion UCM. the error says access denied. what role be to added to access the files from UCM Content (required): Version (incl…
-
Exporting OIC package to object storageI am trying to export Integrations package via API, I have tried with this curl format as directly providing username and password not possible for federated SSO account… -
ReadFileinSegments throwing errorSummary: Content (required):Im downloading report data using downloadReportDataChunk operation. After that i use a stage write with opaque schema. Both these operations …
-
Recommendation/Guidance needed on Usage of EPMAutomate versus RestAPISummary: Looking for guidance on re-engineering of current EPM jobs. Content (required): My team is beginning the process of changing our EPM job automation scripting fo…
-
How to get the Invoice Line DFF info using REST Service in OICSummary: /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceLines/{invoiceLinesUniqID}/child/invoiceLineDff in above Service i am not able to get …
-
Incase of change in WSDL request type( few fields added).. how the mapper will get reflectedSummary: Suppose, there is complex mapping defined for the SOAP service in OIC( which is having huge request payload elements) and there is a requirement to add one new …Narasimha Reddy Chetibottu 11 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Oracle OIC - Read option in FTP adapter with the xsd zip is not workingSummary: Read option in FTP adapter (Invoke Schema- XSD capabilities) with uploaded xsd zip is not working. The zip file has multiple xsd files with interdependencies. C…
-
OIC OAuth Two legged Rest APISummary: Trying to create a REST connection in OIC for the API which supports Two legged authentication. Able to test from Postman, same is failing from OIC with below e…
-
How to concat a repeating element valueSummary: I have to build an integration.We send a request and we get an XML response.We are consuming the message from the outbound queue.Attaching the XML message.I wan…
-
Is there any way to filter the fields from the Business Event triggered from Oracle Fusion?Summary: We need a way to filter the fields from the Business Event triggered from Oracle Fusion like we have in rest api calls Content (required): We have an Event Base…Sachin Shaligram Zambre-Oracle 31 views 5 comments 1 point Most recent by Varun Jain-Oracle Integration
-
Creation of (AR) Customer Record via OICSummary: The requirement is to create a customer party, account, address details for 'Bill-to' and 'Ship-to' and a contact point for 'email'. Content (required): We've b… -
How to list files from specific folder from Oracle Hyperion Planning REST API'sSummary: In Hyperion Planning cloud application, we have directories like inbox and outbox and some directories are available under outbox directory for example /outbox/… -
The simplest solution to generate XML file from Fusion CSV report outputSummary: What is the simplest solution to generate XML output, in a required XSD schema, from CSV Fusion Apps report outputs? Content (required): The SAF-T legal report …
-
Do you know any utility which provides sample JSON data with input as JSON Schema?Summary: Do you know any utility which provides sample JSON data with input as JSON Schema? Content (required): Do you know any utility which provides sample JSON data w…
-
REST Adapter with CSV formatSummary: HI All, Can we send csv payload in REST adapter for a PUT call, Content (required): Kindly share any inputs on implementing REST adapter to send CSV payload to … -
Remove empty elements via XSLSummary Remove empty elements via XSLContent Hello! Has anyone tried to remove/scrub empty elements via XSL in OIC? We already placed conditional mapping for each elemen…
-
How to invoke REST OIC particular integration using basic authenticationSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Single Sign-On SOAP/REST APIsSummary: Content (required): How can we trigger SOAP/REST APIs using the Single Sign-on credentials of Microsoft Azure in Fusion SaaS? We are referring to this blog of t… -
Pass JSON payload as-is without OIC Mapper to SaaS REST APISummary: Content (required): Is there any way we can form a JSON payload and pass that payload as-is without mapping each element from left to right? Version (include th…
-
Elements are blank when Read File in Segment operation is usedSummary: Elements are blank when Read File in Segment operation is used Content (required): I'm trying to read a structured XML using the Read File in Segment operation …
-
ForEach ending before iterate all dataSummary Foreach ending on iteration 8 instead of 16 without showing errorContent Hello, I attached an excel file that is being interated in a for each composite in OIC..… -
How to Find customer data in CustomerAccountService( Receivables -- ERP)Summary i try filter customer account site in customer account.Content Hi, I am trying to find customer account service data in ERP-Receivables through SOAP Service. Ple…
-
Transferring file to an FTP Server that is only accessible via VPN IPsec tunnelContent We need to write an XML file to an FTP Server that is only accessible via VPN IPsec tunnel. We are currently able to write to an SFTP server for testing purposes…
-
OIC Event SubscriptionSummary unable to activate integrationContent I had my integration working i deactivated and activated my integration again i get the below error Activation Error Code :…