Database
Discussion List
-
Switch Oracle DBaaS adapter to Oracle ATP via Configuration EditorSummary: We're looking on an initiative to migrate our OIC database connections on existing integrations from DBCS to ATP. In the Integration > Configure section, does t… -
How to connect to private database from VBCSSummary: How to connect to private database from VBCS Content (please ensure you mask any confidential information): Hello Expert, We have a VBCS application where we ar… -
Met error when using nvl function and parameter in ATP run SQL statementHi All, I have an ATP in OCI using run a SQL statement: When I added the function nvl, it shows error: and there is no error when nvl without parameter: May I know why? … -
What is the best approach to insert report data from oracle fusion to Autonomous DB?Summary: Hello, I am trying to insert the data from a report whose output is in XML format using OIC in which SOAP service is called to retrieve data from report and pas… -
Which one is better in terms of cost Oracle apex or Oracle VBCSSummary: Which one is better in terms of cost Oracle apex or Oracle VBCS Content (please ensure you mask any confidential information): Which one is better in terms of c…
-
Calling DB Procedure from OIC is taking too much timeCalling DB Procedure from OIC is taking too much time, where as when the procedure is executed independently in the Sql developer it is getting completed within seconds.
-
OIC REST - how to save xml payload to ATP clob column opaquelySummary OIC REST - how to save xml payload to ATP clob column opaquelyContent I am trying to build a simple REST integration that when called from Postman with an xml pa…
-
VB schemas on ATPSummary: hi, we have one DV and one Live deployment … we are running VB on the ATP database … on the ATP db, we find there's over 80 vb_vb_xxxxx schemas … should we remo…
-
Trigger app driven oracle Integration from Oracle database using PLSQLSummary: Our requirement is to trigger oracle integration from our Oracle DBaaS Database. Content (please ensure you mask any confidential information): Version (include…
-
Cannot Publish, the Deploy fails with Errors ORA-00955, ORA-00904Summary: hi, we have a vb standalone app running on ATP, already published as Live. Now when we try to publish again, the deployment fails with messages relating to BO's…
-
OIC VCN for whitelistingHello all Is there an easy route to know the VCN for OIC for whitelisting ? We are using ATP database with whitelisting hence need the VCN for OIC instance. Thanks -
Not able to update the status of a sales order via REST APISummary Getting Error when trying to update a status of an orrder via rest apiContent Hi , I am trying to change the status of a sales order using a rest api . (EndPoint…
-
Best practice for high volume data transfer via connectivity agent for databaseSummary: Best practice for high volume data transfer via connectivity agent for database Content (please ensure you mask any confidential information): Would like to kno…
-
Not able to Create/Access Business ObjectsSummary: From Oracle Cloud Applications Configuration →Visual Builder Created an Empty Project and then Created a space by selecting New Visual Application and created t… -
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
Visual Builder Studio unable to create business objects from tenant database and csvSummary: I keep getting an error in my attempt to create business objects from my tenant database and local CSV files Content (please ensure you mask any confidential in… -
Recommended option to connect to ATP DB from VBCS - Tenant DB or ORDSHi Team, We are using VBCS(comes with OIC) for building some complex UI extension. As the volume of data would be high, we'll be using ATP DB connectivity to store the d…
-
How to analyze the "SQLN_EXPLAIN_PLAN" warning in VBCS?Summary: Content (please ensure you mask any confidential information): I need help with the following warning when creating a new version of an App in VBCS I am migrati… -
assign oic array to varchar2 field in DBSummary: Hello everyone, help with the following case. I have an integration in OIC that internally invokes a Rest service, this service has a response that contains an … -
OIC Outbound IP - Sufficient & Secure for whitelisting in OCI?Summary: Is OIC Outbound IP sufficient and secure for whitelisting in security rule for access within private subnet? Content (please ensure you mask any confidential in…
-
parameter value is not getting passed to DB adapter in OICgen3Summary: I am invoking an Oracle ATP connection in my integration. I want to fetch IDs from my database table for which I am writing a simple sql query. I have tried thi…Jigyasa Kamthan-Oracle 81 views 2 comments 0 points Most recent by Jigyasa Kamthan-Oracle Integration -
Delete Statement is not Working in Database Adapter In OIC?Summary: We are Tring to Delete Data From Table EX: DELETE FROM table_name Integration is Showing Success but Data is not Deleting From the Table. Content (please ensure…
-
How to insert data in different REST response level to one ATP table in OIC?Hi All, As the following screenshot, I'd like to insert data the REST response data to a ATP table. For this example, the response payload with one parent level 'item' a…
-
Is there a way to change the schema name in OIC integration DB activitySummary: When we want to use a DB activity in Oracle Integration, we need to choose a schema name and a db object. This process would cause a problem when the production…
-
ATP got ORA-00001 when insert sequence in the primary keyHi All, I tried to use sequence to insert data in my table's primary key: I set the increment to 50 after read this document:https://docs.oracle.com/en/cloud/paas/integr…
-
Retrieve Database Sequence Next value in VBCSSummary: Hi experts, How to get the sequence.nextval in VBCS and display it in user interface where sequence has been stored in ATP DB. Use case: When multiple users acc…
-
ATP Adapter or ORDS REST Services: What’s the Optimal Solution for Integrating with OIC?Summary: We are in the process of integrating the Oracle ATP database with OIC to facilitate certain business logics. With the anticipated large data volumes, we are try…
-
Gen3: vbcs --> atp service connection failing with 403 ACL issue.Hi, Below is the error we are seeing while accessing ATP ORDS service from VBCS gen3 instance. This was working fine in VBCS Gen2. "type": "abcs://proxy_problem/oauth/au…
-
bulk uploadSummary: How can we bulk upload data from an excel. Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
After 24.10 update, BOs don't honour the default sort order of the underlying DB View/TableSummary: We have noticed that after 24.10 update, Business Objects don't honour the default sort order of the underlying DB View/Table Has anyone else noticed this latel…