Posts

Posts

  • sriram iyer
    Where NOT EXISTS Query4
    Topic posted October 31, 2018 by sriram iyerRed Ribbon: 250+ Points, tagged Custom Code, Database, REST, UI in Application Development > Visual Builder public
    Title:
    Where NOT EXISTS Query
    Summary:
    Is it possible to perform the equivalent of a Correlated sub-query using REST
    Content:

    Is it possible to write a query like this in VBCS?

    SELECT *

    FROM   TABLE_1  t1

    WHERE NOT EXISTS (

                SELECT NULL FROM TABLE_2 t2

                WHERE t1.p_id = t2.p_id

                      AND t1.create_date < add_months(trunc(sysdate) - 18))

    Version:
    Version: 18.3.3
  • John Klinke
    October Release Update for Oracle Cloud Platform5.0
    Announcement posted October 29, 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
    Title:
    October Release Update for Oracle Cloud Platform
    Abstract:

    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 October 2018 are listed below. See Oracle Cloud Platform Documentation for more details.

    Announcement:

    API Platform Cloud

    • New navigation menu sidebar has been introduced with options to access other pages. See details here

     

    Application Performance Monitoring (part of Oracle Management Cloud)

    • Integration with Oracle Enterprise Manager Control Center allows viewing DB related information application server

     

    Blockchain Cloud

    • REST proxy supports multiple customized Hyperledger Fabric enrollment certificates to invoke and query chaincodes
    • Now REST proxy supports OAuth 2.0 Access token-based authentication and Asynchronous REST API with Events
    • REST APIs were added to programmatically create an instance, manage channels, chaincodes, nodes & organization
    • You can create OABCS production instances to use the Kafka orderer type
    • Now OABCS deletes chaincode containers that are seldom or no longer used
    • The maximum message size that can be received between peers and orderers is 100MB
    • Now a certificateAuthorities (CA) section has been added to the connection profile
    • The Car Dealer sample has been updated to support rich queries

     

    CASB Cloud

    • You can now create custom policies to generate alerts for actions on identity objects
    • A set of 13 specific controls related to password complexity has replaced Single “Password complexity” security control
    • Now SSO application used to login to monitored application instance has been added to user login reports

     

    Configuration and Compliance (part of Oracle Management Cloud)

    • Oracle Database rule-sets will now execute up to 10x faster due to a change in evaluation processing
    • Center for Internet Security Certification has been achieved. See details here

     

    Content and Experience Cloud

    • OCI Storage Cloud Service Support for new Autonomous Content & Experience Cloud instances on OCI is now available
    • General stability improvements have been made to CEC 18.4.1 to enhance product use

     

    Event Hub Cloud

    • Now you can select the multiple availability domains at the time of provisioning to leverage High Availability feature
    • Key store Integration with Credential store - a key value pair repository of credentials used to access external systems
    • Now General Messaging System (GMS) can be used to facilitate asynchronous messaging between various services

     

    GoldenGate Cloud

    • Now you can create an Oracle GoldenGate Cloud instance with the Oracle GoldenGate 12.3 Microservices Architecture

     

    Infrastructure Monitoring (part of Oracle Management Cloud)

    • Now host prerequisite validation has been added during Cloud agent installation

     

    Integration Cloud

    New Common Features

    • Now Oracle Integration Cloud data objects can be exported from a user-managed to an autonomous environment

    New Integration Features

    • Oracle E-Business Suite Adapter now supports open interface tables and views as invokes (targets) in integrations

    New Process Features

    • Now use an automated tool to move process applications from PCS or another OIC instance to Oracle Integration Cloud
    • Forms editor can assign names to events, labels on repeatable sections and supports relational operations within events
    • Now you can easily keep integrations in process applications up-to-date. See details here
    • New information on Best Practices for Embedding Process UI Components is available. See details here

    New Visual Builder Features

    • The Visual Builder generated applications now use Oracle JET 5.2 libraries and components
    • Additional release information has been listed under the Visual Builder service update section below

     

    Log Analytics (part of Oracle Management Cloud)

    • You can now create custom fields and associate them with your parse expressions while creating a parser

     

    Security Monitoring and Analytics (part of Oracle Management Cloud)

    • New feature added to analyze SSH failed logins by viewing data of three main element using zones

     

    Visual Builder Cloud

    • Improvements have been made to Page Designer, Quick Starts, Action Chain editor, Artifact Browser & Security settings
    • Now improved support has been introduced for variables and types, business objects and connecting to services
    • Changes have been made to the configuration for mobile app build setting
    • Custom permission strings can be provided to replace the strings provided by VBCS for the mobile apps it builds for iOS
    • Web & mobile application templates have been updated to use oj-messages for modern UI & additional display options
    • In the Property Inspector you can now choose the resource bundle to use for storing a translation string
    • Git Tags are no longer used for keeping track of application sources. Commit SHAs are now used instead of tags

     

    See Oracle Cloud Platform Documentation for more details.

  • John Klinke
    New Idea Labs for Oracle Big Data and Oracle Integration...5.0
    Announcement posted October 25, 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
    Title:
    New Idea Labs for Oracle Big Data and Oracle Integration Cloud
    Abstract:

    We are pleased to announce Idea Labs on Cloud Customer Connect for Oracle Big Data and Oracle Integration Cloud. These Idea Labs let you submit, share and vote on enhancement ideas for these two Oracle Cloud Platform solutions.

    Announcement:

    Idea Labs are a great way for you to get your voice heard on how to improve and enhance Oracle solutions. Product management teams will monitor and review all ideas posted by the community and provide guidance on product roadmap plans.

  • Vinod Kumar Kv
    How to do a batch request for parent and child (Both...2
    Topic posted October 24, 2018 by Vinod Kumar KvBronze Medal: 1,250+ Points, tagged Custom Code, Database in Application Development > Visual Builder public
    Title:
    How to do a batch request for parent and child (Both parent and child - NEW)
    Summary:
    How to do a batch request for parent and child (Both parent and child - NEW)
    Content:

    How to do a batch request for parent and child (Both parent and child - NEW)

    Below is batch request JSON for inserting multiple records in single table. Like this what will be the JSON for PARENT-CHILD batch insert.

    SAMPLE BATCH INSERT JSON into single table:

    var batchCreate={
        "parts": [{
              "id": "part1",
              "path": "/Test",
              "operation": "create",
              "payload": {
                "id":"",
                "name":"Nishant",
                "title":"Manager"
              }
            }, {
              "id": "part2",
              "path": "/Test",
              "operation": "create",
              "payload": {
                "id":"",
                "name":"Veda",
                "title":"Director"
              }
            }]
        };

     

  • Ronen Wolf
    Updating the VBCS internal database through APIs?Answered22.0
    Topic posted October 22, 2018 by Ronen Wolf, tagged Business Objects, Database, REST in Application Development > Visual Builder public
    Title:
    Updating the VBCS internal database through APIs?
    Content:

    Hi

    As part of an integration project with OIC I am looking for way to create a custom monitoring application which would be more user friendly than the built-in one. I thought it would be nice to use VBCS for this purpose.

    Can the VBCS objects be updated through some REST APIs?

    Thanks
    Ronen

  • John Klinke
    September Release Update for Oracle Cloud Platform5.0
    Announcement posted September 27, 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
    Title:
    September Release Update for Oracle Cloud Platform
    Abstract:

    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 September 2018 are listed below. See Oracle Cloud Platform Documentation for more details.

    Announcement:

    API Platform Cloud

    • You can now use actions from the specification in the Interface Filtering and Method Mapping policies if your API was created with an Apiary specification

     

    Application Performance Monitoring (part of Oracle Management Cloud)

    • Now you can monitor the performance of hybrid mobile applications
    • You can now customize the errors displayed by APM and mark certain pre-defined errors as acceptable events
    • Now you can define locations for synthetic monitoring using Firefox 45 as well as Firefox 61 and above
       

    Autonomous Analytics Cloud

    Service Management Updates

    • There are now fewer setup steps and your service is ready to use in about 20 minutes. See Creating Services
    • In the Console, all administrator-only options are now under a Service Administration menu for BI and DV services only

    Essbase Updates

    • The Essbase web interface is enhanced with a new look and improved usability
    • In the Files catalog, you can find gallery templates to build fully functional Essbase cubes
    • You can define connections and data sources once and reuse them in various operations
    • Now you can use the enhanced rules editor to preview data, use connections and data sources and define rules
    • You can now create Efficient Dynamic Security Filters on your applications
    • In the Essbase web interface and in Smart View, you can execute free-form MDX queries to analyze cube data
    • Use the MaxL Client to securely manage Essbase cubes and artifacts using a language-based interface
    • Scenario management calculation enhancements have been added
    • Outline formula editor now includes a member tree & a function list to pick members and calculation functions
    • Calculation script editor now includes a member tree & a function list to pick members & calculation functions

    Data Visualization Updates

    • Now you can use data transformation and enrichment recommendations to prepare your data before visualizing it
    • Now you can create Grid Heatmap, Picto, 100% Stacked Bar, Horizontal 100%, 100% Area & Correlation Matrix
    • Enhancements have been added to Map layers, Backgrounds and Data flow
    • Now Auto Save option automatically saves updates to a visualization project without repeatedly clicking on “Save”
    • Now you can use keyboard shortcuts to open artifacts in a new tab or window
    • Inspectors can view & edit properties of standalone objects in Home, Data, Projects, and other top-level pages
    • Data replication enhancements have been added
    • Now you can replace a data set by re-mapping columns used in a project to columns from a different data set
    • Now you can use subject areas as data sources in data sets and data flows
    • Now enable users to search Data Sets using BI Ask
    • Now you can make visualizations more interactive with tooltips
    • Now you can include data actions in embedded visualizations

    Pixel-Perfect Reporting Updates

    • Now you can upload configuration specific files
    • You can now Configure password protection for report outputs in DOCX, PPTX, and XLSX format
    • Now you can apply a digital signature in PDF documents
    • You can use data sets from Data Visualization for pixel-prefect reports
    • Scalability is enabled in an Excel template to overcome the Microsoft Excel limitation of 65000 rows per sheet
    • Now you can validate data model properties and optimize the SQL queries
    • Now you can Optimize SQL queries. See Setting Data Model Properties
    • The output can be compressed prior to delivery to reduce the output size
    • Now you can configure to receive email notifications when emails are delivered or read

    Data Models Update

    • Now you can define database connections in Console and use them in Oracle Analytics Cloud Developer Client Tool
       

    Autonomous Content and Experience Cloud

    • You can now use alternate sizing for many components, such as galleries or images
    • The sidebar navigation menu has changed when editing a site
    • Developers can now create customized themes that use a specific subset of components
       

    Autonomous Data Warehouse

    • Idle sessions that do not hold resources required by other sessions will not be terminated after 60 minutes now
       

    Autonomous Integration Cloud

    New Integrations Features

    • The Oracle RightNow Adapter has been renamed to the Oracle Service Cloud (RightNow) Adapter
    • New adapter added: Oracle Policy Automation Adapter. See Oracle Policy Automation Adapter Capabilities
    • New adapter added: Oracle Talent Cloud for Midsize (Taleo BE) Adapter. See Adapter Capabilities
    • Table operation enhancements have been made for Microsoft SQL Server & Oracle Database Cloud Service Adapters

    New Processes Features

    • New Service activity is available in dynamic processes to invoke an external service from a dynamic process
    • New Train control in forms to sequentially guide users through a multi-step web form activity
    • The new Print action lets you print a presentation of a form when an event occurs
    • You can now monitor form logs and test your form with custom payload data
    • New process runtime enhancements have been added
       

    Big Data Cloud

    • The system software is updated to release 4.11.7. This includes Cloudera Distribution with Hadoop (CDH) 5.12
    • You can now use variables when specifying paths in Oracle Big Data Manager
       

    CASB Cloud

    • Two new security controls have been added for Oracle Cloud Infrastructure (OCI)
    • Compartment monitoring options are now supported with OCI
    • Data Protection now supports a set of General Data Protection Regulation (GDPR) data matchers to use in defining rules
    • A list of resources monitored by application type is now available. See Objects Monitored by Application Type
    • Raw JSON code is now formatted for better readability when it’s displayed in the log data details
       

    Infrastructure Monitoring (part of Oracle Management Cloud)

    Internet of Things Cloud

    Java Cloud

    • Now you can assign a private static IP address when restarting an instance on OCI Classic
    • You can now use the REST API to change the Node Manager password for the WebLogic domain of JCS instance after service instance creation
    • If you stop a JCS instance before a scheduled backup occurs, now the backup begins at its next scheduled time after restart
    • Now you can force scale-in operation when restoring a JCS instance
    • You can now scale the Oracle Traffic Director (OTD) load balancer nodes up or down
    • While creating a JCS instance, you can now select whether you want to create a public or private load balancer
    • If your account has both Bring Your Own License (BYOL) and JCS entitlements, you can now change the license type for an existing instance
    • Changes have been made to Database menu selection and tile on the My Services Dashboard, and the Platform Services menu has been removed

    Log Analytics (part of Oracle Management Cloud)

    • Now link SQL Statement can be used to group SQLs and analyze their behavior and identify anomalies
    • Now you can parse log records with multiple timestamps
    • To obtain the standard deviation of the set of values of a numeric field, you can now use the new stddev() function
       

    Security Monitoring and Analytics (part of Oracle Management Cloud)

    SOA Cloud

    • Now you can choose to validate the database service when scaling up your Oracle SOA Cloud Service instance

     

    See Oracle Cloud Platform Documentation for more details.

  • Moon Ray Lo
    Runtime Fault/Exception Handling in OIC (Oracle SOA...3
    Topic posted September 17, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Cloud, Connection, Database, Integration, Mapping, PaaS, REST, SOAP, Web Services in Integration > Integration public
    Title:
    Runtime Fault/Exception Handling in OIC (Oracle SOA Fault Policy Functionality?)
    Summary:
    Is Oracle SOA Fault Policy Functionality also present in OIC? Especially handling runtime fault on server side
    Content:

    Hello OIC Gurus, 

    Oracle SOA has this Fault Policy Functionality, controlling actions as faults arise, especially recoverable errors (re-try instances). May I know if this feature is also available in OIC? (both user-managed and autonomous OIC). If none, I know leveraging the OIC REST API (retrieve and resubmit error instances) is a feasible option, but do we have another workaround at the moment to attain this functionality? (like raising Cloud Support request for fault-policy configuration?)

    Appreciate all your inputs on this.


    Thanks,
    Moon

  • Gokul Muruganantham
    Can we Poll a table by considering more than one column flag...3
    Topic posted September 12, 2018 by Gokul MurugananthamGreen Ribbon: 100+ Points, tagged Adapters, Database in Integration > Integration public
    Title:
    Can we Poll a table by considering more than one column flag using DB Adapter
    Summary:
    I want to poll a table by checking two column flag values. Is that possible in ICS?
    Version:
    18.3.3.0.0
  • Manash Chowdhury
    Issue Activating ICS Integration - DB Adpater Issue75.0
    Topic posted September 3, 2018 by Manash ChowdhuryRed Ribbon: 250+ Points, tagged Adapters, Agent, Database, Integration, PaaS in Integration > Integration public
    Title:
    Issue Activating ICS Integration - DB Adpater Issue
    Summary:
    Facing Issue while Activating ICS Integration with DB adapter configured.
    Content:

    We are now facing issue in activating and ICS integration with DB adapter. I'll list the steps and the output for better understanding:

    1. Installed a connectivity agent in ICS db server as we will connect to user defined tables in ICS. Below is the output that the agent is running fine:

    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ pwd
    /home/oracle/devDBCS_agent/oic_connectivity_agent
    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ ls
    agenthome  connectivityagent.jar  InstallerProfile.cfg  oic_connectivity_agent.zip  pid
    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ java -jar connectivityagent.jar &
    [1] 26966
    [oracle@DevICSDb-Multichoice oic_connectivity_agent]$ Existing Agent installation found... Starting Agent for message processing.
    Checking for already running instances of this agent. This might take up to 15 seconds ...
    Initializing the credential store ...
    Agent started successfully...Now available for new messages...

    Step 2: Created a db connection with required details and test was successful.

    Step 3. Created an integration with a SOAP and DB adapter. While conencting the db adpater, the SQL query provided was succesful too.

    Step 4. Create the required mapping and tried to activate the integration and got the following error:

    [SEVERE] [ThreadID: 1780] [Logger: oracle.cloud.cpi.agent.ActivationCpiCommand] [SRC Class: oracle.cloud.cpi.agent.ActivationCpiCommand; Method: doRequest] Error in performing activation. java.lang.ArrayIndexOutOfBoundsException: 1
            at oracle.cloud.cpi.agent.store.FileAgentStore.getArtifactsRoot(FileAgentStore.java:97)
            at oracle.cloud.cpi.agent.store.FileAgentStore.addActivation(FileAgentStore.java:28)
            at oracle.cloud.cpi.agent.ActivationCpiCommand.doRequest(ActivationCpiCommand.java:80)
            at oracle.cloud.cpi.agent.ActivationCpiCommand.execute(ActivationCpiCommand.java:54)
            at oracle.cloud.cpi.agent.CpiAgentImpl.execute(CpiAgentImpl.java:40)
            at oracle.cloud.cpi.agent.framework.CpiCommandBus.execute(CpiCommandBus.java:29)
            at oracle.cloud.cpi.agent.framework.CpiCommandBus.receive(CpiCommandBus.java:24)
            at oracle.cloud.cpi.agent.transport.DistributedCpiCommandExecutorOmcs.received(DistributedCpiCommandExecutorOmcs.java:112)
            at oracle.cloud.cpi.agent.transport.AQConsumer$AdapterCommandTask.call(AQConsumer.java:289)
            at oracle.cloud.cpi.agent.transport.AQConsumer$AdapterCommandTask.call(AQConsumer.java:277)
            at java.util.concurrent.FutureTask.run(FutureTask.java:266)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
            at java.lang.Thread.run(Thread.java:745)

    Not sure what's going wrong. Please suggest. We'll try to delete and recreate the agent as the last approach.

  • Manash Chowdhury
    Retrieve SOA-MDS password15.0
    Topic posted August 28, 2018 by Manash ChowdhuryRed Ribbon: 250+ Points, tagged Database, Integration, PaaS, SOACS in Integration > Integration public
    Title:
    Retrieve SOA-MDS password
    Summary:
    How to retrieve the SOA-MDS password and configure the db based MDS connection from jdeveloper
    Content:

    We created a SOA instance and corresponding database instance too. All components were successfully created (db, managed server, WLS etc.). However now during our development we want to configure the db based SOA-MDS in our jdeveloper. We are able to connect to the database using the SSH and "SYSTEM" username. However this connection fails to retrieve the partition details. When checked in weblogic console, the soa-mds connection user seems to be "SP1533128107_MDS". This user I guess was internally created. How do I get the password for this? Is there any option to change the password from the weblogic console? Please assist.