• Digvijay Chauhan
    Accessing Integration User Name in OrchestartionAnswered95.0
    Topic posted October 3, 2019 by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Database, Integration in Integration > Integration public
    Accessing Integration User Name in Orchestartion
    Logged in user infromation


    Use Case: In ad-hoc run of scheduled integration I am populating a Database table and I also want to populate the username who have submitted the integration. Is there a way we can fetch the user details with integration orchestration to be passed to DB procedure?



  • Subayyal Mustafvi
    API Specifications for scheduled integration1
    Topic posted January 3, 2019 by Subayyal Mustafvi, tagged Adapters, API, Cloud, Database, Integration, REST in Integration > Integration public
    API Specifications for scheduled integration
    How to create API Specifications for scheduled integration?

    So I understand how to create API specifications for integrations that start with a REST adapter. I want to create an API specification for a scheduled integration that fetches data from EBS and updates OCC. This integration is triggered every 30 mins.

    Is there a way to create an API Specification for such integration?


  • John Klinke
    August Release Update for Oracle Cloud Platform5.0
    Announcement posted August 23, 2018 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, Autonomous Data Warehouse, Autonomous NoSQL Database, Big Data, CASB, Content and Experience, Data Integration, Database, Database Backup, Developer, Exadata, Express and Schema, Identity, Integration, Internet of Things, Java, Management, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    August Release Update for Oracle Cloud Platform

    We are pleased to announce new updates and enhancements to our comprehensive portfolio of PaaS solutions. A summary of Oracle Cloud Platform release updates for August 2018 are listed below. See Oracle Cloud Platform Documentation for more details.


    Autonomous Integration Cloud

    New Common Features

    • Common logging configuration for Oracle Autonomous Integration Cloud
    • New learning path showcasing the Integrations and Visual Builder features in a Weather API example: Tutorial
    • New security, authentication, & authorization for Oracle Autonomous Integration Cloud REST APIs using OAuth
    • Support for Oracle Integration Cloud Service to Oracle Autonomous Integration Cloud export and import

    - New Integrations Features

    • Enqueueing of messages in the outbound (invoke) direction is now supported
    • Support for consuming external REST APIs that are protected using transport level security (one-way and two-way SSL)
    • Performing a SELECT operation against database tables is supported
    • You can now display integrations in pseudo style format
    • Inline menu for adding actions available for Orchestrated integrations
    • Support for creating schemas from XML, JSON, and ZIP file formats in stage file actions of orchestrated integrations
    • You can now add placeholder notes similar to sticky notes to an orchestrated integration
    • Detection of incomplete functions is available while Integration activation

    - New Processes Features

    • Now you can call a dynamic process from a structured process
    • You can now open decision tables and relations in an expanded dialog for easy editing
    • REST API options were updated, see Oracle Autonomous Integration Cloud REST API
    • Now you can quickly view and access your tasks in a streamlined list right from the Home page
    • This release includes several enhancements for web forms
    • Enhancements to sync up process model decision business objects with their decision model after making changes
    • Now you can easily edit your decision models from within your process application
    • Default values have been set to enable developers to more quickly create and activate a dynamic process
    • Dynamic Process inline validation is supported
    • You can now permanently retain role mappings for application activations
    • New personalization options available to users of your QuickStart Apps

    - New Visual Builder Features

    • Redesign to user interface and application architecture for building visual applications
    • The Visual Builder generated applications now use Oracle JET 5.1 libraries and components
    • Improvements in Page Designer, Page Structure view, Property Inspector and Quick Starts for visual applications
    • Improvements were made to the Business Rules editor and for integrating visual applications with Processes
    • Improvements in Variables and Types editors, Audits window for visual applications and support for translations
    • You can now upload individual files from the Artifact Browser and create folders using the import dialog box
    • The process for importing and exporting visual application archives and resources are now the same
    • Reorganized logical view of web and mobile applications in Artifact Browser will simplify locating and creating artifacts
    • In visual applications, Settings dialog box shows the URL of Services Catalog and authentication used to access catalog
    • Support for application templates available in the Component Exchange associated with your instance
    • Service administrators can now set the location of a Component Exchange instance in the Tenant Settings

    CASB Cloud

    • Filter settings on key Oracle CASB CS pages are now automatically retained, both within a session and between sessions
    • Enhanced support for Oracle Cloud Interface (OCI) security controls and policy alerts
    • You can now create policy alerts for many Oracle ERP Cloud business objects
    • Complete control over the text displayed in the SUMMARY column for policy alerts. See link

    Content and Experience Cloud

    • Repository admins can now create multiple repositories, each having their own policies for publishing and translation
    • Repository administrators can migrate their existing asset repositories to the new repository model
    • Two new user roles – Repository Administrator and Developer – have been added, roles documentation is improved
    • Navigation options have been simplified, you see page based on your role and your service type (standard or enterprise)
    • These features are now incorporated into other menu structures for People, Groups, Collections, and Content Items
    • Content administrators can set translation policies which can be used to add multiple languages for content items
    • There is now an Oracle JET (JavaScript Extension Toolkit) template that can be used to create a site
    • Several enhancements have been made for users who are creating sites
    • Enhancements have been made for creating sites for a mobile setting
    • Developers can now specify rules to redirect user requests from old URLs to their current ones
    • New webhook to post content publishing notification events from Oracle CEC to an external system
    • You can now filter analytics data by groups. See Viewing General Statistics and Viewing Usage Patterns
    • The documentation has been modified to better serve the needs of specific audiences
    • The REST API for Content Management has been renamed to the REST API for Documents
    • Content Delivery SDK for CEC - a lightweight JavaScript wrapper that interacts with the Content Delivery REST API

    Database Schema Service

    • All Database Schema Service environments have been upgraded to Oracle Application Express (APEX) version 18.1

    Data Integration Platform Cloud

    • You can now perform these tasks using autonomous Data Integration Platform Cloud: Synchronize Data, ODI Execution, and Replicate Data
    • Based on the operating system selected, you can download agent to connect to multiple source/target systems
    • Use the DIPC console to capture new transactions in your Oracle data sources & deliver to Oracle and Kafka targets
    • You can add data from a variety of sources into Data Integration Platform Cloud's Data Lake
    • The ODI plug-in for agents enables you to perform data integration tasks remotely in an on-premises environment

    Developer Cloud

    • You can now create and manage software development environments for your project
    • You can now define an existing project to be used as a project template for new projects
    • You can now watch wiki pages and receive email notification when they are updated
    • Java SE 10, Packer, Python 2.7 and 3.6 are now available in the build executors
    • A redesigned user interface makes configuring an SCM polling trigger using a Cron expression schedule much easier
    • Now default avatar image shows your name initials if you haven’t created a Gravatar account or uploaded a picture

    Event Hub Cloud

    • Now you can use the Manage Tags menu option to assign or unassign tags, even for instances that already have tags

    Infrastructure Monitoring (part of Oracle Management Cloud)

    • This release introduces monitoring support for Oracle 18c Database (18.1) and Oracle Database Exadata Cloud Machine

    Integration Cloud

    • FTP Adapter - GZIP support allows your customers/partners to upload files to sFTP/FTP servers as GZIP files

    IT Analytics (part of Oracle Management Cloud)

    • You can now use the script to automate the creation of the monitoring database user and to grant the required monitoring privileges to that user

    Java Cloud

    • Now Bring Your Own License capability is enabled by default
    • Now you can clone legacy instances
    • New Oracle applications have been certified on Oracle Java Cloud Service, See link
    • New patch set updates are available: PSU for Oracle WebLogic Server & PSU for Java Development Kit (JDK)

    Java Cloud – SaaS Extension

    • Now there is a new way to set the UseSunHttpHandler property
    • New Related Deployments selection box available in the provisioning wizard

    Log Analytics (part of Oracle Management Cloud)

    • You can now use the SQL fields in the log data to do clustering and effectively reduce the large volume of data into a finite number of clusters to help in analysis

    Process Cloud

    • New Purge Only option in runtime administration can be used to skip archiving analytics data before purging it

    Security Monitoring and Analytics (part of Oracle Management Cloud)

    SOA Cloud

    • Now you can create Oracle SOA Cloud quick start instances using stack templates
    • Now Oracle SOA Cloud Service can be provisioned to use Managed File Transfer

    Visual Builder Cloud

    • Improvements have been made to the Action Chain editor
    • Support for image gallery added, users can select images defined in the application as well as to upload images
    • Improvements were made to help when mapping variables to parameters as well as Variables and Types editor
    • Improvements have been made to the Page Designer, Business Rules editor and translations
    • New Perform Task Action trigger and new Detail Page Quick Start for integrating visual applications with PCS
    • Support for application templates available in the Component Exchange associated with your instance
    • Service administrators can now set the location of a Component Exchange instance in the Tenant Settings

    See Oracle Cloud Platform Documentation for more details.

  • Vidya Sagar Mahankali
    Auto Generate ID3
    Topic posted April 9, 2019 by Vidya Sagar MahankaliGreen Ribbon: 100+ Points, tagged Business Objects, Custom Code, Database, Groovy, REST, Validation in Application Development > Visual Builder public
    Auto Generate ID
    Need to auto generate a number to use in the application


    We are developing a page where a field needs to be an auto generated ID. I want the auto generation to happen when the page is saved. 

    Initially, when the user enters the page, the ID field will be blank, and a new ID should be generated only at the time of Save. 

    The auto generated ID should be the max ID currently used + 1.



    Version: 18.4.5
  • Mohammed Baig
    Best approach to expose custom database...Answered4
    Topic posted October 31, 2019 by Mohammed Baig, tagged Custom Code, Database, REST, Tip in Application Development > Visual Builder public
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS
    Best approach to expose custom database objects/functionality as Rest service, to consume in VBCS


    We need your help in identifying the best option to expose the custom database objects or custom functionality as a Rest service which can be consumed in VBCS application.

    1. ADF BC Rest - We don't have JCS at moment but if its best option we can get back to customer.
    2. OIC Integrations as Rest - Already subscribed along with VBCS
    3. ORDS - We have custom database of size 15gb 

    FYI, we have already developed an application which is in production now, where we used Oracle JET and ADB BC combination for another customer.

    For this new customer, we have adapted the VBCS and looking for best option to expose Rest services for custom db objects/functionality. 

    Appreciate your response with cons and pros for each of the above approaches Or any other approach apart from the above three. We don't have any skill set limitations.

    Thank you

  • Moon Ray Lo
    Best Practice for OIC to Cloud DB: DB Adapter or RESTful...
    Topic posted July 12, 2019 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Cloud, Connection, Database, Integration, Orchestration, PaaS, REST, Web Services in Integration > Integration public
    Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?
    Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)



    I'd like to hear your inputs as to which approach is better in terms of efficiency, performance and maintenance when connecting to Oracle DB Cloud items (ex: table) from Integration Cloud - DB Adapter Operations or RESTful Services (ORDS)?



    Thanks ahead,


    Version: (190323.0400.26650)
  • Ziv Rubin
    BO Relationships1
    Topic posted May 27, 2019 by Ziv RubinBronze Medal: 1,250+ Points, tagged Business Objects, Database, Groovy, REST in Application Development > Visual Builder public
    BO Relationships
    How to aggregate one BO by two primary keys to another BO?

    Hi All,

    I came across the BOs relationship functionality and I wonder how to create a relationship between two BOs while the second gets updated by aggregated data from the first BO fields? Similarly to updating one table by another using a primary key in SQL.



  • Julian Green
    BO Transaction2
    Topic posted April 8, 2019 by Julian Green, tagged Business Objects, Custom Code, Database, REST in Application Development > Visual Builder public
    BO Transaction

    i updating complex list.. But i want start transaction. if it failure i want rollback or commit. Should I use ORDS or BO?

    ords difficult to use. Table may change over time. For example ;

    INSERT INTO forums_nested_json_table
    (device, TIME, data, signal, seqnumber, lat, lng, radius, source, status)
    SELECT *
        json_table(:body_text, '$'
                "device" VARCHAR2(10)PATH '$.device',
                "time" NUMBER PATH '$.time',
                "data" VARCHAR2(15)PATH '$.data',
                "signal" VARCHAR2(10)PATH '$.signal',
                "seqnumber" NUMBER PATH '$.seqnumber',
                nested PATH '$.location[*]'
                        LAT NUMBER PATH '$.lat',
                        LNG NUMBER PATH '$.lng',
                        RADIUS NUMBER PATH '$.radius',
                        SOURCE NUMBER PATH '$.source',
                        STATUS NUMBER PATH '$.status'
      :status := 201;

    And BO batch or object function?  What is the correct approach?

    I'm confused.. frown

  • Cesar Tepetla Corte
    Break the contents of an OIC variable in lines to insert it...1
    Topic posted April 5, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Cloud, Connection, Database, Events, Integration, Mapping, Orchestration, Process in Integration > Integration public
    Break the contents of an OIC variable in lines to insert it into a database
    Break the contents of an OIC variable in lines to insert it into a database

    Hi everyone,


    I have created a variable in OIC where it stored the contents of a file, for example:
    varoic = "METADATA | Location | SetId | SetCode | ActiveStatus | LocationCode | LocationName | AddressLine1 | Country | PostalCode | EffectiveStartDate
    MERGE | Location | 0 || Active | LocationTest_22032019 | RESTAURANTE_Location22032019 | Jaime Balmes AvenueI Secc, 11550 Miguel Hidalgo, CDMX | MX | 11550 | 1951/01/01

    MERGE | Location | 0 || Active | TLocationTest_23032019 | RESTAURANTE_Location22032019 | Jaime Balmes AvenueI Secc, 11550 Miguel Hidalgo, CDMX | MX | 11550 | 1951/01/01

    when I insert into the database what I'm looking for is to take only the files that start with MERGE, so in theory I should create only two records in the table.

    Which I want comment or help is appreciated.


  • Ziv Rubin
    Browser Crashed While Trying to Load 20K Rows From External...11
    Topic posted August 4, 2019 by Ziv RubinBronze Medal: 1,250+ Points, tagged Business Objects, Database, Groovy, REST, Web in Application Development > Visual Builder public
    Browser Crashed While Trying to Load 20K Rows From External REST API

    Hi All,

    While trying to load data from a rest API to a Business Object, it suddenly crashes - probably because I was trying to load 20K rows.

    Does anyone know a better way to load data from external REST API to my VBCS BO?