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

‘Alternative Payee Name’ Options for Accounts Payable

Posted on February 27th, 2011 by Sanjit Anand ||Email This Post Email This Post

Thanks to reader Ganesh, you pointing this functionality availability in EBS.Last time I observed this lacking functionality while one client migrated from SAP to oracle.

Good news for those having Oracle R12.1.1 , they can utilize this new functionality where a new attribute in the supplier form enabled them link the payee of supplier A to the payee for supplier B(alternate payee). Then after Payable department can enter an invoice you go to the Remit-To columns and set them to the alternate payee.

You need to update the supplier and create a relationship with the alternate supplier in the suppliers form. When new invoices are entered these remit to supplier fields at the invoice header default if just one relationship exists or can be selected from LOV if multiple exist. It appears that if there were multiple relationships this can be changed after validation but prior to accounting.

Check it out for more details at metalink #949183.1

Reference Post

Posted in Oracle Payable, R12 | No Comments »

Oracle Enterprise Content Management Suite 11g

Posted on February 26th, 2011 by Sanjit Anand ||Email This Post Email This Post

dgreybarrow What’s New in Oracle Enterprise Content Management Suite 11g

At the Suite-level, the 11g release provides a number of new features and enhancements to its platform, core content services and repository management that are carried across product components, including:

  • Oracle Fusion Middleware infrastructure: Oracle ECM Suite 11g has been fully transitioned to the Oracle Fusion Middleware platform, with all applications being supported by Oracle WebLogic Server and an Oracle Enterprise Manager dashboard for centralized system installation, configuration, monitoring, logging, performance metrics and diagnostics.
  • Unified content repository: Oracle Content Server provides a unified repository for all Oracle ECM Suite 11g applications, to facilitate the deployment of all services on one infrastructure.
  • Broad server platform and directory support: Oracle ECM Suite 11g offers more choice for organizations with heterogeneous environments, by offering server platform operating system support for Linux, Solaris, AIX, HP/UX and Windows across all applications. Its also expands directory support for all components, adding Oracle Internet Directory and OpenLDAP, in addition to continuing support for Active Directory.
  • Secure Web services: This enables WS-Security for all ECM services, providing support for Security Tokens such as SAML assertions, Kerberos tickets, X509 certificates and custom tokens.
  • Other capabilities: Fast Check-in capability enables organizations to pick and choose which applications and check-in service calls they want to tune for extreme content ingestion speeds –enabling organizations to support multiple types of applications on one unified repository and platform supporting high volume imaging to collaborative document management, and access-intensive digital asset and Web site management.

dgreybarrow Oracle ECM Suite 11g product components include:

Oracle Universal Content Management (UCM) 11g; for document management, Web content management, digital asset management, and built-it retention management.
Oracle Imaging and Process Management (I/PM) 11g; for document imaging and business process management related to automating paper-intensive, back office operations.
Oracle Universal Records Management (URM) 11g; for applying records and retention policies to physical and electronic content in a single consolidated system or “in place” across other content stores.
Oracle Information Rights Management (IRM) 11g (restricted use); for securing sensitive content beyond the network to user’s desktops, flash drives, and laptops to prevent unauthorized usage.

Posted in Emerging Technologies | 1 Comment »

Public Speaking Tips : The Presentation Secrets of Steve Jobs

Posted on February 20th, 2011 by Sanjit Anand ||Email This Post Email This Post

If you like to learn some of the techniques and styles that make Steve Jobs such a great presenter, here’s some excellent advice from Businessweek columnist Carmine Gallo, who is also the author of the book – The Presentation Secrets of Steve Jobs. I think it is an awesome video on presentation skills.

Here are some points extracted from the video:

  • Make your theme clear and consistent
  • Create a headline that sets the direction for the meeting
  • Provide the outline
  • Open and close each section with a clear transition
  • Make it easy for your listeners to follow your story
  • Demonstrate enthusiasm e.g. extraordinary, amazing, cool, incredible, unbelievable, awesome
  • Wow your audience by seeling an experience
  • Make numbers and statistics meaningful
  • Analogies help connect the dots for your audience
  • Make it visual
  • Point a simple picture that doesn’t overwhelm
  • Identify your memorable moment and build up to it
  • Rehearse, rehearse, rehearse
  • Last but not the least…
  • Give your audience an added bonus to walk away with

Posted in General Interest | No Comments »

Understanding “GL Program Optimizer”

Posted on February 19th, 2011 by Sanjit Anand ||Email This Post Email This Post

It is one of the performance improvement tools(mimics a cost-based optimizer.) in Oracle EBusiness within GL product ,that is available to the GL super user responsibility. It has two major functions:

  • Collect statistics to aid in the running of FSGs and GL posting
  • Build indexes on gl_code_combinations where they do not exist.

When you run this program, it collects and stores information on the spread of balances in gl.gl_balances which is used by both the GL posting program and FSGs. Given that the number of balances in gl.gl_balances increases each month with the month end roll process, it is important for the overall performance of posting and FSGs to keep the GL program optimizer stats up to date.

dgreybarrow Running the Program
This program is run by logging onto the GL super user responsibility and then running the concurrent program – GL Program Optimizer.

When running the GL Program Optimizer there are two options:

  • Collect Statistics (Default Yes) -Set this value to Yes
  • Rebuild Indexes (Default No) – Set this value to No

The GL Optimizer, when run with Gather statistics checked, will populate the gl table GL_SEGMENT_FREQUENCIES with current data in regard to your GL_CODE_COMBINATIONS and GL_BALANCES tables. This data is used in some gl programs to maximize performance

dgreybarrow How often often GL Program Optimizer be run?

You should run the GL optimizer at least once a period or after creating a large number of segment values, defining a new chart of account.It better set this up as a scheduled job to be run once per month, a couple of days after the month end roll over.

The GL optimizer is designed primarily to make FSGs run faster. Its recommend that for validation of flexfields, you also create a non unique concatenated index on the account segment, followed by all the other defined segments in flexfield order.

Anyone have more experience with this program , share your input:)

Posted in Oracle General Ledger | 1 Comment »

Review :Oracle E-Business Suite R12 Supply Chain Management

Posted on February 19th, 2011 by Sanjit Anand ||Email This Post Email This Post

Recently I got a chance to go through the book ‘Oracle E-Business Suite R12 Supply Chain Management’ – Packt Publishing. I found this book to SCM Book R12be very informative. This is a must read for beginners as well as seasoned shop floor personnel who turn themselves to know how Oracle SCM product works. For the beginners, in particular, the book offers basic understanding through some examples such as that of Sarmixa telecom. Such discussion would certainly come handy for the beginners. The book is not a bulky one which is one of its USPs and major thrust is on SCM providing insights supplemented by business case with implementaion of EBS for Sarmixa Telecom. All in all, an interesting read.

Topics covered in the books:

Chapter 1: Getting Started with Oracle Supply Chain Management
Chapter 2: Getting Started with Oracle E-Business Suite
Chapter 3: Oracle Advanced Supply Chain Planning
Chapter 4: Overview of Oracle Order Management
Chapter 5: Overview of Oracle Purchasing
Chapter 6: Overview of Oracle Landed Cost Management
Chapter 7: Overview of Oracle Inventory Management
Chapter 8: Overview of Oracle Cost Management
Chapter 9: Overview of Oracle Advanced Pricing

Meanwhile you guys can have a look at one of the sample chapter on following link, more updates once i finish reading.

Posted in Beginner, Misc | No Comments »

Maintenance Wizard in OracleApps

Posted on February 13th, 2011 by Sanjit Anand ||Email This Post Email This Post

Oracle Support provides Maintenance Wizard is a free Tool(Mostly used by DBA) that guide you through the upgrade of Oracle Applications technology stack and products from Release 11i versions to Release 12. Some of the important high point for Maintenance Wizard in Oracle EBS are:

  • Maintenance Wizard is a self-service tool that guides customers in a methodical and repeatable way through the upgrade process.
    • Presents a consolidated, personalized set of instructions in a step-by-step format
    • Validation of important activities
    • Maintains log and status information for all tasks
    • Downloads, merges, and installs many required patches automatically
  • It is provided FREE for Oracle Applications customers who have a standard Product Services contract with Oracle.
  • Maintenance Wizard is supported the same way as any other Oracle product
  • This was formerly Known as Upgrade Assistant
  • This also provides project management utilities to record the time taken for each task and completion status

