Journey on Peoplesoft

When using a dynamic view as a prompt PeopleSoft passes the search keys through automatically and appends to he view's SQL. It is not entirely clear sometimes exactly how it is appending to the SQL but it attempts to determine where to add the brackets, sometimes unsuccessfully. This is largely unsuccessful when the dynamic view is a union, it attempts to put brackets in, somewhere. The trick is to wrap the entire union/clause as a kind of subselect: SELECT FIELD_A, FIELD_B, FIELD_C FROM ( SELECT A.FIELD_A, A.FIELD_B, B.FIELD_C FROM TABLE_A A, TABLE B B WHERE B.FIELD_A = A.FIELD_A UNION SELECT C.FIELD_A, C.FIELD_B, C.FIELD_C FROM TABLE C WHERE C.FIELD_A = 'X' AND C.OPRID = %OperatorID ) Note the entire statement is wrapped in brackets making it simple for PeopleSoft to append to the SQL

Does Oracle/PeopleSoft Integration Broker have support for JSON (JavaScript Object Notation) message format? In PeopleTools 8.40-8.51, Integration Broker does not provide a way via the framework to provide and consume JSON. In PeopleTools 8.52, the REST architecture makes it easier to support formats such as JSON, but still no framework generator/consumer. Since PeopleTools 8.53 and on (8.54, ...) JSON is produced and consumed via Peoplesoft Documents and is seamlessly used within a REST Service.

What is the Cloud? Technically speaking the cloud is hosted storage and computing services hosted over the internet. There are basically 3 types of cloud:  public, private and hybrid. The Public Cloud, such as provided by Oracle for example, is storage and processing power shared among many customers.  It is elastic, meaning customers can expand or reduce the amount of storage and computing power as needed.  Typically customers subscribe by paying for what they need on a scheduled basis, much as they do with their utilities such as electricity or water.  The private cloud is typically used when a customer wants the power and benefits of the cloud without sharing the resources with other customers.  It is dedicated to just that customer.  Private cloud may be hosted in the customers own data center or at a provider’s facility and May still be managed by the cloud vendor.  The billing cycle may be similar to public cloud but more expensive due to the dedicated nature and