1 Reply Latest reply on Jan 28, 2016 10:43 PM by Bashar.

    Concurrent Program Application id Updated but not shown

    1567114

      Hello,

       

      I have a Concurrent Program :Test Sales Invoice

      Application:Order Management (Application id 660)

       

      I later on updated the :

       

      Application id 2001 is for TEST_AR

       

      UPDATE FND_CONCURRENT_PROGRAMS_VL

      SET APPLICATION_ID='2001'

      WHERE

      USER_CONCURRENT_PROGRAM_NAME='Test Sales Invoice'

      AND APPLICATION_ID=660

       

      The row got updated but later on i could not find the Concurrent Program Name in Application Developer.Please help

        • 1. Re: Concurrent Program Application id Updated but not shown
          Bashar.

          Hi,

           

          First of all, you should not be doing such updates against Oracle seeded tables.

          The right thing to do is to copy the program to a new one using the new application through the define concurrent programs window.

           

          Please query the fnd_concurrent_programs and fnd_concurrent_programs_tl to find out what happened to the program.

           

          select *

          from FND_CONCURRENT_PROGRAMS_TL

          WHERE USER_CONCURRENT_PROGRAM_NAME='Test Sales Invoice';

           

           

          select *

          from FND_CONCURRENT_PROGRAMS

          WHERE CONCURRENT_PROGRAM_ID=<concurrent_program_id from the first query>;

           

          Regards,

          Bashar