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

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Oracle AI Data Platform Hackathon at Oracle AI World 2026
Oracle AI Data Platform Hackathon at Oracle AI World 2026 Sunday, October 25, 2026 12:00–5:00 p.m. PT Request your spot at the AI Data Platform Hackathon Join us in person for the Oracle AI Data Platform Hackathon on Sunday, October 25, from 12:00–5:00 p.m. PT in Las Vegas at Oracle AI World. Lunch will be provided.…
Oracle AI Data Platform Customer Advisory Council at AI World 2026
Oracle AI Data Platform team will host an in-person Customer Advisory Council for AIDP customers attending Oracle AI World 2026 on October 26, from 1–3 PM PT. Join Oracle AI Data Platform executive leaders and selected customers for interactive discussions on our product roadmap, priorities, and future direction. Share…