Oracle

Oralce Tutorials and Tips

oracle apps session timeout

Log on session is no longer valid. Would you like to log back in so you can continue working?

Log on session is no longer valid. Would you like to log back in so you can continue working? If you do not log in, any outstanding data changes in your forms will not be saved. Getting this message in Oracle Apps frequently. This is session timeout message.  “ICX:Session Timeout” profile controls this in Oracle …

Log on session is no longer valid. Would you like to log back in so you can continue working? Read More »

Oracle Listagg – Combine multiple rows into a single string in Oracle

Oracle Listagg function helps to concatenate multiple rows into a single string. This article explains this in details. Once a developer asked, “How to combine multiple rows into a single string delimited by comma, or pipe?” The requirement is to get email id from a table, concatenate those by “,” and use it as a parameter while …

Oracle Listagg – Combine multiple rows into a single string in Oracle Read More »

How to Compile custom Oracle forms (fmb) and libraries(PLL)

frmcmp_batch or frmcmp_batch.sh is a UNIX level utility available in Oracle Apps to compile custom form(.fmb) and libraries(.pll). Syntax frmcmp Module= Userid=<userid/password> [Parameters] Optional parameters are (default values given): Parameter Description Module_Type=FORM Module type (FORM, MENU, LIBRARY). Statistics=NO Show statistics. Logon=YES Logon to database. Batch=NO Don’t display messages on the screen. Output_File=<file> Write output to …

How to Compile custom Oracle forms (fmb) and libraries(PLL) Read More »

sql developer monitor session

Monitoring Database Sessions using SQL Developer

SQL Developer or TOAD provides a graphical user interface for monitoring database sessions. It shows Active SQL, Explain Plan, Locks, Wait and lot more information. This feature is very much useful for Database Administrator and even developers. Oracle maintains database runtime statistics related to performance in dynamic performance views i.e v$ and gv$ views. Use …

Monitoring Database Sessions using SQL Developer Read More »

fnd_user_pkg

How to use fnd_user_pkg API in Oracle Apps to create, disable user, add responsibility and reset password

FND_USER_PKG is built-in API in Oracle apps for user management from the back-end. In this article, I will share how to use this API for common user management task like user creation, reset password, adding and deleting responsibility. There are many methods available, but mostly we will focus on common methods. create_user Use this API …

How to use fnd_user_pkg API in Oracle Apps to create, disable user, add responsibility and reset password Read More »

Query to get current executing statement in Oracle concurrent program

Use below query to get the current executing statement in Oracle Apps concurrent programs. SELECT va.sql_text ,va.module FROM APPS.fnd_concurrent_requests fcr ,V$SESSION vs ,V$SQLAREA va WHERE fcr.oracle_session_id = vs.audsid AND vs.sql_hash_value = va.hash_value AND fcr.request_id = <request_id>; Table Information fnd_concurrent_requests:- This table holds the history of all submitted program in Oracle Apps like request id, request …

Query to get current executing statement in Oracle concurrent program Read More »

Oracle report builder stopped working

Oracle Reports Builder stopped working in Windows

Sometimes Oracle Reports Builder crashes in Windows environment. Especially when you are working on Apps upgrade (11i–> R12)  project and retrofitting Reports from 6i to 10G. You, Open report builder 10g Connect to database Open a custom report Report builder goes in not responding stage and after sometime crashes giving below error message.   Reports Builder …

Oracle Reports Builder stopped working in Windows Read More »

FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output

Emailing concurrent request output is a common requirement in any business. You can email a concurrent request output in Oracle Apps using Delivery Options while submitting the request or using API FND_REQUEST.ADD_DELIVERY_OPTION or FND_DELIVERY. You should use this API when you are submitting a concurrent request from backend using PL/SQL.I will explain how to use fnd_request.add_delivery_option and fnd_delivery option, before that, …

FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output Read More »