My Oracle Support Banner

Getting Error 'First operand of . is NULL, so cannot access member RetrieveKeyfieldsString. (180,236)' on Document Version Link When Original Document is Deleted (Doc ID 2972294.1)

Last updated on NOVEMBER 02, 2023

Applies to:

PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Getting an error when trying to access the document version history of a copied document after the original document is deleted:

First operand of . is NULL, so cannot access member RetrieveKeyfieldsString. (180,236) SCM_CS_DOC_MGMT.DocumentUtilities.OnExecute Name:GetNameFromDocID PCPC:18899 Statement:301
Called from:CS_DOC_HIST_WRK.DESCR50_CS.RowInit Statement:5
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

OK

Error in PeopleCode ScrollSelect processing. (2,213) SCM_CS_DOC_MGMT.Controller.Doc_Controller.OnExecute Name:SelectHistoryRows PCPC:89795 Statement:1599 Called from:SCM_CS_DOC_MGMT.Controller.Doc_Controller.OnExecute Name:ViewHistory Statement:1591 Called from:CS_DOC_WRK.VIEW_HISTORY_PB.FieldChange Statement:1 

A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function. This error may have been described by a preceding message. 

Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.


The issue can be reproduced at will with the following steps:

  1. Select an existing draft document. Go to: Menu > Supplier Contract > Create Contracts and Document > Document Management. Find an Existing Document
  2. Check the original document Doc id for the original document: SELECT * FROM PS_CS_DOC_ALLKEYVW WHERE CS_CONTENT_ID = 'XXXXXX'
  3. The Doc id is available in the cs_doc_hdr table: SELECT * FROM PS_CS_DOC_HDR WHERE CS_DOC_ID = 'XX'; 
  4. Copying a new document from the above document. Go to Menu > Supplier Contract > Create Contracts and Document > Document Management.
  5. Select Ad Hoc id: ‘XXXXXX’. ok
  6. Click Create Document button. At Wizard Execution go to next until 'finish'
  7. Document created. Go to Document Version History. Access Document History without any issue
  8. Doc_id details for the copied document:
    1. SELECT * FROM PS_CS_DOC_ALLKEYVW WHERE CS_CONTENT_ID = 'XXXXXXX';
    2. SELECT * FROM PS_CS_DOC_HDR WHERE CS_DOC_ID = 'XXX';
  9. The origin id for the copied document with copy action points to the doc id of the original document: select cs_doc_id_orig from ps_cs_doc_hdr_hist where cs_doc_id = 'XXX'
  10. Now the original document is deleted
  11. Go back to document created. Go to Document Version History link. Getting the error above

  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.