Monthly Archives: January 2014

Consigned Inventory

    Consigned Inventory is used to manage material owned by Third party. So supplier places the inventory in customer’s store or warehouse and allows them to sell or consume it. Customer purchases the stock only after he resells the stock or…

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’ [] 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

Inventory Forecast – Manual Creation

    This post goes through the manual forecast creation process. This also covers the forecast consumption. We will try to create sales order demand and see how the forecast consumption is affected by this demand. Forecast consumption replaces forecasted demand with…