SG-2796 Projects - Flex Business Rules R5PROJECTS.PRJ_PARENT returns NULL on Post Update - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

SG-2796 Projects - Flex Business Rules R5PROJECTS.PRJ_PARENT returns NULL on Post Update

 Description 

*Steps to Reproduce*

1.) Create Flex Business Rules for Table R5PROJECTS, POST UPDATE, Abort on Failure

2.) Flex is:

{noformat}DECLARE

vParent r5projects.prj_parent%type;

vCode r5projects.prj_code%type;

vCoor r5projects.prj_coordin%type;

BEGIN

SELECT nvl(PRJ_CODE, 'NULL'), nvl(PRJ_PARENT, 'NULL'), nvl(PRJ_COORDIN, 'NULL')

INTO vCode, vParent, vCoor

FROM r5projects

WHERE rowid = :rowid;

RAISE_APPLICATION_ERROR(-20001, vCode || ' ' || vParent || ' ' || vCoor );

END;{noformat}

3.) Go to Work | Projects | Projects

4.) Look for a Project with a Parent Project, edit anything then SAVE

*Actual Result*

An error message appears showing the 2nd value NULL

*Expected Result*

An error message appears showing the 2nd value is NOT NULL