Question

ORA-20105: Report.REPCACHECOLERR: Report column [CUSTOMER_ORDER_DELIV_NOTE_REP.ALT_DELIV_NOTE] or comments are invalid. Error [ORA-06508: PL/SQL: could not find program unit being called] raised

  • 18 October 2021
  • 5 replies
  • 556 views

Userlevel 5
Badge +7

Hi All,

I have encountered the below error when installing IFSAPP9 UPD17 in a customer’s DEV environment (Customer gets update from UPD10 to UPD17). This error appears in the _ERROR_install.log but doesn’t lead to any database invalid objects.

 

!!!Error deploying file order\CustomerOrderDelivNote.rdf at 13-OCT-21 11:56:01
!!!Error occurred while executing Plsql Block

BEGIN
   Report_SYS.Define_Report_('CUSTOMER_ORDER_DELIV_NOTE_REP','ORDER','CustomerOrder','Delivery Note','ORDER_INFO_SERVICES_RPT','CUSTOMER_ORDER_DELIV_NOTE_RPI.Report_Delivery_Note',30,NULL,NULL,NULL,'PLSQL1.2');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'DELIVNOTE_TITLE', 'Delivery Note');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'PAGE_FOOTER_TITLES','Visit Address,Invoice Address,Phone,Fax,Bank Giro,Postal Giro,Tax Number');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CUSTOWN_TITLE', 'Owned by Customer');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'SUPOWN_TITLE', 'Owned by Supplier');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'INPUT_UOM', 'Derived from');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'GTIN14_TITLE', 'GTIN 14 No:');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'SEE_DEL_NOTE', '-- See delivery note lines --');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CATCH_UNIT', 'Catch Unit:');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'BARCODE_ID', 'Barcode ID:');
   -- Argentinean report begin
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'NUMERATION_GROUP_AR','R');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'DELNOTE_TEXT1','This document');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'DELNOTE_TEXT2','is not valid');
   Report_SYS.Define_Report_Text_('CUSTOMER_ORDER_DELIV_NOTE_REP', 'DELNOTE_TEXT3','as invoice');
   -- Argentinean report end
   Report_SYS.Refresh_('CUSTOMER_ORDER_DELIV_NOTE_REP');
   Report_Lu_Definition_API.Clear_Custom_Fields_For_Report('CUSTOMER_ORDER_DELIV_NOTE_REP');
   Report_Lu_Definition_API.Enable_Custom_Fields_for_Lu('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CustomerOrder', 'CUSTOMER_ORDER_DELIV_NOTE_REP');
   Report_Lu_Definition_API.Enable_Custom_Fields_for_Lu('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CustomerOrderLine', 'CUSTOMER_ORDER_DELIV_NOTE_REP/ORDER_LINES/ORDER_LINE');
   Report_Lu_Definition_API.Enable_Custom_Fields_for_Lu('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CustomerOrderReservation', 'CUSTOMER_ORDER_DELIV_NOTE_REP/ORDER_LINES/ORDER_LINE/SERIAL_PARTS/SERIAL_PART');
   Report_Lu_Definition_API.Enable_Custom_Fields_for_Lu('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CustomerOrderReservation', 'CUSTOMER_ORDER_DELIV_NOTE_REP/ORDER_LINES/ORDER_LINE/INPUT_VALUES/INPUT_VALUE');
   Report_Lu_Definition_API.Enable_Custom_Fields_for_Lu('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CustomerOrderLine', 'CUSTOMER_ORDER_DELIV_NOTE_REP/ORDER_LINES/ORDER_LINE/PACKAGE_LINES/PACKAGE_LINE');
   Report_Lu_Definition_API.Enable_Custom_Fields_for_Lu('CUSTOMER_ORDER_DELIV_NOTE_REP', 'CustomerOrderReservation', 'CUSTOMER_ORDER_DELIV_NOTE_REP/ORDER_LINES/ORDER_LINE/PACKAGE_LINES/PACKAGE_LINE/SERIAL_PARTS/SERIAL_PART');
