My Oracle Support Banner

Assign Category to New Books by Rapid Spreadsheet Ends in Error (Doc ID 2884589.1)

Last updated on MAY 24, 2023

Applies to:

Oracle Fusion Assets Cloud Service - Version and later
Information in this document applies to any platform.


Assign Category to new Books by Rapid Spreadsheet end in error.

oracle.jbo.AttrSetValException: JBO-FND:::FND_CMN_REC_COMB_VALS_EXST: A record with this combination of values already exists.

The issue can be reproduced at will with the following steps:
1. Navigate to Setup and Maintenance
2. Search Update Fixed Assets Configuration in Spreadsheet
3. Click and Download the spreadsheet
4. Login
5. Click on the Asset Books sheet
6. Click Button Books
7. Load Books and Categories
8. Delete all old Books and keep only the new Book
9. Delete all Categories and enter the Category Assignment to the new Book
7. Validate
8. Generate Configuration File
9. Transfer the zip file to the content management server. Navigate to File Import and Export under Tools, and upload the file to fin/assets/import account
10. Search Upload Fixed Assets Configuration
11. Upload file


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

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