General Ledger Interview Questions in R12 – Part 2
Ledger that is currently in use.
Questions and Answers
What is the best source of information regarding Definition Access Sets?
How to properly assign/remove Definition Access Sets in Oracle General Ledger?
R12 Accounting Flexfield and GL Ledger Flexfield are not matching, is this a problem?
See Document 418154.1 for more information.
How can I setup a Legal Entity country, if the country is not available in LOV?
See Document 438089.1, Document 444633.1 for more information.
How do I remove Balancing Segment Value assignments from a Ledger?
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.
Can I change the Ledger Currency after setup is complete?
See Document 556220.1 for more information.
Can I enable Average Balances for a ledger after the ledger setup is complete?
See Document 734099.1 for more information.
Can I change the Subledger accounting method (SLAM) in the ledger definition after going live?
Can I delete, disable or end-date Primary Ledgers?
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.
Can a Secondary Ledger be associated with more than one Primary Ledger?
See Document 735468.1 for more information.
How do I disable a 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.
How do I disable a Secondary Ledger already created?
See Document 761380.1 for more information.
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?
Can I change Primary Ledger to Secondary and Secondary to Primary?
See Document 603624.1 for more information
How to generate Reporting Sequence?
See Document 744962.1 for more information.
How can I post a journal in an error status? It does not show in the post journal batches screen.
For more information see :
- Document 1390899.1 Troubleshooting Journal Batch Posting Status with Error%
- GL Users Guide: Reviewing the Batch Posting Status
- GL Users Guide: Correcting Batch Posting Errors
What are the batch posting error statuses?
Error2: Selected for posting to a period that is not open
Error3: Showing no journal entries for this batch
Error4: Showing journal control total violation
Error5: Showing multiple problems preventing posting of batch
Error6: Showing an unbalanced journal entry, and suspense posting is not allowed
Error7: Showing invalid journal entry lines or no journal entry lines for this batch
Error8: Showing unbalanced encumbrance entry without reserve account
Error9: Showing an encumbrance journal entry with no encumbrance type
Error10: Showing unbalanced intercompany journal entry
Error11: Showing unbalanced journal entry by account category
Error12: Funds reservation failed
Error13: Showing invalid period and conversion information for this batch
Error14: Showing journal entry with invalid or inactive suspense account
Error15: Showing encumbrance entry with invalid or inactive reserve account
Error16: Showing journal entry with invalid or inactive intercompany account
Error17 – Showing untaxed journal entry
Error18 – Showing unapproved journal batch
Error19 – Unopened reporting currency period
Error20 – Unopened reporting currency encumbrance year
Error21 – Unable to determine conversion rate to replicate journal
Error22 – Invalid or inactive rounding differences account in journal entry
Error23 – Showing sequence assignment failure
Error24 – Showing cutoff rule violation
Error25 – Unable to validate or create CTA
Error26 – Showing insufficient access to ledger or segment value
Error27 – Showing insufficient access to generated accounts defined for ledger
Error28 – Showing invalid balancing or management segment value for the ledger
Error29 – Showing insufficient access to reporting currency or segment value
Error30 – Showing invalid balancing segment value for generated accounts
Error31 – Unopened secondary ledger period
Error32 – Unopened secondary ledger encumbrance year
Error33 – Unable to retrieve accounts from chart of accounts mapping
Error34 – Unable to determine journal effective date
Why is the Post button grayed out on the Enter Journals form?
In Release 11, 11i and 12 this is controlled with Function Security.
See Document 1051909.6: Enable/Disable Posting From Enter Journals Form In General Ledger (GLXJEETN), for more information.Also, the Post button is grayed out also when journal approval is required. This is indicated when the Approve button is enabled for the journal.
Can I delete a batch from the Post Journals form?
Is it possible to select all batches for posting on post journal form ?
See Document 1136093.1
What reports are available for journal posting?
The Journals General report can be run for Posted, Unposted or Error status batches.
Can I post out-of-balance journal entries?
If you enabled suspense posting when you defined the set of books/ledger, General Ledger automatically balances each out-of-balance journal entry against a suspense account you specify for your set of books/ledger.
In R12, you can define additional suspense accounts if you want to balance journal entries with specific sources and categories to corresponding suspense accounts automatically.
References: Oracle General Ledger User’s Guide, Release 12, page 1-192 and Defining Suspense Accounts, Oracle General Ledger Implementation Guide (R12)
Can I post to a parent account?
How do I find out who posted a journal for internal control and audit purposes?
In 11i, an enhancement request bug:3613631 added a new column POSTED_BY in the gl_je_batches table since 11i.FIN_FP.G. Fixed file versions are :
This is included in base R12 version.
Are security rules enforced in posting?
This is controlled by function security in Release 11, 11i . In Release 10.7, you can remove the Post form from the user’s menu, to restrict posting.
Posting in R12 will check on the security rules assigned to the user (see Bug:12433242), in particular regarding the intercompany/intracompany account combinations required for balancing.
Can I post to a period prior to my latest open period? Are the balances rolled forward? Is retained earnings account updated?
Yes, this is valid for all versions. From Oracle General Ledger User’s Guide, Release 12, page 1-188:
When you post to an earlier open period, actual balances roll forward through the latest open period; budget balances roll forward through the end of the latest open budget year; and encumbrance balances roll forward through the end of the latest open encumbrance year.
If you post a journal entry into a prior year, General Ledger adjusts your retained earnings balance for the effect on your revenue and expense accounts.
Note: the budgets and encumbrances balances do not automatically roll forward into a new year. This is accomplished by the Year-End Carry Forward program.
I opened the first period of the new year without closing the prior year. Will this cause a problem if posting is still required to the last year?
Care should be taken in case of using document sequences, as the numbers could start to be consumed in the new period journals.
In R12 the closing period program performs additional work (for example accounting and reporting sequences generation).
Can I drop the GL_POSTING_INTERIM_XX tables?
The GL_POSTING_INTERIM_XX tables are temporary tables and are normally dropped after the process has completed successfully.TIP: Wait a week or so before you delete the table manually, just in case your processes did not complete.
WARNING: Do not drop the GL_POSTING_INTERIM and GL_SUMMARY_INTERIM tables (i.e., the tables without the numbers at the end of their names), as these tables are used by the General Ledger system.
See the following notes for more information:
Document 416542.1: Is there any Program to Drop Temporary tables which are no more required?,
Document 364040.1: GL_POSTING_INTERIM_xxxx Tables are Not Being Dropped after Successful Posting.
How do I run posting from the command line in debug mode?
See Document 1031719.6 for more information.
How can I find and delete a batch that is shown on the Posting execution report with the error ‘No journal entry lines for this batch’?
You post the batch and the Posting execution report contains the error ‘No journal entry lines for this batch’.
Now the batch is greyed out on the Post Journals form and I can not find it on the Enter Journals form.The reason for this error is that this batch does not have any journals.
You need to use the Find Batches window to find the Batch on the Enter Journals form. From there, you can delete the batch.
The first window that is displayed when you navigate to the Enter Journals form is the Find Journals window. You can not find the batch using this window, since there are no journals associated with the batch.
See Document 275992.1 for more information.
I submitted posting and receive the following ORA-01403: no data found error in the log file. How do I correct this?
SHRD0030: glpmpi() encountered an error returning from errexit:SHRD0042: Error in ROUTINE: glpmpi, status: 0
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
See Document 1050587.6: ORA-1403 in glpmpi when posting in General Ledger, for more information.
When I submit a batch for posting I receive the error ‘APP-8058: This form failed to submit your posting concurrent request. Please ensure that your concurrent manager is running.’ What is the cause?
Posting fails with Error 10: Showing unbalanced intercompany journal entry, or Error 16: Showing journal entry with invalid or inactive intercompany account. How can I correct this and resubmit the posting?
If automatic intercompany balancing is not enabled, you must manually add lines to the journal to balance the companies (balancing segment values).
If automatic intercompany balancing is enabled, then one of the following is true:An intercompany account has not been defined for one or more balancing segments and dynamic insertion is not enabled.
The system is trying to create an account code combination that violates a cross-validation or security rule.
The system is trying to create an account code combination that contains a segment that is disabled or not postable.
An intercompany account combination is disabled or not postable.
See Document 1012982.102: How to Check The Correct Setup of Intercompany Accounts to Avoid the Error16, for more information on how to resolve this.
Note: Error16 can also be caused by a cross validation rule preventing the creation of a suspense account. Suspense logic is always applied before intercompany balancing in posting. If you have unbalanced journal headers in your batch, suspense posting will first try to balance them with the suspense accounts, i.e. making the total header debit = total header credit, and also making the journal entries balanced within the balancing segment values.
Leave a ReplyWant to join the discussion?
Feel free to contribute!