Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 52 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Call Function GET_ABSENCE_DAYS_PER_TYPE IN BIP
I try this
SELECT *
FROM
TABLE(GET_ABSENCE_DAYS_PER_TYPE(
'Disfrute de Vacaciones'
,to_char(:p_start_date, 'DD/MM/YYYY')
,to_char(:p_start_date, 'DD/MM/YYYY')
)) AVL
but send me the next error
ORA-00904: "GET_ABSENCE_DAYS_PER_TYPE": identificador no válido
Best Answer
-
@User_II5TP - Please confirm which Oracle product you are using. Based on the function 'GET_ABSENCE_DAYS_PER_TYPE' being used, it seems you are working with Fusion Applications. Kindly confirm so that we can move this thread to the appropriate community for better answers and directions.
Additionally, I came across the following document during my research, which may help you achieve your requirement:
Fusion Absence Management: How to Use Function GET_ABSENCE_DAYS_PER_TYPE in Fast Formula (Doc ID 2323608.1)."0