We have done quite a number of code customisations without problems but this time we have got an error during the order delivery even though everything worked fine during the environment and sanity builds.
Start running Inventory_Part_API.Post_Installation_View at 2023-10-03 18:58:56
!!!Error occurred while executing Plsql Block at 03-OCT-23 18:59:11
BEGIN
Dbms_Output.Put_Line('Start running Inventory_Part_In_Stock_API.Post_Installation_View at ' || TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'));
Inventory_Part_In_Stock_API.Post_Installation_View;
COMMIT;
END;
ORA-04063: view "IFSAPP.SINGLE_MANUAL_RESERVATION" has errors
ORA-04063: view "IFSAPP.SINGLE_MANUAL_RESERVATION" has errors
ORA-06512: at "IFSAPP.INVENTORY_PART_IN_STOCK_API", line 25618
ORA-06512: at line 3
I can’t see a reason for the error. The view definitions look ok. Why would an error happen during order delivery which didn’t happen during the previous builds?
Any help much appreciated!