Archive for May 2009
Belajar dari Alphabet
Posted by: Edi Yanto on: May 29, 2009
A : Accept Terimalah diri anda sebagaimana adanya. B : Believe Percayalah terhadap kemampuan anda untuk meraih apa yang anda inginkan dalam hidup. C : Care Pedulilah pada kemampuan anda meraih apa yang anda inginkan dalam hidup. D : Direct Arahkan pikiran pada hal-hal positif yang meningkatkan kepercayaan diri. E : Earn Terimalah penghargaan yang [...]
How To Get the List of All Responsibilities Assigned To A User
Posted by: Edi Yanto on: May 28, 2009
SELECT frv.responsibility_name name, frv.start_date, frv.end_date FROM apps.fnd_user_resp_groups furg, apps.fnd_responsibility_vl frv, apps.fnd_user fu WHERE furg.user_id = fu.user_id AND fu.user_id = (SELECT user_id FROM fnd_user WHERE user_name = UPPER(:p_user_name)) AND furg.responsibility_id = frv.responsibility_id AND furg.responsibility_application_id = frv.application_id
Query To Find Multi-Org Is Enabled Or Not
Posted by: Edi Yanto on: May 28, 2009
SELECT DECODE (multi_org_flag, ‘Y’, ‘Multi-Org Enabled’, ‘Multi-Org Disabled’ ) FROM fnd_product_groups;
How To Find A Patch Is Applied For A Bug
Posted by: Edi Yanto on: May 28, 2009
SELECT DISTINCT RPAD (ad.bug_number, 11) “Bug Number”, RPAD (app.patch_name, 11) “Patch Name”, RPAD (TRUNC (apr.end_date), 12) “End Date”, RPAD (aprb.applied_flag, 4) “Applied?” FROM ad_bugs ad, ad_patch_run_bugs aprb, ad_patch_runs apr, ad_patch_drivers apd, ad_applied_patches app WHERE ad.bug_id = aprb.bug_id AND aprb.patch_run_id = apr.patch_run_id AND apr.patch_driver_id = apd.patch_driver_id AND apd.applied_patch_id = app.applied_patch_id AND ad.bug_number = nvl(:p_bug_number,ad.bug_number) ORDER BY [...]
Excel Limitations on Images in Oracle Apps
Posted by: Edi Yanto on: May 23, 2009
The Excel output can’t showing the image (even after you save and send to another person or open it at different notebook), but it is showing only small red color empty cross written ‘An Image’. Why??? As many of you know or have noticed, our Excel output for all flavors of BIP/XMLP is not true [...]
BLOB Images in XML Publisher
Posted by: Edi Yanto on: May 21, 2009
- In: Oracle
- 107 Comments
BLOB is “a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary code is stored as a blob. Database support for blobs is not universal.” (wikipedia) Support for extracting BLOB images to XML is coming, the XMLP extraction [...]
Today Is Beautiful Day And I Cannot See It
Posted by: Edi Yanto on: May 13, 2009
A blind boy sat on the steps of a building with a hat by his feet. He held up a sign which said: ‘I am blind, please help.’ There were only a few coins in the hat. A man was walking by. He took a few coins from his pocket and dropped them into the [...]
Scheduled Ship Date Time Always Reset To 23:59:00 in Oracle Apps R11i
Posted by: Edi Yanto on: May 9, 2009
When entering sales order and saving/booking it (depends on auto schedule), the schedule ship date always has a timestamp of 23:59:00. We are not getting the desired ship date for shipping our sales order. The expected behavior is take the timestamp of Requested Date. The cause of this problem has been identified in Bug 4358596 [...]
Tandingan Antar Berkumis
Posted by: Edi Yanto on: May 5, 2009
- In: articles
- 3 Comments
Tiap dua tahun sekali, para pemilik kumis dan jenggot yang unik berkumpul dalam acara World Beard and Moustache Championships. Sejak tahun 1990, kejuaraan ini mempertandingkan berbagai kategori kompetisi mulai dari dari bentuk kumis dan jenggot yang paling sederhana hingga yang paling ekstrim. Kompetisi “wajah berambut” ini dibuka untuk umum. Pada tahun 2007, Brighton (Inggris) menjadi [...]
Hati yang Luka
Posted by: Edi Yanto on: May 4, 2009
- In: articles
- 4 Comments
By: Veronica Mathelda Suatu waktu, ada 3 hati yang bertemu. Hati A : hati yang tidak sempurna, tetapi terlihat sangat indah, hati yang indah, hati yang utuh. Hati B : Hati yang terlihat sangat bahagia, tapi dia memiliki banyak luka yang ditutupi dengan plester Hati C : Hati yang benar2 luka, dan membiarkannya begitu saja.sehingga [...]
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
- BLOB Images in XML Publisher
- Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
- Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables
- Receiving and Return Transaction with Receiving Open Interface (ROI)
- Transact Move Order and Ship Confirm Using API
- Spell Number (Function Terbilang)
- Making Custom Reports Oracle Apps Compliant
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- Tuning PL/SQL Procedure Calls with the NOCOPY Compiler Hint
- Edi Yanto: Hi Mandi, Have you tried the steps on my blog? Please send me your RTF, XML and RDF files to my gmail (edi.y4nto@gmail.com), I'll take a look when I'
- Mandi: Hi Edi, I am trying to incorporate signature and logo for check printing template in R12. I have converted the blob to clob using getbase64 function
- Edi Yanto: Hi Siva, Images on excel output are not scale itself, so you must change the image size according to what you want. More info about excel limitation
Unknown Feed
- An error has occurred; the feed is probably down. Try again later.
Online Apps DBA
- Weekend Online Oracle R12 Apps DBA Training commencing from 03rd June 2012
- Weekend Online Oracle Weblogic Administrator 11g Training commencing from 02 June 2012
- Confused about Oracle IAM software version & release number ?
- ASM block corruption ORA-01115
- Oracle Adaptive Access Manager (OAAM) for beginners
Visitors
Users Online
Recent Comments