Oracle Order Management Cloud

on Thursday, July 30, 2015

Oracle Order Management Cloud is an order capture and fulfillment Cloud solution that is tightly integrated with Oracle Global Order Promising Cloud. It is designed to improve order handling across the order-to-cash process. Pre-integration, centrally managed orchestration policies, global availability, and fulfillment monitoring can enable increased customer satisfaction and order profitability.

Key business benefits includes,

Centralized Order Monitoring
Centralized view of orders allows users to search for orders, view statuses, see a summary of exceptions of customer, product, or supplier, and drill into the data to view additional details.

Manage Order Exceptions
Proactively identify orders that may not meet promise dates and take corrective actions and avoid customer dissatisfaction. Prioritize back orders to maximize key fulfillment metrics.

Execute Against Predictable Order Orchestration Policies
Business users can define, implement and maintain their own fulfillment orchestration policies without the need to resort to technical programming tools decreasing systems cost and minimizing IT complexity.

Change Management
Centralized change order logic supports consistent handling of order changes and revisions across all orders reducing order errors and processing costs.

Database as a Service (DaaS) FAQs

on Saturday, July 4, 2015

Can I build and run reports on data in the Schema service?

Yes. This service supports the Interactive Reports feature of Oracle Application Express, providing a powerful and flexible way to view and manipulate data.

Is DBaaS enabled to use Application Express?


Yes, all service levels include Oracle Application Express and Oracle Application Express Listener. You can disable or remove Application Express from your service instance if you wish.

What editions can I use for DB Cloud Service?


For 11g, you can choose, Standard Edition One, Enterprise Edition, and Enterprise Edition High performance.... for 12c, you can choose EE, EE high performance and EE Extreme performance

What is Standard Edition One suitable for?


SE1 delivers ease of use, power, and performance for workgroup, department-level, and Web applications. Oracle Database Standard Edition One includes all the facilities necessary to build business-critical applications. This edition is only available for Oracle Database 11g Release 2.

How do I SFTP files to DBCS VM?


To SFTP into a DBCS VM, you would just use the OS level user (oracle) using winscp or like program on windows or scp/sftp on linux for moving files around DBCS instances and desktop. Any standard SCP/SFTP program will work. You will also need the private key to be able to SFTP/SCP into a DBaaS instance.

Does DBaaS support SQL*Net connections from outside the Oracle Cloud?


Yes. DBaaS supports direct connections from outside the Cloud with SQL*Net.

What port do i access apex on?


By default 8080, you would need to open the firewall for this. You can of course change this port number.

How about cost of the query is performed ?


This depends on what option you choose when launching your instance. For example, Hourly or monthly option, and which Version and Edition you select as your DB instance. More details available here:  https://cloud.oracle.com/database?tabID=1406491812773

With SQL developer, do i need to manually create an SSH tunnel with putty or is it an in-built feature?


SSH tunnel is built-in feature, this blog post discusses the process in detail for the SQL Developer 4.1: https://blogs.oracle.com/dbaas/entry/connecting_to_a_database_cloud