Webservice call from PLSQL

This article demonstrates the way we can call a webservice from oracle PLSQL. For the purpose of the demonstration we will be calling webservice provided by ‘AddressDoctor’ [http://www.addressdoctor.com/en/] for validating an address. We will build the SOAP request XML file…

Scheduled Programs Query

Below query gives the list of concurrent programs that are scheduled

For viewing more details about concurrent program, navigate to this link For viewing more details about concurrent requests, navigate to this link

Concurrent Request Queries

Below query gives the details of concurrent request(s)

For viewing more details about a concurrent program, navigate to this link

Concurrent Program Queries

Following queries gives details about concurrent program 1. Query to retrieve concurrent program or request set details

For viewing more details about concurrent request, navigate to this link 2. Query to retrieve the parameters for a concurrent program

BOM Explosion API

This blog details exploding a Bill of Material (BOM) for a model given a model number and organization code. It explodes the latest revision BOM. In case BOM of a prior revision has to be retrieved then l_rel_date variable can…

Users logged in the system

Following query gives the users who are logged into the system This query has 2 portions (1) Users who are using a form function (2) Users who are active since 1 minute