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

E-Business Suite Release 12.1.3 Now Available

Posted on August 26th, 2010 by Sanjit Anand ||Email This Post Email This Post

Announced early this week Oracle E-Business Suite 12.1.3 is now available for download.

R12.1.3 is a purly a maintenance patch (RUP) and can only be installed on top of an existing EBS 12.1 environment. which combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patch set.

On the Finance, Procurement and HRMS there is the usual small changes here and there, additional changes for different countries. Compare to 12.1.1 and 12.1.2 had a lot more functionality that we would be interested in all.


  • Oracle E-Business Suite Release 12.1.3 Release Update Pack (Patch 9239090)
  • Oracle E-Business Suite Release 12.1.3 Readme (Note 1080973.1)
  • Oracle E-Business Suite Release 12.1.3: Release Content Documents (Note 561580.1)

Of interest to reader will keep updated with some new features in upcoming post.

Posted in News, R12 | No Comments »

Oracle – Service Contract Creation APIs

Posted on August 20th, 2010 by Sanjit Anand ||Email This Post Email This Post

A Service Contract is a mutual agreement between the customer and the supplier for the products and services being purchased. Oracle allows us to create the following types of Service Contracts:

  • Warranty
  • Extended Warranty
  • Service Agreement
  • Subscription.

Oracle Service Contracts is the module that provides functionalities to manage above listed contract the simplest way possible.

Oracle does not provide any interface tables and concurrent programs to import the legacy contract data. The only way to import them is through these API’s. All the above types of contracts can be created with the same API.

The OKS_CONTRACTS_PUB is the main public API provided by the Oracle Contracts for Service application. The individual APIs are defined as procedures in this package

dgreybarrow Service Contract Public API – OKS_CONTRACTS_PUB

The OKS_CONTRACTS_PUB is the public API provided by the Oracle Contracts for Service application. Within this package, other APIs are specified as independent procedures. Following are the key APIs included in OKS_CONTRACTS_PUB:

  • CREATE_CONTRACT_HEADER: This API is used to create contract header information.
  • CREATE_SERVICE_LINE: This API is used to create contract line for each contract header. This single procedure creates the service/Usage/Warranty line depening on the line type passed.
  • CREATE_COVERED_LINE: This API is used to create covered lines (also called sublines) for each service line.
  • CREATE_BILL_SCHEDULE: This API is used to create the billing schedule for each Service/Usage line.

Posted in Service Contracts | No Comments »

WithHolding Tax and Oracle EBS

Posted on August 18th, 2010 by Sanjit Anand ||Email This Post Email This Post

WHT functionality is offered in Oracle under AP module.

Similar to Automatic VAT processing, Oracle provides the feature for automatic WHT processing. To perform automatic withholding, assign a WHT group (not WHT) to an invoice or invoice lines. WHT group defaults from supplier site. If required, the user can override the default and select a different WHT group.

Typical configuration for Withholding Tax in AP broadly consist of the following four steps

  • Payables Option: Withholding Tax Tab: Allow WHT in Payables Option window for the operating unit

To allow Automatic Withholding Tax for your invoices and expense reports, enable the Use Withholding Tax Payables option.
Navigation: Payables > Setup > Options > Payables > Withholding Tax tab

  • Define your Withholding Tax Authority as Supplier with Venfor Type as ‘Tax Authority’

Define withholding tax authority supplier. Define this supplier as a Standard Supplier with Supplier
Type as ‘Tax Authority’. WHT invoices are created against these suppliers.
Navigation: Payables > Supplier > Entry

  • Define WHT group

Define WHT codes with tax type as ‘Withholding Tax’ and enter the GL Accounts for the WHT accounting.
Navigation: Payables > Setup > Tax > Withholding > Codes

  • Enable WHT on Supplier / Supplier Site for standard suppliers

You need to enable WHT on Supplier and Supplier site. Optionally you can also enter default WHT group for the supplier site.

Accept the default withholding tax group from the supplier site or select another from a list of values while raising the invoice.

Navigation: Payables > Supplier > Enter > Tax Details

Posted in Oracle Payable | No Comments »

Pricing in Purchasing

Posted on August 18th, 2010 by Sanjit Anand ||Email This Post Email This Post

The Procure To Pay cycle (PTP) of any industry includes following some basics steps:

  • Requisition is raised by any department of the plant. Or any automatic process (MPR, Min-Max Planning)
  • The Purchasing Dept. employee (buyer) creates the PO based on the Requisition and previous price information when this exists, otherwise, buyer creates Request for Quotation (RFQ) from different suppliers, based on the Requisition.
  • The Quotations are sent by suppliers in response to the RFQ.
  • The buyer will analyze various Quotations and place the PO on a supplier, based on analysis
  • The Supplier receives the PO and the notification if he has iSupplier Portal implemented .He then supplies the goods on PO lines or sends an ASN.
  • The receiver receives the goods.
  • The invoices are raised and payment is made to the Supplier.

Oracle Purchasing support the pricing using the following structure

PO Pricing


Oracle’s standard features include:

  • Creation of Purchase Requisitions
  • Recovery Pricing information from ASL setup
  • Recovery buyer information from Organization Items Setup
  • Creation of PO and receipt against a PO shipment

Posted in Oracle Purchasing | No Comments »

AssureNET GL : Thats a good Product for “Account Reconciliation”

Posted on August 13th, 2010 by Sanjit Anand ||Email This Post Email This Post

Have you heard about the product called “ASSURENET” , this is one of good product for reconcilation activity getting attention now a days by Accountants , Auditors ,controllers because the good capability of managing Finance accounts reconciliation and Audits trials feature. No matter its Balance sheet account or bank account, this product have great functionality which will add lot of value to business.

What is AssureNET

AssureNET GL is a web-based process management system for the general ledger account reconciliation & certification function. It is designed to strengthen the account reconciliation internal control while making the process much more efficient and SOX compliance.

This Product normally comes with three major functional modules like:

  1. Complete Assigned Tasks & Activities Module
  2. Prepare or Monitor Quality Assurance Reviews Module
  3. Manage or Monitor Task & Activities Module

Using this software you can get the advantage of following benefits:

  • This will Simplified the account reconciliation process , as most of the ERP does not have enough capability keeping the auditors in mind.
  • This will reduced the amount of time necessary for Internal Audit’s testing of account reconciliations.
  • This enhanced the visibility into the performance of the control across the entire enterprise which may include detailed analysis by department, location, products or region.
  • Automated email notifications will help to inform participants of impending reconciliation and review dates or missed deadlines
  • Automated summaries of exception statistics and extensive management reporting
  • Last but not the least complete segregation of duties between the reconciliation, review, approve and certification functions

Application Technology

Typically this application is developed using

  • .NET Framework
  • ASP.NET , AJAX Extensions
  • And SQL Server as database.

This comes with hosted solutions via vendors On-Demand business unit as well as you manage and own this this product at your site.

Check out this product at vendor site, if your department is ready to spend few thousand of dollar.

Posted in Oracle General Ledger, Oracle Product | 1 Comment »