Oracle Apps
Thursday, April 20, 2023
Retaining Date Format in Excel Output from RTF template
›
Sometimes we face issue in getting correct date format in XLS output generated using RTF template. We can retain format selected in Data Tem...
Tuesday, September 22, 2020
Parameterized sql query in PL/SQL block - Bind Variables
›
B eware of parameterized queries. Parameters are sequential and the number changes when you add any additional parameter for new requirement...
Friday, August 10, 2018
›
Business Issue : Form with multiple tabs taking long time to Open Reason : One of block was having multiple Order by clauses and was pick...
FRM-41042: No such property
›
Error while running form - FRM-41042: No such property for set_item_property Cuase : Some visual attribute classes were causing properties ...
Thursday, August 2, 2018
link to ‘Compare to Original PO ‘ – I receive the error that I do not have privileges
›
Custom Responsibility to PO Inquiry causes error - "You have insufficient privileges for the current Operation. Please contact your Sy...
Friday, November 8, 2013
Higher is not better always..
›
Higher is not better always.. I had very tough time with Reports 10g today... I was having below query in After Report trigger.. SELECT a.t...
Comma separated string
›
Using Analytic functions - 25-Oct-18 pass string as '1,2,4,5,678' SELECT REGEXP_SUBSTR (:i_string, '[^,]+', 1, level)...
›
Home
View web version
