Oracle EBS ‘te Eşzamanlının Atandığı Sorumlulukları Bulan Sorgu (Find to Concurrent Program Responsibility Query in Oracle EBS)

• Ali Keskin
• 27 Ara, 2016
• EBS, Oracle, PL/SQL
• concurrent, ebs, eşzamanlı, oracle, responsibilty, sorumluluk
  
• No comment

Oracle EBS ‘te tanımlanan concurrentların aynı zamanda hangi sorumluluklara atandıklarını bulmak için aşağıdaki sorguyu kullanabiliriz.

Oracle PL/SQL

WriteConcurrentShortName -> Bu alana concurrentın short namesini yazıyoruz.

1	WriteConcurrentShortName -> Bu alana concurrentın short namesini yazıyoruz.

Oracle PL/SQL

%WriteHerConcurrentProgramUserNAme% -> Bu alana concurrentın user yani ekran requests listesindeki adını yazıyoruz. Dikkat edilmesi gereken küçük büyük harf duyarlı olması ve başındaki sonundaki % işaretlerinin silinmemesidir. Bu da LIKE komutunun gerekliliğidir.

1	%WriteHerConcurrentProgramUserNAme% -> Bu alana concurrentın user yani ekran requests listesindeki adını yazıyoruz. Dikkat edilmesi gereken küçük büyük harf duyarlı olması ve başındaki sonundaki % işaretlerinin silinmemesidir. Bu da LIKE komutunun gerekliliğidir.

Oracle PL/SQL

SELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,fnd_concurrent_programs_tl fcpt ,fnd_responsibility_tl frt ,fnd_responsibility frs WHERE frgu.unit_application_id = fcp.application_id AND frgu.request_unit_id = fcp.concurrent_program_id AND frg.request_group_id = frgu.request_group_id AND frg.application_id = frgu.application_id AND fcpt.source_lang = USERENV('LANG') AND fcp.application_id = fcpt.application_id AND fcp.concurrent_program_id = fcpt.concurrent_program_id AND frs.application_id = frt.application_id AND frs.responsibility_id = frt.responsibility_id AND frt.source_lang = USERENV('LANG') AND frs.request_group_id = frg.request_group_id AND frs.application_id = frg.application_id AND ( fcp.concurrent_program_name = 'WriteConcurrentShortName' OR fcpt.user_concurrent_program_name LIKE '%WriteHerConcurrentProgramUserNAme%')

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

SELECT frt.responsibility_name,                frg.request_group_name,                frg.description   FROM fnd_request_groups frg              ,fnd_request_group_units frgu              ,fnd_concurrent_programs fcp              ,fnd_concurrent_programs_tl fcpt              ,fnd_responsibility_tl frt              ,fnd_responsibility frs WHERE frgu.unit_application_id = fcp.application_id AND   frgu.request_unit_id = fcp.concurrent_program_id AND   frg.request_group_id = frgu.request_group_id AND   frg.application_id = frgu.application_id AND   fcpt.source_lang = USERENV('LANG') AND   fcp.application_id = fcpt.application_id AND   fcp.concurrent_program_id = fcpt.concurrent_program_id AND   frs.application_id = frt.application_id AND   frs.responsibility_id = frt.responsibility_id AND   frt.source_lang = USERENV('LANG') AND   frs.request_group_id = frg.request_group_id AND   frs.application_id = frg.application_id AND   ( fcp.concurrent_program_name = 'WriteConcurrentShortName' OR      fcpt.user_concurrent_program_name LIKE '%WriteHerConcurrentProgramUserNAme%')