Database
Discussion List
-
Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterSummary Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterContent Hi, RestAPI structure : { 'accountNum' : '123456' 'product' : ['abc','def','g… -
Browser Crashed While Trying to Load 20K Rows From External REST APIContent Hi All, While trying to load data from a rest API to a Business Object, it suddenly crashes - probably because I was trying to load 20K rows. Does anyone know a … -
How to Insert multiple values in Business Object in VBCSSummary How to Insert multiple values in Business Object in VBCSContent Hi Team, My goal is to insert all table data into a business object. How to achieve this. Could y…User_2025-02-05-07-12-25-853 95 views 3 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder -
Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterSummary Run a select clause in ATP database with 'in' Operator using OIC ATP AdapterContent Hi, RestAPI structure : { 'accountNum' : '123456' 'product' : ['abc','def','g…
-
Problem to send the payload of reading a file in Visual Builder to the RESTful web service of ApexSummary Problem to send the payload of reading a file in Visual Builder to the RESTful web service of ApexContent The requirement consists of a screen in Visual Builder …
-
Connecting Oracle Integration to Oracle ATP - Issue with SequencingSummary I am not able to understand from where the sequence is picked up.Content In Oracle ATP DB : Created new sequence CREATE SEQUENCE ZEB_TEMP START WITH 1000000 INCR…
-
Oracle DbaaS Test Connect Failure in ICSSummary ICS Test DbaaS Connection failing after updating the schema passwordContent A number of integrations in ICS using a Oracle DbaaS Connection. The connection was c…
-
How to move IAR file from one OIC to Another OIC instanceSummary Move IAR file from one OIC to Another OIC instancContent I have Export the IAR file from One OIC Instance. 1. Is it IAR having All the dependencies like lookups … -
Image, Large files storage in VBCS?Content What are the datatypes available in VBCS. Is there any way to store image or large files in table in vbcs?User_2025-01-31-02-34-24-578 38 views 2 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
Load data from Microsoft Sql server to Oracle cloud Paas using Web servicesSummary Load data from Microsoft Sql server to Oracle cloud Paas using Web servicesContent Hi, Can anyone please guide me, Is it possible to automate a process to direct…User_2025-02-05-00-15-45-904 14 views 0 comments 0 points Most recent by User_2025-02-05-00-15-45-904 Integration
-
Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tooSummary Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud toolContent Hi, Good day! Need help in connectivity We have crea…User_2025-02-05-00-15-45-904 30 views 0 comments 0 points Most recent by User_2025-02-05-00-15-45-904 Integration
-
Facing issue while reading EDI filesSummary unable to read the file contents of edi filesContent Hi, I am trying read IGM/EGM EDI Files in OIC and tried multiple ways to read by creating NXSD by uploading …Abhinav Prasoon-157527 44 views 0 comments 0 points Most recent by Abhinav Prasoon-157527 Integration
-
Table records is not visible to another admin userSummary Table records is not visible to another admin userContent Hi All, I am facing an issue, I am pulling the data from rest Service( rest Exposed Integration) in a t…
-
XSLT transformationSummary Select a distinct value from a DB resultset arrayContent Hi Folks, Our requirement is to read data from a MS SQL server DB and transform to fusion FBDI templates…Raghavendra Manchigiah-109808 48 views 3 comments 0 points Most recent by Kanchankumar Khedkar Integration -
Compare if a Select query returns data.Summary Compare if a Select query returns data.Content Hi everyoe, I am working on an integration where I must evaluate a condition, first I need to do an operation 'sel…
-
Multiple rows are not updating in database using ICS adapterSummary Multiple rows are not updating in database using ICS adapterContent Issue while updating multiple rows in the database: #1: I have selected 'Update' operation in…
-
How to get Rest Api data in vbcsContent Hi All, I m new to VBCS Visual Builder Application. https://technology.amis.nl/2018/05/25/5-main-concepts-of-the-new-visual-builder-cloud-service/ I followed abo…User_2025-01-31-15-10-49-714 65 views 1 comment 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder
-
Rest end point with parameter value containing single quote is not workingSummary When Business object rest endpoint is queried with parameter value containing single quote, bad request error is throwedContent I have a Business object containi…
-
Not able to reset arraydataprovider variableContent I have a table with data populating from arraydataprovider. I have dragged and dropped a select-one element in one of the column and set the value for the select…
-
Error using stage file with the action: Zip FilesSummary Error using stage file with the action: Zip FilesContent I'm working on an integration that reads a list of files and for each one generates a .dat file and comp…
-
BO RelationshipsSummary How to aggregate one BO by two primary keys to another BO?Content Hi All, I came across the BOs relationship functionality and I wonder how to create a relations…
-
Different ways to generate an APISummary Is there any other way to generate an API?Content Hi Experts, Besides creating a Plan and use its API, is there any other way to generate an API to consume the D…
-
Retry count / Interval in DB adaptersSummary Retry count / Interval in DB adaptersContent Hi, In case of a remote fault, do we have a mechanism to retry the DB insert/Select ? Like we do in SOA or OSB ?. I …User_2025-01-31-16-03-44-491 44 views 6 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Integration UsecaseSummary OnPrem DB to Fusion integrationContent Dear Experts, We are evaluating PaaS offerings to implement the following Integration use case : Integrate transactional d…Raghavendra Manchigiah-109385 26 views 0 comments 0 points Most recent by Raghavendra Manchigiah-109385 Integration
-
Search for data on a VBCS page based on a parameter valueContent Hi, We have devloped a page in VBCS visual application wherein we are displaying data for the jobs submitted in the past. The requirement here is that if the use…User_2025-02-05-01-33-23-630 56 views 21 comments 0 points Most recent by David Konecny-Oracle Visual Builder
-
Error while translating message to the mentioned format.Summary Error creating a stage write and stage readContent I have an integration "App Driven Orchestration" where it starts with a rest adapter that receives a content s…
-
Divide a line every time you find "," to insert into a database.Summary Divide a line every time you find "," to insert into a database.Content I am working on an integration which receives a line similar to this one: 126,12,2007,110…
-
Skip blank lines of a text fileSummary Skip blank lines of a text fileContent Hi everyone, This is my scenario: I have to upload files to UCM, I get the files from an ftp server but I have to validate…
-
Representing an XML schema in VBCSSummary taking a CSV file from OICS and converting it to a json for XML schema complex typesContent Hello All! I need some help on this problem I have I attempted to att…User_2025-02-04-13-35-35-440 57 views 0 comments 0 points Most recent by User_2025-02-04-13-35-35-440 Visual Builder
-
Auto Generate IDSummary Need to auto generate a number to use in the applicationContent Hi, We are developing a page where a field needs to be an auto generated ID. I want the auto gene…User_2025-02-04-20-45-43-416 24 views 3 comments 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder