Question

ORA-20112: Report.REPTEXTEXIST: Design-time error! Report Text tCompany is already defined for Report CUS_ITEM_COUNTER_REP

  • 18 October 2021
  • 3 replies
  • 215 views
Priyanjala Silva
Rank
Userlevel 5
Badge +7

Hi All,

 

I have encountered the below error when installing IFSAPP9 UPD17 in customer’s DEV enviornment.

 

!!!Error deploying file payled\CusItemCounter.rdf at 13-OCT-21 11:56:27
!!!Error occurred while executing Plsql Block
BEGIN
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCompany','Company');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCompanyName','Company Name:');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tPrintDate','Print Date');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tDebit','Debit');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCredit','Credit');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tAccumulatedAmount','Accumulated Amount');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tInvoiceNo','Invoice No.');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tTransactionDate','Trans. Date');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tVoucherDate','Voucher Date');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCustomerNo','Customer No.');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCustomerName','Customer Name');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tTransaction','Transaction Type');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tBalBroughtForward','Balance Brought Forward:');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tBalCarriedForward','Balance Carried Forward:');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tPeriodTotal','Period Total:');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCusItemList','Customer Item With Counter Account');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tDeb','D');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCre','C');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tDeb1','D');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCre1','C');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tDebCre','D/C');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tDiscount','Discount');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tWriteOff','Write off');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tDeduction','Deduction');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCurrDiff','Currency loss/profit');   
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCouAccount','Counter,Account');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tSAccounts','Several,Accounts');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tTxCode','Tax,Code');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tVouDate','Voucher,Date');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCurrCode','Currency,Code');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCurrAmnt','Currency,Amount');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tInvoice','Invoice');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tCreditInvoice','Credit Invoice');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tTaxWithhPay','Tax Withh / Paym.');
   Report_SYS.Define_Report_Text_('CUS_ITEM_COUNTER_REP','tTaxWithhInv','.,Invoice,Tax Withh / Inv.');
END;
ORA-20112: Report.REPTEXTEXIST: Design-time error! Report Text tCompany is already defined for Report CUS_ITEM_COUNTER_REP
ORA-06512: at "IFSAPP.ERROR_SYS", line 1017
ORA-06512: at "IFSAPP.ERROR_SYS", line 154
ORA-06512: at "IFSAPP.REPORT_SYS", line 1531
ORA-06512: at line 2

 

 

This error appears in the _ERROR_install.log. No database invalids are created. 

 

I would like to know if there’s a workaround or a way to resolve this error.

 

Thanks,

Priyanjala

 

This topic has been closed for comments

3 replies

J
Rank
Userlevel 6
Badge +14

Hi @Priyanjala Silva ,

When you check the Report_SYS.Define_Report_ method define in the report you can see that 1st it deletes the data in the report_sys_text_tab

 

Method: Report_SYS.Define_Report_

 

So, when deploying the Report_SYS.Define_Report_Text_ section, it should execute without any duplicates. It seems in you deployment for some reason delete data from the report_sys_text_tab has not been done.

Priyanjala Silva
Rank
Userlevel 5
Badge +7

Hi @Janitha Jinarajadasa ,

Thanking for your comments on this. 

I did a report cache refresh from IEE client and re-executed another UPD installation. In the _ERROR_install.log for that installation the above mentioned error didn’t raise. 

 

Could this be an environment/application related error  ?

 

Best Regards,

Priyanjala

J
Rank
Userlevel 6
Badge +14

Hi @Priyanjala Silva ,

Since these are transactions, cache won’t be an issue. But now you have done the installation again and no error means it has executed correctly. According to the code, removal should be happened first and if there’s an error in that block, it should be visible.

Terms & ConditionsCookie settings