{"id":451,"date":"2009-07-03T13:51:51","date_gmt":"2009-07-03T10:51:51","guid":{"rendered":"https:\/\/enginhafizoglu.com\/?p=451"},"modified":"2011-10-01T00:41:40","modified_gmt":"2011-09-30T21:41:40","slug":"apexten-oracle-ebs-ortamindaki-talebi-calistirma-running-an-oracle-ebs-concurrent-from-apex","status":"publish","type":"post","link":"https:\/\/enginhafizoglu.com\/?p=451","title":{"rendered":"Apex’ten Oracle EBS ortam\u0131ndaki talebi \u00e7al\u0131\u015ft\u0131rma. (Running an Oracle EBS Concurrent from APEX)"},"content":{"rendered":"

Aran\u0131zda bu ne olaki diyenler olabilir. K\u0131saca \u015f\u00f6yle izah etmeye \u00e7al\u0131\u015fay\u0131m. Apex ile oracle e-business ortam\u0131n\u0131 karde\u015f karde\u015f \u00e7al\u0131\u015ft\u0131rmaya u\u011fra\u015f\u0131yoruz bu yaz\u0131da.<\/p>\n

K\u0131saca oracle ebs i\u00e7indeki bir talebi apex i\u00e7inden \u00e7a\u011f\u0131r\u0131yoruz. WIP aray\u00fcz\u00fcne at\u0131lan kayd\u0131 “WIP Toplu Y\u00fckleme” ile i\u00e7eri atmaya \u00e7al\u0131\u015f\u0131yoruz.<\/p>\n

\u00d6nce WIP aray\u00fcz\u00fcne kay\u0131t atmak i\u00e7in bir apex aray\u00fcz\u00fc olu\u015fturdum. Bu aray\u00fczede bir “Create” butonu koydum. Create butonuna bas\u0131ld\u0131\u011f\u0131nda hem wip aray\u00fcz tablosuna kay\u0131t at\u0131yor daha sonrada bu a\u015fa\u011f\u0131da g\u00f6rd\u00fc\u011f\u00fcn\u00fcz prosed\u00fcr ile oracle ebs taraf\u0131nda i\u015f emrini olu\u015fturuyor. Hadi ba\u015flayal\u0131m bakal\u0131m \ud83d\ude42<\/p>\n

\"\"
\nProcesses alan\u0131ndan IS_EMRI_OLUSTUR ad\u0131yla PL\/SQL anonymous block olu\u015fturulur.<\/p>\n

\"\"
\n<\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

Source k\u0131sm\u0131na yazd\u0131\u011f\u0131m\u0131z kod eklenir. Burda \u00f6nemli olan fnd_global.apps_initialize parametrelerini vermeniz. :p9_group_id nedir diyenlere. WIP aray\u00fcz\u00fcne yazarken bunu sequence’den otomatik ald\u0131r\u0131yoruz. Sonrada prosed\u00fcr\u00fcm\u00fcze dahil ediyoruz ki hangi s\u0131radaki kay\u0131tlar\u0131 alaca\u011f\u0131n\u0131 bilsin.<\/p>\n

[sql]DECLARE
\nl_report_name VARCHAR2 (50);
\nreq_id NUMBER;
\nBEGIN
\nfnd_global.apps_initialize (1007899, 60338, 190);
\nl_report_name := ‘WICMLP’;
\nreq_id :=fnd_request.submit_request (‘WIP’,l_report_name,”,”,FALSE,:p9_group_id,0,1, CHR (0),”,
\n”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,
\n”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,
\n”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”);
\nEND;[\/sql]<\/p>\n

\"\"
\n<\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

Di\u011fer alanlar default olarak b\u0131rak\u0131ld\u0131. Bu kadar!!!<\/p>\n","protected":false},"excerpt":{"rendered":"

Aran\u0131zda bu ne olaki diyenler olabilir. K\u0131saca \u015f\u00f6yle izah etmeye \u00e7al\u0131\u015fay\u0131m. Apex ile oracle e-business ortam\u0131n\u0131 karde\u015f karde\u015f \u00e7al\u0131\u015ft\u0131rmaya u\u011fra\u015f\u0131yoruz bu yaz\u0131da. K\u0131saca oracle ebs i\u00e7indeki bir talebi apex i\u00e7inden \u00e7a\u011f\u0131r\u0131yoruz. WIP aray\u00fcz\u00fcne at\u0131lan kayd\u0131 “WIP Toplu Y\u00fckleme” ile i\u00e7eri atmaya \u00e7al\u0131\u015f\u0131yoruz.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[70,79,35],"class_list":["post-451","post","type-post","status-publish","format-standard","hentry","category-oracle-e-is-yonetim-sistemi","tag-apex","tag-ebs","tag-oracle"],"_links":{"self":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=451"}],"version-history":[{"count":8,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions"}],"predecessor-version":[{"id":677,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions\/677"}],"wp:attachment":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}