Bookmark and Share Subscribe You may face visibility problem if is blocked on your network

Wednesday, December 21, 2016

Decoding GST for India, Oracle EBS way

Objective of this page is to provide a junction from where people can find their way quickly.

This is an attempt to decode solution offered by Oracle for GST in India.
In this article I am planning to put some important links of documents given by Oracle or created by myself or other generous people who are sharing their efforts.

From myself:

From Oracle

Pre-release Documentation - Phase 2
Document Name
Document Details
This document provides an overview of the capabilities of the phase 2 EBS GST infrastructure including guidance on the features that can be tested based on the scope of this phase.
This document describes how to configure the O2C cycle.
This document describes how to configure the P2P cycle.
This document describes functional flows for Bill of Entry (BOE).
This document describes supported functional flows under IRISO and Inter Org transfer.
This document describes supported functional flows under OSP.
This document describes setups for configuring TDS under the new architecture.
This document describes the procedure for importing taxes from third-party applications to AR and AP Modules in Oracle Financials for India.
This document describes the functional flows and setup procedures for configuring Oracle Financials for India Block of Asset functionality in the Fixed Asset (FA) module.
This document provide guidelines to calculate taxes on transactions initiated from modules that are not localized once it is imported to AR or AP modules.

Below are links to India GST video recordings that provide detailed step-by-step implementation details.

Few more articles from Oracle

From other sites / blogs

Coming soon....

Wednesday, May 18, 2016

How to cancel / terminate / abort workflow in Oracle R12?

One way is to do it using API WF_ENGINE.ABORTPROCESS by wrtting a simple script like below…

  WF_ENGINE.ABORTPROCESS ('GLBATCH', ' 2949213*847');  
-- wf_engine.ABORTPROCESS ('Type Internal Name', 'Item Key');


Another way which I think is more appropriate than API is to do it from front end… to perform below steps you need to have workflow admin access.

Step 1: Query the workflow and click on ‘Activity History’ button

Step 2: Click on ‘Cancel Workflow’ button
Step 3: Click on ‘Apply’ button

Step 4: Re-query workflow, verify if workflow is cancelled
Step 5: Open ‘Activity History’ and verify if open notification is closed / complete

Thursday, April 28, 2016

Letter of credit (LC Matching) feature in Oracle R12

Background of Letter of Credit (LC):
letter of credit is a letter from a bank guaranteeing that a buyer's payment to a seller will be received on time and for the correct amount. In the event that the buyer is unable to make payment on the purchase, the bank will be required to cover the full or remaining amount of the purchase.

In Oracle R12, this feature is a part of India Localization and it works at the customer level. It is different than Credit Check functionality available in base apps.

Let’s see how it works in system:
Say I want to ship material of amount for which customer has given be LC.

While saving the sale order make sure ‘LC Flag’ is selected in ‘Sales Order India Localization’ form.
Rest of the process of entering/booking sales order is normal.

* We will try to ship only one quantity
Perform below steps
  1. Split the line to 1 qty.
  2. Pick release order line

Now try to ship confirm the shipment.
Though at sales order level ‘LC Flag’, we did not match the LC with this shipment. In such cases, shipment will not go thru, system will show below error and the time of ship confirm.

Below is the form where we can create LC in system. As and when LC is applied to shipments, ‘Balance Amount’ value would get reduced.
Note: LC amount shall be inclusive of tax amount. Example: If sale order line amount is 100 and taxes on that line is 10.23, then LC need to be created of amount equal to or more than 110.23

Below is the screen where we can apply LC to order shipment, it is applied at Delivery details ID level.

Scroll to right side to see more columns. Feed all required details and click on ‘Apply’ button.

Once LC is applied to the line, balance amount of LC shall reduce by applied amount. Let’s verify it.

Sales Order base price
Sales Order line total (1+2)

LC amount
Sales Order line total
LC balance amount (1-2)

Transactional details of LC will be available if you click buttons at bottom of the form… like ‘Qty Amendment’, ‘View Transaction’

Now as LC is applied to the shipment, system will allow to ‘Ship Confirm’.

You may be interested in below article as it given insight of accounting of LC.

Please add your valuable feedback / comments


This blog is purely personal and the thoughts expressed here represent only me. The purpose of this blog is to share information and knowledge about Oracle's product which I have come across with my exposure to the product, practice and observations. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. The blog has been created solely as a educational, for storing portions of the vast Oracle knowledge world. Oracle EBS is an Oracle Corp. product and you should contact Oracle directly for any specific fact or issue.

*NOTE: Few articles on this blog are not completely prepared by me, content is edited and complied after referring various sites to make visitor's job easy