PaaS
Discussion List
-
Issue in select statmentSummary: hi When i am trying fetch data from database , i am getting below error. SQL - select xpa.batch_id, xpa.so_number, xpa.org_id from xxmdn_price_adj_tbl xpa where…
-
Efficiently Handling DB Insert/Update Activity in OIC w/ No Response PayloadSummary DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.Content H…User_2025-02-07-23-59-52-354 214 views 5 comments 0 points Most recent by Biman Dey Sarkar-Oracle Integration
-
Map html to REST including tagsSummary When trying to map attributes containing html formating the tags are just removed by OIC.Content We are trying to implement an integration between DB-AQ and a Or…
-
How many "In Progress" instances can there be in OIC Gen 2?Summary: On the "Track Instances" page, running OIC instances are shown with an "In Progress" status. How many instances will OIC allow to be in this status before it st…
-
bulk data import not workingSummary: ATP Connector for Bulk Data Import Failing when Importing Integration Content (please ensure you mask any confidential information): Hello all, Has anyone run i…
-
Is it possible to have dynamic routing in Oracle PCS (Process Cloud Service) workflowsSummary: Is it possible to have dynamic routing in Oracle PCS (Process Cloud Service) workflows ? We have a requirement to dynamically fetch the approvers and based on w…
-
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…
-
is it possible to trigger App driven integration while clicking on the EndPoint URlSummary: I want to Give the End Point URl In the Fusion So when clicking on the Endpoint URL the app driven integration needs to trigger and in that integration i have c…
-
Processing Large Attachment in GetDocumentData of ScheduleReportWSSServiceContent We wanted to fetch the ESS Job report output of 'Process Receipts Through Lockbox AR LockBox Validation Report. WSDL: https:///xmlpserver/services/ScheduleReport…
-
BIP External Web-service & OICSummary Issue while calling BIP External Web-service from Oracle Integration CloudContent I'm trying to invoke BIP publisher report by calling BIP external Webservices d…User_2025-01-31-15-15-19-379 66 views 5 comments 0 points Most recent by Nagarjuna Nudurupati Integration
-
How to invoke a custom Process Cloud Service" custom flow while submitting a requisition for approvaSummary: How to invoke a custom Process Cloud Service" custom flow while submitting a requisition for approval ? Content (please ensure you mask any confidential informa…
-
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…
-
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 …
-
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…
-
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…