Maintenance Wizard helps you to reduce upgrade tasks by dynamically filtering the necessary steps based on criteria it obtains from your Applications environment. The resulting report is a set of step-by-step instructions of exactly what you need to do to complete your specific upgrade, including any critical patches that your system may require. It can also automatically execute many of the tasks for you, so as to reduce the possibility of errors or accidental omission of vital tasks

dgreybarrow Post for your Interest on subject Line

  • Note 215527.1 – ‘Maintenance Wizard Overview’
  • Note.251253.1 Ext/Pub Maintenance Wizard FAQ
  • Note.248708.1 Int/Pub Authoring Wizard Frequently Asked Questions (FAQ) and Known Issues
  • Note.741129.1 Ext/Pub How to Use Patch Wizard Without Setting up Internet Connection

Posted in Oracle Application | No Comments »

What is Amortized Asset and Expensed-Off Assets Adjustment? Part -II

Posted on February 11th, 2011 by Sanjit Anand ||Email This Post Email This Post

In last post, you have seen what is difference between Amortized Adjustment & Amortized Adjustment , this post we will explore more on Oracle treatment for those two options.

Consider an asset (For e.g. a machine) who’s cost is $100 and has a life in years = 5. Now at the end of 3 yrs, you perform a life adjustment to increase the life of the asset to10 yrs. The table below shows how the accumulated depreciation amount and the calculation will differ for Expensed and Amortized adjustment.

Asset Cost :$100
Life in Years :5
Depreciation/Year :20
At the end of 3 yrs :60

dgreybarrow Expense Adjustment

An expensed adjustment recalculates accumulated depreciation as if the adjustment has been in effect since the asset has been added to service.

In an expense adjustment, accumulated depreciation is recalculated. For 5 yrs STL method, at the end of 3 years accumulated depreciation would be $60. For 10 yrs STL method, at the end of 3 years accumulated depreciation would be $30. When a life change is effected, the accumulated depreciation is adjusted to $30 (60-30) and then on annual depreciation of 10 gets accumulated till the asset gets fully depreciated.

dgreybarrowAmortized Adjustment

On the other hand an amortized adjustment spreads the change over the remaining period of life

So with the same example, if you instead AMORTIZED the change, the accumulated depreciation will still be $60 (that is, not reduced to $30), and annual depreciation of new depreciable amount (cost – accumulated depreciation – salvage value)/remaining asset life (assume salvage value = 0) = (100-60-0)/7 = $5.71 will be taken. The remaining life is taken to the new life in months (If life adjustment has been performed) multiplied by the Rate Adjustment Factor.

dgreybarrow Rate Adjustment Factor aka RAF

After an amortized adjustment, the depreciation amount is adjusted by a Rate Adjustment Factor which allocates amortized change over the remaining life.

Formula for the Rate Adjustment Factor is:

(New Recoverable Cost – Recalculated Depreciation Reserve)/New Recoverable Cost

Posted in Oracle Asset | No Comments »

What is Amortized Asset and Expensed-Off Assets Adjustment?

Posted on February 11th, 2011 by Sanjit Anand ||Email This Post Email This Post

When you are changing financial information of any asset once its aquired in system then you will have two options under financial side.

  1. Effect of adjustment should have retrospective effect, ie, asset will be treated with new financial information as though it would have been, when asset is added or
  2. Effect of adjustment should have prospective effect,ie, the effect of adjustment will affect only future depreciation amounts.

If you choose option 1,it is called EXPENSED ADJUSTMENTS. For expensed adjustments, Oracle Assets recalculates depreciation using the new information and expenses the entire adjustment amount in the current period. Any excess or deficit of depreciation on account of change in financial information will be charged in the current period.

If you choose option 2,it is called AMORTIZED ADJUSTMENTS. For amortized adjustments, Oracle FA spreads the adjustment amount over the remaining life or remaining capacity of the asset. For flat-rate methods, Oracle Assets starts depreciating the asset using the new information. You can set up your amortized adjustments to have a retroactive start date by changing the default amortization start date (usually the system date) to a date in a previous period. Any adjustment amount missed since the amortization start date is taken in the current period. If you amortize an adjustment for an asset, you cannot expense any future adjustments for that asset in that book.

Amortize check box is available in scrren which you need to open via this navigation (N) Asset workbench>Books

Posted in Oracle Asset | 1 Comment »

What is Oracle Guardian?

Posted on February 11th, 2011 by Sanjit Anand ||Email This Post Email This Post

Oracle Guardian is an intuitive tool for preemptive system support. This product is used to find potential problems before they require the attention of your IT support staff or impact your operations and your customers.

Oracle Guardian helps to streamline deployments and day-to-day operations. At the touch of a button, Oracle Guardian does the following[Adopted]:

  • Automatically finds and recommends the right updates and maintenance packs – saving your team time and maximizing your efficiency
  • Scans your domain in seconds to immediately recognize and diagnose software defects.
  • Using simple diagnostic Signature Patterns, quickly provides intuitive and detailed information about potential problems and how to fix them
  • It offers side-by-side comparisons of snapshots or domains, constructing a timeline and comparing configuration and inventory differences
  • It offers customizable signature annotations for managing, filtering, and tracking Signature Patterns and work related to detected Signature Patterns
  • Integrates with Oracle JRockit Mission Control, collecting data through the JRockit Runtime Analyzer and applying Signature Patterns to the data

dgreybarrow What products does Oracle Guardian work with?

It works with most of the ex-BEA product line like WebLogic Platform 8.1 and above

  • WebLogic Portal
  • WebLogic Integration
  • WebLogic SIP Server
  • AquaLogic Service Bus
  • AquaLogic Data Services Platform
  • RFID Enterprise Server

Read the rest of this entry »

Posted in Beyond Apps | No Comments »

Credit Card Transactions in Iexpense -> Accounting for Credit Card Transactions (Part II)

Posted on February 4th, 2011 by Sanjit Anand ||Email This Post Email This Post

In previous Post you have seen different options for Credit Card payment selection, here we are going to details about the accounting entry under different payment options option is used.

dgreybarrow Where is recording

Normally , the payment to the credit card company will result in a decrease in the Cash account. This can be achieved by crediting Cash. The debit amount or amounts will depend on whether the credit card transactions were previously entered in the accounting records.

For example, if the credit card purchases had not been previously entered, then there will be debits to the accounts that are appropriate for the charges. Let’s assume that credit card transaction was for an Confrence Trip . That amount might be debited to Confrence Trip Expense. If the this time credit card transactions were for airline tickets and hotels, you might debit the account Travel Expenses for those amounts.

However, it is possible that the credit card bill was recorded in the accounts prior to paying the credit card bill. Using the example above, the accountant may have debited Confrence Trip Expenses and Travel Expense, and credited Credit Card Payable at the time the bill or statement was received. If the credit card bill is paid two weeks later, the payment will be recorded with a debit to Credit Card Payable and a credit to Cash.

dgreybarrow Expenses Clearing Account

This account is required when you use the Company Pay payment option of Oracle Internet Expenses. Payables uses this as a temporary account to record credit card transaction activity. Payables debits this account when you create an invoice to pay a credit card issuer for credit card transactions. Payables credits this account with offsets to the original debit entries when you submit Expense Report Import for an employee expense report entered in Internet Expenses that has credit card transactions on it.

dgreybarrow Accounting for Credit Card Transactions

In previous Post you have seen different options for Credit Card selection, lets see the accounting entry under different payment option. In order to get indepth, lets assume a user have booked a expense report of $1150 and those were created with these details:

  • Cash and Other Expenses: $500
  • Credit Card Business Expenses: $650
  • Credit Card Personal Expenses: $299

Read the rest of this entry »

Posted in Oracle Application | No Comments »

« Previous Entries