Database
Discussion List
-
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…
-
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 82 views 2 comments 0 points Most recent by Jigyasa Kamthan-Oracle Integration