Posts Tagged ‘troubleshooting’
Migrate To New Domain http://ediyanto.co.cc
Posted by: Edi Yanto on: April 22, 2009
Please visit my new domain at http://ediyanto.co.cc
C U there…
Update (as of 08-Nov-2009):
- Oracle Top-N Query
- Bersyukurlah…
- Cinta Sejati
- Nice Story
- 5 Tips Agar Tak Mudah Lelah
- Belajar dari Alphabet
- How To Get the List of All Responsibilities Assigned To A User
- Query To Find Multi-Org Is Enabled Or Not
- How To Find A [...]
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Posted by: Edi Yanto on: April 19, 2009
Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
MetaLink has a very detailed and informative article concerning ORA-01652 and RAC. There is some troubleshooting required [...]
How to add Value in Lookups with Access Level System
Posted by: Edi Yanto on: February 15, 2009
- In: Oracle
- 2 Comments
The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
Posted by: Edi Yanto on: February 7, 2009
- In: Oracle
- 4 Comments
Three possible errors can occur as below:
The Output Post Processor is not running or does not pick up the request
…
+————- 1) PUBLISH ————-+
Unable to find an Output Post Processor service to post-process request [request_id].
Check that the Output Post Processor service is running.
+————————————–+
…
Solutions:
* Verify that the Output Post Processor is enabled and active.
* If confirmed, [...]
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 [...]
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
ORG_ID
But client has records in [...]
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.
$AD_TOP/patch/115/sql adphpchb.pls 115.16
$AD_TOP/patch/115/sql adphpchs.pls 115.11
To implement the [...]
Unable to View EXCEL Output (XML Publisher) from Concurrent Program Request
Posted by: Edi Yanto on: December 17, 2008
While running XML Publisher report for EXCEL output, the Concurrent Program has the error message :
“ORA-1403: no data found”
The cause of this problem has been identified in Bug 4396843 by Metalink.
The output of the report can be viewed from menu Request > Monitor through System Administration Responsibility or you can solve this problem by 2 [...]
How To Add Workflow Worklist To E-Business Suite Home Page
Posted by: Edi Yanto on: July 9, 2008
Set the following profile options for the user who performs the Home Page personalization: Personalize Self Service Definition – Yes and FND: Personalization Region Link – Yes
Login to Applications Home Page and select the ‘Personalize Page’ link.
In the search option look for the “Row Layout” value in the list of values
(style field) and click on [...]
Unable To Install Oracle Workflow Builder On Windows Vista
Posted by: Edi Yanto on: July 8, 2008
- In: Oracle
- 5 Comments
When you try to install the Oracle Workflow Builder on Vista, the following error appears:
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be 4.0, 5.0, 5.1 or 5.2. Actual 6.0
Failed <<<<
Oracle Workflow Builder Client has not been Certified yet to run on Windows Vista.
To configure the compatibility mode for an application, just locate the installation [...]
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- Edi Yanto: Hi Ang, You can find the solution for this problem at http://www.ediyanto.co.cc/unable-to-view-excel-output-xml-publisher-from-concurrent-program-req
- ang: xml view output to excel ORA-01403: no data found -------------------------------------------------------------- FRM-40735: WHEN-BUTTON-PRESSED
- Edi Yanto: Hi Ricky, Have you try to set the security setting (Enable Automatic prompting for file download) for your internet/local/trusted sites zone at inter
Edi Yanto (何万新)
- Oracle Top-N Query October 2, 2009Using RANK function, with a faster execution plan (WINDOW SORT PUSHED RANK) SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal, RANK() OVER (ORDER BY SAL Desc) AS Emp_Rank FROM Emp) WHERE Emp_RankEdi Yanto
- Bersyukurlah… June 30, 2009AKU TAK SELALU MENDAPATKAN APA YANG KUSUKAI oleh karena itu AKU SELALU MENYUKAI APAPUN YANG AKU DAPATKAN. Kata-kata di atas merupakan wujud syukur. Syukur merupakan kualitas hati yang terpenting. Dengan bersyukur kita akan senantiasa diliputi rasa damai, tentram dan bahagia. Sebaliknya, perasaan tak bersyukur akan senantiasa membebani kita. Kita akan selalu […]Edi Yanto
- Cinta Sejati June 30, 2009Kenapa kita menutup mata ketika kita tidur ? Kenapa kita menutup mata ketika kita menangis ? Kenapa kita menutup mata ketika kita membayangkan sesuatu ? Kenapa kita menutup mata ketika kita berciuman ? Hal hal yang terindah di dunia ini biasanya tidak terlihat Ada hal hal yang tidak ingin kita lepaskan dan ada orang orang yang tidak ingin kita tinggalkan Tap […]Edi Yanto
- Nice Story June 8, 2009Share on FacebookEdi Yanto
- 5 Tips Agar Tak Mudah Lelah June 2, 2009Sebagian orang mengeluhkan kondisi tubuhnya yang cepat capai atau lelah. Kebanyakan orang menilai hal itu diakibatkan kerja ekstra. Tetapi, sebenarnya hal itu dilatarbelakangi kebiasaan seseorang sehari-hari. Berikut lima tips yang dikutip VIVAnews dari WebMD, Sabtu 25 April 2009 agar kondisi tubuh Anda tidak mudah capai atau lelah. 1. Lapar atau tidak, sara […]Edi Yanto
- Belajar dari Alphabet May 29, 2009A : AcceptTerimalah diri anda sebagaimana adanya. B : BelievePercayalah terhadap kemampuan anda untuk meraih apa yang anda inginkan dalam hidup. C : CarePedulilah pada kemampuan anda meraih apa yang anda inginkan dalam hidup. D : DirectArahkan pikiran pada hal-hal positif yang meningkatkan kepercayaan diri. E : EarnTerimalah penghargaan yang diberi orang lai […]Edi Yanto
- How To Get the List of All Responsibilities Assigned To A User May 29, 2009 Edi Yanto
- Query To Find Multi-Org Is Enabled Or Not May 29, 2009SELECT DECODE (multi_org_flag, ‘Y’, ‘Multi-Org Enabled’, ‘Multi-Org Disabled’ ) FROM fnd_product_groups; Share on FacebookEdi Yanto
- How To Find A Patch Is Applied For A Bug May 29, 2009 Edi Yanto
- Excel Limitations on Images in Oracle Apps May 23, 2009The 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 binary [...]Edi Yanto
Blogs.oracle.com Recent Posts (all languages)
- Paul Vocker on IFRS
- 週末はちょっとおしゃれな外苑前でスキルアップ 2/2 - ストレージ管理&チューニング -
- 週末はちょっとおしゃれな外苑前でスキルアップ 1/2 - アプリ・テスト -
- Moving of internal blog entries here
- Office 2007 files in SES 10.1.8.4
- Parallel Processing in ODI
- You're Invited: OPN Specialized Launch
- Уровни партнерства в новой программе и ключевые преимущества
- A Time/Hour Selector in ADF Faces - Did you know?
- Around the World
Online Apps DBA
- Autoconfig in Oracle Apps R12 adautocfg.sh
- Oracle Service Bus 10.3.1 Installation
- Unable to call fnd_ldap_wrapper . create_user / update_user ORA-20001
- Custom Schemas are not analyzed when Gather Schema Statistics are submitted.
- How to create FMW 11g schemas (SOA, WebCenter) on Solaris (non Windows/Linux) platform ?
Visitors
Users Online
Recent Comments