Scribd Logo
Upload

Welcome to Scribd!

  • 535 views

    Reporting Currency in R12

    Uploaded by

    sriram
    The document discusses configuring reporting currencies in Oracle R12. It involves 11 steps: 1) defining a rounding difference tracking account, 2) assigning it to the ledger, 3) defining exchange rate types, 4) defining exchange rates, 5) defining reporting currency setups at the ledger level, 6) defining a reporting GL responsibility, 7) assigning the reporting ledger to the responsibility, 8) assigning the responsibility to a user, 9) opening periods in the responsibility, 10) creating a journal in the primary ledger and posting it, and 11) reviewing the journal in the reporting ledger. The key differences between multiple reporting currencies in R11i and reporting currencies in R12 are also summarized.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Reporting Currency in R12

    Uploaded by

    sriram
    535 views19 pages
    The document discusses configuring reporting currencies in Oracle R12. It involves 11 steps: 1) defining a rounding difference tracking account, 2) assigning it to the ledger, 3) defining exchange rate types, 4) defining exchange rates, 5) defining reporting currency setups at the ledger level, 6) defining a reporting GL responsibility, 7) assigning the reporting ledger to the responsibility, 8) assigning the responsibility to a user, 9) opening periods in the responsibility, 10) creating a journal in the primary ledger and posting it, and 11) reviewing the journal in the reporting ledger. The key differences between multiple reporting currencies in R11i and reporting currencies in R12 are also summarized.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses configuring reporting currencies in Oracle R12. It involves 11 steps: 1) defining a rounding difference tracking account, 2) assigning it to the ledger, 3) defining exchange rate types, 4) defining exchange rates, 5) defining reporting currency setups at the ledger level, 6) defining a reporting GL responsibility, 7) assigning the reporting ledger to the responsibility, 8) assigning the responsibility to a user, 9) opening periods in the responsibility, 10) creating a journal in the primary ledger and posting it, and 11) reviewing the journal in the reporting ledger. The key differences between multiple reporting currencies in R11i and reporting currencies in R12 are also summarized.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    535 views19 pages

    Reporting Currency in R12

    Uploaded by

    sriram
    The document discusses configuring reporting currencies in Oracle R12. It involves 11 steps: 1) defining a rounding difference tracking account, 2) assigning it to the ledger, 3) defining exchange rate types, 4) defining exchange rates, 5) defining reporting currency setups at the ledger level, 6) defining a reporting GL responsibility, 7) assigning the reporting ledger to the responsibility, 8) assigning the responsibility to a user, 9) opening periods in the responsibility, 10) creating a journal in the primary ledger and posting it, and 11) reviewing the journal in the reporting ledger. The key differences between multiple reporting currencies in R11i and reporting currencies in R12 are also summarized.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 19

    Reporting Currency in R12 / Multiple Reporting

    Currency in 11i
    It is used to translate balances from functional currency to
    foreign currency at transaction level. Here we use Daily rates.
    There are three levels are there.
    Balances level- All the balances will be translated.
    Journal Level-All the journal entries will be translated
    Sub ledger Level- All the journals from AP, AR will be
    translated.
    Note: In reporting feature we will be having one primary ledger
    and unlimited reporting ledgers.
    Setup Steps:
    1. Define “Rounding Difference Tracking A/c” at account
    segment value.
    2. Assign rounding difference a/c to ledger.
    3. Define Exchange rate type
    4. Define Exchange rates.
    5. Define Reporting currency Setup’s in setup step at ledger
    level.
    6. Define Reporting GL Responsibility.
    7. Assign reporting Ledger to Reporting GL Responsibility.
    8. Assign Reporting GL Responsibility to User .
    9. Open periods in Reporting Currency responsibility.
    10. Enter Journal in primary ledger and post it.
    11. Query the journal in Reporting ledger to check the result.
    Diffence between Multiple Reporting Currency in 11i and
    Reporting Currency in R12.
    1. In 11i we can called as “Multiple Reporting Currencies” but
    in R12 we are calling like “Reporting Currencies”.2. In 11i we
    have to define reporting set of books and assign primary set of
    book to reporting set of books. But In R12 directly we can add

    Sensitivity: Internal & Restricted


    reporting currencies to ledger. It is easy process.
    3. In 11i we can report upto 8 reporting currencies but where as
    in r12 we can report en number of currencies.
    4. In 11i we have one limitation to do MRC. If the chart of
    account and calendar should be same to do the MRC. But in R12
    if the calendar or chart of account is differ we can do “Reporting
    currencies” by using Secondary Ledgers.

    Let's see how to configure Reporting currency concept in R12


    Step: 1 Define “Rounding Difference Tracking A/c” at account
    segment value.
    Navigation: Setup--> Financials--> Flex fields--> Key-->
    ValuesEnter Structure name and Segment, Say “Find”
    Enter “Rounding Difference Tracking Account” with Qualifiers
    as Yes, Yes, Expenses, No, No.

    Sensitivity: Internal & Restricted


    Now, Save it.
    Step 2: Assign Rounding Difference Tracking account at Ledger
    level
    Navigation: Setup --> Financials --> Accounting setup manager
    --> Accounting setupQuery your ledger and click on Update
    accounting optionsGo to Primary Ledger set up step and
    say Update
    Go to “Ledger Options” tab and click on “Journal processing’
    region and Assign “Rounding difference tracking account”.

    Click on “Finish” and see for confirmation message.


    Step 3: Define exchange rate type
    Navigation: Setup --> Currency --> Rate --> types
    Click on New and Enter Rate type and Description

    Sensitivity: Internal & Restricted


    Save and close the window.

    Step 4: Define daily ratesNavigation: Setup --> Currencies -->


    Rates --> Daily.
    Click on New and fill the details as below

    Sensitivity: Internal & Restricted


    and Click on Enter by date range and fill the same details with
    Start date and end Date. Save and close the window.
    Step 5: Define Reporting currency Setup’s in setup step at
    ledger
    Level.
    Navigation: Setup --> Financials --> Accounting setup manager
    --> Accounting setup.
    Now, Query your primary ledger --> click on Update accounting
    options--> In setup step Click on update of “Reporting
    Currencies”.
    Now, Click on “Add reporting currency”
    Currency conversion level: JournalCurrency: USD
    Enter reporting currency name
    Enter short name & Description
    Ledger Options:
    First ever open period: Jan – 11
    Add Rounding Difference tracking account
    Currency Translation options:
    Choose Default rate type
    Retain transaction rate type: Yes
    ** If yes – Rate type will take from Primary ledger
    ** If No – It will take above default rate as per primary ledger

    Sensitivity: Internal & Restricted


    Error handling:
    Missing conversion rate: Use last rate
    Number of days to find the last rate: 5
    Journal Conversion Rules:
    Retain journal creator from source Ledger: Yes
    Note:
    1. If Yes – Journals will transfer from Primary to reporting
    2. If No – Journals will not transfer

    Sensitivity: Internal & Restricted


    Update Journal Source: Other, Journal Category: other, Convert
    journals: Yes
    Note: If you do not want to transfer all journals, click on “Add
    another row” to define source and category.
    Data Conversion Initialization:First future conversion period –
    Apr 11
    Historical Conversion:
    Retain original conversion type: No
    Choose historical conversion rate date & type
    Say “Apply”
    Update reporting currencies:
    Now, You can see one more reporting ledger with “Journal” as
    currency conversion level

    Sensitivity: Internal & Restricted


    Click on Apply button.
    Step 6: Define Reporting GL Responsibility.
    System administrator Navigation: Security --> Responsibility --
    >Define.
    Click on new and create Reporting GL Responsibility.

    Sensitivity: Internal & Restricted


    Save and close the window.
    Step 7: Assign Reporting Ledger to Responsibility.
    System Administrator Navigation: Profile --> system.
    Select your Responsibility and Profile Option as shown below

    Sensitivity: Internal & Restricted


    Click on Find button, and Enter Reporting Currency
    in Responsibility field.

    Save and close the window.


    Step 8: Assign Reporting GL Responsibility to the User.
    System Administrator Navigation: Security --> User --> Define.

    Sensitivity: Internal & Restricted


    Query the user name and assign Reporting GL Responsibility to
    the user.

    Save and close the window.

    Step 9: Open periods in reporting GL Reponsibility.


    Switch to Reporting GL Responsibility.
    Navigation: Set up --> open / close.
    Open till Current Period.

    Sensitivity: Internal & Restricted


    Close the window.
    Step 10: Create Journal in Primary Ledger and post
    Switch to Primary Ledger Responsibility.
    Navigation: Journal --> Enter
    Click New Journal Button and enter Mandatory Information to
    test it.

    Sensitivity: Internal & Restricted


    Save and post it.

    Step 11: Review Journal in Reporting ledger.


    Switch to Reporting Ledger Responsibility.
    General ledger Navigation: Journal --> Entry.
    Query the query the journal to view it.

    Sensitivity: Internal & Restricted


    Close the Window.
    Posted by Krishna at Tuesday, June 23, 2015
    Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
    Labels: General ledger
    2 comments:
    1.
    Jennifer N19 February 2019 at 20:46

    Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please
    check oracleappstechnical.com
    Reply

    2.
    Zack Smith17 April 2019 at 03:45

    I really thank you for the valuable info on this great subject and look forward to
    more great posts. Thanks a lot for enjoying this beauty article with me.Mconvert I
    am appreciating it very much! Looking forward to another great article. Good
    luck to the author! All the best!

    Sensitivity: Internal & Restricted


    Reply
    Newer PostOlder PostHome
    Subscribe to: Post Comments (Atom)
    Oracle Applications

    View Post by topics


    Accounts Payables (10)
    Accounts Receivables (8)
    Cash Management (1)
    Fixed Assets (3)
    General ledger (12)
    Inventory (1)
    MOAC (1)
    Order Management (3)
    Others (1)
    Purchasing (2)
    Cycles
    Order to Cash (O2C)
    Procure to Pay (P2P)
    Period Closing Procedure
    Period Closing Process
    Issues & Solutions
    AP (10)
    AR (6)
    CM (2)
    FA (2)
    GL (2)
    INV (1)
    OM (5)
    PUR (2)
    Save Water

    Sensitivity: Internal & Restricted


    Blog Archive
    22 Dec - 29 Dec (1)
    25 Feb - 4 Mar (1)
    11 Feb - 18 Feb (1)
    16 Jul - 23 Jul (1)
    9 Jul - 16 Jul (1)
    2 Oct - 9 Oct (1)
    11 Sep - 18 Sep (1)
    28 Aug - 4 Sep (1)
    28 Feb - 6 Mar (9)
    7 Feb - 14 Feb (1)
    31 Jan - 7 Feb (1)
    27 Dec - 3 Jan (1)
    20 Dec - 27 Dec (2)
    6 Dec - 13 Dec (1)
    29 Nov - 6 Dec (2)
    8 Nov - 15 Nov (3)
    1 Nov - 8 Nov (1)
    25 Oct - 1 Nov (2)
    18 Oct - 25 Oct (1)
    4 Oct - 11 Oct (2)
    20 Sep - 27 Sep (2)
    13 Sep - 20 Sep (1)
    6 Sep - 13 Sep (1)
    30 Aug - 6 Sep (1)
    23 Aug - 30 Aug (1)
    26 Jul - 2 Aug (6)
    19 Jul - 26 Jul (1)
    12 Jul - 19 Jul (4)
    5 Jul - 12 Jul (2)
    28 Jun - 5 Jul (1)
    21 Jun - 28 Jun (3)
    14 Jun - 21 Jun (3)

    7 Jun - 14 Jun (10)


    "Stuck in the Interface" , Invoice not created in AR and no error is showing in the interface.

    Save Tree

    Live Traffic Feed


    How helpful is this blog
    Save Water

    Sensitivity: Internal & Restricted


    Disclaimer

    The opinions expressed here represent solely my own. Anything I expressed, share here
    represent, based upon experience, practice and observation and does not represent the thoughts,
    intentions, plans or strategies of my current & previous employers and their clients.

    Oracle Logo

    Total Pageviews
    103,434
    Translate

    Powered by Translate

    Follow by Email

    Save Water

    Popular Posts
     "Stuck in the Interface" , Invoice not created in AR and no error is showing in the interface. (or) The AutoInvoi
    (RAXMTR) may complete without error but will not spawn the AutoInvoice Import Program. And Sales Order Line stat
    Verify that the Request ID is null on the transactions to be imported, If the request_id is not null then any run of Auto in

    Sensitivity: Internal & Restricted



    Revenue Recognition
    In Revenue Recognition we have two concept in oracle apps. 1. Invoicing Rule. 2. Accounting R


    Budget
    Budget concept is used for planning and controlling purpose. We can define budget up to maximum 60 periods. They
    budget....


    Reporting Currency in R12 / Multiple Reporting Currency in 11i
    It is used to translate balances from functional currency to foreign currency at transaction level. Here we use Daily rate
     Sales Order line status is "Awaiting Invoice Interface - Incomplete Data". Unable to create RMA Credit Memo
    Solution 1: Query the Sales Order, The Sales order Line status will be " Awaiting Invoice Interface - Incomplete Data"


    Revaluation Concept in Oracle Apps
    It is used to identify unrealized gain/loss amount which occurred due to foreign exchange rate fluctuations. The differe
    ...
     Accounts Receivables
    System Options (AR) Define system options to customize your Receivables environment. Is is used to set some defa
    rece...


    User is unable to Void the payment.
    Illustration- 1 : User is unable to Void the payment. Solution: You cannot void payment on a payment document that p
    that...
     Fixed Assets
    Key flexfields in FA. There are three Key Flex Fields in Fixed Assets: 1. Category KFF.
     RMA(Return Material Authorization) Concept in Oracle Apps
    RMA functionality allows the user to return the goods delivered to customer against Sales Order. Return from custome
    various...

    Sensitivity: Internal & Restricted


    This blog is crea
    Krishna Mallidi
    Oracle Apps Func
    E Mail: krishnare

    Awesome Inc. theme. Theme images by Jason Morrow. Powered by Blogger.

    Sensitivity: Internal & Restricted

    You might also like