Database
Discussion List
-
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… -
VBCS doesn't respect BO Data Security rule for View based on column value and session usernameSummary: VBCS doesn't respect BO Data Security rule for View based on column value and session username Content (please ensure you mask any confidential information): I … -
Calling External APIs from VBCSSummary: Hi, I am working with Oracle Visual Builder (VBCS) and I need to call an external API (for example, https://jsonplaceholder.typicode.com) directly from my appli…
-
cannot read/modify an object after modifying it in parallel in OIC Merge OperationSummary: Hello, We are using the insert/update (Merge) operation for inserting or updating the data to a table, which was working fine before but it is failing with belo…
-
Business Object Rest Api Getting error when we pass Multiple Values for q parami'm trying to access Business Object Rest api in Postmen Client When i pass filter q param with below https://.vbcs.com/1.0/resources/data/UserInfo?q=iBLPN='ABCD';workOr…
-
preview image in vbcsHi @Nada Bashar @Sherif Bashar I need to display a preview of an image that the user uploads. I was able to successfully upload the image to the database using FilePicke… -
I have connection reset issue when doing a Merge operation in SQL Server tableSummary: I have an integration that extract data from Fusion and loads the data into SQL server table. I can insert a new record or update an existing record in the SQL …
-
Object Storage IDCSI was able to create the bucket and namespace earlier in the oracle idcs but now I am getting the error message as "You do not have authorization to perform this request…
-
Can't able to set value to select-single filed in Oracle VBCSSummary: Hi All, I m facing some issue in select-single filed. when i create a record using select-single its working fine that same way, when i go to edit that record t…
-
best approach to insert into multiple tables from OICSummary: Looking for the best way to proceed to bring in data with many collections of data within it Content (required): Hi. I am extremely new to OIC and just stumbled…
-
Application ArchitectureSummary: More of a general question about application archtitecture. Is there a best practice guide when it comes to application architecture? Let explain what I am tryi… -
Sort column when download the data in visual builder templateSummary: Hi, Is there a way to sort the column when we download data? I do the column sort and save the file. When I do the download data next time, the sorting will rem…
-
is there any free limit for the OCI object storage that we can consume in oracle vbcsI wanted to utilise the object storage for storing image files in oracle vbcs , so can i use the oci's free limit or need to buy a storage
-
View BLOB Image in Image ComponentSummary: I have a REST API hosted in Oracle ORDS which is giving me an image in response (source type = Media Resource). Below is a sample query SELECT image_content_typ…
-
Issue saving data to BOSummary: While trying to Save Data to a BO using SDP . It is saving as 0 1 2 3 etc. The Field Name is Emp_Dept_Name which has data like 'HR', IT ', etc. It is selected t… -
How to Show the Table Data Just Besides the Input Text Box as PopupSummary: We have a Requirement to show the Tabel data just besides the Input Text box The Data is getting Populated to the Input Text box based on Table First Selection …
-
Oracle VBCS: Creating Business objects from more than 1 schema in Oracle visual builder applicationHi All, We have 2 schema created in our ATP DB. and we wanted to created Business Object for our application using both the schemas. But what I observed is that once I c…
-
Enabling audit will impact performance of the applicationHi Team, We want to enable "Audit" for all Financial Modules in Oracle fusion application. Could you please confirm, will this impact performance of the application? Reg…
-
Using API gateway instead of directly calling ORDS APISummary: Hi Experts I have a requirement to call ORDS API via API gateway instead of directly calling from visual builder application. Is this possible? Any solution on …
-
REST APII have two tables named attendance_device_user and attendance_device_missing_punch. Legal entity defined for all user in attendance_device_user table. What I wish to ach…
-
When leveraging existing table in VBCS, how to create composite key in Business Object ?Summary: Not able to create a composite key on existing table in Business Object. Need to maintain unique values in 2 columns, so created composite key constraint in the…
-
OIC db adapter sequencing issue with insert statementSummary: We are using OIC gen 3 (25.04.1) to insert records in atp database. In the db adapter, we are using a sequence. We have noticed that sequence used by the db ada…
-
OIC 3.0: Delay in processing large XML from OTBI – How to improve performance?Summary: Hi community, I'm looking for ideas or best practices to improve the performance of an integration in Oracle Integration Cloud (OIC v3.0) that is currently taki… -
How can I be sure my OIC Service Version: 25.04.1 supports Transparent Application Continuity?Summary: We have DBaaS connections defined within OIC which use the standard DBaaS wallet connection strings, etc. We've enabled Transparent Application Continuity on th… -
How can I insert a pdf file into blob column in OIC?Summary: How can I insert a pdf file into blob column in OIC? I have a pdf file that transfers into /stage with the ftp adapter and I need it insert it into a blob colum…
-
How data polling mechanism work from Database in OIC By Using Database Adapter as Trigger?Summary: How data polling mechanism work from Database in OIC By Using Database Adapter as Trigger Content (please ensure you mask any confidential information): Version…
-
Multiple Email Notify Attachments DamageSummary: The attachments that i get from my ATP database and included in the OIC integration notification action are damaged because of XML tags when use stage write act…
-
Realtime use cases for business objectSummary: Realtime use cases for business object Content (please ensure you mask any confidential information): Hi Expert, How we can leverage Business object in VBCS in …
-
How to show date and time based on user zoneSummary: How to show date and time based on user zone Content (please ensure you mask any confidential information): Hi Expert, we have a date field where we are display…
-
Oracle DBaaS send query parameters in SELECTHi, I'm trying to send query parameters in my SELECT statement but it keeps returning in syntax error: I have thought we use # to define variables? I let the Query gener…