3 Replies Latest reply: Jan 18, 2013 6:02 AM by SriniVelumuri RSS

    Journal import fails when called from PLSQL

    983693
      Hi,

      When journal import is called from plsql code it is failing with error in 'gllacc() Function returning without value and no data found'.

      Same transaction is run succesfully from front end.

      I checked both gl_interface and gl_interface_control table but couldnt find the issue.

      Any info on this would be very helpful.

      Thanks
      Sandhya
        • 1. Re: Journal import fails when called from PLSQL
          shreevat
          provide your code snippet please.

          Thanks
          Shree
          • 2. Re: Journal import fails when called from PLSQL
            983693
            FOR l_rec IN (SELECT ledger_id,group_id from apps.gl_interface
            WHERE status='NEW'
            AND user_je_source_name='GIS_DATA_CONVERSION'
            GROUP BY ledger_id,group_id
            ORDER BY group_id

            )
            LOOP
            apps.gl_journal_import_pkg.populate_interface_control (user_je_source_name => 'GIS_DATA_CONVERSION',
            GROUP_ID => l_rec.group_id,
            set_of_books_id => l_rec.ledger_id,
            interface_run_id =>vl_interface_id,
            table_name => 'GL_INTERFACE',
            processed_data_action=>'D'
            );
            COMMIT;
            vl_request_id := apps.fnd_request.submit_request (application => 'SQLGL', -- application short name
            program => 'GLLEZLSRS', -- program short name
            description => NULL, -- program name
            start_time => NULL, -- start date
            sub_request => FALSE, -- sub-request
            argument1 => 2065, --Data access set id
            argument2 => 'GIS_DATA_CONVERSION', --Source
            argument3 => l_rec.ledger_id, -- set of books id
            argument4 => l_rec.group_id,
            argument5 => 'N', -- error to suspense flag
            argument6 => NULL, -- create summary flag
            argument7 => 'N' -- import desc flex flag
            );
            COMMIT;

            IF ( vl_request_id = 0 ) THEN
            xxgis.gis_conv_util_pkg.debug_print_p(1,'FND_LOG','E001: Journal Import Submission Failed. ' || SQLERRM);
            retcode := 2;
            EXIT;
            --
            ELSE

            xxgis.gis_conv_util_pkg.debug_print_p(1,'FND_LOG','P001: Submitted Journal Import Program for group id: ' || l_rec.group_id ||
            'and ledger :'||l_rec.ledger_id|| ', Request ID: ' || vl_request_id);
            END IF;

            END LOOP;
            • 3. Re: Journal import fails when called from PLSQL
              SriniVelumuri
              Incorrect parameters provided for running Journal Import
              Refer note 1512061.1

              Regards,
              Srini