1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Automating Journal Import program from PL-SQL code and Posting Journals

Discussion in 'Oracle Financials' started by passionist, Aug 19, 2013.

  1. passionist

    passionist Guest

    Populating GL_Interface_Controls table and GL_Interface also.Then run the below program with same SOB,Interface run id & Group id is not required as I am also not populating the same in GL Interface.After running the below program also had found that no error is coming but request id is being returned as by the below function for Journal Import.

    Please can anybody help me to know where the issue is. Also plz let me know if it needs to be called in LOOP.

    Thanks in advance.

    ln_request_id := fnd_request.submit_request ( application => 'SQLGL',
    program => 'GLLEZL',
    description => null,
    start_time => SYSDATE,
    sub_request => FALSE,
    argument1 => to_char(p_iface_run_id),
    argument2 => to_char(ln_sob_id),
    argument3 => 'N', -- Post errors to suspense
    argument4 => NULL, -- Start Date
    argument5 => NULL, -- End Date
    argument6 => 'N', -- Create Summary Journal
    argument7 => 'N' -- Import DF

  2. Bharat

    Bharat Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Vijayawada, India
    Hi Ankit,

    We can see the report output from application end. Have you came across any error ? If concurrent program is errored out, we can check the error messages in LOG File. Even if you don't see the program errored out some times it will show errors in LOG file. Please go through the LOG file for error messages on this.