You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP Report - Full Scan on doo_headers_eff_b

edited Sep 11, 2024 1:02PM in Order Management 1 comment

Summary:

Hi Team

We have defined index enabled EFFs on Sales Order header however the SQLs are not doing Index scan when using EFFs columns for data selection. On Further research we find there are no extensible index maintained on this table, which is a Gap as there is a provision to define Index from UI.

The product gives a provision to select an indexed field on an EFF segment (UI Configuration) however backend table for OM 'doo_headers_eff_b' does not have any index defined to honor the UI configuration.

Flexfieled Name- Header Information

Code: DOO_HEADERS_ADD_INFO

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!