Category 222
Discussion List
-
execution of stored procedure does not return dataSummary: Content (required): I have an integration that connects to the DBCS database and runs a separate procedure. The DB procedure returns a cursor type field. When I… -
run OIC service from mailSummary: Hello everyone, I need the following functionality that involves a visual builder screen and an integration: I have a screen that invokes an OIC integration thr…
-
Archive files in OICSummary: What are the different ways to archive and secure the working files into a history/archive file server and retain it for an extended period in OIC. Moreover, wh… -
MS Graph send messages API not working in OICSummary: Hello, We are trying to integrate MS Teams with Cloud Order Management and as part of it are able to create team and channel within MS Teams. However when we ar…
-
Not able to View Visual Builder with ServiceUser RoleSummary: Not able to View Visual Builder with ServiceUser Role Content (required): We attempted to restrict developer access to higher environments by granting them only…
-
Is there a way to change the schema name in OIC integration DB activitySummary: When we want to use a DB activity in Oracle Integration, we need to choose a schema name and a db object. This process would cause a problem when the production…
-
Issue in invoking ERP Rest Adapter for Sales Order Creation.Summary: Issue in invoking ERP Rest Adapter for Sales Order Creation. Initially integration takes around 15-20 mins for completion and then later it errors with “Service…
-
OIC Gen 3: Eloqua|Retrieve a sync REST API giving 404 Not FoundSummary: I am trying to invoke an Eloqua rest api through OIC gen3, it is giving 404 Not Found. Retrieve a sync | get | /api/bulk/2.0/syncs/{id} I am passing query param…Jigyasa Kamthan-Oracle 39 views 3 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration -
Merge PDF file using OICSummary: 1) In Oracle Integration Cloud (OIC), we have a use case for creating a new function using libraries. The use case is to consolidate various pdf files related t…
-
Error An error occurred contact your help desk (FND-2)Summary: Our HR department is receiving this error codes when they go to approve transactions for our document record workflows such as change personal information and m…
-
How to read .docx/.doc file in OICHello, We have a requirement to pick the source file which is with .doc/.docx file extension from SFTP and create a GL FBDI file from that source file. Is there a way or…
-
Oracle Integration Cloud 3: For-each repeating element is read onlySummary: Am I missing something obvious? When configuring a for-each loop in OIC 3, the field to configure a repeating element is read-only so I can't pass it any values… -
Is there any REST API to add and update items to the cycle count ?Summary: I see one API /fscmRestApi/resources/11.13.18.05/cycleCountTransactions . Is this for add items to cycle count ? Do we have PATCH operation supported for this f…
-
Extract fields from XML responseSummary: In OIC i'm receiving a BI Report that has xml data in it (i added a sample response as an attachment). I need to access the individual Columns out of the Row ar…
-
How to get the status of HCM Extract ESS job status in details using Webservice in OIC?Summary: Hi All, We have built an HCM Extract which is integrated to third party via OIC and third party system pass parameter values based on the requirement. Extract D…
-
Use round function to rounding to 2 decimal placesSummary: Use round function to rounding to 2 decimal places Content (please ensure you mask any confidential information): Hi experts, I working in data maping but I nee…
-
UKG Pro WFM (Dimensions) Timecard File Import into OracleSummary: Has anyone done a Timecard Import from UKG Pro WFM (Dimensions) to Oracle HCM/Payroll and how did you go about handling processing of the data? We are currently…
-
ATP got ORA-00001 when insert sequence in the primary keyHi All, I tried to use sequence to insert data in my table's primary key: I set the increment to 50 after read this document: But when I run the integration it shows 'OR…
-
Gen3 OIC Dashboard monitor accessHi Team, Since Insights is not a part of Gen3 OIC anymore. we want to make our OIC dashboard public for few users to consume. is there a way that we can make the oic mon…
-
How to set user context when calling SaaS Rest API using OIC using common ConnectionWe are calling the Sales Order Hub REST API from OIC and need to pass the user context to indicate who created the order in the VBCS application. Is there an easy way to…
-
What Job role or Privilege is needed to view Supplier Registration Requests using REST APISummary: We have a requirement to view Supplier Registration Requests using REST API (/fscmRestApi/resources/11.13.18.05/supplierRegistrationRequests/). But we are getti… -
Use the replace or replace String functions to remove special charactersSummary: Hi everyone, I need to remove special characters from a string for example: "A.*BC(D E+FGH?/IJK L#M%&//#?¡'¡N~OP" I have tried to apply the functions without su…
-
Can we send encrypted file as an attachment in the notificationSummary: Can we send encrypted file as an attachment in the notification Content (please ensure you mask any confidential information): Can we send encrypted file as an …
-
Where does the credentials mentioned in a connection saved in OIC?In OIC to connect to ATP etc.. we use credentials in the connection. Where does these credentials of a connection saved ?
-
Synchronizing Employee and Manager Details with Microsoft Office Using Oracle Integration CloudSummary: I have a requirement to synchronize employee and manager details from Oracle HCM to Microsoft Office using Oracle Integration Cloud (OIC). The data includes emp…
-
Does OIC have a feature to dynamically choose connections during runtime(based on target parameter)?Summary: Does OIC have a feature to dynamically choose connections during runtime? Content (please ensure you mask any confidential information): We have multiple fusion…
-
old OIC instance from June aborted when restarted integration. Config to not retain such old data?I have a scheduled integration which I restarted for the 1st time ever in November. Suddenly I saw an old errored out instance from June getting aborted. Where is the co…
-
Read timed out error while invoking BIP report from OICSummary: We are trying to invoke BIP report in pdf output from OIC, report invocation is taking 5 minutes and after that it errored out with below error: javax.xml.ws.We…
-
OIC Integration activation failure in Gen3Hi, We have created one OIC integration which involves a REST trigger and one invoke REST connection. That Integration is getting failed in activation with below error: …
-
Get error when OIC integrations runs over 5minsHi All, I created a complex integration to load data to HCM, I think it needs about a hour to complete because there is a loop to call other REST API, and I got error 'd…