General Ledger & Intercompany

Get Involved. Join the Conversation.

Posts

  • Swathi Potla
    Transfer balances to GL cube completes with error
    Topic posted Yesterday by Swathi PotlaRed Ribbon: 250+ Points, tagged Financials, General Ledger, Public Sector 
    Title:
    Transfer balances to GL cube completes with error
    Summary:
    Transfer balances to GL cube completes with error , It says " Data is not loaded, because of missing dimension members. Please check the output file. Add them and re-submit the Refresh Balances prog
    Content:

    Transfer balances to GL cube completes with error , It says Data is not loaded, because of missing dimension members. Please check the output file. Add them and re-submit the Refresh Balances program. We ran all the related GL programs such as Update and Publish chart of accounts etc . This issue raised after 19D upgrade and only happens in secondary ledger. Any inputs will be appreciated.

    Thanks

    Swathi Potla
     

    Version:
    19D
  • Durgaprasad Mohapatro
    Mass disable and end date currencies15.0
    Topic posted November 20, 2019 by Durgaprasad MohapatroSilver Medal: 2,000+ Points, tagged Financials, General Ledger 
    Title:
    Mass disable and end date currencies
    Content:

    Hi All,

    In Fusion, Out of box, there are around 250 currencies defined and all are enabled.

    Is there a way we can mass update to end date and disable  the currencies that is not used/required? Any FBDI, ADFDI excel kind easy to use way..

    Thanks,

    Durga

  • Fernan Ceriola
    Disable the 19C update: Performance Enhancements in Period...1
    Topic posted November 18, 2019 by Fernan Ceriola, tagged Financials, General Ledger 
    Title:
    Disable the 19C update: Performance Enhancements in Period Close Work Area
    Summary:
    The customer would like to disable this feature and perform thier taks in outstanding subledger transactions.
    Content:

    Hi Experts,

    Our client had their patching 19D update over the weekend and they noticed something different with outstanding subledger transactions.  We checked this update and this was from 19C.  They would like to disable this and unfortunately having difficulty in locating this Opt-In feature.  Also, we noticed in the document for Performance Enhancements in Period Close Work Area (https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/19C/19C-financials-wn.htm) that it's no longer optional from update 19D.  Does this mean whether they like it or not they have to use this feature?

    Regards,

    Fernan

     

     

    Version:
    19D
    Image:
  • Jim Van Tongerloo
    Account Monitor: Parent values not showingAnswered2
    Topic posted November 14, 2019 by Jim Van TongerlooGold Trophy: 10,000+ Points, tagged Financials, General Ledger 
    Title:
    Account Monitor: Parent values not showing
    Summary:
    Parent values not showing in the dropdowns in Account Monitor
    Content:

    Hi,

    We have a rather straightforward setup:

    COA 01 -> Ledger 01 -> Data Access Set 01
    COA 03 -> Ledger 03 -> Data Access Set 03
    COA 04 -> Ledger 04 -> Data Access Set 04
    COA 20/21 -> Ledger 20 & Ledger 21 -> Data Access Set 20 & Data Access Set 21

    When creating an Accounting Group in the Account Monitor for 01/03 or 04, I see all the values for the natural accounts just fine (including parent values like '6' which groups all expense accounts).

    When creating an Accounting Group for the shared COA 20/21, opening the dropdown for natural account, only the child values are there, not the parent values.

    The account hierarchy is built, active, audited and flattened, published.

    Any idea why these parent values don't show in the natural account dropdown?

    Thanks.
    Jim

    Version:
    R13 19C
  • Dan Rinaldi
    Daylight Savings Time and Report Run Timing1
    Topic posted November 12, 2019 by Dan RinaldiGreen Ribbon: 100+ Points, tagged Financials, General Ledger, Reports 
    Title:
    Daylight Savings Time and Report Run Timing
    Content:

    In BI Publisher, we schedule reports using EST time zone.

    Whenever daylight savings time occurs, we have to re-schedule our reports as they are off one hour.

    Is there a way to avoid this?

    Thanks,

    Dan

  • Vikash Sethi
    Create a new Request Set4
    Topic posted November 5, 2019 by Vikash SethiSilver Medal: 2,000+ Points, tagged Financials, General Ledger, Setup / Administration 
    Title:
    Create a new Request Set
    Summary:
    Create a new Request Set for Revaluation
    Content:

    I want to create a request set which can run Revaluation for multiple ledgers one by one. It was easy doing in on-Prem ERP. Do you know what are the steps to create this 'Enterprise Scheduler' / Request Set? Please let me know.

    Thanks

    Vikash

    Version:
    19C
  • Sigrid Buitelaar
    Using reporting currencies with month-end exchange rate2
    Topic posted November 4, 2019 by Sigrid BuitelaarGold Medal: 3,500+ Points, tagged Financials, General Ledger, Period Close / Reconciliation 
    Title:
    Using reporting currencies with month-end exchange rate
    Summary:
    Using reporting currencies with month-end exchange rate
    Content:

    Hi there

    Customer has a reporting currency with currency conversion level ' journal'  and with error handling set at 'report error'. This would imply for an error to be reported in case of a missing conversion rate.

    Customer's primary ledger is in EUR and one of the reporting currencies is USD. We are now noticing that when an EUR transaction is entered in the EUR ledger, on a day when no EUR to USD exchange rate excists, the transaction is not even posted in the EUR ledger despite of the fact that the conversion EUR to USD would only be required for posting the reporting currency. 

    Is this indended functionality? Wouldn't the conversion level 'journal' mean that one subledger transaction would create 2 separate journals, one in primary leger and one in reporting currency? 

    The company has the business requirement to inquire on detailed (subledger) transactions in reporting currency, however the actual exchange rate is not available until monthend. To enable detailed inquiry the choice was made to use a reporting currency. If the transactions would be posted throughout the month in the PL and only once a month, but with detail, in reporting currency, this would suffice. What would be another way to achieve this result?

     

    Version:
    13 19C
  • Farooq Haider Syed, PMP
    NEW Analytics for ERP - 19D2
    Topic posted November 4, 2019 by Farooq Haider Syed, PMPBlack Diamond: 60,000+ Points, tagged Financials, General Ledger 
    Title:
    NEW Analytics for ERP - 19D
    Summary:
    Financials Analysitcs avaialble for 19D?
    Content:

    HI,

    Any one know if the new ERP Analytics available in 19D.

     

    thanks

  • gabriel kinovisques
    R13 How to request access to Oracle DEMO instanceAnswered34.0
    Topic posted October 31, 2019 by gabriel kinovisquesRed Ribbon: 250+ Points, tagged Financials 
    Title:
    R13 How to request access to Oracle DEMO instance
    Summary:
    R13 How to request access to Oracle DEMO instance
    Content:

    Hello 

    Maybe it is not the right forum , however I was wondering if you can share with me, the process how to request access to Oracle DEMO instances.

    Thanks for your help

    Best Regards

     

     

  • Janelle Azimullah
    Populating the "Reconciliation Reference" field...Answered2
    Topic posted October 31, 2019 by Janelle AzimullahGold Trophy: 10,000+ Points, tagged Configuration, Financials, General Ledger, Period Close / Reconciliation, Setup / Administration, Subledger Accounting, Tip 
    Title:
    Populating the "Reconciliation Reference" field from Subledger
    Content:

    I want to explore using the Reconciliation Reference to reconcile payroll costs using the Reconcile Clearing Accounts feature. 

    This will require me to populate the "Reconciliation Reference" field in the General Ledger entries created by the Subledger Accounting engine. The Reconciliation Reference would need to present in the Journal Line for the reconciliation process to work. 

    Has anyone achieved this and would you be able to provide guidance on how you achieved this? 

    Version:
    R13 19C
    Image: