Duplicated Record Validation In Script Does Not Work (Doc ID 2018287.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.9 [23016] version, Configuration - General

While Having a call and WebEx session with the Customer the issue was clarified.

ACTUAL BEHAVIOR
---------------
The Duplicated Record Messages are not displayed properly when More than one Record is created with Same "Account Name" value. Duplicate validation is not triggering.

EXPECTED BEHAVIOR
-----------------------
Duplicate validation should happen properly and Error Message should be Displayed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Log into the Siebel Tools, Query for the BbusComp Name "CUT Invoice Sub Accounts" and Create a New Calculated Field "LN Num of FA"
2. Enter the Calculated value as like Below
GetNumBCRows('Account', 'CUT Invoice Sub Accounts', '[Parent Account Id]="' + GetProfileAttr("ACCNTID") + '" AND ([Account Type Code] = "' + LookUpValue ("CUT_ACCOUNT_TYPE","Billing") + '" AND [Name] = "' + [Name] + '")', 'All')
3. On the BC Levelm Right Click and Select the Option "Edit Server Scripts" and Select PreWriteRecord Event
4. Populate the Below Code
if (LNNumofFA >= 1)
  {
  TheApplication().RaiseErrorText("FA with the same name already exists");
  return (CancelOperation);
  }
5. once the Application is Compiled and navigated to the Account Screen-->Account List View-->Billing Accounts Applet
6. Create New Record and See that the Name is populated with the Parent Account name and save the Record by filling all the Required Fields.
7. Create another New Record, see that the same Name is Populated as like Previous Record and Save the Record.
8. The Record is Saved Successfully, No Error Message is show and this is not the expected behavior.

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