Category Archives: Scripts

Concurrent Program with Parameter Details

Below query is used to pull Concurrent Program, Parameters and from which Responsibility it can be Run.

Thanks Khadeer B for Providing the Query.

Query to Find Schema and its status

Query to list out the Schemas and the status of the products in Oracle Applications.


Send Email using UTL_SMTP

Send Email using UTL_SMTP:

Sample Script to Send email from PLSQL Code using UTL_SMTP:

A Special Thanks to Rajanikanth Yeturi for Providing this article.

Split Delivery Detail API

Standard API to Split the Delivery detail:



Auto create Delivery

Auto Create a delivery for a Delivery Detail.

Find the delivery detail id from the booked sales order line and pass as a parameter.

Sample script to Auto create deliveries:

Script to verify the script: