For a field on a Report view (a _REP view, like CATALOG_NO on CUSTOMER_ORDER_CONF_REP), how do you trace back to find which underlying table or source it actually comes from, when the _REP view's own SQL in Oracle Developer only shows a reference to its result-key lines rather than the real source mapping?

All FAQ questions / Reporting and analytics

Answer

Look at the corresponding _RPI package instead of the _REP view's own SQL — for CUSTOMER_ORDER_CONF_REP, that would be CUSTOMER_ORDER_CONF_RPI. The _RPI package is where the actual field-to-source mapping logic lives (populating the report's result data), so that's where you'll find which underlying table or view a specific _REP field is actually sourced from — for example, CATALOG_NO in this case comes from CUSTOMER_ORDER_LINE_TAB.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions