There may be various reasons for the above error. Sometimes the open cursor does not closing and loop is running without closing the cursor in the database level source code. What kind of invoices you are going to Print?
Useful information Chamaka. Thank you for sharing
Hi @Daviddavid ,You can refer the below link for the details of creating plugins.https://docs.ifs.com/techdocs/Foundation1/050_development/025_operational_reporting/190_using_report_plugins/Also use the sup topic ‘Create a plugin’ for your requirement. Hope this will help thanks,thilini
Hi,What is the application version? APP9 or APP10? We may need to check this from the database side? can you mentioned the method name correctly? thanks,thilini
Hi, You can extract the report data in XML_Report_Data_tab to the excel from the data base directly. Or do you need to extract report to excel from client side? Is this report with huge data set? thanks and regards,thilini
@Rakesh :What is your application track? Is it Application APP10? /thilini
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
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.