nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

VO for ASE tables

Mawahid

Content

Hi,

are there VO for ASE tables like ASE_USER_LOGIN_INFO to extract data other then using BIP
I would like to do scheduled extract to load into ADW for reporting
what are the options
please suggest

Find more posts tagged with

OTBI

BI Cloud Connector

Comments

Nathan CCC

Hi,

for each cloud you can read the manual to track if a view object is used by the metadata repository database (RPD)

for financials clound
https://docs.oracle.com/en/cloud/saas/financials/20a/analyze-and-report.html

review data lineage
https://cloudcustomerconnect.oracle.com/files/caf0decefa/R13_19D_Financials_OTBI_database_mapping_with_ViewObjects.xlsx

Robert Fighiroae-Oracle

Hi Mawahid,

Currently, there is no VO for ASE tables. You can use below query to extract data via BI Publisher:

SELECT
per_details.GUID,
per_details.LAST_LOGIN_DATE LAST_LOGIN_DATE,
per_details.DAYS_SINCE_LAST_LOGIN,
per_details.USERNAME,
per_details.PERSON_ID,
per_details.SUSPENDED,
per_details.active_flag
from (SELECT distinct aul.USER_GUID GUID,
aul.LAST_LOGIN_DATE LAST_LOGIN_DATE,
trunc(SYSDATE)-trunc(LAST_LOGIN_DATE) AS DAYS_SINCE_LAST_LOGIN,
UserPEO.USERNAME,
UserPEO.PERSON_ID,
UserPEO.ACTIVE_FLAG,
UserPEO.SUSPENDED
FROM
ASE_USER_LOGIN_INFO aul,
PER_USERS UserPEO
WHERE
aul.USER_GUID = UserPEO.USER_GUID(+)
) per_details
ORDER BY DAYS_SINCE_LAST_LOGIN desc

If you require to have this data mapped to a VO or to a Subject Area then please raise an Idea on the BI page:

https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary

Best regards,

Robert

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: FDI Security & Deep Dive into GL Segment Security. We are revisiting FDI Security - a top topic requested by our Office Hours attendees. We will begin with an overview of key security concepts and how security is managed in FDI. We will then dive deeper into GL Segment Security across Fusion and FDI…
OCI Enterprise AI - Product Roadmap Update October 2026
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…