Database
Discussion List
-
Optimizing Performance in VB BO for Large DatasetsSummary: Content: Hi Expert, I have a table with 6 million records. When I run a “SELECT * FROM” statement in SQL Developer, it executes very quickly, within a few secon… -
Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?Summary Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)Content Hi, I'd like to hear your inputs as to which approach is better in terms of efficien… -
OIC Table SchemaHi Everyone, I would like to ask if there's a way to know what is the schema of the table configured in the OIC. Currently modifying an integration and I need to configu…
-
CRUD operation on ADP on save to reflect in BOSummary: I have an ADP which has to be inserted in a BO based on ATP table(Custom VBCS BO). The ADP has some columns which is there in specified BO as well (ADP in not b…
-
How to pass collections to PL/SQL package from OICSummary: We are in the process of transferring all direct table operations (insert/update/delete) from the OIC database activity to a PL/SQL package. However, we are enc…
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…
-
Fusion - Apex integrationHi Experts, We are using oracle fusion application cloud ERP(SAAS). We also have paas services (OIC4Saas and apex on DBCS) for saas extensions. We wanted to use Oracle F…
-
fetch refresh token in REST callSummary How to fetch refresh token in OIC REST callContent Hi All, We have configured REST OAUTH as Resource owner password credential with access token URI in connectio…User_2025-02-08-06-30-58-076 45 views 6 comments 0 points Most recent by Rajkiran-Oracle Integration -
Is ORDS supported by Oracle to use with OIC-VB?Summary: Please, Oracle teams. Is ORDS supported by Oracle to use with OIC-VB? We are planning to do some screens VB to use ORDS. Some of the tables has clob. content, w…
-
Getting an error while trying to get value from parent BO's Attribute in Before Insert TriggerSummary: I am using Before Insert trigger, in which trying to get the value of BO' attribute. Content (please ensure you mask any confidential information): For example,…
-
Identify OIC connections to ATP database using unexpected database serviceSummary: We have hundreds of OIC flows that connect to our ATP database. We only have 1 OIC connection defined to the database, and it is using the service "_tp". Howeve… -
OIC - Is there any other option apart from agents to connect to on-premise database?Summary: OIC Connectivity option to on-premise database apart from agents Content (please ensure you mask any confidential information): Would like to know if we can use…
-
How to use Bulk Import option in Snowflake adapter in OICSummary: I am trying to load bulk data into Snowflake tables from Fusion using OIC, I see in the documentation we have an option to bulk import data using internal or ex…
-
how to replace schema name in db procedure invocation in OIC GEN3Summary: We have a requirement where the schema name need be changed when we move the code from Non-prod to prod instance. Please let us know how the schema name change …
-
UniversalConnectionPoolException Error for Database Connection on OCI ConsoleSummary: UniversalConnectionPoolException Error for Database Connection on OCI Console Content (please ensure you mask any confidential information): Hi Team, Greetings!… -
How to edit this page called journey in Fusion ?Summary: how to edit this page like viewing the HTML code or add new components
-
What is the best way to sync Oracle Cloud ERP data to Oracle Autonomus DatabaseWe are currently using Oracle Integration Cloud application to integrate other systems with our Oracle Cloud ERP (SaaS) application. In most of the integrations we do ru…Pradeep Moganti 191 views 6 comments 0 points Most recent by Ahmed Samir Abdelnaeim-Oracle Integration
-
issue with stored procedure invocationSummary: We are trying to call a same stored procedure from two different schema.But from one schema it is working fine and from another schema it is failing.Please let …
-
How to find pages that Oracle made it with VBCS ?Summary: I want to know where i can find new responsive page that Oracle made it with VBCS and enter to edit it in VBCS
-
Downloading an excel file from object storage is corrupted.Summary: Unable to open the excel file downloaded from the Object Storage. Content (please ensure you mask any confidential information): Hi Team, I am facing an issue w… -
How to read tab delimited file in oic integrationSummary: We have to read a text file from FTP server. File structure is bit complex and we cannot use directly from csv (tab delimited) and not from XSD schema. I use cs…
-
How to format Time type in built in export buttonSummary: There is a column that is time type and i want to format it from T12:00:00 to 12:00 when exporting a table to excel file from built in export button
-
VBCS with ATP in a private subnetSummary: We are a long term EBS customer and starting our cloud journey. We have lot of OAF extensions in EBS. We want to use VBCS for building some of those in the clou…
-
Is it possible to download csv files from OneDrive on OIC Integration?Summary: OneDrive + OIC Content (please ensure you mask any confidential information): I have a requirement where I must download CSV files from an integration, is this …
-
Receiving 502 : Connection refused Error while invoking ORDS API from Oracle VBCSIn the Development instance, When invoking an ORDS REST service that has no Authentication from VBCS is failing, an error is given below. { "type": "abcs://proxy_problem…
-
Multiple ATP Tenants on VB RuntimeSummary: Does VB support multiple ATP tenants? As an example, Application A in VB runtime A that is connected to ATP Tenant A. Does VB support Application B in VB runtim…
-
Default a Value for Only for Specific Row using Select Single LOVSummary: We have 2 Values for a LOV Y and N for a Field named Eligibility which has 4 Rows named Row1, Row2, Row3 and Row4 from a SDP Table for each employee. We want to… -
DBCS Table import issueSummary: While importing DBCS table , getting below error. Content (please ensure you mask any confidential information): Version (include the version you are using, if …
-
-
Can we use sql hints in OIC DB adapter while running a SQL statement?Summary: I want to use a SQL hint in OIC DB adapter to run a SQL statement . When I click on validate query it says success . But on finishing the configuration the proj…