ORA-00904 "INVENTORY_PART_API"."GET_PART_STATUS" after upgrade from 23.2.9 → 25R1 (25.1.3) on demand planning server

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!