My Oracle Support Banner

Unable To Update Patientlist (Doc ID 280389.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Healthcare Transaction Base - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

 Get the following error when trying to update the PatientList on the server:
oracle.apps.ctb.fwk.base.common.CTBException
TYPE_PARAM = ERROR
CODE_PARAM = FND_RECORD_DELETED_ERROR
MESSAGE_PARAM = Unable to perform transaction on the record.
Cause: The record has been deleted by another user.
Action: Re-query the records to get the new data.

Steps to duplicate:

Step 1:
getting an existing patientList from the server
************************************************
PatientListQueryCriteria criteria =
getPatientListHelper().newPatientListQueryCriteria();

criteria.setRootSearchTerm(criteria.createSearchTerm(PatientListQueryCriteria.PA
TIENTLIST_NAME,"TEST_LIST"));

PatientList[] lists = getPatientListService().findPatientLists(criteria);

PatientList foundlist = lists[0];
************************************************

Step 2:
updating the local PatientList
************************************************
PatientListFilter filter = getPatientListHelper().newPatientListFilter();
filter.setColumnType("STAFF_ID");
filter.setEqualsString("4");

foundlist.setFilters(new PatientListFilter[]{filter});
foundlist.setOperationAsUpdate();
********************************************************

Step 3:
trying to update the PatientList on the server but an exception is thrown
**********************************************************
PatientList[] newlist = getPatientListService().updatePatientLists(new
PatientList[]{foundlist});

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!


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