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

Oracle terminal releases and terminal patchsets,CPU

Posted on January 25th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Few reader question..

  1. What is the difference and theory behind Oracle terminal releases and terminal patchsets ?
  2. What are Critical patch updates ?
  3. What is the terminal release after 11.5.10 CU2? or Do you have 11.5.10 CU3/CU4?

Terminal release means that the version specified is the last point release of that product. For example, the “terminal release 11.5.10” for the 11i E-Business Suite would mean that there will not be any further releases of 11i after 11.5.10. Specifically, that would mean there will not be a release 11.5.11 for 11i.

The terminal patchsets means that would the last patchset provide on that particular release.

This is very simple as this example:
In 10g Release 2 the last patchset would be, upon further there won't be any more patchset will be released under this version.
In 9.2 release the last patchset is, upon further there won't be any more patchset will be released under this version.

In other word :Terminal meaning no more patchsets are going to be delivered, so you will be forced to either apply one-offs or upgrade.

Critical patch updates

Oracle provides critical patch updates (CPUs) to its customers to fix known bugs that are critical in nature also includes security fixes.

Critical Patch Updates are the primary means of releasing security fixes for Oracle products:(Adpoted-otn )

  • A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes nonsecurity fixes that are required (because of interdependencies) by those security patches.
  • Due to the threat posed by a successful attack, Oracle struongly recommends that fixes are applied as soon as possible.
  • CPUs are released on the Tuesday closest to the 15th day of January, April, July and October each year

You can find information at Oracle Technology Network .

Q .What is the terminal release after 11.5.10 CU2? or do you have 11.5.10 CU3/CU4?

It's just a matter of terminology.There was the original 11.5.10 install (or upgrade maintenance pack).Then came (3240000), (upg from 1CU 3460000) and (upg from pre-11.5.10 3480000).

Since there was change in stretegy that why here are the details for ATG Rollup patchsets

  • CU3 = ATGRUP3 (4334965)
  • CU4 = ATGRUP4 (4676589)
  • CU5 = ATGRUP5 (5473858)
  • CU6 = ATGRUP6 (5903765) :This is the latest

dgreybarrowOracle EBS 11i Technology support Matrix


dgreybarrowMetalink Notes

  • 738923.1 :Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Note (January 2009
  • 315713.1 :Prior E-Business Suite Security Alerts
  • 329689.1 :E-Business Suite (Oracle Applications) 11.5.1 through 11.5.6 Desupport Notice
  • 363827.1 :Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10

dgreybarrowRefrence Link :

Posted in AOL | 1 Comment »

User Unable to Export Data to TSV File

Posted on January 23rd, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

For new Implementation, certain things never focused by implementation team i.e user desktop configuration which might be a big reason that is reported by end user once Business switch to new system. This is specially true, when your client belong to SME's (Small and medium enterprise).

Lets me summarize few issue with File ->Export

  1. User Unable to Export Data to TSV File
  2. Export functionality does not prompt for saving the file.
  3. Data export from Oracle form is missing some rows in the output file , specially from AP Invoice workbench , Gl account enquiry screen and AR Transaction workbench

Some of them are purely desktop issue, still you need to do such steps if such things being reported by remote users.

Do verify the following:

  1. You should have the following Viewer Option entry: File Format Mime Type Description Allow Native Client Encoding
    -------------- -------------------------------- -------------------- -----------------------
    Excel application/ Microsoft Excel Checked
  2. Check out the table FND_MIME_TYPES_TL entry. A row contains an entry for FILE_FORMAT_CODE = "EXCEL" and MIME_TYPE ="application/"

Next you need to verify these details:

  1. What is the windows OS on your computer (XP, W2000, etc...)? Which service pack?
    i.e.: Microsoft Windows XP - Profesionnel - Version 2002 - Service Pack 2 check the comptability matrix.
  2. Version of excel on user computer.
  3. Version of Internet Explorer in user computer.
  4. Deactivate any pop-up blockers in windows XP or in Internet explorer
  5. You need to do a try to compare the two computers? (The computer where you have the issue and the computer where the export is working)
  6. Try the following as part of quick check:
    In the Tools -> Internet options, set the following:
    • Open Internet Explorer and choose Tools-->Internet Options
      • Click on the Security Tab
      • Click the Custom Level button
      • Scroll down to the "Downloads" options
      • Enable the option "Automatic prompting for file downloads"
      • Enable the option "File Download"

Once you done, close browser, open browser than try to export again.

If still getting an error , you need to verify these details too.

  • In Internet Explorer select the Tools menu - Internet Options - Security - Custom Level
  • Adjust all the settings for ActiveX Controls and Downloads to be either 'enable' for the following zones :
    • - Internet
    • - Local Intranet
    • - Trusted Zones
  • Try to add the site of instance to Trusted Zone and adjusted Security level to Low protection.
  • Restart the browser and now test.

99% chances that you can able to resolve 1 and 2 , else not, ask Oracle with SR and wait for a day.

For 3,you need to check with Oracle, there might be chances the version of form is bit lower.

Similar Post

Posted in AOL | 1 Comment »

It’s been a long time…A busy month….One million Page views !

Posted on January 20th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Well its been nearly more than a month since I last posted something here. I must have been busy because I dont know the reason why! Things simply went uncontrolled since last week of Dec '08. Well actually I have been a super busy, 1 millionworking on a client project in the office that was due to go live in first week of Jan'09 and wanted to make sure it went ok.

I don't know about you but I'm exhausted.So, it is time to relax.. festive season locally,a long weekend for Lunar New year therefore a perfect occasion to do some housekeeping for blog .

Thanks for everyone...

Moreover, Normally I pay so little attention to this blog since last one month, that I didn’t notice my page view count rolling over 1 million. It must have done somtime at least begining of this year. Therefore, I would like to thanks To all readers,visitors.

In the 19 months since I start counting, I think that’s a fantastic achievement (if I say so myself!)

But, I’m going to be slow blogger till end of March,09 because of some added responsiblity with new role , still keep you posted thats will help to support your daily life with Oracle.

I know I've been very behind in answering comments lately, but I hope to get back to it soon, so please be patient if you're waiting.If there's anything you'd like me to cover which I haven't already, just get in touch via comment, I will try to reach as much I can.

Wishing a very happy Chines new Year to everyone.

2009 will be the Year of the Ox, which symbolises prosperity through fortitude and hard work. In other words, persevere and work hard and steadily. Considering the world ecenomical fact, though it’s not the year to be outrageous or impulsive, but hard work will be rewarded, what you say..lets hope..

Gong Xi Fai Cai!

Thats all for now…And thank you all again.

Posted in Misc | 4 Comments »

Withholding Tax

Posted on January 18th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Withholding tax is an amount withheld by the party making a payment to another (payee) and paid to the taxation authorities, depending on the nature of the product or service being paid for. Local WHT is often used to counteract tax evasion and tax avoidance whereas overseas WHT is often used to collect tax from payers within the boundries rather than payees who may be outside the boundries.

WHT tax is often applied to

  • Dividends and Interest payments: Tax may be deducted at source from dividend payments, in addition to Corporation tax.

In India, tax is not withheld at source from dividends since tax is paid by company on the profits (excluding dividends) and hence dividend income is tax free in hands of payee.

UK has imposed a 20% withholding tax on distributions from Real Estate Investment

  • Payroll payments to employees: In most countries, employers are required to deduct tax from salary.
  • Contract and consultancy work payments: Payments to contractors, consultancy firms, realty business etc are subjected to tax deducted at source Withholding Tax is applied as a part of local regulatory requirement, to reduce the final payment made to the supplier. WHT is then paid to the local tax authority as per the local regulations.

Sometimes WHT is applied to cross country payment, based on country-to-country relations. At other times, it is applied on Invoices from all Foreign Suppliers, to boost local business or to make them subjected to local VAT, which otherwise would be applicable for local suppliers. In few
countries, WHT is applied also on certain types of local vendors as well (eg. consultants).

Posted in Oracle Payable | No Comments »

What is PLM?

Posted on January 17th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This focus on the Product (product innovationproduct profitabilityproduct decisionsproduct lifecycleproduct network)

"Product Lifecycle Management (PLM) is the business activity of managing a company's products all the way across the lifecycle in the most effective way.” (source -*2PLM - Product Lifecycle Management Magazine)

In other word:

  • PLM enables companies to accelerate product innovation and maximize product profitability
  • …through the management of the information, processes and decisions about their products…
  • …throughout the product lifecycle and across the global product network

Which kind of industry needs PLM

  • Industrial manufacturing industry to track and manage engineering change orders .
  • High technology
  • Life sciences and pharma industry
  • Food & beverage
  • Retail

Posted in Beyond Apps, Centrestage | No Comments »

Six things to know about Oracle WorkFlow

Posted on January 12th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Is AME a subcomponent of WF engine?

No. Oracle Approvals Management (AME) is to define approval rules that determine the approval processes for Oracle applications. The Workflow module uses this information for sending notification to the approvers based on the rules defined in AME

Will Oracle provide a Migration Tool from ebiz workflow to BPEL?

BPEL does everything that Workflow can do, but there is no migration tool to take a workflow process and convert to a BPEL process, like oil and water, so BPEL processes have to be built from scratch

In the future, is BPEL going to replace Oracle Workflow with in E-Business Suite?

No, Workflow will not be replaced by BPEL inside E-Business Suite. BPEL is used in Fusion Applications for business process orchestration and integration needs

Can we use Oracle Workflow Builder component alone with other Java Applications?

No, Oracle Workflow Builder is the development tool that is designated to work only with Oracle Workflow

Is it possbile to have Workflow Manager running on separate node?

No, Workflow Manager can only run from the concurrent tier, as it is a component of Oracle Applications Manger which runs on the concurrent tier in Oracle Applications. For more information, please refer to the Oracle Applications Manager online help.

Standalone Oracle Workflow uses Workflow Manager as a component tool of Oracle Enterprise Manager.

Why do some workflows need workflow background processes and some don't?

Depending on the design as some item types need to execute functions which have higher cost so these functions should be deferred and execute later.

This will be happen by the workflow background process. Also if the design has an activity, which is relative to time and the time, has passed the activity is now marked as NOTIFIED by the Workflow Engine, this requires the workflow background process to execute it. Also if the design has a stuck process, which has a status of ACTIVE, but cannot progress any further

Posted in Tool | No Comments »

ChatterPlace – EBS, Fusion, Fusion Apps

Posted on January 11th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

News and Views for Oracle related, all in one place.

  1. AVM: Powerline Repeater / Fritz Repeater
    Last weekend my Powerline Adpater 546E broke. I tried some restarts but after 1-5 minutes the WLAN went down and the adapter got really hot.Perhaps the missing mesh functionality was due to a hardware problem which caused this total failure.Never mind. I ordered a Fritz Box Repeater 1160 and followed the instructions from AVM:Note: If […]
  2. Good But Not Good Enough Coding Practice
    Good: Alert from from localhost but what script is this? If the was only 1 cron entry and intuitive, then I would not be blogging about it. ALERT … Goldengate process “EXTRACT(PU)” has a lag of 02 hour 22 min on localhost Better: Alert is from localhost for ALERT … Goldengate process “EXTRACT(PU)” has a […]
  3. APEX 18.1 New Feature: Logging Web Service Requests
    APEX has turned 18 (ish) and EA-2 is now available. In this post, I will introduce a brand new (very small) feature of APEX 18.1.APEX has had some support for consuming web services even before it was a shipped product (even before it was called HTMLDB). With this release of APEX, Carsten Czarski has made […]
  4. ODA X6-2M – Expanding Storage can be unsuccessful when impatient
    In ‘A Brief History of Time’ (RIP Mr. Hawking), Chapter 2 is named ‘Space and Time’ – and this title fits perfect with a current problem, I was faced with, when expanding disk capacity in an ODA X6-2M.Long story, told shortAn ODA X6-2M, equipped with the standard disk configuration, ran out of space and my […]
  5. Paying someone to learn for you?
    In my previous post called Nobody is an expert at Oracle Database 18c I said, “There will be lots of people and companies who will happily take your money to learn the new tech, but that’s probably the subject of another post…” Here is that post. I see two distinct scenarios, and have two very different […]
  6. Friday Philosophy – Not My Cup Of Tea
    A few days ago I tweeted a copy of a “motivational poster”. I don’t normally like motivational posters but this one struck a chord with me as it was a lesson I took a long time to learn. Not everyone will be your cup of tea. Which is a very British (I think) way of […]
  7. ODA Xx – Space Waste When Using ACFS (instead of ASM) For Databases
    Disclaimer: I will not discuss the necessity of an ACFS FS to store database files, nor compare ASM and ACFS or it’s benefits. What to use / what fits best in Your environment is up to You, folks … ;-)Pretty sure that this is for lots of people a well-known problem – but for all […]
  8. Converting Normal Disk Groups to Flex Disk Groups in Oracle 18c
    In this post, You can convert a conventional disk group ie created before Oracle ASM 18c to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option. Migrating (converting) to a flex disk group can be performed for a NORMAL or HIGH redundancy disk group with the CONVERT REDUNDANCY TO FLEX […]
  9. New look of ASMCA in Oracle 18c
    Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS). In addition, you can use the ASMCA command-line interface as a non-GUI utility. In Oracle 18c database, ASMCA comes up with new GUI interface which looks cool and easy to […]
  10. GDPR Solutions in the Day of Automation
    There’s something for having job security and many of the solutions that I see offered for RDBMS challenges offer just that. With compliance with EU’s GDPR, (General Data Protection Regulations) just around the corner, (mark you calendar, May 25, 2018) you’d think we’d all be scrambling for a simpler solution to discovering and addressing all […]

Posted in Misc | No Comments »

Oracle iSupplier portal – How its Works

Posted on January 9th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle iSupplier Portal enables secure, self-service business transactions between companies and their suppliers provides suppliers with the ability to directly manage business transactions and access secure information

Key business flows Include:

  • Purchase Order Acknowledgement
  • Create Advance Shipment Notice and Advanced Shipment Billing Notice
  • Create Invoice

Core Functionality of this application are :

1) PO Collaboration

  • View and Acknowledge PO
  • Submit PO Change Requests and Split Shipments
  • Manage Deliverables
  • View agreements and PO revision history
  • Issue Work Confirmations

2) Shipment Notices

  • Inbound logistics
  • Plan the optimum route
  • You can view Delivery Schedules, receipt, returns and overdue receipts

3) Inventory

  • View item inventory Information like on-hand stock, item locations, lot and serials
  • Vendor Managed inventory – supplier manage their inventory at customer’s location
  • Consigned inventory – View on hand stock on consigned items as well as associated p2p transactions.

4) Supplier Management

  • Vendor registration
  • Supplier profile Management e.g. address, business classification, bank details, tax details, item, category etc.

5) Buyer’s Internal view

  • Provide all information which supplier view
  • Search information across all the suppliers
  • Search and view supplier items

6) For Invoice and Payments

  • This provides view the history and status of all invoices
  • This Provide view the history of all payments done

