Database
Discussion List
-
Establishing VBCS Connectivity to Private ATP Instances via Tenancy SettingsI am attempting to establish a connection between Oracle Visual Builder (VBCS) and an Autonomous Transaction Processing (ATP) instance using the Tenant Settings (the nat… -
Architectural Guidance: Integrating VBCS with DBCS for Spreadsheet-Based Data IngestionSummary: I am designing a solution in Oracle Visual Builder (VBCS) that requires users to upload a spreadsheet to insert or update records directly into an Oracle Databa…
-
Data Sync for Project in VBCS Extension and Oracle FusionRequirement: Bidirectional Data Sync for Project in VBCS Extension and Oracle Fusion Context: We have a requirement to build a custom application over VBCS extension to …
-
Connect to ATP in VBCSSummary: Hi, i am trying to connect to ATP from VBCS using Tenancy Setting, while in OIC connection we are using agents to connect to ATP while trying to connect to the …Converse_with_OraEnthu 12 views 3 comments 0 points Most recent by Converse_with_OraEnthu Integration
-
Integration scenario - OIC3Hi Team, We need your assistance in below scenario. High-Level Process Flow Extract data from external systems (PostgreSQL, SQL Server, etc.). Load the extracted data in…
-
java.sql.SQLException: UCP-29: Failed to get a connectionSummary: OIC getting this error often when call to private Oracle ATP PL/SQL call execution Internal Exception: java.sql.SQLException: UCP-29: Failed to get a connection… -
Oracle VBCS: Auditing and logging in VBCS application for production instance at runtimeHi All, We wanted to enable Auditing and logging functionality in our VBCS application at different data level to track its history and also want to debug any production…Rohit Chaturvedi 11 views 3 comments 0 points Most recent by Vignesh Viswanath-Oracle Visual Builder
-
java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not existSummary: For a new ATP database table we are getting below error> java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist I am able to insert into the table… -
ATP Connection OIC gen3Summary: Content (please ensure you mask any confidential information): I'm passing the information from a BIP extract to the ATP DB connection using OIC. Whenever there…
-
DB Issue - DBMS_CLOUD.COPY_DATA performanceI am loading the data from CSV file on OIC object storage to ATP using DBMS_CLOUD.COPY_DATA The execution time of this approach is not Consistent. For some run it is tak…
-
DBMS_CLOUD.COPY_DATA performance IssueSummary: I am loading the data from CSV file on OIC object storage to ATP using DBMS_CLOUD.COPY_DATA The execution time of this approach is not Consistent. For some run …
-
OIC Architecture Question:Summary: We recently implemented OIC. Part of that implementation included PL/SQL packages which are called by the OIC integration platform. We believe is typical archit… -
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…
-
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 … -
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…