• 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
  • 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 RubinBlue Ribbon: 750+ 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 RubinBlue Ribbon: 750+ 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?



  • Ranveer Tiwari
    Calling SQLLDR from SOA Composite ?2.0
    Topic posted March 18, 2019 by Ranveer TiwariRed Ribbon: 250+ Points, tagged Database, Integration, Orchestration in Integration > Integration public
    Calling SQLLDR from SOA Composite ?
    Calling SQLLDR from SOA Composite ?

    Please can somewhere share us the way to invoke SQLLDR from SOA Composite, the idea is to load file into stage table using sqlldr as SOA Composite?

  • José Alves
    Can a JCS-SX application connect to multiple databases...15.0
    Topic posted January 12, 2018 by José Alves, tagged Cloud, Database, PaaS in Application Development > Java public
    Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?
    Can a JCS-SX application connect to multiple databases (and perform select/insert/ etc)?

    Hello all

    It seems that JCS-SX is bound to one database schema in a multi-tenant database.

    Question is, can a JCS-SX application connect to another schema in another database in the oracle cloud or is it restricted to use only that specific database schema?

    The reason for this question is that we need to use JCS-SX and a database with several schemas and no pl/sql restrictions in terms of low level networking and file system access.