13 Replies Latest reply on Jul 12, 2019 4:49 AM by Abdul-Oracle

    Unable to complete Data Load Execution

    2623642

      I updated the log level to 5 still the log file do not show exact line, where it is failing.

      I see following two error code in the log file:

      - 2019-06-17 11:18:08,699 ERROR [AIF]: The script has failed to execute:

      - 2019-06-17 11:18:08,808 FATAL [AIF]: Error in COMM Pre Import Data

       

      The script works fine in SQL Developer but not in FDMEE

       

      This script works fine in SQL Developer and FDMEE

      SELECT glc.segment1 Co,

        'ACCUM' Account,

        DECODE(glc.segment1,'2422',(SUM(NVL(ael.accounted_dr,0)) - SUM(NVL(ael.accounted_cr,0))- 100000),

        (SUM(NVL(ael.accounted_dr,0))- SUM(NVL(ael.accounted_cr,0)) ))

        Entries FROM apps.xla_ae_headers aeh, apps.xla_ae_lines ael, apps.gl_code_combinations glc

        WHERE aeh.ae_header_id = ael.ae_header_id AND ael.code_combination_id = glc.code_combination_id

        AND (glc.segment3 BETWEEN '170000' AND '170120' OR glc.segment3 = '170300' OR glc.segment3 = '186600' OR glc.segment3 = '187030' OR glc.segment3 = '284500')

        AND aeh.ledger_id = 2023

        AND ael.accounting_class_code = 'ASSET'

        AND aeh.application_id = 140

        AND ael.accounting_date BETWEEN '01-JAN-2019' AND '31-JAN-2019'

        group by glc.segment1;

       

       

      The moment I replace the hard coded value "100000" to a query from one of the view, it throws an error in FDMEE (The script has failed to execute:). The script works fine in SQL Developer but not in FDMEE.

       

      select glc.segment1 Co, 'ACCUM' Account,

                          decode(glc.segment1,'2422',(sum(nvl(ael.accounted_dr,0)) - sum(nvl(ael.accounted_cr,0))- (select sum(nvl(fmav.deprn_reserve,0)) from

                          apps.fa_mass_additions_v fmav where fmav.book_type_code = 'XXX' and fmav.context = 'Conversion')),

                          (sum(nvl(ael.accounted_dr,0)) - sum(nvl(ael.accounted_cr,0)) )) Entries

                          from apps.xla_ae_headers aeh, apps.xla_ae_lines ael, apps.gl_code_combinations glc

                          where aeh.ae_header_id = ael.ae_header_id

                          and ael.code_combination_id = glc.code_combination_id

                          and (glc.segment3 between '170000' and '170120' or glc.segment3 = '170300' or glc.segment3 = '186600' or glc.segment3 = '187030' or glc.segment3 = '284500')

                          and aeh.ledger_id = 2023

                          and ael.accounting_class_code = 'ASSET'

                          and aeh.application_id = 140

                          and ael.accounting_date between '01-JAN-2019' and '31-JAN-2019'

                          group by glc.segment1;

       

       

      What could be possible issue with this?