Finding resource

Hi Ed,

from MS I would script.

select distinct TABLE_NAME
from
openquery (IFS,
'
SELECT *
FROM
ALL_TAB_COLUMNS
WHERE COLUMN_NAME like ''CF$%''
')
ORDER BY TABLE_NAME

ORACLE version: (leave the openquery “box”)
SELECT *
FROM
ALL_TAB_COLUMNS
WHERE COLUMN_NAME like 'CF$%'
ORDER BY TABLE_NAME

Then use the table/view - name to look up the presentation object.
 

Please give me feedback if this “way” will help.

BR

Michael

Hi Ed,

did a quick test:
You can combine that:
 

The script took around 30 seconds in result in around 2500 records.
Because a CF$ field can be used in different “objects” (tables and views) I would not search for all of them but exactly for a given CF$_xyz Field.
HTH
Michael

Sorry, I dont understand it, in oracle how can I find out what is the source from which draws some column? It doesnt have to be just CF, but any column in general. Exist some general Oracle SQL query to find source?

Hi Ed,

than just the

SELECT *
FROM
ALL_TAB_COLUMNS
WHERE COLUMN_NAME like 'CF$%'
ORDER BY TABLE_NAME

That will you the tablename and other information of all tables containing a spefic column name.

If is a spefic column name just
SELECT *
FROM
ALL_TAB_COLUMNS
WHERE COLUMN_NAME = ‘ORDER_NO’
ORDER BY TABLE_NAME

will give you all tables with a ORDER_NO in it.

HTH
Michael

When I start this query in Oracle SQL, it will return tables/view in which this column appears, but how can I find out if this is names of modules in IFS cloud? 

Hi Ed,
just use the other script or the combination of both.
You will see the navigator description and the presentation object.

Do you really need the module names?

Hmm, perhaps there is a connection between presentation object and lu/ module.

I will search for that.

All the best
Michael

​@Ed22  Assuming your question is basically, “If I see a field in a page, how do I know where it came from and if it’s a calculation, how do I know that that is”?

If you have functional SME’s to ask, that would be a place to start.  In your example, a Manufacturing SME would know how the Machine Run Factor is set for the Shop Order Operations.  There’s also the Field Description which you can turn on.  This describes the general purpose of the field.

If you’d like to dig more on your own, you need a way to see the view and API definitions with a PL/SQL browser connected to your DEV environment.  The way I’d  start is to take a look at the view behind the Page you’re looking at.  In your example, you’d be looking at the SHOP_ORDER_OPERATION_JOIN view.  The view should give you an idea of the areas where the fields originated.  Digging further, you could look at the SHOP_ORDER_OPERATION_API.Insert___ procedure which would tell you how the data is gathered to create a new line.

If you actually know the API to calculate a field - your example: shop_order_operation_api.Get_Remaining_Labor_Man_Hours, just take a look at the API and it will tell you exactly how it’s calculated.  Note that the screen-shot most like does NOT match your version, so please use it as an FYI only.