-
Continue reading →: Preventing Duplicate Page Submissions in Oracle APEX
When building web applications with Oracle Application Express (APEX), one common challenge developers face is duplicate page submissions. This usually happens when a user clicks the submit button multiple times or refreshes the page after submitting a form. If not controlled, it can lead to duplicate records, inconsistent data, and…
-
Continue reading →: How to Force “Save As” Dialog for Text Output in Oracle EBS Concurrent Requests
To ensure that text output files from concurrent requests in Oracle E-Business Suite prompt a “Save As” dialog box instead of opening directly in the browser, follow these configuration steps (System Administrator Responsibility): To ensure the output is treated as a downloadable file:
-
Continue reading →: How to Compile Concurrent Program Flexfields
You can compile concurrent program flexfields with below steps (if you have the error message descriptive flexfield……… is not compiled): on EBS Applications, submit concurrent request “Compile Non-Compiled Flexfields” on System Administrator Responsibility on OS Server open putty and run this command fdfcmp apps/<apps password> 0 Y D ‘XXCUST’ ‘$SRS$.XX_CONC_PROG_SHORT_NAME’…
-
Continue reading →: How To Raise User Defined Exception in Oracle PL/SQL
You can raise exception with this below scripts: DECLARE ey_custom EXCEPTION; PRAGMA EXCEPTION_INIT (ey_custom, -20288); BEGIN raise_application_error (-20288, ‘EY – This is a custom error’); EXCEPTION WHEN ey_custom THEN DBMS_OUTPUT.put_line (SQLERRM); END; –OR DECLARE ey_custom EXCEPTION; BEGIN RAISE ey_custom; EXCEPTION WHEN ey_custom THEN RAISE_APPLICATION_ERROR (-20288, ‘EY – This is a…
-
Continue reading →: How To Compress File Using UTL_COMPRESS Package in Oracle
The below code is used to compress the file using standard package (UTL_COMPRESS) in Oracle. DECLARE v_filename VARCHAR2 (100); src_file BFILE; v_content BLOB; v_blob_len INTEGER; v_file UTL_FILE.file_type; v_buffer RAW (32767); v_amount BINARY_INTEGER := 32767; v_pos INTEGER := 1; BEGIN v_filename := ‘EY_TOP.dat’; src_file := BFILENAME (‘EY_DIR’, v_filename); DBMS_LOB.fileopen (src_file, DBMS_LOB.file_readonly);…
-
Continue reading →: How To Enable/Disable Concurrent Parameter Dynamically
Scenario: We want to disable “Sample No” parameter if “Type” parameter value is “Receipt“, otherwise disable “Receipt No” parameter if “Type” parameter value is “Sample” and the parameter must be mandatory if enable. We have to define concurrent program with the following parameters: Type (value are Sample or Receipt, using…
-
Continue reading →: SQL Script to Retrieve List of Profile Values
SELECT p.profile_option_name short_name, n.user_profile_option_name NAME, DECODE (v.level_id, 10001, ‘Site’, 10002, ‘Application’, 10003, ‘Responsibility’, 10004, ‘User’, 10005, ‘Server’, 10006, ‘Org’, 10007, DECODE (TO_CHAR (v.level_value2), ‘-1’, ‘Responsibility’, DECODE (TO_CHAR (v.level_value), ‘-1’, ‘Server’, ‘Server+Resp’)), ‘UnDef’ ) level_set, DECODE (TO_CHAR (v.level_id), ‘10001’, ”, ‘10002’, app.application_short_name, ‘10003’, rsp.responsibility_key, ‘10004’, usr.user_name, ‘10005’, svr.node_name, ‘10006’, org.NAME, ‘10007’,…
Hello,
I’m Edi Yanto
Integration & Automation Consultant | Workato | Oracle EBS/Fusion Technical Consultant | OCA, OCP, OCE
Welcome to My Blog “Oracle Tips That Actually Work”
Let’s connect
Join the fun!
Stay updated with our latest articles and ideas.
Recent posts
Calendars
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
Archives
- January 2026
- November 2025
- June 2018
- March 2018
- December 2017
- January 2017
- June 2016
- May 2016
- June 2015
- December 2014
- September 2014
- May 2014
- April 2014
- August 2013
- April 2013
- November 2012
- May 2012
- March 2012
- January 2012
- May 2011
- April 2011
- March 2011
- July 2010
- June 2010
- April 2010
- October 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- July 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- June 2007
- May 2007
- April 2007
- March 2007
Categories List
Latest Comments
thanks Edi for the script. this is helpful
Thanks Edi Yanto..this is helpfull
Hi Muhammad Lahrasib, You can use the data template (https://ediyanto83.wordpress.com/2014/09/16/oracle-bi-publisher-using-data-template/) to generate the XML file as the engine, do not…
Hi i have a situation here my blob file in 120 kb when i convert it into xml, the xml…
Blog Stats
275,744 hits
Edi Yanto (何 萬 新) 
terbukti berhasil, thanks edi yanto