Great Personal Development Truths

via  – for full articles  60 Inconvenient Personal Development Truths.

  1. The acquisition of knowledge doesn’t mean you’re growing.  Growing happens when what you know changes how you live.
  2. You can’t have good ideas unless you’re willing to generate a lot of bad ones.
  3. A good idea without action is nothing at all.
  4. It’s not so much about finding opportunities as it is about creating them.
  5. 10% of our lives is decided by uncontrollable circumstances.  90% is decided by how we react to those circumstances.
  6. What we don’t start today won’t be finished by tomorrow.
  7. If you’re waiting for the perfect conditions, ideas or plans to get started, you’ll never achieve anything.
  8. If you keep doing what you’re doing, you’ll keep getting what you’re getting.
  9. Change is often resisted when it is needed the most.
  10. Discipline is choosing what you want most over what you want right now.  Read The 7 Habits of Highly Effective People.
  11. The harder you work, the luckier you will become.
  12. Kindness and hard work together will always carry you farther than intelligence.
  13. Life is not easy, especially when you plan on achieving something worthwhile.
  14. Tough times don’t last, but tough people do.
  15. Lots of successful people have failed as many times as they have succeeded.
  16. Nobody succeeds all by themselves.
  17. Right now, there’s a lot you don’t know.
  18. Having a plan, even a flawed one at first, is better than no plan at all.
  19. In the beginning, you need to say “yes” to a lot of things to discover and establish your goals.  Later on, you need to say “no” to a lot of things and concentrate on your goals.
  20. No matter how you make a living or who you think you work for, you only work for one person, yourself.  The big question is:  What are you selling, and to whom?
  21. We all have different strengths.  What worked for someone else might not work for you.
  22. To be great does not mean you have to dominate others.  It means you have to dominate your own potential.
  23. Being successful is a journey, not a destination.
  24. Results are more important than the time it takes to achieve them.
  25. Being busy and being productive are two different things.
  26. Being happy and being successful are two different things.
  27. You don’t have to settle.  It’s simply a choice you make every day.
  28. Life is full of opportunities to feel exactly the way you want to feel.
  29. You have every right to be happy, but it’s up to YOU and only YOU to exercise that right.  Read The Happiness Project.
  30. You have the ability to clear negativity from your mind with a single thought.

via  – for full articles  60 Inconvenient Personal Development Truths.

Some more here …..

  1. We are all multi-dimensional human beings with simultaneous dimensions of success and failure in our lives.
  2. Your success isn’t just about you.  It’s about how you positively impact the lives around you.
  3. Any fool can criticize, condemn and complain, and most fools do.
  4. Holding onto anger is like grasping a hot coal with the intent of throwing it at someone else – you are the one who gets burned.
  5. Life isn’t always logical.
  6. When you spend time worrying, you’re simply using your imagination to create things you don’t want.
  7. It’s usually only as good or bad as you think it is.
  8. There is a lesson in everything you do, and learning the lesson is how you move forward.
  9. No matter how smart you are, you will make mistakes.
  10. There’s no such thing as ‘risk free.’  Everything you do or don’t do has an inherent risk.
  11. Saying “no” to right people gives you the time and resources required to say “yes” to right opportunities.
  12. Just because you can doesn’t mean you should.
  13. When you’re caught up in the moment and your emotions are soaring, you’re bound to make poor decisions.
  14. Simplicity is often a major factor of success.  But the process of simplifying things is rarely easy.
  15. Cutting your losses is often better than the alternative.
  16. It’s uncomfortable to challenge the status quo, but it’s worth it.
  17. You can raise the bar or you can wait for others to raise it.  Either way, it’s getting raised.
  18. Oftentimes, the only reason they want you to fit in is that once you do they can ignore you and go about their business.
  19. Confusion isn’t a bad thing.  It means you’re growing and thinking.
  20. When you see the world as it is, but insist on making it more like it could be, you matter.
  21. When kids grow up wanting to be you, you matter.
  22. Trying to be somebody you’re not is not sexy.  Be you.  That’s when you’re beautiful.
  23. Good looks attracts the eyes.  Personality attracts the heart.
  24. Sometimes you just have to do your own thing your own way, no matter what anyone else thinks or says about you.
  25. When you receive negative feedback, remember, it doesn’t matter how many people don’t get it, it matters how many do.  Read The 4-Hour Workweek.
  26. If you awake every morning with the thought that something wonderful will happen in your life today, and you pay close attention, you’ll often find that you’re right.
  27. Truly ‘rich’ people need ‘less’ to be happy.
  28. A good life is when you assume nothing, do more, need less, smile often and realize how fortunate you are right now.
  29. If you want love, give love.  If you want friends, be friendly.  If you want money, provide value.  It really is this simple.
  30. If there was ever a moment to follow your passion and do something that matters to you, that moment is now.

