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
-
Ability to Store Values in ArraySummary: Ability to Store Values in Array Content (required): Hello All, In the integration below, I am iterating on the files in a specific directory and doing a Read F… -
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…
-
FTP Connection Not Working Properly After Change Password Multiple TimesSummary: FTP Connection Not Working Properly After Change Password Multiple Times Content (required): Hello All, I am working on the integration below in which I have ad…
-
Can we use more than 2 tables in Select Operation for a DB call in OIC?Summary: Ex: Table 1 has a primary key P1, Table 2 has a primary key P2 and there are two other columns (P3,P4) present in both the tables but these columns are not defi…
-
Connect Oracle SaaS (ERP, HCM, CX) Discover Financial Services - August 17th 2022 9:00 a.m. PTSummary: Content (required): Accelerate your multicloud modernization with prebuilt connectivity to any SaaS, on-premises, and custom applications. Jump-start your Oracl… -
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…
-
3rd Party FTP – OCI – HCM Integration > Best PracticesSummary: 3rd Party FTP – OCI – HCM Integration > Best Practices Content (required): Hello All, We are working on an integration which reads HDL files from a directory on…
-
Insert mutiples in Oracle ORDS failsContent I have a table in ATP database. I converted table into right click ORDS service. I am able to insert single row using postman. I am not able to insert mutiple ( …
-
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 204 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…