Mapping
Discussion List
-
Reading large JSON file in OIC IntegrationSummary: Hi , We have a requirement where we are getting JSON file of around 90-100 MB. We cannot use stage read to read entire file as it supports upto 10 MB only. Also…Sumit Kumar-261264 216 views 10 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Mapping issue in sample integration with EBS from the OIC documentationSummary: Unable to add 'if' construct under P_HEADER_ID Content (required): Add the Oracle E-Business Suite Adapter (Trigger) and the REST Adapter (Invoke) to the Integr…
-
UPS Integration to Oracle Inventory Management Cloud through OICSummary: One of my customer uses UPS as a 3PL for forward and reverse logistics process. They send lot of data (Sales Orders) through EDI from Oracle to UPS. And from UP…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Kanchankumar Khedkar Integration
-
ERP Adapter issueSummary Error: The application has encountered an unexpected error. Please check the applications connection details, credentials and retry your request.Content I'm tryi…
-
REST API for Get all lookup codes > How to escape special charactersSummary: REST API for Get all lookup codes > How to escape special characters Content (required): Hello All, I want to use the Get all lookup codes REST API in OIC (work…
-
Reading first occurrence of the repeating element column from the JSON fileSummary: Hi Team, I am trying to read a JSON file ( sample content pasted below ) via OIC. My requirement - Pick the single/first occurrence of the repeating 'additional…
-
How to send data as per the below Json formatSummary: How to send data as per the below Json format Content (required): Hi Expert, I have requirement to send the data as per the below JSON structure. I need to send…
-
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
Oracle Database Adapter - SQL IssueSummary Issue while trying to create a SQL queryContent Hello guys, i'm trying to implement a simple query as code snippet but i'm receiving the following error: Error: …
-
Get Base64 from REST API to Retrieve Attachment from a ProcessSummary: I am using following REST API to get the attachment and it works fine on postman. Content (required): I am not sure what or how should I configure the REST adap…
-
Any XSLT function to get the Last Day of a Month when the input parameter is sent as MON-YY?Summary: Any XSLT function to get the Last Day of a Month when the input parameter is sent as MON-YY? Content (required): We have a requirement to get the Last Day of a …
-
(copy-of) Payload from parent Integration to child Integration is not working as expected on readSummary: Hello, Need some guidance here please. we are passing an xml structure (Copy-of) from parent integration to child integration and then we are trying to use the …Balaji Sivaselvaraja-186077 72 views 5 comments 1 point Most recent by Balaji Sivaselvaraja-186077 Integration
-
How to Map data from multiple data sets or nodes to target nodeSummary: How to Map data from multiple data sets or nodes to target node Content (required): Please find the attached file for detailed explanation of my query. I have d…
-
OIC to Amazon S3 IntegrationSummary Fetching and Placing files in S3 buckets using OIC integrationContent Hi , We have a requirement where we need to fetch files from Amazon S3 buckets. We followed…
-
StageRead New Line in CSV file within Quotes in OICSummary: Content (required): We have a new line character in the CSV File within the Double Quotes for Example: ----------------- A,B,C,D A1,B1,"C1 C11",D1 A2,B2,"C2 C21…
-
Library Javascript 'require'Summary Having issues using the 'require' command in Library/javascript in OICContent Why can't I use the "require" command in my javascript program (library) for OIC? I…
-
Rest Receivables invoice attachment with postman OK, with OIC does not work (for me...)Summary: Hello, I would appreciate your help with this issue: I use postman with this payload: https://egyp-test.fa.em3.oraclecloud.com/fscmRestApi/resources/11.13.18.05…
-
How to Escape special charters (like space) in query parameters in REST adapterSummary: How to escape special charters (like space) in query parameters in REST adapter. OIC is encoding the value for Space -> + instead of %20 Content (required): Act…
-
Need JSON schema for Creating JSON response for successful records via OICSummary:Need JSON schema for Creating JSON response for successful records via OIC Content (required):I have an app driven oic integration that takes in array of employe…
-
First record of stage write is always getting missedSummary: Content (required): I am passing a json as input to my app driven integration. Input [{"name":"ABC","PersonNo":"123"},{"name":"DEF","PersonNo":"456"},{"name":"G…Jaeyshree Kumaran Kalpana 14 views 4 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
Ability to keep the integration running when the FTP connection lostSummary: Ability to keep the integration running when the FTP connection lost Content (required): Hello All, My integration uses FTP connection to List, Read, and Move f…
-
What is the best practices of using Lookup in OIC for fetching records?Summary: Need Lookup best practices. Should we create integration specific separate lookup or there should be one common lookup(as key name value pair) to be used across…
-
Stage Action Zip results in Error due to folder does not existSummary Stage Action Zip results in Error due to folder does not existContent Use Case: In OIC, I am Listing the files from SFTP Server and running a loop to fetch a set…Shivakumar Ayyanagowdar-Oracle 15 views 5 comments 0 points Most recent by Oracle PaaS Consultant-Oracle Integration
-
Using Number function to increment a Number to 1 Million fails in OIC MapperSummary: We have a requirement where Incrementing a Number beyond 1 Million makes a number be represented in Scientific Notation/Exponential format and not as a number X…Shivakumar Ayyanagowdar-Oracle 13 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration
-
How to read a file from 4th lineSummary: How to read a file from 4th line Content (required): Hello Expert, we are getting CSV a file where the header is in 4th row and data is starts from 5th row.Now …
-
Add line break in XML fileSummary: Content (required): Hi experts, I am working on an integration which will generate an xml file, my schema is as follows:
-
need help to understand xpath error -OICSummary: Hi Guys. I am geting this xpath error, however I have no Idea how to "bebug" it. Content (required): Version (include the version you are using, if applicable):…
-
How to pass null value for LOV field in OIC mapper. How to remove tag from payload if its nullSummary: How to pass null value for LOV field in OIC mapper. How to remove tag from payload if its null Content (required): I am trying to update list of 9 DFFs via REST…Jaeyshree Kumaran Kalpana 57 views 3 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
Extract Data from SaaS to VBCS ApplicationSummary Extract Data using an OTBI ReportContent Hello, I have a requirement to retrieve data from our Oracle ERP Cloud applications. I need to extract the data via an O…
-
FileReference:How to get the contents of a file from a loop and insert them into a tableSummary: Content (required): Hi everyone, I am building an integration which downloads a .zip file I am only interested in getting an .xml file the flow is able to recog…