My Oracle Support Banner

Rapid Implementation Troubleshooting Guide (Doc ID 1902445.1)

Last updated on DECEMBER 14, 2023

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.8.0.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion General Ledger - Version 11.1.8.0.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Purpose

This document helps in troubleshooting known issues found while using Rapid Implementation spreadsheet feature described in guide Oracle Financials Cloud Implementing Enterprise Structures and General Ledger:
https://docs.oracle.com/cd/E51367_01/financialsop_gs/FAIGL/F1489230AN193E8.htm#F1453099AN193ED.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 
Frequently Asked Questions, Limitations/Restrictions and Suggestions related to the Rapid Implementation
 1.Can I use Rapid Implementation to add new values at a later point?
 2.Can I change accounting calendar period frequency or adjusting frequency on re-upload?
 3.Can re-upload delete values in the system if I remove values or LE(s) or BU(s) in the spreadsheet?
 4.Do I need to deploy chart of accounts when new values are manually added?
 5.How do I know the names of the entities created?
 6.How are names derived for the setup entities except Legal Entity and Business Unit?
 7.What is the primary ledger and default legal entity for each business unit?
 8.Can I change the Ledger's calendar, chart of accounts, existing Ledger-LE assignments (or) LE-BSV assignments on re-upload?
 9.Can I upload Financial Common entities without providing BU(s) or LE(s) or both?
 10.Is the same value set used for both Primary Balancing Segment (PBS) and Intercompany segment?
 11.The user does not want to use the same value set for both Primary Balancing Segment (PBS) and Intercompany segment since user does not want to specify additional security rules. How do I proceed?
 12.Does RI support creating statistical accounts?
 13.Does RI create secondary ledgers, ALC and reporting currencies?
 14.Why are two versions "%Base" and "%Current" created for each hierarchy (tree)?
 15.What are the size limits for names of various objects?
 16.Is Primary Balancing Segment must be the first segment?
 17.The GL Rapid implementation spreadsheet is not accepting the word "FUNCTION" as a segment name. What are the restricted reserved keywords?
 18.How to create multiple ledgers using Rapid implementation file for General ledger which share  the same chart of accounts
 19.How can we use a different segment separator (eg: ".") instead of default "-".
 20.Value Set is created with the name as <Segment> <Ledger Name>. Is there a way to change this or to specify the value set name that we would like to see since the Chart of Accounts will be used by multiple ledgers?
 21.Is there a way to add values to the Chart of Account segments without specifying parents?
 22.The user wishes to create multiple LEs for one country but wants each LE to be associated to a separate ledger using RI.
 23.The user wishes to use an existing calendar and does not want Rapid Implementation to create the same.
 24.How does RI handle upload of existing values?
 Known Issues and Workarounds
 1.User getting "Compile error: Can't find project or library" upon pressing "Validate data" button.
 2.Getting "Enter date in 'MM/DD/YYYY' format only" validation error , even after formatting the date cell to be MM/DD/YYYY type and entering the date in MM/DD/YYYY format
 3.Run-time error '13: Type mismatch
 4.In Release 8 when we click on Add Segments button in the spreadsheet, it does not add segment sheets to fill data for segments.
 5.Unable to update Retained Earnings on the ledger Options UI
 6.From FSM, unable to upload ChartOfAccounts.zip. On clicking submit, the browsed file disappears and nothing happens.
 7.RI upload using non-MM/DD/YYYY generates incorrect Calendar Start Date.
 8.Unable to insert/delete rows in 'Companies and Legal Entities' Spreadsheet.(getting some warning pop up stating cells are locked and Sheet needs to be unprotected.)
 9.Create Hierarchies failed with Hierarchies creation failed java.lang.NullPointerException
 10.When trying to "Upload Hierarchy" > "Create New Hierarchy", the value set does not show up for "Value Set" LOV.
 11.When trying to "Upload Hierarchy" for Natural Accounts, the process fails with below error:Exception Message: Create Value Sets Values failed.
 12. During upload of FinancialCommonEntities.zip hitting the below error failing to update Ledger. JBO-GL:::GL_EO_ASM_LE_TIME_DEFAULT: <MESSAGE><NUMBER>GL-781337</NUMBER><TEXT>You can only select one of the legal entities to be the default for the time zone.
 13.FCE fails to create ledger with error - JBO-GL:::GL_ASM_INVALID_RET_EARN_TYPE: <MESSAGE><NUMBER>GL-781323</NUMBER><TEXT>You must specify an enabled balance sheet account that is postable but not a summary account to be used as the retained earnings account.
 14.How does RI handle upload of existing values?
 15.During FinancialCommonEntities.zip upload, RI process fails to upload Business Units
 16.During FinancialCommonEntities.zip upload, RI process created duplicate Legal Entities
 17.After RI upload, the user finds the account values got created with the wrong account types and there exist code combinations that need to be corrected
 18. The user wishes to upload non-English data using RI spreadsheet. While uploading RI process fails to upload in the non-English language.
 19.User finds incorrect ledger currency assigned to the primary ledger.
 20.Upload fails to process Primary Ledgers with below error:LedgerRelationshipEOJBO-27040: Value "Ledger Name greater than 17" for field TargetLedgerShortName exceeds the maximum length allowed
 21.HierarchiesOnly.zip upload does not flatten hierarchy on modifying existing hierarchy

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