I want query for below columns, for AR Invoice Integration Exception report using interface Tables.

Question

Columns are

ACCOUNT_CLASS,

Distribution_Account,

description,

Invoice_Number,

Distribution_Amount,

Payment_Term,

Currency,

GL_DATE,

Error_Reason,

Ship_To_customer_Name,

Bill_To_customer_Name,

Bill_To_Site_Name,

Ship_To_Site_Name,

Oracle Division Number

Gianni Ceresa · Answer

Please do not (double or) triple post.

https://community.oracle.com/products/oracleanalytics/discussion/20653/i-want-query-otbi-for-below-columns-ar-invoice-integration-exception-report-using-interface-tables#latest

User_14HUA · Answer

I want Bi report for this,(i need data model for this(query))

Steve F-2 · Answer

Hi @User_14UAH,

It is always helpful to the community, if you describe the product/version you are using.

In your case, this sounds like a question for the OTBI , or perhaps the Fusion Data Intelligence Platform community , not the Oracle BI product community .

Please clarify, so a moderator can attempt to move your post to the proper community.