Archive for January 2009
The Right Person And The Right Time
Posted by: Edi Yanto on: January 24, 2009
Somebody once told me that “Finding the right person is very hard and very wrong…..it is best to be the right person for the one you love and start from there…you’ll always end up disappointed when you set standards and define a “right person” for you…and don’t rush things….cozsomewhere somehow God is preparing somebody for [...]
Securing PDF Output on XML Publisher
Posted by: Edi Yanto on: January 24, 2009
Worked Example I – Securing a PDF output You can now embed any of the XML Publisher properties into your RTF template <<reference to property lists>> These would then be resolved at runtime by the XML Publisher engine; you can either use hard coded values or embed the values inside the incoming XML data. If [...]
Request ID Parameter LoV Not Populated for XML Report Publisher Program
Posted by: Edi Yanto on: January 12, 2009
When you submit the XML Report Publisher Program (XDOREPPB) you are prompted to select the Request ID for the data generation program. The LoV for this parameter is not being populated due to an incorrect profile option reference. To work around this issue, you must change the references to the incorrect profile option in the [...]
How to Get XML File From XML/BI Publisher Report in Oracle Apps
Posted by: Edi Yanto on: January 12, 2009
You can get the XML file from the XML/BI Publisher report based on concurrent request with the below steps: *) View->Requests *) Find the request you’re interested in *) Click on Diagnostics button *) Click the View XML *) Save the file to your PC by doing File->Save As, *.xml Or you can get it [...]
Academic Document Workflow Berbasis XML
Posted by: Edi Yanto on: January 7, 2009
You also can view and download My SlideShare presentation here. SKPL – AcaDocFlow DPPL – AcaDocFlow Screenshot AcaDocFlow
Mudah…Sulit
Posted by: Edi Yanto on: January 7, 2009
You also can view and download My SlideShare here.
APP-AR-96282: Unique Constraint AR.HZ_CUST_ACCT_SITES_U2 Violated
Posted by: Edi Yanto on: January 7, 2009
After entering the address details in Create Customer Form, get error when saving: “APP-AR-96282:Error The following SQL error occured ORA-00001 : unique constraint (AR.HZ_CUST_ACCT_SITES_U2) violated” Cause The current value of sequence hz_cust_acct_sites_s is smaller than the existing data in hz_cust_acct_sites_all.orig_system_reference. select hz_cust_acct_sites_s.currval from dual; returns 3188 SQL> select column_name from dba_ind_columns where index_name=’HZ_CUST_ACCT_SITES_U2′; COLUMN_NAME ORIG_SYSTEM_REFERENCE [...]
11i.AD.I.6 Fails with Error “Pls-00302: Component ‘Is_patch_applied2′ Must Be Declared”
Posted by: Edi Yanto on: January 7, 2009
When attempting to apply Patch 6502082 – 11i.AD.I.6, the following error occurs AutoPatch error: Error while executing statement AutoPatch error: ORA-06550: line 3, column 10: PLS-00302: component ‘IS_PATCH_APPLIED2′ must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored The issue is caused by the following setup: Following package versions for package APPS.AD_PATCH are not created. [...]
Recompile Invalid Objects using DBMS_DDL or Custom Script Using EXECUTE IMMEDIATE
Posted by: Edi Yanto on: January 7, 2009
Operations such as upgrades, patches and DDL changes can invalidate schema objects. For this reason it makes sense to recompile invalid objects in advance of user calls. It also allows you to identify if any changes have broken your code base. In order to compile a program, you must own that program (in other words, [...]
Bagaimana Otak kita Bekerja & Cara Pandangnya ?
Posted by: Edi Yanto on: January 3, 2009
CARA OTAK BEKERJA… Petunjuk “melihat” gambar : – Kalau pandangan mata Anda mengikuti gerakan putaran bulatan warna PINK, maka hanya akan terlihat bulatan satu warna yaitu PINK. – Tapi kalau pandangan mata Anda terpusat ke tanda “+” hitam di tengah, maka bulatan yang berputar akan berubah warnanya menjadi HIJAU. – Kemudian jika pandangan mata Anda [...]
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