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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Integration
Discussion List
-
Expose OIC integration as rest api with OauthHi All, We have created an app based integration which is exposed as an api. We have configured it to be exposed with oauth as per instructions given in https://www.atea…
-
Can't update individual row using Update lookup Rest APISummary Can't update individual row using Update lookup Rest APIContent Hi, I need to update the selected row value in lookup using OIC rest API, For example 'Row1' valu…
-
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 184 views 5 comments 0 points Most recent by Oracle PaaS Consultant-Oracle
-
Query for specific instance id in activity stream log of OICSummary: We have enabled Service log for OIC - Gen2 and trying to find activity stream for a specific instance id which is not visible from OIC dashboard. Is there a way…
-
Excel to CSV - OICSummary: Since FBDI accepts on csv format and we have requirement for scheduled integration to read a excel file and convert into csv followed by the mapping with FBDI t…
-
REST_REQ_PLD_ERR Error while calling a REST Service using POSTContent Hi All, I am having an issue while calling the REST Service from OIC. The error details are as provided below. Error Message
-
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 Generate Sign a JSON Payload using RSA Key and SHA256 Algorithm In OICSummary: Hi All, I have a requirement to generate signature for the json payload using RSA private key using SHA256 algorithm. After generating the signature I need to a…
-
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 172 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 …