END;
ORA-20105: Report.REPCACHECOLERR: Report column [CUSTOMER_ORDER_DELIV_NOTE_REP.ALT_DELIV_NOTE] or comments are invalid. Error [ORA-06508: PL/SQL: could not find program unit being called] raised
ORA-06512: at "IFSAPP.REPORT_SYS", line 2118
ORA-06512: at line 18

 

I have manually deployed order\CustomerOrderDelivNote.rdf file in the database and it was successful without any errors. Customer’s harvested code is same as Archive code.

 

Please let me know if anyway to resolve this issue.

 

Thanks,

Priyanjala


This topic has been closed for comments

5 replies

Userlevel 5
Badge +12

Hi,

This could be due to report name exceeding the maximum allowed character length 30 hence db objects associated having issues in the dictionary.

 

Check if any views exceeding the length by below sql and alter the names where necessary 

 

SELECT  table_name ,Dictionary_SYS.Comment_Value_('LU', comments)

      FROM   fnd_tab_comments

      WHERE  table_type = 'VIEW'

      AND    LENGTH(Dictionary_SYS.Comment_Value_('LU', comments)) > 30

Userlevel 5
Badge +7

Hi @Ruchira ,

 

Thanks for your suggestion. I have executed the above mentioned query in the DEV database. But it didn’t return any views exceeding the maximum no. of characters.

 

 

Best Regards,

Priyanjala

Userlevel 6
Badge +14

Hi @Priyanjala Silva ,

 

Force report cache and see whether it works
1.Force a Full Refresh of the cache via BEGIN Report_SYS.Refresh_Active_List__(1, 'TRUE'); END;
2.Force a refresh of the report via BEGIN Report_SYS.Refresh_('CUSTOMER_ORDER_DELIV_NOTE_REP'); END;

Userlevel 3
Badge +4

Hi Priyanjala,

Just mentioning below info. which I noticed, not exactly sure the reason for the error though.

Column ALT_DELIV_NOTE is adding to the view CUSTOMER_ORDER_DELIV_NOTE_REP from
ORDER_INFO_SERVICES_RPV

H.&ALT_DELIV_NOTE          ALT_DELIV_NOTE

&VIEW_RPV H

DEFINE VIEW_RPV          = ORDER_INFO_SERVICES_RPV

 

Noticed that two column comments for the column ALT_DELIV_NOTE in the creation of the view CUSTOMER_ORDER_DELIV_NOTE_REP.

COMMENT ON COLUMN &VIEW..ALT_DELIV_NOTE IS
   'FLAGS=A----^DATATYPE=STRING(50)/UPPERCASE^TITLE=Alt. Delivery Note:^QUERY=Alt. Delivery Note:^QFLAGS=-CS--^ITEM_NAME=iAltDelivNote^';

-- Additional comments for columns only used to Argentina report...

COMMENT ON COLUMN &VIEW..ALT_DELIV_NOTE IS
   'FLAGS=A----^DATATYPE=STRING(50)^TITLE=Numeration:^ITEM_NAME=iAltDelivNote^';

 

CORE Database, the created view has
comment on column CUSTOMER_ORDER_DELIV_NOTE_REP.ALT_DELIV_NOTE is 'FLAGS=A----^DATATYPE=STRING(50)^TITLE=Numeration:^ITEM_NAME=iAltDelivNote^';

 

Just wandering any changes in ORDER_INFO_SERVICES_RPV or any report cache issue for the column comments (as there are two for the column ALT_DELIV_NOTE ) affects for the error during the installation time.

 

Best Regards,

Prabhavi.

Userlevel 5
Badge +7

Hi @Priyanjala Silva ,

 

Force report cache and see whether it works
1.Force a Full Refresh of the cache via BEGIN Report_SYS.Refresh_Active_List__(1, 'TRUE'); END;
2.Force a refresh of the report via BEGIN Report_SYS.Refresh_('CUSTOMER_ORDER_DELIV_NOTE_REP'); END;

Hi @Janitha Jinarajadasa ,

 

I have tried the steps you mentioned and started new installation. But still the error appears in the _ERROR_install.log of the new installation as well.

 

Thanks,

Priyanjala Silva