Hello Everyone,

We recently upgraded our environment from IFS Cloud 23.2.9 to 25R1 (25.1.3). After the upgrade, we are facing issues with Demand Planning server jobs.

Error observed in logs:

ORA-00904: "INVENTORY_PART_API"."GET_PART_STATUS": invalid identifier IN SELECT PART_NO, CONTRACT, SUBSTR(PART_NO,1,4), ifsapp.COMMODITY_GROUP_API.Get_Description(SUBSTR(PART_NO,1,4)), ifsapp.INVENTORY_PART_CHAR_API.Get_Attr_Value(CONTRACT, PART_NO,'TYPE'), ifsapp.INVENTORY_PART_CHAR_API.Get_Attr_Value(CONTRACT, PART_NO,'TYPE'), ifsapp.INVENTORY_PART_API.Get_Part_status(CONTRACT, PART_NO), ifsapp.Inventory_Part_Status_Par_Api.Get_Description(inventory_part_api.Get_Part_Status(CONTRACT, PART_NO)) FROM ifsapp.INVENTORY_PART WHERE CONTRACT = :1

Symptoms

• The Demand Planning server is up and running, but some jobs fail with the above error.

• When we run the same SQL query directly in the database, it executes without error.

• The error only occurs when the Demand Planning server executes the job.

Questions

1. Has anyone else encountered this after moving to 25R1?

2. Was INVENTORY_PART_API.Get_Part_Status deprecated in 25R1?

3. Is there a new/replacement API introduced for retrieving Part Status? If yes, where do we need to modify this in Demand Planning setup/jobs?

Any guidance or experience would be much appreciated.

Thanks in advance!