And remember, the extra mile is the stretch of road that’s never crowded.  As long as you follow your heart and never stop learning, you’ll turn not older, but newer every day.

via  – for full articles  60 Inconvenient Personal Development Truths.

Oracle EBS – Fixed Assets : Overview

Fixed assets, constitute the durable capital base of an enterprise (traditionally the  “Property, Plant and Equipment”), necessary to deliver products and services expanded to include investments in non-tangible
assets like software.

Asset management encompasses three primary activities:
Physical Upkeep: Comprises asset location, asset condition and assignment
Asset Tracking: Covers the whole gamut from controlling, leased, loaned and consigned items from acquisition to asset maintenance.
Financial Administration: Involves asset value, depreciation and taxation.

Two Types of Asset Books:
Corporate Books: Where are all assets are created or captured, accounted, Depreciated and retired as per the GAAP rules.

Tax Books: Tax books use the asset data of the corporate book but account, Depreciate and retire as per the tax rules.

Capital Assets such as building and machinery typically lose their value over time.
The loss of value during any given period is called depreciation and it is charged as anexpense in that period. The value of asset at any point in time –usually cost minusaccumulated depreciation–is called net book value.

When an asset is acquired / built, asset is assigned an initial book value, an economic life and a calculation to determine value of asset at each period during that economic life. An asset may have a residual value beyond which it will not depreciate.

At the end of its economic life, the initial cost of asset (less residual value if any), will have been expensed. The depreciated book value appears on balance sheet as an asset. The asset is taken off books when it is sold. The diff between sale price and book value at the time of the sale is gain/loss on sale.

Fixed Asset Process flow

Fixed Asset Process flow

R12 New Features – Fixed Assets

Payables to Assets Integration

Payables now has a new level of detail between Invoice Header and Invoice Distribution. The new level is Invoice Lines. At this new level, new field are available to enter details that will integrate to Assets, these fields are:

•   Manufacturer
•    Model
•    Serial Number
•    Warranty Number
•    Asset Book
•   Asset Category

Event Accounting

Assets now has event accounting, meaning that every transaction is treated as a new event to the assets. The impact on assets are as follows:

•    Audit trail will no longer show voided transaction types if changes occur in the month an asset was added.

•   No longer forced to delete assets in the period it was added, due to the event accounting – Oracle treats the addition and retirement as two separate events, so now Oracle allows assets to be retired in the period added.

•   Event accounting also allows for transferring accounting to GL multiple times in a period.

Auto Prepare Mass Additions

New APIs and Quick Codes are available to automate the Prepare Mass Additions process. There are default rules available, you can accept the defaults or choose to create custom rules. These APIs and Quick Codes will automatically process data and assign the required data attributes, such as:

Depreciation Expense Account

Asset Category

Default rules:

Asset Category – this is derived from the asset cost clearing account, as long as there is one to one relationship between the account and asset category. This process will only impact items in the ‘New’ and ‘On Hold’ queue names.

Expense Account – this is derived from the clearing account combination and overlaying the natural account segment with the value of the natural account segment of the depreciation expense defined in the asset category. If the program cannot derive an expense combination, the queue name is set to ‘On Hold’.

This should minimize the amount of manual efforts involved in the Prepare Mass Additions process. Manual updating is still required – some required fields may not be populated.

Asset Category – a one to one relationship between cost clearing account and asset category – this will expand the Chart of Accounts of many companies.

Expense Account – the expense combination is going to be derived from a Balance Sheet account. Oracle will simply overlay the natural account segment, replacing the cost clearing account leaving all other segment values alone. If there are certain requirements for P&L accounts versus Balance Sheet accounts, i.e. cost center required for P&L, this may present issues.

Manual efforts are required to perform Merging, Splitting, Add to Assets and Merge then Split functionality.

Auto Depreciation Rollback

In Release 12, you will no longer be required to run the Rollback Depreciation process in order to make corrections to assets. After running depreciation when a correction or change is required, simply choose the asset to modify. Oracle will automatically rollback depreciation for this single asset. Make your modifications and when you re-run depreciation, Oracle will re-calculate depreciation based on the modifications made to the asset.

The features to rollback depreciation and rollback journal entries that are in R11i are no longer available in R12.

Month End Close

Create Accounting process is now used in Assets – journals are created not by a period, but by events and a date. This means that one can create accounting on the 15th of a month for all transactions performed at the end of the month. This allows for clients to view accounting prior to month end for events that will greatly impact the books(i.e. mass retirements, transfers, etc.)

Oracle EBS R12 – Multi-Oracle Access Control – MOAC

Multi-Org or multiple organization access (MOAC) is basically the ability to access multiple operating units from a single application responsibility. In Release 11i, when one had to enter or process data for multiple operating units, one had to login to different responsibilities because each responsibility could only access one operating unit. If one was managing Payables for Sweden, Norway and Finland one needed to define three different responsibilities. In Release 12, one would create a Security Profile and assign as many operating units as you required. One can tie that security profile to a single responsibility using a profile option called

“MO: Security Profile”.

Oracle-R-12 MOAC1

Oracle-R-12 MOAC2

For example, you could assign the security profile to the ZZ_PAYABLES.. Responsibility to allow that responsibility to process invoices across all (specified as per user need) operating units.

In Release 12, define a security profile in HR using the Security profile form or the Global Security profile form, and assign all of the operating units that one would want a responsibility to access. you need to run a concurrent request called

“Run Security List Maintenance”

from HR which will make those security profiles available and allow one to assign them to a responsibility via a profile option called MO: Security Profile.

you can define an operating unit using the Accounting Setup Manager in Oracle General Ledger or Organization Definition form in Oracle HRMS or Inventory. An operating unit is then attached to a default legal context (as compared to Legal Entity in Release 11i)

Define a security profile using either of the two forms: Security Profile form or the Global Security Profile Form that is shown below. Both forms look almost identical where Security Profile Form allows one to select operating units from only one Business Group where as Global Security profile Form allows one to select operating units from multiple Business Groups.

Global Security Profile

Oracle-R-12 MOAC3

you can define another profile option called MO: Default Operating Unit
which is optional and allows one to specify a default operating unit that will be the default when you open different subledger application forms.


Oracle R12 Financials New Features Overview – Video and Presentation

A comprehensive look of functional enhancements, new features and an overview of new modules; also core financial module new features and functions and demonstrate and discuss enhancements to existing features and functions in the Oracle R12 Financial Suite of products.

Credit goes to – IwareLogic team –

Refer presentation via slideshare

Metalink : EBS Data Model Comparison Report Overview [ID 1290886.1]

Very useful if you doing upgrade project or want to know internal database level changes and to learn more technically. Refer Document ID : 1290886.1  , on Oracle Support ( formally Metalink )

Here is link — Metalink Document direct link

EBS Data Model Comparison Report Overview [ID 1290886.1]

The EBS data model comparison report provides the database object definition changes between two EBS releases to help users to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

Users can select a product and navigate the database object definition differences for each supported database object type.

Applicable Releases – Release 12.1.3

How to view the Comparison Report

Download the zip file and unzip the file into to a local directory. Open the file “DataModelComparisonReport.html” in your browser from the local directory where you have unzipped the file.Top frame will have a product LOV. Users can select a product and navigate to the database object definition differences for each supported database object type which is displayed in the bottom frame.

Select one of the links below to view the data model comparison report for a specific release.

  • Release to Release 12.1.3 (zip)
  • Release 12.0.4 to Release 12.1.3 (zip)
  • Release 12.1.1 to Release 12.1.3 (zip)
  • Release 12.1.2 to Release 12.1.3 (zip)

Here is the list of additional prefixes known to products that are considered for comparison in addition to their own product short code.

Product Short Name Additional Prefixes
EDW EDW (from all product schema including the common schema, e.g. APPS)

Oracle R12 – Oracle EBS Tax Module Overview

•    Oracle E-business tax is a new product in R12.
•    It provides the infrastructure for transaction tax knowledge management and delivery using a global system architecture that is configurable and scalable for adding country-specific tax content.
•    It is a single point solution for managing transaction-based tax.
•    Uniformly delivers tax services to all E-Business Suite business flows through one application interface.
•    It Consists of a tax knowledge base, a variety of tax services that respond to specific Tax events, a set of repositories (for tax content and tax recording) that  allows customers to manage their local tax compliance needs in a proactive  manner, as well as the ability to integrate with external tax content providers  through a single integration point.

Features of E-Business Tax include:
•    Date affectivity on your tax configuration.
•    Tax simulator which enables you to test your tax configuration.
•    Classify your tax exceptions:
– Item.
– Intended use.
– Place of supply.
•    Look for commonalities:
– Define a classification rule to apply to many suppliers.
– Define a classification rule to apply to many suppliers.

E-Business Tax Setup Steps:

E-Business tax Setup Steps

Tax Authority
“A government entity that regulates tax law, administers, or audits one or more taxes”.

Tax Regime
“The set of tax regulations that determine the treatment of one or more taxes administered by a tax authority”
Examples of a tax regime include:
•    A sales and use tax in the United States includes rules for state, county, and city sales and use taxes.
•    An excise tax regime in India includes rules for excise tax and additional excise tax.
•    A VAT tax regime in Argentina includes rules for standard VAT, additional VAT, and perception VAT.

“A distinct charge imposed through a fiscal or tax authority”
Examples of a tax include VAT for the United Kingdom and TVA for France.

Tax Jurisdiction
“A geographical area where a tax is levied by a specific tax authority or where a specific tax rate applies”
Examples of tax jurisdictions include:
•    The tax jurisdiction for VAT in Germany is the country of Germany.
•    The tax jurisdiction for a San Jose city tax is the City of San Jose, California.
•    The tax jurisdiction for Provincial Goods and Services tax (PST) in Canada is a particular Province, such as Ontario or British Columbia.

Tax Status
“The taxable nature of a product or service in the context of a transaction for a tax type”
Examples of a tax status include taxable standard rate, zero rated, exempt, and non-taxable. A tax status is similar to the concept of the tax type definition used within Payables and receivables in releases prior to Release12.

Tax Rate
“The rate specified for a tax status in effect for a period of time. You can express the tax rate as a percentage or as a value per unit quantity”
An example of a tax rate is 7.5% for a state sales and use tax.

Recovery Rate
The rate of input tax that is allowed to be recovered or offset against output tax. The recovery rate is applicable to VAT taxes. For example, organizations that only produce VAT applicable goods and services can use 100% recovery rate on most purchases.
Organizations that produce VAT exempt goods and services, for example, financial institutions, have a 0% recovery rate.

Operating Unit Tax Accounts
The tax accounts that the system uses to post the tax amounts derived from your transactions.
The tax accounts you define serve as default accounting information for taxes, tax rates, tax jurisdictions, and tax recovery rates.


Oracle PL/SQL – Calculating Weekdays between two dates

Calculating total number of Week Days between two given dates is most common requirement. This article shows few methods to do this.

Calculating total number of Week Days between two given dates



ToDate DATE )


ToTalSunDays NUMBER := NEXT_DAY(ToDate – 7,’SUNDAY’) –

NEXT_DAY(FromDate – 1,’SUNDAY’) ;

ToTalSaturDays NUMBER := NEXT_DAY(ToDate – 7,’SATURDAY’) –

NEXT_DAY(FromDate – 1,’SATURDAY’) ;


RETURN (ToDate – FromDate – (TotalSundays+TotalSaturdays)/7 -1) ;


Executing this function in a pl/sql block…



2 BusinessDays NUMBER;


4 BusinessDays := TotWeekDays(’01-MAY-2001′,’31-MAY-2001′) ;

5 DBMS_OUTPUT.PUT_LINE(‘Total Business Days : ‘||TO_CHAR(BusinessDays) ) ;

6* END;

SQL> /

Total Business Days : 23