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
-
An error occurred while processing the request payload in the target REST endpoint in OICContent Hi everyone, Brief Summary of my topic: Target system is exposing as REST service and accepting as JSON payload same we are enhancing in OIC. created REST adapte… -
Unable to get proper callback when running a BulkImportData Job on Fusion from OICSummary: Hi, I am attempting to run a BulkImportData task using the Oracle ERP Cloud Connector on OIC. The import is working as expected, no issue on that end. My issue …
-
Getting Timeout with Database adapter in OIC while executing view in EBS databaseSummary: We created an Oracle Database Adapter to connect Oracle Ebusiness Suite Database with an agent and query Views with a simple select query with one where conditi… -
401--UnauthorizedSummary 401--UnauthorizedContent Dear All, I am trying to call the web service, by using the endpoint URL of Integration. but ends up with below error '401-unauthorized'… -
How to get child resources also in runtime for business rest service get operation in B2B adapterSummary: I am using Oracle CX Sales B2B Service adapter Business Rest service get operation. Under map all child objects are showing but no value coming for them in run …
-
How to Get the xml data of a reportSummary: How to Get the xml data of a report Content (required): Hi All, We are looking for the web-service to get the xml data/output name of the report.Below is the sc…
-
Multiple sales order in single payload using rest apiHi, I am creating sales orders by Reading the CSV file. My questing here is I want to create all the sales orders at the time. If any error occurs I don't want to create… -
Slack Missing_scope users:read.email in OIC Slack AdapterSummary: Content (required): When we add the scope "users:read.email" in the connection then it gives us an error that this scope is not supported. We were able to add "…
-
Is there a Catalog for REST APIs in Oracle Fusion (like we have ServiceCatalog service for SOAP)Summary: Is there a Catalog for REST APIs in Oracle Fusion (like we have ServiceCatalog service for SOAP services)? Is there any equivalent for REST services which shows… -
HCM Integration : How to check failed recordsSummary: HCM Integration : How to check failed records Content (required): HCM Adapter in OIC does not offer a callback unlike ERP. Also we can't query the stage tables.…
-
Write an excel file using OICHi, Is there an option to write to an excel file in OIC? I am looking to upload this excel file in UCM or in a SFTP for a 3rd party to pick up?
-
Speed up Integrations that use REST APISummary: Is there a way to speed up REST api roundtrips to Fusion? Content (required): We have an integration that processes an inbound CSV file to update costs in inven… -
How to run report using REST API?Summary: Can we run a report in fusion applications using a REST API? We have ReportService which is a SOAP service. Do we have a similar service in REST? Content (requi…
-
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 212 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle -
OIC StageRead CSV-Insert records in sequenceSummary: Hi, I am reading the csv file using stage read and I observed that it is reading in sequential order but when I insert those records into database table it is n…
-
Callback flow version behaviorSummary: When invoking an integration with the SOAP adapter utilizing a callback, how does the flow version actually work? Content (required): We have integrations that …
-
Editing Invoke co-located integration?Summary: Is there any way in OIC to edit the integration shape for invoking another Integration? Content (required): We are using the integration shape "Local Integratio…
-
Workato vs Oracle Integration CloudSummary: Content (required): Do you have any comparison chart between Workato and Oracle Integration Cloud for integrations with both Oracle and Non-Oracle systems? Vers…
-
Date and time conversionSummary issue by String to Date and TimeContent I have a scinario of getting String type Date and Time values from Source need to populate into DB as a timestamp fields.…
-
IntegrationSummary Validate a date in AICContent How can I validate any date whether it is a proper date or not in AIC?
-
OIC - Read dynamic columns CSVSummary: Hi, I am having FBDI integration which reads 70 columns of filled data as CSV file from FTP location. So my integration is reading the file successfully. But th…
-
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 … -
How to force an OIC Integration Instance to complete with PARTIAL_COMPLETION statusSummary: Hi, Does anyone know wether it is possible to force an OIC integration instance to complete with PARTIAL_COMPLETION status? Content (required): Does anyone know…
-
Oracle Integration Update Webcast June 16th 2022Summary: Oracle Integration Product Update Webcast Content (required): Attend to get the latest updates and innovations on Oracle Integration May 2022 release. Our Oracl… -
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:
-
OIC-Aborted to SucceededSummary: Hello All, Can OIC version 22.2.2 integration instance can be changed from Aborted to Succeeded without resubmitting the same? For one of our testing, we aborte…
-
Is callback possible in OIC for HCM cloud?Is callback possible in OIC for HCM cloud like we do with Oracle ERP cloud.
-
Stage File Action List operation returns empty list.Summary: A "list files" operation for a Stage File action returns an empty list, even though a previous FTP operation was successful. Content (required): Hello Integrati…
-
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…
-
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…