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
Skip to content
  • Register

    • Historic table for EFF "ego_item_eff_b_" is timing out.

    edited Mar 11, 2025 2:32PM in Supply Chain Planning and Collaboration

    I am writing a very simple query to see historical EFF data for an item and It is timing out when I tried to search with the inventory Item ID. What is the issue with this table?

    Version : 24D (11.13.24.10.0)

    Code Snippet:

    SELECT * FROM ego_item_eff_b_
    WHERE INVENTORY_ITEM_ID = '100000075736134'
    AND context_code = 'TFS_LSG_DANGEROUS_GOODS_INFO'

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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