Oracle Financials for India (OFI)

Goods and Service Tax (GST)

Support for Import Taxes to
Receivables and Payables
Author: SanthoshKumar Ananth
Creation Date: 11-Feb-2017
Last Updated: 11-Nov-2017
Document Ref:
Version: 2.0

Organization: Oracle India Private Limited

OFI GST Tax Interface Phase2 1

Document Control

Change Record

Date Author Versio Change Reference

n

11-Feb- Santhoshkumar 1A Initial document

2017 Ananth
03-Mar- Santhoshkumar 1.0 Frozen Document
2017 Ananth
11-Nov- Santhoshkumar 2.0 Frozen Document
2017 Ananth

Reviewers

Name Position

Rajnish Kumar Director, Tax development

V S Baburaj Product Strategy Director

Audience

Name Position

12.1 & 12.2 Implementation Team

12.1 & 12.2 Customers

OFI GST Tax Interface Phase2 2

 Table of Contents
Document Control .................................................................................................................. 2
1.Introduction.......................................................................................................................... 4
1.1 Scope............................................................................................................................ 4

2.Old and New features .......................................................................................................... 5

3.Implementation Overview .................................................................................................... 6
3.1 Setup Flow .................................................................................................................... 6
3.2 Troubleshooting Tips..................................................................................................... 7
3.3 Implementation Tips ...................................................................................................... 7
3.4 Best Practices ............................................................................................................... 8

4.Feature Overview ................................................................................................................ 9

4.1 Process Flow - AP......................................................................................................... 9
4.2 Interfacing OFI Taxes to AP .........................................................................................10
4.3 Process Flow – AR.......................................................................................................15
4.4 Interfacing OFI Taxes to AR .........................................................................................16

5.Invoice Number Generation for Interfaced Invoices ............................................................23

5.1 AR Invoices ..................................................................................................................23
5.2 AP Invoices ..................................................................................................................26

6.HSN / SAC Codes ..............................................................................................................27

7.Summary ............................................................................................................................29

OFI GST Tax Interface Phase2 3

1.Introduction
• The Objective of this white paper is to give an overview of the OFI Product extension for
importing GST(Goods and Service Tax) taxes to AR and AP

• This document will help the users to understand the tax import and accounting the same for the
transactions imported from third party systems(Legacy)

1.1 Scope

This document provides the details of Interfacing Taxes to Legacy AR/AP Transactions

The current content has been compiled in reference to the frozen scope specified in the document: EBS
GST Infrastructure Scope.docx

OFI GST Tax Interface Phase2 4

2.Old and New features

Old Feature New feature

Imported external system’s invoice/transaction Imported external system’s invoice with

without India tax to EBS India/transaction tax to EBS

Missing external system’s tax value and Handle external system’s tax value and
accounting in EBS AP/AR modules accounting in EBS AP/AR modules

• The feature will ensure correctness of data for customers and sync of data between EBS
and external sources.

• Helps customer to reconciliation and decision-making

• Make the system more convenient and easier to use

New Features introduced

• Interface Data Mapping UI

• Interface table for imported taxes

• New UI to review and modify (insert, delete, update) incorrect data in the interface table

• New Error messages

• ‘India - Interface Tax Purge Program’

OFI GST Tax Interface Phase2 5

3.Implementation Overview
3.1 Setup Flow

Navigation:

(N)  Oracle Financials for India  Tax Configuration  Define Tax Conversion

A new setup UI ‘Interface Data Mapping’ will be introduced for tax code mapping. Tax code mapping is
provided to user to map external system tax definition with Oracle EBS tax code definition.

Business rules for the UI:

 Operating Unit field is mandatory; LOV will list all available values base on MOAC (Multiple Org
Access Control) architecture
 Taxable Event field is mandatory; Value is External or Standard
a) If it is selected as External then Tax recalculation will not happen. Users need to enter the
tax amount explicitly.
b) If it is Standard then taxes can be recomputed and accounting can be done
 Use EBS Tax Code: Check box, when it is chosen, Tax Code Mapping region will gray, reject
entry.
System will pick the GST taxes defined in the application itself
 Imported Tax Code: user could predefine tax code of imported tax in this region. Imported Tax
Code is unique for one Operating Unit with Taxable Event combination value.
 OFI Tax Code: When user selects Tax code from the LOV, and no modification will be allowed.
They will be retrieved from Existing Tax code definition form.
 Inclusive Flag: Read only.

OFI GST Tax Interface Phase2 6

3.2 Troubleshooting Tips

 Issue

External tax field disabled in Open interface Tax Details India Localization UI

 Troubleshooting

Use EBS Taxable External tax Tax External Tax OFI Tax Field
Tax Code Event field Category Field
Existing

Yes External Any Value Any Value Disabled Always can

Enter/Modify

Yes Standard Any Value Any Value Disabled Always can

Enter/Modify

No External Any Value Any Value Always can Disabled

Enter/Modify

No Standard Any Value Any Value Always can Disabled

Enter/Modify

3.3 Implementation Tips

 Verify external system’s tax code mapping to EBS system’s OFI tax code in ‘Interface Data
Mapping’ UI.
 Upload unique key of original transaction to OFI interface table and EBS transaction interface
table. It will ensure the OFI tax data can be matched to correct transaction line.
a) For AR Transaction : Unique Key of Original transaction for AR will be
BATCH_SOURCE_NAME,LINE_GDF_ATTRIBUTE19, LINE_GDF_ATTRIBUTE20 in
RA_INTERFACE_LINES_ALL
b) For AP Transaction : Unique Key of Original transaction for AP will be
REFERENCE_KEY1,REFERENCE_KEY2 and REFERENCE_KEY3 in
AP_INVOICE_LINES_INTERFACE

OFI GST Tax Interface Phase2 7

3.4 Best Practices

 Upload OFI interface table along with base interface table when user is trying to update EBS with
data from his external system.

OFI GST Tax Interface Phase2 8

4.Feature Overview
4.1 Process Flow - AP

Import Invoice Data to AP

Interface Table

Import Tax data to OFI

Open Interface Table

Run “Payable Open Correct Data in Base/OFI

Interface Import” Interface

Program Check Error message in

Completed log/output file
Successfully

View Imported Taxes in

Tools  India Tax details

Validate the Invoice

OFI GST Tax Interface Phase2 9

1. Import Invoice data to AP interface table

(User should upload OFI interface table along with base interface table when user is trying to update
EBS with data from his external system.)

2. Import OFI Taxes to OFI Taxes interface table.

3. Run concurrent program ‘Payables Open Interface Import’ to import AP invoice from interface table.

4. Make sure the Concurrent Program completes successfully. Rectify the data in Base/OFI Interface in
case of any errors/warnings

5. View imported taxes in Tools  India Tax details

6. Run concurrent program ‘Invoice Validation’ to validate imported AP invoices.

4.2 Interfacing OFI Taxes to AP

Step 1: Populate AP interface tables

AP_INVOICES_INTERFACE,AP_INVOICE_LINES_INTERFACE

Below columns and values should be populated as such in AP_INVOICE_LINES_INTERFACE

Table : AP_INVOICE_LINES_INTERFACE

Column Value

REFERENCE_KEY3 OFI TAX IMPORT

REFERENCE_KEY2 Invoice Line Number
REFERENCE_KEY1 Invoice_num
CALC_TAX_DURING_IMPORT_FLAG Y

The above values are very specific to import the taxes successfully to India Localization. Apart from the
above values all other values which are mandatory for Payable Open Interface Import to create the AP
transaction also needs to be populated

Step 2: Populate JAI interface tables

Below columns and values should be populated as such

Table : JAI_INTERFACE_LINES_ALL

Column Value

OFI GST Tax Interface Phase2 10

 TRANSACTION_NUM Value should be the same as
reference_key1 of
AP_INVOICE_LINES_INTERFACE
TRANSACTION_LINE_NUM Value should be the same as
reference_key2 of
AP_INVOICE_LINES_INTERFACE
BATCH_SOURCE_NAME OFI TAX IMPORT

