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

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Oracle Analytics Cloud: CEAL Guidance Office Hours - Americas and Europe
Join us this November for Oracle Analytics Cloud (OAC) Office Hours! We’ll explore recently released Data Visualisation (DV), AI features and take a closer look at the Deep Insights Agent—all in one webinar. Through demonstrations and practical examples, we’ll highlight the latest enhancements and explore how these…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: Optimizing FDI Workbook Performance & Showcase of Performance Tools. Learn best practices and optimization strategies for building performant workbooks in Oracle FDI. We’ll share practical tips and lessons learned to help report authors avoid common pitfalls and design workbooks with performance in…