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.

Related posts:

Query to Find Schema and its status

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


 

Related posts:

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.

Related posts:

Split Delivery Detail API

Standard API to Split the Delivery detail:

 

Related posts:

Auto create Delivery using WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES

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:

 

Related posts: