Mapping
Discussion List
-
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 achieve File to base64 in OIC.Summary Here, how we can do File -> Base64Encode? and What operation we have to choose in the FTP adapter?Content I have a requirement, I have to convert the base64encod… -
traversing the rest response in OICSummary reading rest response of particular attributesContent Hi Folks, I am working on a poc and getting rest response as below. My requirement is to read the AccountNu… -
How To Schedule a Integration at the end of every monthContent Hi Expert, I want to schedule a integration at the end of every month.Can Anyone share me the steps and also the ical expression. Regards, Pritam
-
Migrating Integration to ICS to OIC one of Invoke adapter giving error and not saving.Summary Integration is working in ICS and that integration migrated to OIC . It is not giving configure option and having draft . When edit and save then it is giving er… -
How to process multiple files in same directorySummary How to process multiple files in same directoryContent I have a directory in FTP called Student in which there are three files Programs, Courses and Terms. All t…
-
How to Convert date into YYYY/MM/DD HH24:MI:SSContent Hi All, I have a requirement where i need to change the source file date format into YYYY/MM/DD HH24:MI:SS in the mapper. Thanks ,
-
CASDK-0041: An error occurred while invoking the REST endpoint.Summary We are running OIC to push files from UCM to Azure. For some of the files we are getting this errorContent Fault Details : -
How to do application/x-www-form-urlencoded request in OIC rest adapterSummary How to do application/x-www-form-urlencoded request in OIC rest adapterContent Hi all, In POSTMAN, I can able to get a response using Body as x-www-form-urlencod…
-
How to get the AP invoice report that is generated in the fusion to send as attachment in email viaContent Hi All, Our Requirement is to get the AP invoice report that is generated in the fusion to send as attachment in email via OIC. so how we can implement the use c…
-
How transform application/x-www-form-urlencoded to JSON payload using stage file?Content Hello, An external system invoking OIC with the request content-type application/x-www-form-urlencoded. After decode the reference to string, how do I map to eac…
-
Get the node value from a repeted node.Summary I want to get the href value from a payload that have several href in the response. Is there a function to be used on the map operator to get just the first ocur…Rodrigo Leonel Sartorato-162426 16 views 9 comments 1 point Most recent by Rodrigo Leonel Sartorato-162426 Integration -
Hanlde dynamic REST response in OICContent Hi Experts, I'm calling the external REST API in OIC which returns the dynamic response as below: Response-1 { "name":"Ankur", "age":1 } Response-2 { "contact":"… -
OIC Inconsistency in Extending Data TypesSummary OIC Inconsistency in Extending Data TypesContent Hello! We have an app-driven integration that invokes a "Publish to OIC" integration, and a Subscribe integratio…
-
Configure Trigger REST adapter to accept text/html response bodyContent Hello, I am trying to configure a trigger rest adapter to call an external API that returns a XML text as the response but with the content-type text/html. How s…
-
OIC mapping - XPath expression failureContent Getting back to working on this project after almost a year. Via this forum, Hemanth helped me create parent/child xsd's (attached) for a multi-namespace xml pay…
-
source ID not available in the database record, we have to collect the missing source ID and we haveSummary source ID not available in the database record, we have to collect the missing source ID and we have to send those IDs to the source.via email.Content Hi, I have…
-
How to return custom error response from default handlerContent Hi All, I have created an app driven integration for creating a requisition where end user will pass the request payload and in the response i am passing the req…
-
Lookup Table Column in ForEach ActivityContent We don't have any database, so storing list of eligible BU in the lookup with some other fields. I want to use this table column (lets say BU) as ForEach Rowset.… -
How to skip mapping for a particular value in mappingContent Hi All,- I have a one requirement where i have to create requisition using SOAP web-service. The scenario is end user will send supplier item number and i am dir…
-
How to unzip the .iar file using WinZip softwareContent Hi All, After exporting the integration i want the mapping file so that i can edit the mapping the notepd++.How can i unzip the .iar file and get the mapping fil…
-
Assign JSON Array in MapperContent I have a requirement where I need to map JSON array to an object in Mapper. I am attaching the screenshots, please guide if there is any easy way or any workarou…
-
OIC substitution to SOA || Simple and Complex Integration || Oracle Service BusContent Hi team, I have three queries regarding integrations. Firstly, what do we mean by simple and complex integrations? I have seen in many blogs being mentioned that…
-
Parse a file with trailer in OICSummary Parse a file with trailer in OICContent Hello I am trying to parse a file with trailer in OIC. Since the format of the trailer line is different to the other dat… -
Aggregation Using For-Each-Group in MapperSummary Aggregation Using For-Each-Group in MapperContent I have the following data input: AAA Line 1 1000 2020-04-01T00:00:00Z BBB Line 2 100…
-
How to generate sequence for FBDI in IntegrationSummary How to generate sequence for FBDI in IntegrationContent Hello I am building a Integration in OIC to generate the Payables FBDI from the input txt file. Sequence …
-
FEB2021 Update: Directly Edit Raw XSLT Code in Mapper ConsoleSummary As mentioned on the FEB2021 Update, we can now directly edit Raw XSLT Code in Mapper Console.Content Hello, As part of the FEBRUARY 2021 Update - we can now dire… -
Object(global) of class cannot be converted toContent Hi, While integrating OIA with Oracle database in Oracle Integration Cloud(OIC), as we mapped global(id) of OIA a default parameter to a primary key id of Oracle…
-
Getting a list of errors while Integrating OIA with Oracle DBContent Hello, While integrating OIA with Oracle DB, as we activate the integration and insert values from OIA UI to the Oracle DB to store inside the database, below ar…
-
Extended Data Types not visible in the mapper of Stage File action for Read Operation as sourceContent Hi Everyone, I'm trying to make use of the Extended Data Types functionality in OIC. I can see this being available in the mapper where my source is a Trigger Co…