Saturday, October 21, 2017

Useful Scripts and Queries

Useful Scripts and Queries

fnd_user_pkg

User Management in Oracle Apps using fnd_user_pkg api

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...

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...

Most Recent