FAQ for Accounting Setup Manager


1.How to properly assign/remove Definition Access Sets in Oracle General Ledger?

Follow Document 415901.1 for steps on how to remove the Definition Acess Sets, but please note that DAS definitions cannot be deleted. These will remain in the Definition Access Sets -> Define form but will not have the definition name assigned to it (if all definitions were removed - in this example we only created one - then deleted it).

2.R12 Accounting Flexfield and GL Ledger Flexfield are not matching, is this a problem?

As documented in the General Ledger User Guide and Implementation Guide, the new GL Ledger Flexfield is automatically created and maintained. Users should ignore this Flexfield and never change it. Development has confirmed that the value for the dynamic insertion will not cause a problem. So if you notice any inconsistencies between Accounting Flexfield and GL Ledger Flexfield can be completely ignored.
See Document 418154.1 for more information.

3.How can I setup a Legal Entity country, if the country is not available in LOV?

Navigate into Legal Entity manager responsibility ->Setup -> Jurisdictions -> create identifying jurisdiction by setting identifying to Yes and territory to the country required, enter any name. Then enter registration codes. If the jurisdiction is already set to yes, then go to System Administrator Responsibility> go to Profile options> select the application name as General Ledger> then select the user by your user> in the profile choose <Default Country> , change the default country to the country required.
See Document 438089.1, Document 444633.1 for more information.

4.How do I remove Balancing Segment Value assignments from a Ledger?

Initially it was not possible to remove a BSV assigned to a Ledger once the setup has been complete, but it was delivered via recommended Patch 7529614:R12.GL.A.
However, this functionality does not apply to a Legal Entity. There is no possible way to remove a BSV assigned to a Legal Entity once the setup is complete.

5.Can I change the Ledger Currency after setup is complete?

No, it is not possible to change the ledger currency after the accounting setups have been completed. Same as in R11, in R12 the chart of accounts, calendar and currency cannot be changed after the setup has been completed and any attempt to perform such a change in the tables will not be supported and is highly un-recommended.
See Document 556220.1 for more information.

6.Can I enable Average Balances for a ledger after the ledger setup is complete?

No, it is not possible to enable average daily balances for a ledger once the ledger has been saved. Once the ledger setup is complete, the option to enable average daily balances is not available as part of the accounting setup manager.
See Document 734099.1 for more information.

7.Can I change the Subledger accounting method (SLAM) in the ledger definition after going live?

The accounting method should not be changed without advice from the subledger support team. Changing it can cause severe corruption, if, for example, you go from standard accrual to MFAR or the other way around. Please log a service request with the relevant subledger team to get further advice on whether the change is possible.

8.Can I delete, disable or end-date Primary Ledgers?

Document 782244.1 says that it is not possible to delete or end date the primary ledger whenever created and completed.
Yet, you can workaround this through the responsibilities - create a new Data Access Set, to prevent access to the ledgers that you wanted to delete and only allow access to the Primary Ledger required and attached this Data Access Set to the users responsibilities.

9.Can a Secondary Ledger be associated with more than one Primary Ledger?

No, a secondary ledger can only be associated with a single primary ledger.
See Document 735468.1 for more information.

10.How do I disable a Reporting Ledger?

Disable the Reporting currency from Accounting Setup Manager. In Accounting Setup Manager disable the conversions to the reporting ledger.
Create a new ledger set and a new data access set that contains only the Primary ledger
Update the GL: Data Access Set profile option at the responsibility level with this new data access set.

See Document 563546.1 for more information.

11.How do I disable a Secondary Ledger already created?

Query for your Primary Ledger from the ASM and click on the "Disable" icon next to the secondary ledger you in the Secondary Ledger table.
See Document 761380.1 for more information.

12.How do I set up the Responsibilities and Data Access Sets needed for a Primary Ledger and Secondary Ledger, when the ledgers have different charts of accounts? Can a Ledger Set be used in this case?

All ledgers in a Ledger Set must share the same chart of accounts and accounting calendar/period type combination. So a Ledger Set cannot be used in this case, where the charts of accounts are different. Instead, separate responsibilities must be used for access to each ledger. See Document 460654.1 for more information.

13.Can I change Primary Ledger to Secondary and Secondary to Primary?

No, changing ledger types is not permitted for the time being. The only way is to create new ledger after R12 implementation and use consolidation to put the 'history'.
See Document 603624.1 for more information

14.How to generate Reporting Sequence?

The ledger is setup to have Sequencing Context defined for GL Period Close - GL Journal Entry or GL Period Close - Subledger Journal Entry.
See Document 744962.1 for more information.