5 Replies Latest reply: Oct 16, 2013 4:09 PM by 444d6388-6958-4541-87e9-dd0ccd1cf22f RSS

    Table in GL a/c

    444d6388-6958-4541-87e9-dd0ccd1cf22f

      Hi

       

      I am new to Oracle Financials. I am trying to find out how to find the table FLEX_VALUE_SET_ID.

       

      I could find table FND_ID_FLEX_STRUCTURES_VL from front end through HELP from the Account setup screen.

       

      Could anyone navigate me to find the FLEX_VALUE_SET_ID table thru front end??

       

      Thanks,

       

      Vasu

        • 1. Re: Table in GL a/c
          Asif Muhammad

          Hi Vasu,

           

           

          I am trying to find out how to find the table FLEX_VALUE_SET_ID.

           

          This is actually column and not a table.

           

          TABLE_NAMECOLUMN_NAME
          FND_COLUMNSFLEX_VALUE_SET_ID
          FND_DESCR_FLEX_COLUMN_USAGESFLEX_VALUE_SET_ID
          FND_FLEXBUILDER_PARAMETERSFLEX_VALUE_SET_ID
          FND_FLEX_HIERARCHIESFLEX_VALUE_SET_ID
          FND_FLEX_HIERARCHIES_TLFLEX_VALUE_SET_ID
          FND_FLEX_VALIDATION_EVENTSFLEX_VALUE_SET_ID
          FND_FLEX_VALIDATION_QUALIFIERSFLEX_VALUE_SET_ID
          FND_FLEX_VALIDATION_TABLESFLEX_VALUE_SET_ID
          FND_FLEX_VALUESFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_HIERARCHIESFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_HIER_ALLFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_NORM_HIERARCHYFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_RULESFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_RULE_LINESFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_RULE_USAGESFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_SETSFLEX_VALUE_SET_ID
          FND_ID_FLEX_SEGMENTSFLEX_VALUE_SET_ID
          FND_SEG_RPT_ATTRIBUTESFLEX_VALUE_SET_ID
          FND_DESCR_FLEX_COL_USAGE_VLFLEX_VALUE_SET_ID
          FND_FLEXBUILDER_PARAMS_VLFLEX_VALUE_SET_ID
          FND_FLEX_CONC_PARAM_VSET_VFLEX_VALUE_SET_ID
          FND_FLEX_DESCR_SEG_VSET_VFLEX_VALUE_SET_ID
          FND_FLEX_HIERARCHIES_VLFLEX_VALUE_SET_ID
          FND_FLEX_KEY_SEG_VSET_VFLEX_VALUE_SET_ID
          FND_FLEX_VALUES_VLFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_CHILDREN_VFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_DESTINATION_VFLEX_VALUE_SET_ID
          FND_FLEX_VALUE_RULES_VLFLEX_VALUE_SET_ID
          FND_FLEX_VSET_VFLEX_VALUE_SET_ID
          FND_ID_FLEX_SEGMENTS_VLFLEX_VALUE_SET_ID
          FND_SEGMENT_NAMES_VFLEX_VALUE_SET_ID

           

           

          Thanks &

          Best REgards,

          • 2. Re: Table in GL a/c
            Pradeep Kalyan

            FLEX_VALUE_SET_ID is not a table...Can you please let me know what are you looking for?

            • 3. Re: Table in GL a/c
              444d6388-6958-4541-87e9-dd0ccd1cf22f

              Hi Asif,


              I have to find the accounts creation date but was not sure how to get to the FND_FLEX_VALUES_VL table to create a query


              I thought i could get it from FND_VALUE_SET_ID ( thinking that was a table)


              Could you please tell how you find all these tables ??


              Can we see it through the front screen??



              Thanks in advance,


              Vasu

              • 4. Re: Table in GL a/c
                Asif Muhammad

                Hi Vasu,

                 

                I am not a development guy, but anyways answering your quesiton:

                Could you please tell how you find all these tables ??

                I queried from the backend using the following command:

                select table_name, column_name

                from all_tab_cols

                where column_name = 'FLEX_VALUE_SET_ID'

                and table_name like 'FND_%'



                Can we see it through the front screen?

                You may use  softwares like SQL Navigator, TOAD  to query this from the client machine.


                IF you mean to say front end, as in term of Oracle Application then the answer is No, and you can get this datas using  above softwares.


                Thanks

                • 5. Re: Table in GL a/c
                  444d6388-6958-4541-87e9-dd0ccd1cf22f

                  Hi Asif,

                   

                  Thanks for anwering my question. I am just learning to make queries and your answers have been very helpful to me.

                   

                  Thanks a lot.

                   

                  Vasu