Functional Guy- Devendra Gulve: 2016

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:

Many more to come, stay tuned....

How to make India GST regime tax entry as recoverable in Oracle EBS
Item classification for GST regime
Third party registration for GST in India
GST India Tax types, Tax rates, Tax category setup, Claim Term
First party registration and Common configuration for GST in India
GST - Tax Authority Setup in Oracle EBS

From Oracle

India Goods and Service Tax (GST) Info Center (Doc ID 2176820.2)

India Goods and Service Tax (GST), August 2016 (Doc ID 2170500.1)

Procure to Pay (P2P) Troubleshooting for India GST (Doc ID 2188096.1)

Order to Cash (O2C) Troubleshooting for India GST (Doc ID 2122383.1)

Pre-release Documentation - Phase 2
Document Name	Document Details
EBS GST Infrastructure Scope - Phase 2	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.
Order to Cash (O2C) User Guide - Phase 1 and Phase 2	This document describes how to configure the O2C cycle.
Procure to Pay (P2P) User Guide - Phase 1 & Phase 2	This document describes how to configure the P2P cycle.
Functional Flow for Bill of Entry (BOE) - Phase 2	This document describes functional flows for Bill of Entry (BOE).
Functional Flow for IRISO & Inter Org flow - Phase 2	This document describes supported functional flows under IRISO and Inter Org transfer.
Functional Flow for Outside Processing (OSP) - Phase 2	This document describes supported functional flows under OSP.
Functional Flow and Setups for Tax Deducted at Source (TDS)	This document describes setups for configuring TDS under the new architecture.
Functional Flow for Tax Interface - Phase 2	This document describes the procedure for importing taxes from third-party applications to AR and AP Modules in Oracle Financials for India.
Functional Flow and Setup for Block of Asset Functionality - Phase 2	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.
Guidelines for Calculating Taxes for transactions initiated from modules that are not localized - Phase 2	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…

BEGIN

WF_ENGINE.ABORTPROCESS ('GLBATCH', ' 2949213*847');

-- wf_engine.ABORTPROCESS ('Type Internal Name', 'Item Key');

END;

COMMIT;

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):

A 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

Split the line to 1 qty.
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.

1	Sales Order base price	188967.00
2	Taxes	27872.63
3	Sales Order line total (1+2)	216839.63

1	LC amount	2168397.00
2	Sales Order line total	216839.63
3	LC balance amount (1-2)	1951557.37

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.

https://oraclefinancial.files.wordpress.com/2010/05/case-study-on-letter-of-credit.pdf