Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Understanding Time Zone Features in Oracle E-Business Suite 12

Posted on October 6th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

One unique aspect of a global implementation is that multiple locations may use the same system at the same time.

What if , You need to implement Timezones for each Legal entity like US, UK, Singapore and China in your Global single Instance.

Business transactions need to be accounted for in the correct period, in particular for financial transactions such as invoicing, collections,
etc. In addition, global instances with locations in vastly different geographical regions need the ability to close each location at period end in their own time zone.Therefore , you need to have understanding for Time Zone Features in EBS R12.

Date Fields in Oracle E-Business Suite can be classified under these broad categories

Transaction Date

This is Typically Date/Time which are associated as a part of transaction creation or maintenance.

Typical example in EBS context are Transaction date, Order Date, Shipment Date, service order effective date etc.

Accounting Date This is Typically GL Date. This date determines which Accounting period the transaction Accounting period the should be booked in.
Server (database) Date

This is dates that are primarily used in Data base operations.

Such dates are typically user to capture as Creation Date,Last updated Date

Standard Oracle provides three Time Zone features that can be used:

Server Time Zone

This determines the date and time on which Database dates are determined

In absence of Legal Entity Time Zone or User Preferred Time zone set up, this is the default time zone on which all date fields are determined

Legal entity Time Zone This determines the Accounting Date for certain in-scope transactions related to Accounting
User Preferred Time Zone This determines the time zone displayed for in-scope Transaction Dates
you can check out these two easy refrence note for more insights.
  • Doc ID 402650.1 -UPTZ User-Preferred Time Zone Support in Oracle E-Business Suite Release 12
  • Doc ID 726851.1 -LETZ (Legal Entity Timezone)

Related Posts

Posted in AOL, Oracle Application | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.