Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'Item Supply/Demand' Form

bsc1000May 27 2009 — edited May 28 2009
Hi All,
Our requirement is to find out the available quantity which shown on ‘Item supply/Demand’ form through custom concurrent program .
So we have used code from Form which calls package INV_TM.LAUNCH which in turns
Call concurrent program INXDSD. Using above pack we can able to produce data
In table MTL_SUPPLY_DEMAND_TEMP but we could find following mismatch :
1.Column Value ‘ON_HAND_QUANTITY’ from table and ‘Avail Quantity’ Field from FORM do not match .
2.Above package return two values for variables TOTAL_TEMP and AVAIL_QTY_TEMP
In our code package returns NULL for these two columns.

These two values are used to show ‘Avail Quantity’ Field in form.

do anyone know why two values are returned as NULL or any alternative aprroach for this ?
Appreciate help on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2023
Added on May 27 2009
3 comments
1,854 views