How to use multiple different Oracle subject areas in one report?

Question

I am currently trying to recreate a BI Publisher report that shows Sales and Gross Profit into FDI. We are pulling in fields from SCM-Sales Order, Financials-AR Transactions, SCM-Inventory Transactions, SCM-COGS and Gross Margin that are all currently working in the report. We also need to pull in supplier name and supplier number from one of the Procurement subject areas. However, when we add in either the supplier name or number we get the following error:

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "T7923"."SUPPLY_TRACKING_LINE_SUPPLIER_ID": invalid identifier

at OCI call OCIStmtExecute.

Is there a way for us to join in one of the Procurement subject areas, so we can pull in supplier name and number?

User_2G0X5 · Answer

Does this mean after 23R1 we are unable to pull in supplier name or number?

Sumanth V -Oracle · Answer

@User_2G0X5 - The column name mentioned in the error has been deprecated in the 23R1 version only.

Please let us know which version of FDI you are using and kindly validate with OOTB procurement subject areas for Supplier Name and Supplier Number. Thanks!

User_2G0X5 · Answer

@Sumanth V -Oracle

The error persists when pulling in supplier name and supplier number.