Oracle Communities

Oracle Analytics and AI

Child Item

Bring back the SYSTEM - LAST QUERY functionality from EBS allowing to get the SQL query used to disp

Description

Hello, in EBS the functionality to search for SYSTEM - LAST Query on any result field to get the SQL query used to display those results including the filter applied would be useful to accelerate Custom BIPublisher report or other adhoc SQL requirement easier.

Use Case and Business Need

This would be useful to accelerate Custom BIPublisher report or other adhoc SQL requirement easier in case of more custom object linking several modules

Original Idea Number: 9e29f01d80

Find more posts tagged with

Submitted

Cross Pillar

Extensibility

FDI Front End

ERP Analytics Content

Status: Submitted

Comments

A.JOSH

I was looking for a similar solution and came across this. Some options presented in this could help to some extent.

https://community.oracle.com/mosc/discussion/3976271/system-last-query-option-in-oracle-erp-cloud

Thanks,

y2000

This should get more votes. Oracle are shooting themselves in the foot making Fusion so difficult in so many aspects. EBS life was so much better where we could also access the all_source table to inspect standard pl/sql packages used. Viewing the background logic in pl/sql gave insight in the data models.