how to Linking Expense and Advance (Financials Query Report Development)

Kauan_Bohn

Hi Oracle Community,

I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense and an advance recorded in Oracle Cloud, but I’m unable to find a foreign key (FK) to establish this relationship in my query.

JohnW-Oracle

Hello @Kauan_Bohn,

Thank you for the question. This is likely possible in FDI Subject Areas without having to search for a Foreign Key but it seems like your question was not intended for the warehouse side. You may want to pose this question here: https://community.oracle.com/products/oracleanalytics/categories/otbi

Regards,

John

Kauan_Bohn

Thank you John!