This discussion is archived
7 Replies Latest reply: Feb 1, 2013 11:33 AM by Hussein Sawwan-Oracle RSS

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

user221796 - oracle Newbie
Currently Being Moderated
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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points