You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

how to access user-defined tables in BI SQL Query

edited Apr 7, 2020 12:25AM in Reporting and Analytics for HCM 1 comment

Content

hi ,

      We have an element entry called fuel statement. It has an input value called discount. Now I am trying to access a user-defined table value called discount percentage in my query and trying to do a simple multiplication but it is not working. Any ideas how to make it work.

Element entry input value= discount

UDT value=  Discount_percentage=0.9 (90%)

DISCOUNT= DISCOUNT*Discount_percentage

 

SELECT
    (TO_NUMBER(VALUE) * (DISCOUNT)) AS FUEL_DISCOUNT
FROM
    FF_USER_TABLES_TL            TL,
    FF_USER_ROWS_F               RW,
    FF_USER_COLUMNS              CL,
    FF_USER_COLUMN_INSTANCES_F   INS
WHERE
    1 = 1
    AND USER_TABLE_NAME = 'HG_PR_Transaction_Fee_Control_Table'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Feedback strip

Quick feedback, earn a badge!

How would you rate your Customer Connect experience?

Could have been better
It was ok
It was great