PJF: FBDI Rapid Install for Expenditure Type Fails with 'A record with the value XXX (Expenditure Type) already exists. Enter a unique value.'
Last updated on JULY 13, 2018
Applies to:Oracle Fusion Project Foundation Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.
Customer used the rapid install for PPM to load expenditure types. The log file said it processed 500 and 70 failed. There were 620 in the file. When he opened the page in the UI, none of them showed up but he was able to create a new one manually in the UI. When he queried the table PJF_EXP_TYPES_B, no records were found. Error in the log file is:
Expenditure Type tab processing.
Batch Number : : 1
Creating Revenue Category :Labor Revenue
Batch Number : : 2
Expenditure Category (ExpenditureCategory): The following total of rows were processed: 40. The following number of rows failed: 0.
Execution time for importing expenditure category : 1.0
Expenditure Type (ExpenditureType): The following total of rows were processed: 500. The following number of rows failed: 70.
Please review and correct the following failures.
Row Identifier : Monthly Base Processing Fee
The attribute Expenditure Type is required.
A record with the value Monthly Base Processing Fee already exists. Enter a unique value.
Expenditure Type (ExpenditureType): The following total of rows were processed: 120. The following number of rows failed: 0.
He found that if he entered in smaller batches (100 then 200 and the remainder 230), the items loaded successfully. I look in the Project Portfolio Management Cloud Implementing Project Financial Management UG and I look on the spreadsheet itself ('ASSUMPTIONS' and 'OVERRIDES' oh which there is nothing at all) and find nothing that talks about the maximum number to upload.
There were 2 expenditure types with the value 'Monthly Base Processing Fee' with different expenditure categories.
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