MarkView Self-Service Invoice : Cannot view SSI barcodes in an environment that was upgraded to MarkView 7.0
4870
Summary
4870
Applies To
- ERP System: Oracle, SAP
- MarkView Version: 7.0 (Note: This can also impact MarkView 6.5).
Behavior
- When a user clicks the Barcode icon on the SSI Request Status page the barcode fails to appear. Instead, a blank page comes up. The mvssi.log indicates that the OC4J is throwing a null pointer exception when attempting to supply this barcode
The SSI request will appear in the Request Status page with a Status of IMPORT. Clicking the barcode icon results in a blank page and no error is observed by the user.
Known Causes
- The 7.0 upgrade inserts a RequestID cover page class property for the Self Service Invoice Packet workitem class. Since this property already exists for the Self Service Invoice class, the second RequestID property is a duplicate and this leads to a SQL statement fetching 2 rows when it will only accept one row.
Resolution
- Disable the duplicate property and change its name so that this duplicate will not be found by the SSI code.
SQL> update mvt_cover_page_class_property cpcp set cpcp.enabled_yn = 'N' where cpcp.cover_page_class_property_id = (select cpcp1.cover_page_class_property_id from mvt_cover_page_class_property cpcp1, sf_workitem_class_property wcp, sf_workitem_class wc where wc.class_name = 'Self-Service Invoice Packet' and wc.workitem_class_id=wcp.workitem_class_id and wcp.property_name = 'RequestID' and wcp.workitem_class_property_id=cpcp1.workitem_class_property_id); SQL> update sf_workitem_class_property wcp set wcp.property_name = 'ImageSource' where wcp.workitem_class_property_id = (select wcp1.workitem_class_property_id from sf_workitem_class_property wcp1, sf_workitem_class wc where wc.class_name = 'Self-Service Invoice Packet' and wc.workitem_class_id=wcp1.workitem_class_id and wcp1.property_name = 'RequestID'); SQL> commit;
Keywords: ssi, self service invoice, self-service invoice