Oracle Analytics and AI

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

Find more posts tagged with

Accepted answers

Sumanth V -Oracle

@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)."

All comments

Sumanth V -Oracle