+16Hi,
I will prepare a report. I need a query of the Navigator Previews of permission sets. I couldn’t find the connection between permission sets and the navigator. I must use the fnd_navigator view because It has a translated version of the navigator. Do you have any idea?
Best answer by hhy38
Hi,
To solve the problem I translated presentation objects. First of all, I got all the presentation objects into an Excel file. After that, I made the translations. Then, I wrote a PLSQL script to insert translations. Finally, I wrote a query to get the translated names of the presentation objects.
SELECT * FROM temp_table FOR UPDATE;
DELETE FROM temp_table;
/*BEGIN
FOR rec_ IN (SELECT * FROM temp_table t WHERE t.area2 = 'tr')
LOOP
ifsapp.pres_object_description_api.insert_description(rec_.area1, 'tr', rec_.area3);
END LOOP;
END;*/
SELECT t.po_id,
t.lang_code,
t.description,
ifsapp.pres_object_description_api.get_description(t.po_id, 'tr') ceviri,
'ifsapf:' || t.po_id ekran
FROM ifsapp.pres_object_description t
WHERE (substr(t.po_id, 1, 3) = 'tbw' OR substr(t.po_id, 1, 3) = 'frm')
AND t.lang_code = 'en';
+16Hi
Do you have any suggestions?
+22Hi
It seems FND_NAVIGATOR stores navigator entries for Aurena client, not the IEE.
I don’t have an exact answer, but I hope below queries will help you to build something
Query to get the windows (Presobjects) granted for a permission set
select * from pres_object_grant
where role = 'YOUR_PERMISSION_SET_ID'
Query to get the window names and translations
select * from language_text_translation a, pres_object b
where a.name = b.po_id
and a.lang_code = 'sv' -- Use your language code here
and b.pres_object_type_db = 'WIN' Hope it helps!
Damith
+16Hi
I think something is wrong with our translations. Because we have only 166 object translations in the language_text_translation view for Turkish. So, we need to translate presentation objects. Thank you for the effort.
Best Regards,
Hasan
+16Hi,
To solve the problem I translated presentation objects. First of all, I got all the presentation objects into an Excel file. After that, I made the translations. Then, I wrote a PLSQL script to insert translations. Finally, I wrote a query to get the translated names of the presentation objects.
SELECT * FROM temp_table FOR UPDATE;
DELETE FROM temp_table;
/*BEGIN
FOR rec_ IN (SELECT * FROM temp_table t WHERE t.area2 = 'tr')
LOOP
ifsapp.pres_object_description_api.insert_description(rec_.area1, 'tr', rec_.area3);
END LOOP;
END;*/
SELECT t.po_id,
t.lang_code,
t.description,
ifsapp.pres_object_description_api.get_description(t.po_id, 'tr') ceviri,
'ifsapf:' || t.po_id ekran
FROM ifsapp.pres_object_description t
WHERE (substr(t.po_id, 1, 3) = 'tbw' OR substr(t.po_id, 1, 3) = 'frm')
AND t.lang_code = 'en';
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.