Unable to find "Department" column in fusion SCM tables

Pooja_123

Hi Team,

I am looking for Department column which was populated with DFF. The list of value for this column would be like below. The column is created from font end application with label as "PSSR for".

Department Column Step by Step Doc.docx

Department Column.docx

Environment - Other
Environmental - New Tank
Environmental - Piping
Environmental - Tank Upgrades
Food Service - Other
Maintenance - Propane
Maintenance - Air Machines
Maintenance - Asphalt
Maintenance - Canopy
Maintenance - Car Wash
Maintenance - Dispenser Replacement
Maintenance - HVAC
Maintenance - LED

Mallikarjuna Kuppauru-Oracle

Hi @Pooja_123

This is an question to Fusion team. Let me include the FDI Moderator team to review the above.

@Balakarthik Santhana Venugopal-Oracle Any input/comments on this?

Regards,

Arjun

Pooja_123

Hi @Balakarthik Santhana Venugopal-Oracle  any update from your end

Pooja_123

I am looking for table name which contain this department column with above value.

Pooja_123

Hi,

Waiting for your response team. Expert kindly suggest the solution

Gianni Ceresa

@Pooja_123 , are you using Fusion Data Intelligence? Or you are building Publisher report in your Fusion directly?

If you don't have FDI, then you should consider asking in a Fusion forum because your question is about Fusion data, not a technical question on how to use Publisher. The Fusion forum is at https://community.oracle.com/customerconnect (it's a separate forum space, content can't be moved there and that's why you will need to look at the best matching category and ask there if needed).

If you are using FDI, would it be a question for Fusion ERP Analytics, Fusion SCM Analytics, Fusion HCM Analytics or Fusion CX Analytics? Your question could be moved in one of these 4 category to get you a better audience.

Pooja_123

@Gianni Ceresa , I am using BIP Publisher reporting tool. Here Functional team gave me requirement that you need to bring Department column in the report. So they showed me the column value in front end application(Oracle Application Cloud). Now they are asking me to bring that column in your BIP report.

In the front end they are using DFF with column label PSSR for and contain values I mentioned above. I searched the same value in almost all fusion table, but unable to get the same value in tables.

Gianni Ceresa

Ok, then you are really into a Fusion data question and that one you better ask it in the forum I linked in my previous reply.

You are going to use Publisher, but your question is just about data, and that can only be answered by Fusion people who are in that other forum.

Go there, look at the categories and post in the best one matching your needs.