{"id":927,"date":"2026-04-23T11:47:50","date_gmt":"2026-04-23T11:47:50","guid":{"rendered":"https:\/\/forgefuse.wasmer.app\/?p=927"},"modified":"2026-04-23T11:52:40","modified_gmt":"2026-04-23T11:52:40","slug":"debugging-oracle-ebs-concurrent-programs-like-a-pro","status":"publish","type":"post","link":"https:\/\/www.forgefuse.net\/index.php\/debugging-oracle-ebs-concurrent-programs-like-a-pro\/","title":{"rendered":"Debugging Oracle EBS Concurrent Programs Like a Pro"},"content":{"rendered":"\n

When working with Oracle E-Business Suite<\/strong>, concurrent programs are at the heart of most business processes. And sooner or later, every developer runs into the same challenge:<\/p>\n\n\n\n

\n

\u201cWhy is my concurrent request failing\u2026 and where do I even start?\u201d<\/p>\n<\/blockquote>\n\n\n\n

This post is both a debugging guide<\/strong> and a SQL cheat sheet<\/strong> I personally rely on when troubleshooting issues in real environments.<\/p>\n\n\n\n

\n\n\n\n
Understanding Log vs Output Files<\/h5>\n\n\n\n
\ud83d\udcc4 Log File (The Real Debugging Tool)<\/h5>\n\n\n\n

The log file<\/strong> is where everything important happens.<\/p>\n\n\n\n

It contains:<\/p>\n\n\n\n

    \n
  • PL\/SQL errors<\/li>\n\n\n\n
  • Debug messages<\/li>\n\n\n\n
  • Execution steps<\/li>\n\n\n\n
  • SQL errors (ORA-xxxx)<\/li>\n<\/ul>\n\n\n\n

    Example:<\/p>\n\n\n\n

    ORA-01403: no data found<\/pre>\n\n\n\n
    This is always your first place to check<\/strong><\/p>\n\n\n\n
    \n\n\n\n
    \ud83d\udcca Output File (User-Facing Result)<\/h5>\n\n\n\n
    The output file<\/strong> is what the user sees.<\/p>\n\n\n\n
    It contains:<\/p>\n\n\n\n
      \n
    • Report data<\/li>\n\n\n\n
    • XML \/ PDF output<\/li>\n\n\n\n
    • Formatted results<\/li>\n<\/ul>\n\n\n\n
       If output is empty but request is \u201cNormal\u201d, the issue is often in logic, not execution.<\/p>\n\n\n\n
      Using FND_FILE for Debugging<\/h4>\n\n\n\n
      The FND_FILE<\/code> package is your best friend.<\/p>\n\n\n\n
      Writing to Log<\/h6>\n\n\n\n
      FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of program');<\/pre>\n\n\n\n
      Writing to Output<\/h6>\n\n\n\n
      FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Report Line');<\/pre>\n\n\n\n
      Real Debug Example<\/h6>\n\n\n\n
      FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before fetching employee');

      SELECT employee_name
      INTO   l_name
      FROM   employees
      WHERE  employee_id = p_emp_id;

      FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee: ' || l_name);<\/pre>\n\n\n\n
      Always log:<\/p>\n\n\n\n
        \n
      • Input parameters<\/li>\n\n\n\n
      • Key variable values<\/li>\n\n\n\n
      • Execution checkpoints<\/li>\n<\/ul>\n\n\n\n
        Additionally, I usually like to wrap the log and output functions in a separate procedures inside my PLSQL package. I usually name them “log” and “outp” accepting only one parameter of VARCHAR type.<\/p>\n\n\n\n
        \n\n\n\n
        Common Errors and How to Read Them

        ORA Errors (Database Errors)<\/h5>\n\n\n\n
        Example:<\/p>\n\n\n\n
        \n
        ORA-01403: no data found<\/p>\n<\/blockquote>\n\n\n\n
        Meaning:<\/p>\n\n\n\n
        Your SELECT INTO returned no rows<\/p>\n\n\n\n
        Fix:<\/p>\n\n\n\n
        BEGIN\n\nSELECT \u2026\nINTO \u2026\nFROM \u2026\nWHERE \u2026;\n\nEXCEPTION\n  WHEN NO_DATA_FOUND THEN\n  FND_FILE.PUT_LINE(FND_FILE.LOG, 'No data found');\nEND;<\/code><\/pre>\n\n\n\n
        APP-FND Errors (Application Layer)
        Example:<\/h5>\n\n\n\n
        APP-FND-01564: ORACLE error 1403 in\u2026<\/p>\n\n\n\n
        Meaning:<\/p>\n\n\n\n
        Wrapper around ORA error
        Often tied to concurrent processing<\/p>\n\n\n\n
        Always scroll further down in log to find actual ORA error.<\/p>\n\n\n\n
        Tracing SQL from Concurrent Programs<\/h4>\n\n\n\n
        When logs are not enough, enable SQL trace.<\/p>\n\n\n\n
        Option 1: Enable Trace for Request<\/h5>\n\n\n\n
        Set profile:<\/p>\n\n\n\n
        Concurrent: Allow Debugging = Yes<\/pre>\n\n\n\n
        Then enable trace at request level.<\/p>\n\n\n\n
        \n\n\n\n
        Option 2: Add in Code<\/h5>\n\n\n\n
        EXEC DBMS_SESSION.SET_SQL_TRACE(TRUE);<\/pre>\n\n\n\n
        Trace file will be generated on DB server.<\/p>\n\n\n\n
        \n\n\n\n
        Option 3: Use FND_TRACE (Advanced)<\/h5>\n\n\n\n
        FND_TRACE.SET_TRACE_ON;<\/pre>\n\n\n\n
        \n\n\n\n
        Top SQL Queries Every EBS Developer Should Know<\/h4>\n\n\n\n
        These are extremely useful when debugging.<\/p>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Find Concurrent Request Details<\/h5>\n\n\n\n
        SELECT
            request_id,
            phase_code,
            status_code,
            argument_text,
            logfile_name,
            outfile_name
        FROM
            fnd_concurrent_requests
        WHERE
            request_id = :request_id;<\/pre>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Get Full Request + Program Info<\/h5>\n\n\n\n
        SELECT
            r.request_id,
            r.phase_code,
            r.status_code,
            p.concurrent_program_name,
            p.user_concurrent_program_name
        FROM
            fnd_concurrent_requests r,
            fnd_concurrent_programs_tl p
        WHERE
            r.concurrent_program_id = p.concurrent_program_id
        AND p.language = 'US'
        AND r.request_id = :request_id;<\/pre>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Find Log and Output File Names<\/h5>\n\n\n\n
        SELECT
            logfile_name,
            outfile_name
        FROM
            fnd_concurrent_requests
        WHERE
            request_id = :request_id;<\/pre>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Find Responsibility and Menu<\/h5>\n\n\n\n
        SELECT
            fr.responsibility_name,
            fm.menu_name
        FROM
            fnd_responsibility_vl fr,
            fnd_menus fm
        WHERE
            fr.menu_id = fm.menu_id;<\/pre>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Trace User Access (Which Responsibility User Has)<\/h5>\n\n\n\n
        SELECT
            fu.user_name,
            fr.responsibility_name
        FROM
            fnd_user fu,
            fnd_user_resp_groups_direct furg,
            fnd_responsibility_vl fr
        WHERE
            fu.user_id = furg.user_id
        AND furg.responsibility_id = fr.responsibility_id
        AND fu.user_name = :user_name;<\/pre>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Find Concurrent Requests by User<\/h5>\n\n\n\n
        SELECT
            request_id,
            phase_code,
            status_code,
            requested_start_date
        FROM
            fnd_concurrent_requests
        WHERE
            requested_by = (
                SELECT user_id
                FROM fnd_user
                WHERE user_name = :user_name
            )
        ORDER BY request_id DESC;<\/pre>\n\n\n\n
        \n\n\n\n
        \ud83d\udd0d Check Parameters Passed to Program<\/h5>\n\n\n\n
        SELECT
            argument_text
        FROM
            fnd_concurrent_requests
        WHERE
            request_id = :request_id;<\/pre>\n\n\n\n
        \n\n\n\n
        Real Debugging Workflow (What I Actually Do)<\/h4>\n\n\n\n
          \n
        1. Open concurrent request<\/li>\n\n\n\n
        2. Check log file first<\/strong><\/li>\n\n\n\n
        3. Search for:\n
            \n
          • ORA-<\/li>\n\n\n\n
          • ERROR<\/li>\n<\/ul>\n<\/li>\n\n\n\n
          • Add FND_FILE<\/code> logs if needed<\/li>\n\n\n\n
          • Run SQL queries to inspect data<\/li>\n\n\n\n
          • Enable trace if issue is unclear<\/li>\n<\/ol>\n\n\n\n
            \n\n\n\n
            Common Mistakes to Avoid<\/h5>\n\n\n\n
            \u274c Not checking log file first
            \u274c Printing debug info to OUTPUT instead of LOG
            \u274c Ignoring parameter values
            \u274c Not handling exceptions
            \u274c Assuming data exists<\/p>\n\n\n\n
            \n\n\n\n
            Final Thoughts<\/h4>\n\n\n\n
            Debugging concurrent programs is a skill that improves fast with practice.<\/p>\n\n\n\n
            Once you combine:<\/p>\n\n\n\n
              \n
            • Log file reading<\/li>\n\n\n\n
            • Proper FND_FILE<\/code> usage<\/li>\n\n\n\n
            • SQL tracing<\/li>\n\n\n\n
            • Handy queries<\/li>\n<\/ul>\n\n\n\n
              You move from guessing \u2192 to systematic debugging<\/strong><\/p>\n\n\n\n
              And that\u2019s when things become much easier.<\/p>\n","protected":false},"excerpt":{"rendered":"
              Logs, Output, Common Failures, SQL Tracing + Must-Know Queries<\/p>\n","protected":false},"author":1,"featured_media":929,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":4,"footnotes":""},"categories":[2,18],"tags":[19,15],"class_list":["post-927","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-article","category-orace-e-business-suite","tag-e-business-suite","tag-oracle"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/posts\/927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/comments?post=927"}],"version-history":[{"count":0,"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/posts\/927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/media\/929"}],"wp:attachment":[{"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/media?parent=927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/categories?post=927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.forgefuse.net\/index.php\/wp-json\/wp\/v2\/tags?post=927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}