Asset Category Books upload error with "JBO-27027: Missing mandatory attributes for a row with key oracle.jbo.Key ###### of type CategoryBookDefault (Doc ID 2525439.1)

Last updated on FEBRUARY 08, 2024

Applies to:

Symptoms

When user is trying to use the Asset Category and Book template, they are receiving errors.

Error:
----------

Business object: Fixed Asset Category. Status: Completed with errors. Status details: Pause on error was overridden by the object. Review and report the errors for this object to product Assets.
Detail Object: Category. Status: Completed with errors. Status Details: A total of 14 rows were processed. 14 rows of them failed and 0 rows completed with warnings.. Started: 3/19/19 5:08 PM. Ended: 3/19/19 5:08 PM.
Row Identifier: ##########  ##### null. Status: Error. Message Code: FA_API_SHARED_INVALID_NOTNULL. Severity: . Message Text: You must enter a valid value for the field Prorate Convention.
The data row can be found in batch file Category/1_BATCH.zip. Cause: Action:

JBO-25026: Row oracle.jbo.Key[##########   #####  null ] with XML tag CategoryVORow cannot be loaded.JBO-25027: Attribute CategoryBook at index 48 with XML tag CategoryBook cannot be loaded.JBO-25025: Rowset with XML tag CategoryBook cannot be loaded.JBO-25026: Row oracle.jbo.Key[##########] with XML tag CategoryBookVORow cannot be loaded.JBO-25027: Attribute CategoryBookDefault at index 132 with XML tag CategoryBookDefault cannot be loaded.JBO-25025: Rowset with XML tag CategoryBookDefault cannot be loaded.JBO-25026: Row oracle.jbo.Key[##########] with XML tag CategoryBookDefaultVORow cannot be loaded.JBO-25030: Detail entity CategoryBookDefaultEO with row key oracle.jbo.Key[[##########]] cannot find or invalidate its owning entity.JBO-27024: Failed to validate a row with key oracle.jbo.Key[##########] in CategoryBookDefaultEOJBO-27027: Missing mandatory attributes for a row with key oracle.jbo.Key[##########] of type CategoryBookDefaultEOJBO-FA:::FA_API_SHARED_INVALID_NOTNULL: FA-645031


Steps to Replicate:
----------------
1. Populate the Asset Category and Book template
2. Upload categories

Changes

Cause

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