For populating tax details user can use JAI_INTERFACE_TAX_LINES_ALL

India Localization data can also be populated using the OFI TAX OPEN INTERFACE UI provided as well

Navigation

(N)  Oracle Financials for India  Transactions  Tax Open Interface

Import Module : Payables Note: The source should

be OFI Tax Import

OFI GST Tax Interface Phase2 11

 TRANSACTION_NUM: Value should be the same as
reference_key1 of AP_INVOICE_LINES_INTERFACE

TRANSACTION_LINE_NUM: Value should be the same as

reference_key2 of AP_INVOICE_LINES_INTERFACE

Click on Tax Details Button will open the UI where user can enter the taxes

OFI GST Tax Interface Phase2 12

In case of any errors users can click on Errors button and correct the same

NOTE : Re-processing errored records of OFI Interface is still under review and will be coming up asap

Step 3 : Run Concurrent program ‘Payable Open Interface Import’ to import AP Invoice from
interface table

Step 4 : Make sure the Payable Open Interface Import is successful . Rectify the data in
Base/OFI interface in case of any errors/warnings

Step 5 : View imported taxes in Tools  India Tax details and on satisfactory results,Validate
the Invoice

OFI GST Tax Interface Phase2 13

 Misc tax lines got created Misc tax distributions got created

OFI GST Tax Interface Phase2 14

4.3 Process Flow – AR

Import Invoice Data to AR

Interface Table

Import Tax data to OFI

Open Interface Table

Run “Auto invoice” Correct Data in Base/OFI

Interface

Program Check Error message in

Completed log/output file
Successfully

View Imported Taxes in

Tools  India Tax details

OFI GST Tax Interface Phase2 15

1.Import transaction data to AR interface table

(User should upload OFI interface table along with base interface table when user is trying to update EBS
with data from his external system.)

2.Import OFI Taxes to OFI Taxes interface table:

3.Run concurrent program Auto Invoice

4. Make sure the Concurrent Program completes successfully. Rectify the data in Base/OFI Interface in
case of any errors/warnings

5. View imported taxes in Tools  India Tax details

4.4 Interfacing OFI Taxes to AR

As a Pre-Requisite the below setups needs to be performed manually in Account Receivables Module

a) Create Transaction Source ‘OFI TAX IMPORT’

b) Line Transaction Flexfield is created as below

OFI GST Tax Interface Phase2 16

OFI GST Tax Interface Phase2 17
Step 1: Populate RA interface tables

Below columns and values should be populated as such

Table : RA_INTERFACE_LINES_ALL

Column Value

BATCH_SOURCE_NAME OFI TAX IMPORT

WAREHOUSE_ID Inventory Organization ID in
which the transaction is to be
imported
LINE_GDF_ATTR_CATEGORY JG.IN.ARXTWMAI.OFI TAX
IMPORT
LINE_GDF_ATTRIBUTE19 TRX number,
( In case automatic Trx
number populate any unique
Number
for the above line gdf
attribute)
LINE_GDF_ATTRIBUTE20 Line Number
INTERFACE_LINE_CONTEXT Recommended to have the
same as OFI TAX IMPORT

The above values are very specific to import the taxes successfully to India Localization. Apart from the
above values all other values which are mandatory for Autoinvoice to pass the AR transaction also needs
to be populated

Step 2: Populate JAI interface tables

Below columns and values should be populated as such

Table : JAI_INTERFACE_LINES_ALL

Column Value

TRANSACTION_NUM Value should be the same as

line_gdf_attribute19 of
ra_interface_lines_all
TRANSACTION_LINE_NUM Value should be the same as
line_gdf_attribute20 of
ra_interface_lines_all
BATCH_SOURCE_NAME OFI TAX IMPORT

For populating tax details user can use JAI_INTERFACE_TAX_LINES_ALL

OFI GST Tax Interface Phase2 18

NOTE : Please note that the transaction number(for Automatic Numbering) you provide over here is just
for tracking purpose through which the interface data in Receivables and interface data in Localization is
mapped and not the actual AR Transaction number

India Localization data can also be populated using the OFI TAX OPEN INTERFACE UI provided as well

Navigation

(N)  Oracle Financials for India  Transactions  Tax Open Interface

Import Module : Receivables Note: The source should be

OFI Tax Import

OFI GST Tax Interface Phase2 19

 TRANSACTION_NUM: Value should be the same as
line_gdf_attribute19 of ra_interface_lines_all

TRANSACTION_LINE_NUM: Value should be the same as

line_gdf_attribute20 of ra_interface_lines_all

Click on Tax Details Button which will open the UI where user can enter the taxes

In case of any errors users can click on Errors button and correct the same

NOTE : Re-processing errored records of OFI Interface is still under review and will be coming up asap

OFI GST Tax Interface Phase2 20

Step 3 : Run Autoinvoice program with source as OFI Tax IMPORT

Source should be OFI Tax IMPORT

Step 4 : Make sure the Autoinvoice is successful and user is able to query the AR Transaction

select trx_number from ra_customer_Trx_all where INTERFACE_HEADER_CONTEXT='OFI TAX

IMPORT' and INTERFACE_HEADER_ATTRIBUTE1='&INTERFACE_HEADER_ATTRIBUTE1'

INTERFACE_HEADER_ATTRIBUTE1 value is nothing but the value provided in the column

INTERFACE_LINE_ATTRIBUTE1 of RA_INTERFACE_LINES_ALL

OFI GST Tax Interface Phase2 21

Step 5 : View imported taxes in Tools  India Tax details

OFI GST Tax Interface Phase2 22

 Tax amount is populated

Tax distributions got created

5.Invoice Number Generation for Interfaced Invoices

This section explains about the Invoice number generation for Interfaced AP/AR Invoices

5.1 AR Invoices

Taxable Invoice Invoice Date

Event Number

External Any Value Any Value

Standard Disabled Disabled

If the Taxable Event is External then the user need to input the Invoice number and Invoice Date while
populating the Tax Interface lines and the same values will be carried over to the AR Invoice that is being
created

OFI GST Tax Interface Phase2 23

 Taxable Event : External

Invoice Number and Date needs to be

populated by the user

The Invoice Number and Date values

populated in interface is carried over
to the AR Invoice

OFI GST Tax Interface Phase2 24

If the Taxable Event is Standard then the Invoice number and Invoice Date fields will be disabled.Based
on the Document Sequence defined the Invoice number will get generated

Taxable Event : Standard

Invoice Number and Date fields are

disabled

OFI GST Tax Interface Phase2 25

 Based on the Document Sequence
Setup, the Invoice Number gets
generated

5.2 AP Invoices

Taxable Invoice Invoice Date

Event Number

External Disabled Disabled

Standard Disabled Disabled

For AP irrespective of Taxable Event being External or Standard the Invoice number and Date fields will
be disabled. User need to provide the Supplier Invoice Date and Number manually after the Invoice is
imported to Payables

OFI GST Tax Interface Phase2 26

 Taxable Event : Standard

Invoice Number and Date fields are

disabled

Taxable Event: External

Invoice Number and Date fields are

disabled

Supplier Tax Invoice Number and Date

needs to be provided by the user
manually

6.HSN / SAC Codes

Two new fields HSN and SAC Code has been added in the Tax Interface UI and the user can input their
required values while entering the same

Table : JAI_INTERFACE_LINES_ALL

Columns : HSN_CODE,SAC_CODE (NOTE: Any one of the Columns can be populated)

OFI GST Tax Interface Phase2 27

 HSN Code Entered in Tax
Interface Lines

HSN Code Entered in Tax

Interface Lines populated
to the AR Invoice

SAC Code Entered in Tax

Interface Lines

OFI GST Tax Interface Phase2 28

 SAC Code Entered in Tax
Interface Lines populated
to the AR Invoice

7.Summary
The above document will provide the below benefits:

• Interfacing Taxes to Legacy AR/AP Transactions

• Tax recalculation and Accounting of taxes

OFI GST Tax Interface Phase2 29