7 Replies Latest reply: Feb 1, 2013 1:33 PM by Hussein Sawwan-Oracle RSS

    Profile description is not visible from Application which the LDT file has.

    785267
      Experts,

      I am running into strange issue.

      Dev created a LDT file for a profile and requested to upload it through a one-off patch.

      The profile got updated into the DB for all the 3 languages - US, KO and AR.
      However the description is not visible for US when tried to verify from the Forms.

      Further analysis gave a tip that the description is NULL only for US and exists for other 2 Langs (KO and AR).
      SQL> select PROFILE_OPTION_NAME, DESCRIPTION, LANGUAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE
      2 from fnd_profile_options_tl where
      3 profile_option_name='INL_ITEM_CATEGORY_SET';

      PROFILE_OPTION_NAME DESCRIPTION LA LAST_UPDAT LAST_UPDATED_BY CREATED_BY CREATION_D
      ------------------------- -------------------------------------------------- -- ---------- --------------- ---------- ----------
      INL_ITEM_CATEGORY_SET {Category Set to determine the items that will be  AR 09-NOV-12              122        122 11-JUL-11
                                LCM trackedسÙÙ
                                               اÙ
      ٠سÙÙ
            اÙ
      ٠سÙÙ
            اÙ
      ٠سÙ}

      INL_ITEM_CATEGORY_SET {Category Set to determine the items that will be  KO 09-NOV-12              122        122 11-JUL-11
                                LCM trackedâ
                                            ¦'+++ '+++ '+++ '+++ '+++ '+++ '+++ '++
                                +Ã

      INL_ITEM_CATEGORY_SET                                                                            US 12-MAR-12             *2330*        122 11-JUL-11

      SQL>

      Also identified the Last Updated By is from FND User - "PROCESS_OPS"

      SQL> select USER_ID, USER_NAME from fnd_user where USER_ID in (122, 2330);

         USER_ID            USER_NAME
      ------------------         --------------------------------------------------------------------------------
             122               ORACLE12.2.0
            2330              PROCESS_OPS


      SQL>

      What could be the reason behind this change?
      Why the profile description only for US Lang is not getting updated whereas for other languages it got updated by FND User - "ORACLE12.2.0"?

      It clearly shows on 09-Nov-12 there were some changes happened and that to by User_ID 122 which updated for KO and AR.
      For some reason the same was not applied for US Lang.