Error in Manager Self Service when Submit Request with Multiple Requester Comments: "First operand of . is NULL, so cannot access member FindAppRecThread. (180,236)" (Doc ID 2032310.1)

Last updated on JANUARY 23, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

HTML Email approval for Employee transfer Requests ( also for other approvals eg: Promotion, Terminate ).

User getting error in MSS Transfer Employee (or Promote Employee) component when submit request with high volume of Requester comments.

Note: System works fine when comments are less.
 
Fatal SQL error occur in Transfer, Promotion Transaction and other transactions where HTML emails are enabled
  

ERROR

First operand of . is NULL, so cannot access member FindAppRecThread. (180,236) EOAW_CORE.ApprovalManager.OnExecute Name:AddComments PCPC:11027 Statement:199
Called from:HMAF_AWE.WRAPPERS.ApprovalManager.OnExecute Name:AddComments Statement:19
Called from:HR_TRANSFER_MGR.GBL.SavePostChange Statement:26

The first operand of the dot operator is the NULL value, indicating the lack of any object value. As a consequence, the given method or property cannot be used



STEPS

The issue can be reproduced at will with the following steps:
1. Enable HTML email feature for the approval transaction (either Promotion or Transfer employee)
2. Navigate to Main Menu->MSS->Job and Personal Inf->Transfer employee
3. Enter higher volume of comments
4. Click on Submit
5. Get the above error.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms