Getting Error "Retrieving rows from the FA_CONVENTION_TYPES table for the convention XXXXX and the fiscal year name XXXXX failed" When Attempting To Post Mass Additions Created From FBDI (Doc ID 2596236.1)

Last updated on OCTOBER 04, 2019

Applies to:

Symptoms

When attempting to post mass additions loaded using FBDI spreadsheet, the following error occurs even though Prorate Convention Codes are already set up.

ERROR
-----------------------
Retrieving rows from the FA_CONVENTION_TYPES table for the convention XXXXX and the fiscal year name XXXXX failed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download the Mass Additions Interface FBDI spreadsheet
2. Update the spreadsheet with the data
3. Generate the CSV file
4. Run Load Interface File for Import
5. Run Post Mass Additions

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.