When Primary and Secondary Ledgers use Different Calendars, It is possible to create a Secondary Ledger with a Subledger Data Conversion.
(i) Secondary ledgers can have a different calendar than the primary ledger.
This data conversion level uses both Subledger Accounting and the General Ledger Posting program to create the necessary journals in both the primary and secondary ledgers simultaneously. Subledger Accounting creates the journal entries from subledger transactions if the subledger integrates with Subledger Accounting.
General Ledger Posting creates the journal entries for all other transactions that do not integrate with Subledger Accounting, including manual journal entries
(iii) How data is converted if the calendar is different:
(i) Secondary ledgers can have a different calendar than the primary ledger.
Secondary ledgers represent the primary ledger's accounting data in another accounting representation that might differs in one or more of the following ways:
- Chart of accounts
- Accounting calendar/period type combination
- Currency
- Subledger accounting method
- Ledger processing options
(ii) Subledger Data Conversion Level
This data conversion level uses both Subledger Accounting and the General Ledger Posting program to create the necessary journals in both the primary and secondary ledgers simultaneously. Subledger Accounting creates the journal entries from subledger transactions if the subledger integrates with Subledger Accounting.
General Ledger Posting creates the journal entries for all other transactions that do not integrate with Subledger Accounting, including manual journal entries
(iii) How data is converted if the calendar is different:
The following conversion rules are used to convert data from the primary ledger to the secondary ledger:
• Calendar Conversion: If the secondary ledger uses a different accounting calendar from the primary ledger, the journal effective date determines the corresponding non-adjusting period in the secondary ledger.
However, when running create accounting from the subledger, user gets the following error message: "The access set XXXX Primary Ledger assigned to the system profile option GL: Data Access Set does not include read and write privileges for the ledger Vision operations Secondary Ledger and the balancing or management segment value.
However, when running create accounting from the subledger, user gets the following error message: "The access set XXXX Primary Ledger assigned to the system profile option GL: Data Access Set does not include read and write privileges for the ledger Vision operations Secondary Ledger and the balancing or management segment value.
Please use the Data Access Sets window in General Ledger to include read and write privileges for the ledger and segment values or assign a different ledger access set to the system profile option."
Per the Oracle Financials Implementation Guide for Release 12, when creating a data access set, all ledgers and ledger sets assigned to a data access set must share the same chart of accounts and accounting calendar/period type combination.
The way to provide the subledger access to both the primary ledger and secondary ledger, while running create accounting, is to set the following system profile options:
Per the Oracle Financials Implementation Guide for Release 12, when creating a data access set, all ledgers and ledger sets assigned to a data access set must share the same chart of accounts and accounting calendar/period type combination.
The way to provide the subledger access to both the primary ledger and secondary ledger, while running create accounting, is to set the following system profile options:
- GL: Data Access Set -- to point to the primary ledger
- SLA: Additional Data Access Set -- to point to the secondary ledger
No comments:
Post a Comment