Replies posted by Thilini Halgaswaththa

7 Replies

B
Superhero (Employee)
Bhagya WickramasingheSuperhero (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

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

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

2
B
Superhero (Employee)
2 years ago
R
Sidekick (Partner)
RakeshSidekick (Partner)
asked in Finance (Financials)

Manual Supplier Invoice Pdf

@Rakesh :What is your application track? Is it Application APP10? /thilini

5
R
Sidekick (Partner)
2 years ago
N
Sidekick (Partner)
nimesh
asked in Finance (Financials)

How to extract Report Generator Reports to Excel?

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 

5
AkilaR
Hero (Partner)
2 years ago
O
Do Gooder (Customer)
oliver.monaghanDo Gooder (Customer)
asked in Finance (Financials)

ORA-20105: Assert.IS_PKG_METHOD: "Intface_Util_API." is non existing package method.

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

4
P
Hero (Employee)
2 years ago
D
Do Gooder
DaviddavidDo Gooder
asked in Finance (Financials)

General Ledger Accounts Report to Excel

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

4
T
Hero (Employee)
2 years ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Keyboard shortcuts

Useful information Chamaka. Thank you for sharing 

10
A
Hero (Employee)
2 years ago
H
Do Gooder (Customer)
hlhasangaDo Gooder (Customer)
asked in Finance (Financials)

ORA-01000: maximum open cursors exceeded

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?

9
Dinushi Liyanage
Hero (Employee)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings