Financials – General

Get Involved. Join the Conversation.


    Tausif Mulla
    Oracle cloud lookups effective date
    Topic posted January 28, 2019 by Tausif MullaBronze Medal: 1,250+ Points, last edited February 6, 2019, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary control, Cash Management, Collections, Compliance, Configuration, Discussion Forums, Expenses, Financials, Fusion, General Ledger, Help Center, Intercompany, OTBI, Payables, Period Close / Reconciliation, Receivables, Reports, Search, Security, Setup, Setup / Administration, Subledger Accounting 
    72 Views, 2 Comments
    Oracle cloud lookups effective date
    Oracle cloud lookups effective date

    Hi, Can lookups maintained in oracle cloud ERP be effective dated ? We have checked in "setup and maintenance"  under "standard lookups" and we have "Enabled" and "Start Date" / "End date". How can we use these to have a future effective dated ? Will the system allow ?

    Your inputs will be appreciated !




    • Neil Ramsay

      The question is unclear: date effectivity of lookups is a very complex area since the date criteria could system date, GL date etc. and the effectivity should be different depending on whether a transaction is being created / updates vs inquired upon.

      What is the specific use case that you have in mind?

      • Tausif Mulla

        Thanks Neil for looking into this ! I received a response on other post related with this. I believe for custom lookup we can have start date and end date. No effective date.