Skip to main content

 

Hello,

 

When creating a custom field expression using the following API:

LORA1APP.ORDER_SUPPLY_DEMAND_API.GET_ORDER_SUPPLY_DEMAND_TAB(CONTRACT, PART_NO, CONFIGURATION_ID, PROJECT_ID)

I receive the following error. I have tried formatting the API with TO_CHAR but no luck. Any guidance on how to resolve this?

 

 

 

I have also tried writing the following SQL statement to return the results field ORDER_SUPPLY_DEMAND_TYPE

SELECT ORDER_SUPPLY_DEMAND_TYPE
FROM CUSTOMER_ORDER_LINE_DEMAND
WHERE order_no = :order_no
AND line_no =:line_no
AND rel_no = :rel_no

 

When using the above SQL argument to create the custom field I receive the following error

 

 

Please advise, Thanks.

Hi @bpamlin 

in which screen do you want to create it?

What is LORA1APP why don’t you use IFSAPP?

@Link I want the Custom Field on the Customer Order Lines screen in IFS.

Lora1app is our super user in test environment. We could also use IFSAPP interchangeably.

 

Thanks, 

Hi @bpamlin 

Seems issue with the used Api function.

ORDER_SUPPLY_DEMAND_API.GET_ORDER_SUPPLY_DEMAND_TAB(CONTRACT, PART_NO, CONFIGURATION_ID, PROJECT_ID)
which returns Table

FUNCTION Get_Order_Supply_Demand_Tab (
   contract_                    IN VARCHAR2,
   part_no_                     IN VARCHAR2,
   configuration_id_            IN VARCHAR2,
   project_id_                  IN VARCHAR2 ) RETURN Custord_Supply_Demand_Tab;

Thanks & Regards
Shan

@Link I want the Custom Field on the Customer Order Lines screen in IFS.

Lora1app is our super user in test environment. We could also use IFSAPP interchangeably.

 

Thanks, 

 

Hi @bpamlin 

I’ve just tested your sql query and it works good.

How did you enter the arguments?

 

THANK YOU @Link that seemed to work for me as well. Much appreciated!

Reply


Terms & ConditionsCookie settings