Oracle Analytics Publisher

Call Function GET_ABSENCE_DAYS_PER_TYPE IN BIP

Accepted answer
13
Views
1
Comments

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

  • Sumanth V -Oracle
    Sumanth V -Oracle ✭✭✭✭✭
    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)."