10/12/2021 SR Detail

Last Login: October 11, 2021 9:16 PM EET Switch to Cloud Support Shereen (Available) (0) Contact Us Help

Dashboard Knowledge Service Requests Patches & Updates Community

Service Requests > Give Feedback...
Severity 2 SR 3-26897261897 : create report on apex from fusion application
Update Summary

Last Updated 11 days ago Problem Description wei need to create a repo...
Close SR... Re-Open SR...
Severity 2-Significant

History Sort by: Newest on Top Filter by: -- Show All Entries -- Hide System Messages Status Closed
Escalation Status Never Escalated
Oracle Support- 18 days ago [ODM Knowledge Content] Opened 1+ month ago
Last Updated 11 days ago
Knowledge Review completed.
Bug Reference No Related Bugs
Oracle Support- 1+ month ago [ODM Answer] Attachments No Related Attachments
Related Articles View Related Articles
Hi Shereen -
Related SRs No Related SRs
My name is Diego and I will be attending your Service Request (SR).
Support Identifier 23336121
Oracle Fusion encompasses several services, so that depends on what specific service you are using, but as a Customer Reference No Reference Number
Edit
general guideline: Number
Account Name ‫ﺷﺮﻛﺔ ﺗﻮزﻳﻊ و ﺗﺴﻮﻳﻖ اﻟﺴﯿﺎرات‬
1.- If your service uses Oracle REST Data Services (ORDS), and it is REST-Enabled, you can configure in APEX a ‫اﻟﻤﺤﺪودة‬
"REST Data Source" that connects to that server Primary Contact Shereen Sharaf Edit...
and then create a report on APEX based on that "REST Data Source".
Alternate Contact Add Alternate Contact...
This approach is probably the most convenient from an APEX perspective, but it requires that your Oracle Fusion
database uses ORDS. You can tell if is uses ORDS or not System No Related Systems
by looking into your service details. Or if you provide us more details about your service, we can investigate that Host No Related Hosts
for you. Product Oracle Application Express (APEX)
For more information about this approach see: Product Version 21.1.1
Cloud Infrastructure Gen 1 Exadata Cloud at Customer
a) Oracle REST Data Services (ORDS) Product (Oracle Exadata Database Cloud
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/18.2/aelig/installing-REST-data- Machine)
services.html#GUID-4D976DAE-8B24-41E3-81D5-B1C22E33287F Operating System Microsoft Windows (32-bit)
OS Version 10
b) REST-Enabled SQL Service
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/18.2/aelig/rest-enabled-sql-
service.html#GUID-BA9F9457-ED3A-48A4-828A-CC8CBEA9A2AB

c) Creating and using a "REST Data Source" in APEX:

https://docs.oracle.com/en/database/oracle/application-express/21.1/htmdb/managing-REST-data-
sources.html#GUID-93D7A596-03A9-48AF-9FC9-6538BCC25DED

2.- Another option is to create Database Links (DB Links) in the database where your APEX is installed, that point
to the database in Oracle Fusion.
For example, if in your Oracle Fusion database you have a table named EMPLOYEES, you can create a DB Link
that you can query in an APEX report in the following way:

SELECT * FROM EMPLOYEES@<db_link_name>

If you take this approach, be careful when migrating or upgrading your Database or APEX versions, as DB Links
could get misconfigured.

For more information about this approach see:

a) Database Links
https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/distributed-database-
concepts.html#GUID-93B235DD-BF66-444D-9F0F-9D4B2F590C41

b) Managing Database Links

https://oracle-base.com/articles/misc/managing-database-links

c) CREATE DATABASE LINK

https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/CREATE-DATABASE-LINK.html#GUID-
D966642A-B19E-449D-9968-1121AF06D793

If you can provide us more information about what specific Oracle Fusion service are you using, maybe we can
offer additional recommendations.

In case you are not yet aware of the following note, I can mention it as it may enhance your support
experience:
Note 166650.1 Working Effectively With Oracle Support Services

Best regards,

Diego Reyes Calderón (He/Him)

APEX Support Team, Oracle Customer Support
Office Hours:
12:00 to 21:00 CST, Tuesday to Friday
10:00 to 19:00 CST, Saturday

Oracle Support- 1+ month ago [ODM Question]

Copy right (c) 2021, Oracle. A ll rights reserv ed. Legal Notices and Terms of Use Priv acy Statement

https://support.oracle.com/epmos/faces/SrDetail?_adf.ctrl-state=1578au5vzc_4&srDetailRelativeDateParam=null&queryModeName=Technical&srNumber=3-26… 1/1