Categories
- All Categories
- 143 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
VO for ASE tables

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
Comments
-
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.htmlreview data lineage
https://cloudcustomerconnect.oracle.com/files/caf0decefa/R13_19D_Financials_OTBI_database_mapping_with_ViewObjects.xlsx0 -
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 descIf 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
0