[HIFIS3 LIST] Hifis ACER #: 01966 Field Detailline Does Not Accept Null Values >>> Approved

  • From: <henry.dagher@xxxxxxxxxxxxxxxxx>
  • To: <henry.dagher@xxxxxxxxxxxxxxxxx>, <Maria.Wallenius@xxxxxxxxxxxx>, <hifis-sisa@xxxxxxxxxxxxxxxxx>, <hifis3@xxxxxxxxxxxxx>
  • Date: Tue, 12 Jan 2010 11:14:34 -0500

Category:  Report: Fix / Reports

Originator:  Dagher, Henry            

Priority:  High

Issue
Field DETAILLINE does not accept null values. (      1581) 
C:\DOCUME~1\MARIAW\LOCALS~1\TEMP\000046C903QU.FXP Line # 201 

Solution:
Jason: Report is Attendance Yearly... Elena resolved it previously by running 
DQ tools and correcting errors. It is missing lookups.

Users are advised to run Data Quality tools to detect broken lookups links and 
fix them.

On our side, we will need to wrap Lookups call with NVL() to avoid a crash. An 
NVL() should yield text indicating the link is bad; e.g. a user-friendlier 
version of 'Invalid Lookup link'.

Status:  Approved

Assigned to: Diaz, Jorge              


Currently Open ACERs Statistics
===============================
Bug               49
Change Request   110
DataConv: Fix      1
DataConv: New      3
Issue              3
New Feature       32
New Module         4
Report: Change    32
Report: Fix       17
Report: New       50
-------------------------------
Total Open ACERs    301

Other related posts:

  • » [HIFIS3 LIST] Hifis ACER #: 01966 Field Detailline Does Not Accept Null Values >>> Approved - henry.dagher