Is anybody aware of a way of generating a IFSAPP schema map or (via SQL) a report that shows relationships between tables to tables / views to views?
Hi
Here is relation between logical units:
select * from reference_sys_tab
Conjuction with dictionary_sys_view_tab might help to identify views connected with LU’s.
I believe one reason standard Oracle reporting tools can’t tell you much is that IFS does not use much by way of constraints, etc. Business rules and parent/child relationships are defined by the package API code. Right now I could go in and delete all records from CUSTOMER_INFO_TAB, making all CUSTOMER_INFO_ADDRESS records orphans -- no conditional key linkage would prevent that, as far as I can tell.
Good to know about the Reference_Sys table!
Thanks,
Joe Kaufman
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.