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 |