xml
Discussion List
-
How Insert date field from csv into databaseSummary: What is the correct way to process a date to insert into a database? Content (required): Hi experts, I have a csv file on the ftp server like this: I have confi… -
Ability to Get the Value of XML Tag Based on CriteriaSummary: Ability to Get the Value of XML Tag Based on Criteria Content (required): Hello, In the below XML, the tag '' repeats and it has 2 child nodes and : Is there …
-
Data Stitch: Datatypes might not be compatible: Anonymous .vs.Summary: Datatypes might not be compatible: Anonymous .vs. Content (required): Hello experts, I'm working on an integration which launches another integration inside a f…
-
how to write BIP SQL query using offset and fetch nextSummary: Hi Experts We have a BIP report which selects huge data which causes integration to fail due to 10 MB data exceeding error. We want to use FETCH NEXT and OFFSET…
-
How to define XML document as response for REST Trigger ConnectionSummary: How to define XML document as response for REST Trigger Connection Content (required): I have a XML Payload shown in the attached document and I want it to be d…
-
(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 71 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…
-
Failed to import Library. EncryptDecrypt.zip doesn't contain either jar or xml file.Summary: Hi All I want to import my JavaScript library to OIC which I was able to do 1 year back with same .jar file, but when i try to do now it saying import only .zip…
-
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 13 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 11 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration
-
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:
-
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 126 views 3 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
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…
-
Send ESS JOB from OICSummary: Inconsistency when sending an ESS JOB from OIC Content (required): Hello everyone, I am building an integration to execute the standard "Trial Balance Report" r…
-
CASDK-0032: Unable to validate the resource.Summary: Content (required): Hi team, I am trying to create a SOAP trigger connection using a WSDL URL having no authentications in it. As I am trying to test the connec…
-
HCM ATOM Feed - Emp New Hire/Update Include Business Object checkbox disabledSummary HCM ATOM Feed - Emp New Hire/Update Include Business Object checkbox disabledContent Hi Everyone, The Include Business Object in HCM Atom Feed is disabled for Em…
-
OIC Parse XML from Database FieldSummary: We are storing an XML payload in a database field and need to pull it into an OIC integration as the payload for a co-located integration. Content (required): T…
-
OIC FTP adapter - erroing out with UTF-8-BOM encoding. Any workaround?Summary: OIC FTP adapter erroring out when the xml file is of UTF-8-BOM encoding. Works well when its UTF-8. Content (required): We have an issue while reading an invoic…
-
XSLT solution to select from 1st source only nodes NOT present in 2nd sourceSummary: Have simple case where 2 XML sources are processed in a way where nodes from 1st xml file are excluded if they already part of 2nd xml file Brute force approach… -
Convert json to xml in OICHow can I convert json to xml? I am using the new hire atom feed api. In it in an xml island I am being returned the below json content. How can I convert the below json…
-
SOAP trigger value not accessible inside IntegrationSummary: I have an App driven integration with SOAP trigger where value is received using a soap payload. When i try to assign that value anywhere throughout the integra…
-
Integration Error This Position Name already exists in EBSSummary: This Position Name already exists in EBS Content (required): We have Integration for Position from HCM to EBS. Reading File from SFTP, we are facing some issues… -
Issue while using scheduleReport SOAP Operation of ScheduleReportWSSServiceSummary Issue while using scheduleReport SOAP Operation of ScheduleReportWSSService from OICContent In OIC, we have configured a SOAP Connection with WSDL URL: https:///…
-
Namespace Issue while using getScheduledReportOutputInfo SOAP Operation of ScheduleReportWSSServiceSummary Namespace Issue while using getScheduledReportOutputInfo SOAP Operation of ScheduleReportWSSServiceContent Issue with getScheduledReportOutputInfo SOAP Operation…
-
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 … -
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…
-
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…
-
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…
-
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…