Configurator

Get Involved. Join the Conversation.

Topic

    Harshal Agrawal
    Configurator Tables
    Topic posted July 12, 2018 by Harshal AgrawalRed Ribbon: 250+ Points, last edited July 12, 2018 by Al SatchuBlue Ribbon: 750+ Points, tagged Configurator, Public Sector 
    468 Views, 11 Comments
    Title:
    Configurator Tables
    Summary:
    How to find tables names from front end
    Content:

    Hi All,

    How can we search table name in Fusion from front end, likewise we use to do in EBS diagnostic or record history.
    How can we search table name, Currently I need to search the table name where Configurator information is stored while configuring the model from Order Management.
    I need Configurator options related information in OM. Item related information I have got from Lines_all table.

    Thanks,
    Harshal

    Comment

     

    • Al Satchu

      Hi Harshal,

      You can use OTBI - Oracle Transactional Business Intelligence for this. Applications navigation: Reports and Analytics >> Browse Catalog. Create your own data model and select SQL Query and the correct data source e.g. ApplicationsDB_FSCM.

      For further assistance with this, please follow up directly with Oracle Support.

      Regards, Al.

    • Al Satchu
    • Harshal Agrawal

      Hi Al,

      I have checked this tables and even in CZ_MODEL_NODES_VL using parent _id I can get the option feature and its options.
      But from where I can retrieve the configurator model information from Order management ?
      I mean in which table the options of the option features are stored which we are configuring while booking the order.
      Like wise in DOO_ORDER_FLINES_V table we can get all the parts related information which are selected or picked while booking the order.In same way in which table we can get options and option feature related information.

      Thanks,
      Harshal

    • Al Satchu

      Supplemental structure (i.e. option features / options) are not stored in Order Management, they exist only on the configuration.

      Refer to our table and view documentation.

      The CONFIG_HEADER_ID and CONFIG_REVISION_NUMBER stored on the config order line (DOO_ORDER_LINES_ALL_INT) in Order Management points to the configuration details within Configurator: CZ_CONFIG_HEADERS, CZ_CONFIG_LINES, CZ_CONFIG_LINE_ATTRS.

       

    • Harshal Agrawal

      Thanks Al, Thanks for the table information.
      Can we get the tables information like diagnostics in EBS R12, in fusion can we find the table name at runtime ?

    • Al Satchu

      Harshal, can you clarify what you mean by which table names at runtime?

    • Harshal Agrawal

      Hi Al,

      Runtime means while selecting the option, while configuring the model from Order management.

      Thanks,
      Harshal

    • Al Satchu

      I meant which diagnostic tables were you referring to for runtime in EBS that you are also looking for in Fusion? Specifically what are you trying to achieve?

    • Harshal Agrawal

      I am trying for configurator run time configuration tables. which option is selected for order and in its line.

    • Al Satchu

      As stated above, the runtime configuration details may be found across these tables: CZ_CONFIG_HEADERS, CZ_CONFIG_LINES and CZ_CONFIG_LINE_ATTRS. Refer to the documentation link above for details.

      You'll find the CONFIG_HEADER_ID and CONFIG_REVISION_NUMBER for the configuration you're interested on the corresponding order line in DOO_ORDER_LINES_ALL_INT.

    • Harshal Agrawal

      Thank you Al.