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

User_2G0X5

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
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?

Sumanth V -Oracle

@User_2G0X5 -

Kindly let us know if you are able to view data when pulling in the Supplier Name and Supplier Number from the Procurement subject areas, or if the same error persists.

User_2G0X5

@Sumanth V -Oracle

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

Sumanth V -Oracle

@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

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