Check out at link for Oracle Datasheet .

Posted in Oracle Purchasing | No Comments »

iProcurement – How It Works

Posted on January 4th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle iProcurement enables internal corporate requesters to independently order items from both local (internal) and remote (external) catalogs. It is the starting point for the ordering process and provides powerful self-service requisitioning capability with an intuitive, Web shopping interface.

It is a key component of Oracle Advanced Procurement, the integrated suite that dramatically cuts all supply management costs.

In an efficient and automated manner, Oracle iProcurement:

  • Constitutes a key component of the procure-to-pay business flow.
  • Helps an enterprise process and manage requisitions.
  • Helps an enterprise process and manage receipt of the requested goods or services.

As a part of Oracle Advanced Procurement, iProcurement

  • Delivers measurable savings
  • Reduced maverick spend
  • Greatly simplified process for purchasing goods and services
  • Requesters can quickly purchase the items they need with an easy to use interface that provides all the information they require to make purchases while directing them to preferred vendors and pricing
  • For purchasing managers iProcurement provides powerful tools for managing catalogs in real time, stores and content zones

If you are planning to implement this application, here are the Core features & functionality of this application, boardly divided under these heads.

1.Catalog Management

  • This Provides flexible solution to catalog and content management
  • Punchout / transparent Punchout feature will establish direct link to supplier’s web store to access their catalogs
  • This stores and provide a way for requesters to shop among a variety of catalog types and sources.
  • This provides a category and descriptor Management (Such as supplier and Price)
  • This also control on requester’s access based on categories, catalog sources and operating unit


  • Configure stores to include any combination of local catalogs, punchout catalogs, informational catalogs, and transparent punchout catalogs.
  • Administrators can control which catalogs and stores are available to different classes of requesters.
  • Powerful search Capability
  • Shopping list- Create own favorite shopping list of frequently ordered items. Create public list that can be access by all requestor
  • Saved shopping carts- Create n number of shopping carts in progress.
  • Non Catalog request – Request for items and services which are not in catalog
  • Automatic document creation- Supplier PO contracts and quotation generate PO and releases accordingly without buyer’s intervention.
  • Center Led Procurement- Create global contract agreement and use it for all organization.

3. Checkout

  • Delivery
    • Provide options to stock delivery option like multiple destination types, delivered at one time addresses location.
    • This also integrated with Enterprise asset management
  • Billing
    • You can manage multiple account distribution and account generation workflow rules.
    • This is integrated with Oracle projects and Oracle Grants enables requesters to optionally reference projects, tasks, and award information about shopping cart order lines.
    • Encumbrance support lets user view funds online before submitting requisition.
  • Notes and attachments
    • This Provide additional information to approvers, buyers, suppliers, and receivers by attaching text, URLs, and other file types to the requisition.
  • Approvers
    • Approval and workflow setup determines the approver list for each requisition. During checkout, the requester can add approvers and change the first approver in the approver list. You can also customize it to meet your business needs.

4.Desktop Receiving

  • From their desktop, a requesters can receive internally and externally sourced items or the entire requisition.
  • View supplier advanced shipment notices (ASNs) as well as internal shipments
  • Workflow-driven receipt confirmation mechanism that proactively sends a notification to requesters to confirm receipt on the due date.

5.Requisition Tracking & Management

  • This enables you to track the status of all the requisitions and also Procure to Pay life cycle
  • This will keep real time notification keeps you up-to-date

If your compnay or Procurement dept looking option to simplify and automate company’s flow of ordering for Services,Refill for inventory,CIP , Opex, Capex Purchasing then this application will drastically reduce employee and bookkeeper time spent in procurement process.

Posted in Oracle Footprint, Oracle Purchasing | 1 Comment »

Page 1 of 11