To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
Create a global variable with custom schemaSummary: Hi, I want to create a global variable with custom schema. There seem to be no clean way to upload the custom xsd and create a variable on it as we do in SOA. I… -
Stage File Actions - List Files and zip file is having issue.Summary: List File payload dont have the data and zip file action is going into error. Content (required): I am creating a HDL integration. I create .dat file using FTP … -
Scheduled Integrations are Stuck and Running for Very Long TimeSummary: Hi, We have many scheduled integration which calls a child integration for performing a task. We observed that many times these schedulers are stuck in OIC and …
-
How to query REST Service with a parameter containing special characters like +,. etc in OICWe are trying to use REST Service and pass a parameter containing + or , in the parameter value in OIC. How can we achieve this in OIC? I know from postman, we have to u…
-
For Each on distinct valuesSummary: Content (required): Hi All, Is there a way to use For Each on distinct/unique values ? I see that there is no way to edit the input of For Each... Version (incl… -
HDL Dat file to load Talent Review Rating values against employeesSummary: Hi Team, We wanted to load Talent Review Rating values (yellow color highlighted information from the snapshot) against bulk numbers of employees. Please share … -
Setting up a Connectivity AgentSummary: I've followed the instructions at https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/downloading-and-running-premises-agent-installer.htm… -
How to Convert a Synchronous OIC Integration to One WaySummary: I want to convert a synchronous OIC integration to one way. Integration is using REST trigger. When I am trying to uncheck "Configure to receive a response", OI…
-
Switch Case Limitation in OICSummary: Is there a limit on the number of Switch Conditions you can use in a Switch Activity? I checked the OIC Documentation but nothing says about it. Thanks ahead! -
Unable to generate .dat file using nxsd mapping fileSummary: Content (required): I am creating an HDL integration using Oracle HCM adaptor. Before using the HCM connection we need to generate the .dat file using nxsd mapp…
-
API to load bulk data in Oracle SAASSummary: API to load bulk data in Oracle SAAS Content (required): Hi, We need some API which can be used to load bulk data in Oracle SaaS . Version (include the version …
-
Question about Oracle Cloud Platform Application Integration 2021 Specialist 1Z0-1042-21Summary: HI , Is there any difference between 1Z0-1042-20 and 1Z0-1042-21 exams? Do both these exams contain the same questions? Are there any new questions added to 1Z0…
-
Integrating SAP Ariba using OIC with MIME attachmentsSummary: To connect SAP Ariba using OIC Ariba Connector Content (required): OIC has inbuild OIC Connector. However in the SAP Ariba Restrictions it mentions MIME attachm…
-
Flat file to CSV conversion using OICSummary: I would like to convert flat file/positioned file to CSV using oic. Content (required): Hi Team, My client requirement is to read the data from FTP which is fix…
-
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…
-
Oracle Integration Update Webcast December 16th 2021Summary: Oracle Integration Product Management Webcast December 16th 2021 Content (required): Product Management Webinar: Attend to get the latest updates and innovation… -
Integration Customer Newsletter Autumn Edition 2021Summary: Newsletter Content (required): It is time for the November quarterly update to Oracle Integration. With autumn in the Northern Hemisphere, we are excited to sha…
-
How we decide oic sizing? how we calculate number of multiple oic instances based on inbound trafficSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
For each current indexSummary: Content (required): How can I get the current index of a for each loop (in the diagram, not xslt)? Thanks Version (include the version you are using, if applica…
-
OIC to Amazon Seller SiteSummary: Integrating OIC to Amazon Seller Central Content (required): Based on below blog, OIC starts to support Amazon seller integration: https://blogs.oracle.com/inte…
-
Unable to activate integration in 1 environmentSummary: Content (required): We are getting the below error while activating this integration in 1 environment but not in the other 2 environments. We did refresh the me…
-
Translation to native failed. Element 'EnteredDebitAmount' not expected..Hi Expert, I am creating integration for bulk data import to journal import, while running integration getting following error. Error Summary: oracle.fabric.common.Fabri…
-
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:
-
Moving Files with different formats from ftp server to local server.Hi All 1) I would like to move 2 files with different formats from 1 server to another via a single integration. Even though its basically an ftp mget I still need to do…
-
One way Procedure calls in Oracle DB AdapterSummary: Invoke Long running DB procedures is Oracle Database Content (required): We are Invoking Oracle Database procedure from OIC which on has only input parameters. …
-
Dynamic Number of attachmentsSummary: Content (required): We have a requirement to send an email notification with multiple attachments from OIC. The maximum number of attachments are 10 and these a…
-
Integration attempts to check filesize but errorsSummary: Simple Integration lists file on FTP server, then for each file I check whether file is less than 4000 bytes or its extension is 'TXT'. If TRUE then I move to a…
-
Can we place multiple SQL queries inside an Oracle DB Adapter?Summary: Content (required): Hi team, So we are trying to make a REST API integrated with an Oracle OnPrem Database which will be fetching information against a few ques…
-
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…