Category 222
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… -
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…
-
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…
-
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… -
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 230 views 3 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration -
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…
-
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…Jaeyshree Kumaran Kalpana 902 views 3 comments 0 points Most recent by Jaeyshree Kumaran Kalpana Integration
-
OIC-Reprocess from last failureSummary: Hi, I do have one OIC long-running integration, basically, it is calling 3 external endpoints, suppose if it fails at the 2nd endpoint and the next time if I re…