4 Replies Latest reply: Jan 25, 2013 5:53 AM by AlexAnd RSS

    GL Code Combinations Load

    732230
      Gurus,

      Always a pleasure to post questions in oracle forums and here i am with another.

      I have close to 900 rows of code combinations to be load into GL_CODE_COMBINATIONS table. Accounting department don't want to do this manually.

      We at IT department have to load'em.

      Please provide me the guidelines and pre-requisites that needs to taken care while uploading manually.

      Meanwhile i am gathering information from my end also.

      Thank You.
        • 1. Re: GL Code Combinations Load
          795376
          Hi Karthik ,

          Is the COA , Dynamic Insertion enabled ?


          Regards
          Muthu
          • 2. Re: GL Code Combinations Load
            Pk
            Karthik,
            There is a API for creating the gl_code_combinations, it will create newly if combination is not present in gl_code_combinations table.

            fnd_flex_ext.get_ccid

            Check the parameters of this API and use accordingly.

            Regards,
            • 3. Re: GL Code Combinations Load
              user12239272
              Dear Karthi,

              You can load the GL Code Combinations using Data Loader.

              DataLoad Classic Version 4.3.1.1 is a open source, you can download.

              formate the cell as below,

              \{TAB}     \{TAB}     601.611.999.131120.99.999.9999     \{TAB}     02-APR-2011     \{TAB}     \{DOWN}
              \{TAB}     \{TAB}     601.612.999.131120.99.999.9999     \{TAB}     02-APR-2011     \{TAB}     \{DOWN}
              \{TAB}     \{TAB}     601.631.999.131120.99.999.9999     \{TAB}     02-APR-2011     \{TAB}     \{DOWN}
              \{TAB}     \{TAB}     601.632.999.131120.99.999.9999     \{TAB}     02-APR-2011     \{TAB}     \{DOWN}
              \{TAB}     \{TAB}     601.633.999.131120.99.999.9999     \{TAB}     02-APR-2011     \{TAB}     \{DOWN}


              Regards

              S.Srinivasa Vijayan
              • 4. Re: GL Code Combinations Load
                AlexAnd
                >
                I have close to 900 rows of code combinations to be load into GL_CODE_COMBINATIONS table. Accounting department don't want to do this manually.
                >
                if rows in a file then load it in some table by sqlloder as example or may be try to use external table

                for creating code combinations try
                delimeter := fnd_flex_ext.get_delimiter ('SQLGL', 'GL#', 101) ;
                for x in (select segment1 || delimeter  || segment2 ||delimeter..... as concat_segments from extr_table) loop
                if fnd_flex_keyval.validate_segs('CREATE_COMBINATION',
                                                     'SQLGL',
                                                     'GL#',
                                                     101,
                                                     x.concat_segments) then
                      new_ccid := fnd_flex_keyval.combination_id;
                      dbms_output.put_line(new_ccid);
                end if;
                end loop;
                commit;
                'CREATE_COMBINATION' - Combination is created if doesn't exist.