General Ledger & Intercompany

Get Involved. Join the Conversation.

Comments

  • Felix Beaudoin

    Hi Alan!
    Please refer to this MOS Document:

    ADFdi Vs File Based Import For Importing Journals (Doc ID 1622476.1)

    It should contain all the answers you are looking for.
    Regards,
    Felix

  • Harold Lecomte

    Hi Vikash,

    I have used the Clearing Account Reconciliation feature as part of an implementation project, please see my key takeaways below:

    • In order to use account reconciliation for entries coming from subledger, you will need to define journal lines rules to populate the 'reconciliation reference' field. If the 'reconciliation reference' field is empty, the automatic reconciliation feature will not work.
    • The consequence of using journal line rules to populate the reconciliation reference is that the journal lines that come from Oracle Cloud subledger will be posted at detailed level, even if you have chosen to summarise accounting entries in your subledger accounting setup. This makes sense since you would need to reconcile items at transaction detail level but it is worth keeping in mind if you wish to maintain a thin ledger.
    • I have seen this account being used for accrual entries, with number of journal lines to be reconciled monthly fairly limited (under 1,000 lines). However using clearing account reconciliation for journals posted directly to GL is dependent on accountants populating accurately the reconciliation field otherwise the automatic reconciliation will not work.
    • We did some performance testing with up to 200,000 lines and were able to reconcile them automatically with the process taking less than 2 minutes so  volume seems to be handled fairly well.
    • My main concerns/issues with the feature as currently available are:
      • The automatic reconciliation does not work if the reconciliation reference is empty, even if you have only 2 lines available for reconciliation with corresponding debit and credit amount.
      • Once a rule is setup, it is not possible to update the accounts that it applies to. So every time you wish to add new accounts in the scope of the reconciliation feature, a new rule needs to be created.
      • Automatic reconciliation works solely based on amount and reconciliation reference, no other attributes can be used to reconcile the items. For example, it would be useful to have the possibility to add a date parameter in the reconciliation rule.
      • There is no amount tolerance on the feature for automatic reconciliation. Amount tolerance can only be used for manual reconciliation.
      • When manual reconciling items where total debit is not equal to total credit (within the amount tolerance), there is no functionality to write off that unbalancing amount. Therefore using the tolerance feature will result in having a balance stuck on the clearing account.

    In summary, I would say that this feature is fairly basic and can only be used in some scenarios. ARCS or other reconciliation solutions may be more appropriate for complex reconciliation such as:

    • Use multiple attributes to match debits and credits
    • Use amount tolerance as part of the automated reconciliation
    • Use advanced reconciliation rules where the reconciliation attributes may not be exactly the same (e.g. due to a typo)
    • Create an automatic write off for reconciling items that do not exactly balance

    I hope this helps and look forward to reading comments from other members who have used this feature!

    Thanks,

    Harold

  • Amol

    Resolved this (Response from Oracle)

    ======================================

    I did more research on same and found the logic behind usage of Reversal date, here are the details:

     

    ADB in below text should be referring to Average Daily Balance Ledger

    1. At startup (before loading the spreadsheet), if there atleast one ADB ledger in the users data access set then the fields Reversal Date and Reversal Period will both be enabled. If there are no ADB Ledgers in the Users DAS - then the Reversal Date will be a read only field. However this will stop the user from entering data in the field. He can enter data in the field but it will not be read.

    2. If ADB Ledger then will read the reversal date information and not read the reversal period information. If Not ADB Ledger then will read Reversal Period information and not read Reversal Date information.

    Please let me know if any further query on the same.

    Thanks,

    Oracle Support

    ==============================================================================================================================

  • Ravi Kanth Vuddagiri

    a. Go to BPM Worklist > Task Configuration
    b. Select the appropriate task, in this case FinGLJournalApproval.
    c. Click on the Configuration tab and find the check box to 'Skip creator for Approval List'

  • Neelam Thakur

    Hi Isaline,

     

    This is done from "Manage Account Hierarchies".  You should make the change to each version of the hierarchy. Just open the hierarchy. This will put it in Draft mode, once in, expand highlight the node to which you nee to add a child. You can add a specific value by simply selecting from the left panel and moving it over to the right panel. Please note that the newly added value gets added to the bottom. Yo can manually move it up to put it in the correct alphabetic order. Once done same the changes. Then from the actions menu, perform row flattening, column flattening, audit and finally set status to active. Once done, navigate to "Publish Account Hierarchies" to publish.

    Hope this helps!
    Thanks,

    Neelam

  • Neelam Thakur

    Hi Subhash,

    Thanks for your response and the screenshot. That prompted me to look further into this and found this article which explains the differences in Summarize By and Group By. Thanks again.

    No Summarization Option Not Available in GL Journal Entry Summarization (Doc ID 2076038.1)

    Thanks,

    Neelam

     

     

  • Ba Kwon

    CVR error messages are stored in application messages. In FSM, search task "manage messages".  In Message Name, enter your message name, in your CVR screen shot, it's GL_CVR_1002001_FLOATERS and click Search. Then click Edit to update the message and save.

  • Krishna Sharma

    Hi

    Check 3 things

    1. IF CVR is enabled for that combination

    2. IF dynamic code combination is not enabled for you, then create the code combination and it should accept.

    3. the nature of account should be correct, it can be expense etc.

  • Ravi Kanth Vuddagiri

    1. Use General Ledger > Period Close > Inquire on Detail Balances to extract balances data per BSV/period. I have tested performance for download till ~20000 lines and it completes in 3-4 minutes.

    2. If you have more lines, create OTBI report to extract data.

    3. Run Trial Balance Report and select parameter Summarize by as 'Account'. You will be able to view all segments.

    Let me know if none of the solutions worked for you.

  • Karthikeyan Sukumar

    Hi Sridhar- Yes that is intended functionality now in 19C. Since the GA Dashboard is the one to show only GL related subjects and no need to show the Process Montior under this dashboard. Now only Oracle cleaned up this features

    You need to go to scheduled process to check for any process status

     

    Thanks!

    Karthik

  • Leaman Crews

    Hi all, just a general question here.

    I thought that, at a minimum, Oracle disables external email notifications and interfaces after a P2T is complete. That has been my experience, at least; it seems to be a part of the cloning script. I have to specifically re-enable these things in Test or Dev after P2T

    Has anyone experienced something different?

  • Wendy Ware

    Hi Felix, there's this document:

    Oracle Support Document 2104933.1 (What Are The Steps Required for the Cube, FR Reports and Allocations After a P2T?) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2104933.1

     

    In addition to this I schedule any maintenance processes.  I'd be curious to see what checklists other people have.  Thanks, Wendy

  • Harold Lecomte

    Hi Vikash,

    I am not aware of a way to drill directly from Smartview onto subledger details. I find that the easiest way to drill directly to subledgers details is to use the Review Subledger Journals task in GL (General Accounting > Journals > Review Subledger Journals). 

    I hope this helps.

  • Vikash Sethi

    We have found an issue with 19A. Till 18C, the Journal approvers can approve the journal going into the Journal itself (although they can approve through email as well as going to 'Requiring My Approval' tab as well). But with 19A, Approve/Reject buttons are enabled for everyone (even for non-approvers) in the Journal UI itself. Per Metalink note # 2505238.1, this is available with 19A to all the users. The purpose is that the approvers should be able to approve but the non-approvers should get the following error message when they try to approve - You can’t approve or reject the journal because you’re not the approver.(GL-782239) 

    Our issue is that this error is coming for the actual approvers as well. Although they can go and approve through other areas but still this is an issue. I have already raised an SR with Oracle to see if there is a solution to this issue.

    If anybody knows the answer, please let me know.

  • Jon Hayes

    I've spotted 1 or 2 annoying, minor issues that only affect administrators, but on the whole; a lot more has been fixed than broken for us.

    The one that affects me most is when running Import Journals online, it now only displays the first 10 results in the Source LOV meaning we have to click Search. You also can't type the first part of the name in and tab out, as it seems to be searching the Source ID rather than Source Name.