Skip to main content

I have a created a Lobby element which is timing out.  I am logged on as user IFSAPP.  The result is the same for two other users.  The PL/SQL query behind the element returns the FIVE records in FOUR seconds

select

contract,

part_no,

ifsapp.inventory_part_cfp.Get_Cf$_Qty_Demand (contract,part_no) qty_demand

from inventory_part ip

where ip.PART_STATUS = 'C'

and ip.CONTRACT = 'PCT'

and ifsapp.inventory_part_cfp.Get_Cf$_Qty_Demand (contract,part_no) >0

 

The Lobby Data source I have created with the same query takes 90 seconds to populate with either “&AO” or “ifsapp” prefix

 

The Lobby element times out and doesn’t return any data after 2 minutes.

The Custom Field referred to is using a select statement:

select ipa.qty_demand from ifsapp.INV_PART_CONFIG_PROJECT_ALT ipa
where ipa.contract = :contract and ipa.part_no = :part_no

Does anyone have any suggestions why the disparity or how to resolve?

Many thanks!

 

Lobby data source

 

Would it help to prepare an IAL that is always live?

Selection on inventory part view/table would then be less intensive.

Is the custom field necessary? Otherwise you could try to do something like this.

SELECT contract,
 part_no,
 qty_demand
FROM ifsapp.inv_part_config_project_alt
WHERE inventory_part_API.get_part_status(contract, part_no) = 'C'
AND contract = 'PCT'
AND qty_demand > 0

The INV_PART_CONFIG_PROJECT_ALT view has a lot of joins and get functions, so it’ll take some time to run. 

 

Thanks for the alternative views; INV_PART_CONFIG_PROJECT_ALT wins the day!

Reply


Terms & ConditionsCookie settings