VO for ASE tables

User_32E4S

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

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