Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Query SQL Data "Create Direct from Database" — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query SQL Data "Create Direct from Database"

Received Response
49
Views
1
Comments
edited Jul 5, 2020 3:26AM in Order Management 1 comment

Summary

Cloud- Query SQL Data "Create Direct from Database" - without limit of 200 Rows

Content

Hi All,

In Cloud R13 there is one way to run SQL Query direct on the database

This Process eliminates the 200 Rows issue and gives different download options like Excel, PDF, Powerpoint, XML etc...
Please follow this Link as updating the image option here is too clumsy 

https://community.oracle.com/docs/DOC-1027192

Connection Pool for Different Modules

HCM_OLTP for HCM, 
CRM_OLTP for CRM BI reports, 
FSCM_OLTP for Finance/ERP related BI Reports
For example:

HCM - "HCM_OLTP"."Connection Pool"
CRM - "CRM_OLTP"."Connection Pool"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!