Skip to main content
Solved

ORA-04063: package body "IFSAPP.DELIVERY_NOTE_API" has errors

B
Superhero (Employee)
Forum|alt.badge.img+13

Hi Team,

During delivery deployment of non-GET related code we have received the following error. We have noticed that this error occurring when delivery includes the files of ORDER module

Error message:

               !!!Error deploying file SHPMNT.module at 11-AUG-21 11:55:02

               !!!Error occurred while executing Plsql Block

               BEGIN

                  Dbms_Output.Put_Line('Start running Delivery_Note_API.Post_Installation_View at ' || TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'));

                  Delivery_Note_API.Post_Installation_View;

                  COMMIT;

               END;

               ORA-04063: package body "IFSAPP.DELIVERY_NOTE_API" has errors

               ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.DELIVERY_NOTE_API"

               ORA-06512: at line 3

 

Do you have any idea to overcome this error?

Best Regards,
Bhagya

Best answer by Thilini Halgaswaththa

Hi @Bhagya Wickramasinghe :

 

This error occurs when the ORDER component is part of the delivery, but INVOIC is not in the delivery. This issue was introduced from GET bugfix 158663. Deployment issues are in the file DeliveryNote-Ext.plsql.

The issue is in "Delivery_Note_API.Generate_Pt_Tansport_Doc" method

 

               - In the declare-section of the method the variable "order_rec_" is surrounded by "$IF Component_Order_SYS.INSTALLED $THEN".

               - Further down the line "cus_tax_id_             := order_rec_.tax_id_no;" is surrounded by "$IF Component_Invoic_SYS.INSTALLED $THEN"

 

If ORDER module is part of the delivery but INVOIC is not in the delivery, the conditional compilation will skip the declaration of the "order_rec_"  variable but the usage will still be present causing this error.

 

As a solution we need to apply the bug fix 160491 which is in the solution 295998(Deployment issue in file DeliveryNote-Ext.plsql)

 

Hope this will helps you.

 

thanks and regards,

thilini

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

T
Hero (Employee)
Forum|alt.badge.img+7

Hi @Bhagya Wickramasinghe :

 

This error occurs when the ORDER component is part of the delivery, but INVOIC is not in the delivery. This issue was introduced from GET bugfix 158663. Deployment issues are in the file DeliveryNote-Ext.plsql.

The issue is in "Delivery_Note_API.Generate_Pt_Tansport_Doc" method

 

               - In the declare-section of the method the variable "order_rec_" is surrounded by "$IF Component_Order_SYS.INSTALLED $THEN".

               - Further down the line "cus_tax_id_             := order_rec_.tax_id_no;" is surrounded by "$IF Component_Invoic_SYS.INSTALLED $THEN"

 

If ORDER module is part of the delivery but INVOIC is not in the delivery, the conditional compilation will skip the declaration of the "order_rec_"  variable but the usage will still be present causing this error.

 

As a solution we need to apply the bug fix 160491 which is in the solution 295998(Deployment issue in file DeliveryNote-Ext.plsql)

 

Hope this will helps you.

 

thanks and regards,

thilini

S
B
Dinushi Liyanage
4 people like this
  • S
    Sahan Udana
  • B
    Bhagya Wickramasinghe
  • Dinushi Liyanage
    Dinushi Liyanage
  • Ruwandi De Saram
    Ruwandi De Saram
B
Superhero (Employee)
Forum|alt.badge.img+13

Thanks for the information @Thilini Halgaswaththa !

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings