Posts Tagged ‘troubleshooting’
Invoice Listing with Repeatable Row Header and Splitting Rows Across Pages on Oracle XML Publisher
Posted by: Edi Yanto on: May 21, 2008
Repeatable Row Headers
If your transactions/invoices break across a page and you want to repeat the column header row this can be achieved using MSWord’s functionality.
Highlight the header row
Table > Table Properties
Under the Row tab select the ‘Repeat as Header row at the top of each page’
If the transactions/invoices table breaks [...]
How to open Excel Spreadsheets from Oracle Applications Concurrent Request
Posted by: Edi Yanto on: March 11, 2008
If you want to make XML Output to be displayed with Excel Spreadsheets when run the reports in Concurrent Request, you must add the highlighted line in System Administrator > Install > Viewer Options.
If your concurrent request using XML Publisher, at run time when you click on the Options button, you should see the [...]
How to View Oracle Reports in Oracle Apps
Posted by: Edi Yanto on: December 26, 2007
- In: Oracle
- 2 Comments
When viewing report output (View -> Requests menu, Find button, place your cursor on the row of the report that you want to view, View Output button) using the standard Oracle Report Viewer, select Tools -> Copy File menu to open the report in a web browser (such as Netscape Navigator or Internet Explorer).
a.) If [...]
Use a FOR UPDATE Cursor
Posted by: Edi Yanto on: December 18, 2007
The cursor FOR UPDATE clause is only used with a cursor when you want to update tables in the database. Generally, when you execute a SELECT statement, you are not locking any rows. The purpose of using the FOR UPDATE clause is to lock the rows of the tables that you want [...]
Assigning Nested Tables with Set Operators
Posted by: Edi Yanto on: May 16, 2007
The SQL language has long offered the ability to apply set operations (UNION, INTERSECT, and MINUS) to the result sets of queries. In Oracle Database 10g, you can now use those same high-level, very powerful operators against nested tables (and only nested tables) in your PL/SQL programs and on nested tables declared as columns inside [...]
Possible Exceptions for Collection Assignments
Posted by: Edi Yanto on: May 15, 2007
Assigning a value to a collection element can cause various exceptions:
If the subscript is null or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must be an integer. Associative arrays can also be declared to have VARCHAR2 subscripts.
If the subscript refers to an uninitialized element, PL/SQL [...]
Exit Early from Nested FOR Loop
Posted by: Edi Yanto on: May 14, 2007
If you want to exit from any enclosing loop, but not just the current loop, you can label the enclosing loop and use the label in an EXIT statement.
<<outer>>
FOR i IN 1..5 LOOP
. . . . .
FOR j IN 1..10 LOOP
. . . . .
EXIT outer WHEN . . . .
. . . . .
END [...]
Tuning PL/SQL Procedure Calls with the NOCOPY Compiler Hint
Posted by: Edi Yanto on: May 1, 2007
NOCOPY is a hint to the compiler about how you would like the PL/SQL engine to work with the data structure being passed in as an OUT or IN OUT parameter. By default, OUT and IN OUT parameters are passed by value. The values of any IN OUT parameters are copied before the subprogram is [...]
Suppress Duplicate Values in Oracle
Posted by: Edi Yanto on: April 18, 2007
In the below example, we can suppress duplicate values in the MGR column, display a blank line between manager number groups, and suppress the display of repeated values in the DEPTNO column using the BREAK command.
SQL> BREAK ON mgr SKIP 1 ON deptno
when the query executes, the report output is organized based on the specifications [...]
Tuning the Oracle8i Database
Posted by: Edi Yanto on: April 16, 2007
The below step are for optimizing performace of Oracle8i Database :
Tune architecture and design of the data model.
Tune Applications. It’s important to design efficient SQL statements. Efficient SQL Statement take less time to process. You must also consider the data access and manipulation operations in detail.
Tune memory structures, memory tuning involves tuning the System [...]
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- Tuning PL/SQL Procedure Calls with the NOCOPY Compiler Hint
- The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
- Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor Variables
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- APP-AR-96282: Unique Constraint AR.HZ_CUST_ACCT_SITES_U2 Violated
- Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances
- The Right Person And The Right Time
- Error fetch out of sequence in Payables Open Interface Import (APXIIMPT)
- DAUN, POHON DAN ANGIN
- How to View Oracle Reports in Oracle Apps
- 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
Unknown Feed
- An error has occurred; the feed is probably down. Try again later.
Visitors
Users Online
Recent Comments