My Oracle Support Banner

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.