PaaS
Discussion List
-
can I create OIC instance in domain replication regionHi Experts, please advise, I'm in process of creating OIC instance under compartmentA and test domain. For test domain, home region is Germany Central (Frankfurt) and re…
-
how to make table scrollable in UI web form in oracle process automation version 3Summary: Hi Friends , I have drawn a table in my UI form in the PCS version 3 , but the table have multiple columns , I need to make the table scrollable so that the use…
-
sum function with big decimals numbersSummary: Hi, We have a validation in gl rates Integration for checksum of all the rates in the source file. But since gl rates have longer decimal values upto 40 decimal…
-
Sample OIC integration using DB package with plsql table type as in and out parametersSummary: Sample OIC integration using DB package with plsql table type of records as in and out parameters please share the DB package as well Thanks Content (please ens…
-
Sample OIC integration using FINDER option ( instead of q) in REST apisSummary: Sample OIC integration using FINDER option ( instead of q) in REST apis for ex /fscmRestApi/resources/11.13.18.05/cashBanks in the query parameter , finder is o…
-
Unable to connect to SFTP using private key in OIC, it is working fine in WINSCPSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
IBM MQ Series JMS invokeSummary: IBM MQ Series adapter invoke error Content (please ensure you mask any confidential information): Hi Team, we have created a IBM MQ Series JMS invoke connection…
-
How to generate unique id for each record in OIC integration mappingSummary: Hi all, how we can generate the unique ID for each record and it will never repeat. I tried with date timestamp but even seconds are not changing. If my file ha…
-
Is Instance ID in OIC Gen3 not a numeric one?Summary: Is Instance ID in OIC Gen3 not a numeric one? In the Gen3 it is showing as "R-NOnHQNEe8p2yXhQ8uxaA" though it is System geneerated, but can this be configured t…
-
OIC to Amazon S3 IntegrationSummary Fetching and Placing files in S3 buckets using OIC integrationContent Hi , We have a requirement where we need to fetch files from Amazon S3 buckets. We followed…
-
how to skip a column in while reading the file of fixed length in OIC (FTP Adapter)Summary: Hi, We are reading a fixed length file from an FTP directory using FTP adapter. There is one column in the file which have different length of characters. For e…
-
Error invoking Local integration in OICSummary: We have a critical integration related to invoices and billing and it calls multiple sub process. So the parent main process failed as it received error invokin…
-
OIC Gen3 > Stage File Action ‘Read File in Segments’ > For Each Loop > Activity StreamSummary: OIC Gen3 > Stage File Action ‘Read File in Segments’ > For Each Loop > Activity Stream Content (required): Hello All, I am using a For Each Loop within a Stage …
-
Working with timezones in OICSummary Working with timezones in OICContent From the integration source, I receive two data: 1) A "datetime" in YYYYMMDDHHMISS format and a timezone (like "America/Los_…
-
Can OIC consume BLOB or CLOBSummary DB Adapter is invoking a PL/Sql Procedure which is returning CLOB/BLOB as out parameter, Can we consume the same in OIC.Content DB Adapter is invoking a PL/Sql P…
-
Cannot create instance > Not authorized to create integration instanceSummary: Cannot create instance > Not authorized to create integration instance Content (required): Hello All, I am not able to create an instance - PFA screenshot. Any …
-
OIC REST - how to save xml payload to ATP clob column opaquelySummary OIC REST - how to save xml payload to ATP clob column opaquelyContent I am trying to build a simple REST integration that when called from Postman with an xml pa…
-
Convert json to xml in OICHow can I convert json to xml? I am using the new hire atom feed api. In it in an xml island I am being returned the below json content. How can I convert the below json…
-
OIC - JavaScript Function Library Timeout IssueSummary Calling a JS function in OIC Orchestration with 15-second timeout limitContent Hi, We just found out that the “Wait” Action in OIC/ICS is only available for Sche…
-
OIC FTP - get last modified dateSummary: How to convert a file's last modified time to a date in OIC Content (required): In OIC Gen2 I'm downloading some files from an SFTP server, but I also want to a…
-
How to delete files older than x days on OIC file serverSummary: Bulk delete files older than x days Content (required): Is there any script or a way to mass delete files older than x number of days? We need to cleanup our fo…
-
Subscribing to Business Event from Boomi or MulesoftSummary Subscribing to Business Event from Boomi or MulesoftContent Dear All, Is it possible to subscribe to Oracle ERP Business Events (example: Payables Invoice Create…
-
OIC IBM DB2 Adapter & AS400Summary DB2 AdapterContent Hello All, I understand OIC has a prebuilt IBM DB2 adapter which allows to perform CRUD operations for DB2. However another Document Doc ID 24…
-
Error when Create Agent GroupSummary: try to install agent , got error :Agent Installation Failed !!! Error occurred while checking version response. Agent Installation Failed. Content (required): V…
-
List files OIC not workingSummary: NA Content (required): Hi Team, We were trying to list the files from a FTP server which is on Port 21 and observed that List files is not working and it is not…
-
OIC and PaaS/IaaS certificationsSummary: For those that don't know until August 31st 2023 Oracle are offering 2 free certification attempts mainly in the PaaS/IaaS space this includes an attempt at the…
-
Automation for OIC DeploymentSummary:Automation for OIC Deployment Content (required): Do we have any way of using CI/CD in OIC and any documentation or links will be helpful to implement. Version (…
-
What exactly is a stage file?Summary: Content (required): I've been working in OIC for a few years now, and I've just kind of accepted the Stage File function for what it is and can do. But what exa…
-
How to achieve File to base64 in OIC.Summary Here, how we can do File -> Base64Encode? and What operation we have to choose in the FTP adapter?Content I have a requirement, I have to convert the base64encod…
-
Run the same integration multiple times in parallelSummary: Run the same integration multiple times in parallel Content (required): Hi everyone, I am working on a requirement where I have to process files and take them t…