gl drilldown for financials for india transactions

5/24/2018 GL Drilldown for Financials for India Transactions

1/39

Oracle E-Business SuiteRelease 12.1.3 : GL Drilldown Functionality

for Financials for India Transactions

-Srinivas Gadde, Principal Support Engineer.


2/39 2010 Oracle CorporationProprietary and Confidential 2009 Oracle CorporationProprietary and Confidential 2

Financials for India Support for GL Journal Line Drilldown Functionality

Date : 23-Feb-2011Web Conference_id / Key : 8038554 / 1234

Intercall: Dial Toll free Number: http://www.intercall.com/oracle/access_numbers.htm and give

Conference_id: 1157813, Passcode:2254

Program Objectives:

a. Understanding GL Drilldown feature and its application in Financials for India.

b. Overview on diagnostic scripts available for checking Tax

c. Question & Answer Session

How to join the Web Conference:

Please do the following to connect:-

1. Open the following in MS INTERNET EXPLORER: https://strtc.oracle.com/imtapp/app/prelogin.uix

2. In the "Join Conference" box on the right, please enter the following:

Conference ID:

Conference Key:1234 Your Name: "Your Name"

3. Click "Join Conference"



Disclaimer:This document in any form, software or printed matter, contains proprietary information that is the exclusive

property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions ofyour Oracle Software License and Service Agreement or other applicable contract with Oracle, with which you

agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or

distributed to anyone outside Oracle without Oracles prior written consent. This document is not part of your

license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or

affiliates.

This document is for informational purposes only and is intended solely to assist you in planning for the

implementation and upgrade of the product features described. This is not a commitment to deliver any material,

code, or functionality, and should not be relied upon in making purchasing decisions. The development, release,and timing of any features or functionality are always at Oraclessole discretion. This document is not considered

part of the applicable program documentation.

Due to the nature of the product architecture, it may not be possible to safely include all features described in this

document without risking significant destabilization of the code.

Purpose:This document provides an overview of features and enhancements included in Oracle E-Business Suite Release

12.1 and applicable updates. It is intended solely to help you assess the business benefits of upgrading your existing

Oracle products to this release or implementing completely new Oracle developed products, and planning your I.T.

projects.



Oracle Online Training MaterialsUsage Agreement

Use of this Site (Site) or Materials constitutes agreement with the following terms and conditions:

1. Oracle Corporation (Oracle) is pleased to allow its business partner (Partner) to download and copy the

information, documents, and the online training courses (collectively, Materials") found on this Site. The use of

the Materials is restricted to the non-commercial, internal training of the Partners employees only. The Materialsmay not be used for training, promotion, or sales to customers or other partners or third parties.

2. All the Materials are trademarks of Oracle and are proprietary information of Oracle. Partner or other third party

at no time has any right to resell, redistribute or create derivative works from the Materials.

3. Oracle disclaims any warranties or representations as to the accuracy or completeness of any

Materials. Materials are provided "as is" without warranty of any kind, either express or implied, including without

limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.

4. Under no circumstances shall Oracle be liable for any loss, damage, liability or expense incurred or suffered

which is claimed to have resulted from use of this Site of Materials. As a condition of use of the Materials, Partner

agrees to indemnify Oracle from and against any and all actions, claims, losses, damages, liabilities and

expenses (including reasonable attorneys' fees) arising out of Partners use of the Materials.



Agenda

Introduction

How is GL Drilldown Feature important in Financials for India product.

Functional Flow

Technical Flow

Known issues

Troubleshooting



Introduction

GL Drilldown feature allows users to view sub ledger transaction information for the GL journal line created byimporting information from the sub ledger products. Users are able to view sub ledger transaction information fordifferent Products using the GL Drilldown feature by navigating to the Product UI that is the source of suchtransaction.

The Drill Down feature is invoked by Drill Down button on Journal Review screen. The Drill Down button opens

XLA Drill Down UI. The UI shows product transaction and accounting information related to journal line.

Oracle Financials for India (OFI) generates certain accounting entries that are directly posted to General Ledger

and these entries do not have GL Drilldown feature enabled. OFI captures the required information in the reference

fields using which you will be able to find the source of the accounting entry. To carry out reconciliation using the

reference fields requires manual effort and hence is seen as usability issue. To overcome this you either requirecustom scripts for reconciliation or develop custom reports. By enhancing OFI to support GL Drilldown feature,

your will be able to directly find the originating transaction from the Drill down UI. This support will help in

reconciling and finding originating transactions and also in satisfying auditors on the genuineness of the accounting

entries in the system.

The nature of Tax accounting entries generated by OFI can be broadly classified into two, they are:

Accounting entries generated independently where they are directly posted to General Ledger. (E.g.

accounting entries generated during the RG manual entries, RG consolidation, at the time of costing of

inventory etc)

Accounting entries for OFI that are part of the sub ledger accounting. (E.g. Tax Accounting entries for AR

and AP transactions.)

The scope of this project is for extending the GL Drill Down feature for those accounting entries that are

posted directly to General Ledger by OFI.



The Enhanced GL Drilldown feature will allow you to view JAI transaction information for the GLjournal created by importing accounting information from JAI thus by reducing the effort requiredin Reconciliation.

You will be able to view JAI transaction information for Oracle Receivables India, OraclePayable India, Oracle Projects India, Oracle Inventory India, Oracle Order Management India andOracle Purchasing India.

You will be able to further drilldown from the Journal line to the related accounting lines and theentire JAI transaction using the products transaction inquiry form.

The View Journal Entry Lines UI is used for reconciliation purpose between GL and Sub

ledgers. The View Journal Entry Lines UI will display the accounting and transaction details forjournal line. The columns and content displayed in the UI vary according to source transactionthat has generated the journal line. For determining the source transaction, the Journal Source,Journal Category and additional parameters are used.

This feature is invoked by Drill Down button on Journal Review screen. The Drill Down buttonwill open XLA Drill Down form. The form will show product transaction and accounting informationrelated to journal line.

How is GL Drilldown Feature important in Financials for India product.



Functional Flow

The process followed for navigating into the OFI Product UI and View Accounting UIis depicted using the following flow chart:



Procure to Pay Cycle

India Local Purchasing>Purchase Order>Purchase Order Localized


10/39 2010 Oracle CorporationProprietary and Confidential 2009 Oracle Corporation Proprietary and Confidential 10





Receipt Localized Form

India Local Purchasing>Receipts>Receipt Localized


14/39

2010 Oracle CorporationProprietary and Confidential 2009 Oracle Corporation Proprietary and Confidential 14


India Local Purchasing>Receipts>Receipt Localized


15/39



India Local Purchasing>Receipts>Receipt Localized>Tools View Accounting


16/39





17/39





18/39


Importing Transactions to GL

India Local General Ledger>Import>Run


19/39


Journal Entry Inquiry

India Local General Ledger>Inquiry>Journal


20/39





21/39





22/39


GL Drilldown to Source Module


23/39


GL Drilldown to Source Transaction

A ti E t i i R i t L li d f


24/39


Accounting Entries in Receipt Localized form

After importing Tax entries and posting to GL, you can check accounting from

India Local Purchasing>Receipts>Receipt Localized>Tools>View Accounting


25/39


Technical Flow


26/39


Journal Source Journal Category OFI UI

Receivables India Register India Enter Transactions India Localization

Projects India Register India Invoice Review - India

Inventory India MTL Receipts India Localization

Payables India Payments RG Registers Consolidation Screen India Localization

Payables India Bill of Entry India Bill of Entry India Localization

Purchasing India Receiving India Receipts India Localization

Purchasing India OSP Receipt India Discrete 57F4 Transactions - India Localization

Purchasing India OSP Issue India Discrete 57F4 Transactions - India Localization

Purchasing India OSP Issue India Enter Manual 57f(4)

Register India Inventory India Excise / VAT Details

Register India VAT India Excise / VAT Details

Refer the below table for details on the Journal Source and Journal Categorycombination linkage to OFI UI:


27/39


Journal Source Journal Category OFI UI

VAT India Register India

Invoice Review - India

Confirm Shipment India Localization

Enter Transactions India Localization

Settlement (Settlement Details)

Manual Entry

Service Tax India Register India

Manual Entry

Service Tax Repository Review


Settlement (Settlement Details)

Service Tax Distribution

Register India Register India

Confirm Shipment India Localization

RG23 Part I & Part II Entry India Localization

PLA Entry India Localization

RG-1 Entry India Localization

India Tax Collected Receivables IndiaConfirm Shipment India Localization


Following four combinations of Journal Source and Journal Category, transaction flows from MultipleUIs/sources. Hence in such cases for determining the OFI UI we will have to use Object Nameand TableName(field Reference_3& Reference_4in the GL_JE_LINES table) along with Journal Source andJournal Category. XLA call will need to pass this additional information to open the correct OFI UI.

I t d E i ti Obj t


28/39


TYPE BELONGING

COMPONENTS

NAME OF THE OBJECT** FILE NAME NEW/MODIFY/OBSELETE

FORMS

PO Receipts Localization Form JAINPORE.fmb MODIFIY

AP Settlement Detail Form JAINRGSP.fmb MODIFIY

AP Manual Entry Form JAINRGMT.fmb MODIFIYAP Service Tax Repository Review Form JAINRPRW.fmb MODIFIY

AP Service Tax Distribution Form JAINRGDT.fmb MODIFY

INV Inter-Organization Transfer Form JAINEXCDET.fmb MODIFY

AR Enter Transaction Localization Form JAINARTX.fmb MODIFY

Confirm Shipment Localization Form JAINCSHP.fmb MODIFY

AP Bill of Entry Localization Form JAINIBOE.fmb MODIFY

PLA Manual Entry JAINPLAM.fmb MODIFY

PB Invoice Review Localization Form JAINRWDI.fmb MODIFY

INV RG-1 Entry Form JAINIRGI.fmb MODIFY

INV RG23 Part I and Part II Entry Form JAINRGAC.fmb MODIFY

AP RG Registers Consolidation Form JAINRGCO.fmb MODIFY

Approve (4) Dispatch Form JAIN4.fmb MODIFY

Approve (4) Enter Manual Form JAINOSPM.fmb MODIFYGL OFI GL DrillDown Form JAINIQDRL.fmb NEW

GL OFI GL View Accounting Form JAINIQACL.fmb NEW

PACKAGES XLA XLA_DRILLDOWN_PKG xlaiqdrl.pkb MODIFY

PLL XLA XLACORE .pll MODIFY

Impacted Existing Objects


29/39


Receipts India Localization Form Design - JAINPORE.fmb

This slide is the technical description of modifications of PO Receipts form, and four new views, inwhich two of the four are for fetching data from base tables, while the other two are the supporting viewfor application.

These changes achieve the following features:

In Receipt India Localization form, user can view accounting of transaction via View

Accountingin Toolmenu.

From GL journal forms, user can drilldown specific journal lines to the subcomponent transaction

form.

Form Receipts India Localizationwill be drilldown when Journal Source, Journal Category and eventscombine as below:

No. Event Name Journal Source Journal Category Other Key

1 Receipt Purchasing ReceivingGL_je_lines.description : Local Receiving

Entry for the Receipt And

Transaction Type RECEIVE

2 Cenvat Claim Purchasing Receiving

GL_je_lines.description : Local Cenvat

Entries And

GL_je_lines.description : Transaction Type

DELIVER or RECEIVE

3 Cenvat Claim reversals Purchasing ReceivingGL_je_lines.description : Local Cenvat

Entries And

RETURN TO VENDOR


30/39



4 Delivery Purchasing Receiving GL_je_lines.description : Local Receiving Entryfor the Receipt And Transaction Type

DELIVER

5 Return To Vendor Purchasing Receiving GL_je_lines.description : Local Receiving Entryfor the Receipt And Transaction Type RETURN

TO VENDOR

6 Return to Receiving Purchasing Receiving GL_je_lines.description : Local Receiving Entryfor the Receipt And Transaction Type RETURN

TO RECEIVING

7 Delivery (Expense Items) Purchasing Receiving GL_je_lines.description : Local Receiving Entry

for the Receipt And Transaction TypeDELIVER And Item

8 Return To Receiving

(Expense Items)

Purchasing Receiving GL_je_lines.description : Local Receiving Entryfor the Receipt And Transaction Type RETURN

TO RECEIVING And Item

9 BOE Application andRelieving

Purchasing Receiving GL_je_lines.description : Local Receiving Entryfor the Receipt And Transaction Type

RECEIVE

10 Receipt (Trading

organization)

Purchasing Receiving GL_je_lines.description : Local Receiving Entryfor the Receipt And Transaction Type

RECEIVE and Item


31/39



11 VAT Receipt --- Receiving Purchasing ReceivingGL_je_lines.description : VAT Regime.

And


12 VAT Receipt --- Delivery Purchasing Receiving GL_je_lines.description : VAT Regime.AndTransaction Type DELIVER

13 SERVICE Receipt --- Receiving Purchasing ReceivingGL_je_lines.description : SERVICE Regime.

And


14 VAT Receipt RTV Purchasing Receiving

GL_je_lines.description : VAT Regime.

And

GL_je_lines.description : Transaction Type RETURN

TO VENDOR

15 SERVICE Receipt RTV Purchasing Receiving

GL_je_lines.description : SERVICE Regime.

And

GL_je_lines.description : Transaction Type RETURN

TO VENDOR

16 RMA Accounting Purchasing Receiving GL_je_lines.description : Local VAT RMA Entries

17 VAT Claim Purchasing Receiving GL_je_lines.description : Local VAT Claim

18 BOE Write Off Inventory MTLGL_je_lines.description : Transaction Type DELIVER

of Parent Trx Type RECEIVE

19 Correction Purchasing Receiving GL_je_lines.description : Transaction Type CORRECT


32/39


Form Base View Transaction View Accounting View

Receipts India Localization Form Design - JAINPORE.fmb JAI_RCV_AEL_GL_V JAI_RCV_AEL_SL_v

JAI_PO_REC_AEL_GL_v JAI_PO_REC_AEL_SL_V

Settlement Detail Form Design - JAINRGSP.fmb JAI_SETTLEMENT_AEL_GL_V JAI_SETTLEMENT_AEL_SL_V

JAI_AP_SET_AEL_GL_V JAI_AP_SET_AEL_SL_V

Manual Entry Form Design - JAINRGMT.fmb JAI_MANUAL_ENTRY_AEL_GL_V JAI_MANUAL_ENTRY_AEL_SL_vJAI_AP_MANUAL_AEL_GL_V JAI_AP_MANUAL_AEL_SL_v

Service Tax Repository Review Form Design - JAINRPRW.fmb JAI_STAX_REVIEW_AEL_GL_V JAI_STAX_REVIEW_AEL_SL_V

JAI_AP_STREVIEW_AEL_GL_V JAI_AP_STREVIEW_AEL_SL_V

Service Tax Distribution Form Design - JAINRGDT.fmb JAI_STAX_DISTRIBUTION_AEL_GL_VJAI_STAX_DISTRIBUTION_AEL_SL_

V

JAI_AP_STDISTRIBUTION_AEL_GL_VJAI_AP_STDISTRIBUTION_AEL_SL_

V

Inter-organization Transfer Form Design - JAINEXCDET.fmbJAI_INTERORG_TRANSFER_AEL_GL

_V

JAI_INTERORG_TRANSFER_AEL_SL

_V

JAI_INV_INORGTRAN_AEL_GL_V JAI_INV_INORGTRAN_AEL_SL_V

Confirm Shipment India Localization Form Design - JAINCSHP.fmb JAI_SHIP_AEL_GL_V JAI_SHIP_AEL_SL_V

JAI_OM_SHIP_AEL_GL_v JAI_OM_SHIP_AEL_SL_v

Enter Transaction India Localization Form Design - JAINARTX.fmb JAI_TRX_AEL_GL_V JAI_TRX_AEL_SL_V

JAI_AR_TRX_AEL_GL_V JAI_AR_TRX_AEL_SL_V

Bill of Entry India Localization Form Design - JAINIBOE.fmb JAI_AP_BOE_AEL_V JAI_AP_BOE _AEL_SL_V

JAI_AP_BOE_AEL_GL_V

PLA Register manual entry India Localization Form DesignJAINPLAM.fmb JAI_PLA_ENTRY_AEL_V JAI_PLA_ENTRY_AEL_SL_V

JAI_PLA_ENTRY_AEL_GL_V

Invoice Review India Localization Form Design - JAINRWDI.fmb JAI_PROJECT_INV_AEL_V JAI_PROJECT_INV_AEL_SL_V

JAI_PROJECT_INV_AEL_GL_V

RG-1 Entry India Localization Form Design - JAINIRGI.fmb JAI_ RG1_ENTRY_AEL_v JAI_ INV_RG1_AEL_GL_V JAI_INV_RG1_AEL_SL_V

RG23 Part I and Part II Entry India Localization Form Design - JAINRGAC.fmb JAI_ RG23_ENTRY_AEL_V JAI_ INV_RG23_AEL_GL_V JAI_INV_RG23_AEL_SL_V

RG Registers Consolidation India Localization Form Design - JAINRGCO.fmb JAI_ RGCO_ENTRY_AEL_V JAI_ INV_RGCO_AEL_GL_V JAI_INV_RGCO_AEL_SL_V

Approve 57F(4) Dispatch India Localization Form DesignJAIN57F4.fmbJAI_

OSP_DISPATCH_AEL_VJAI_ PO_OSP_DISP_AEL_GL_v JAI_PO_OSP_DISP_AEL_SL_V

Approve 57F(4) Enter Manual India Localization Form DesignJAINOSPM.fmb JAI_ OSP_ENTRY_AEL_V JAI_ PO_OSPM_AEL_GL_V JAI_PO_OSPM_AEL_SL_V


33/39


OFI GL View Accounting Form Design JAINIQACL.fmb

OFI will created new form for View Accounting, similar to the existing XLA forms. This decouples the dependency with XLAform and does not increase the size/complexity of the XLA forms. It also gives more flexibility to JAI in terms of design/coding of the new UIs.

XLA_DRILLDOWN_PKG Package Design xlaiqdrl.pkb

This package is a PL/SQL wrapper to GL Team for Drilldown specific procedures.

XLA library Design XLACORE.pll

This procedure determines which function name will be called when pressed Line drilldown on GL journal UI, the procedureto be modified to call OFI drilldown form instead of XLA drilldown form in case of OFI source and category.


34/39


Demo

Di ti d T bl h ti


35/39


Enable FND logging as per Metalink Note # 433199.1 to get the

debug log. Obtain the Applications Collection Tool (ACT) report as per

Metalink Note # 293127.1 to verify the files version at your

instance.

Enable the profile option FND: Diagnosticsto 'Yesto get more

detailed logging. This would also provide the stack trace for anyexception.

To verify whether the issue is related to any personalization or

customization, set the profile option 'Disable Self-service

Personal' to Yes.

Diagnostics and Troubleshooting

Additi l R


36/39


Additional Resources Oracle Financials for India Webcast on Period End Processing related to Excise

(Doc ID 1077287.1)

Oracle Financials for India Webcast on Excise and Customs Regime (Doc ID

557374.1) For product information on My Oracle Support

http://support.oracle.com/

For Release 12.1 information on My Oracle Support

http://support.oracle.com/ Note 806593.1

For Oracle product documentation

http://www.oracle.com/technology/documentation/applications.html

For more information about Oracle Applications

http://www.oracle.com/applications/home.html

For more information about Education

http://www.oracle.com/education/index.html

Welcome to Your Financials for India Community Document:ID 779633.1 For more information about Support

http://www.oracle.com/support/
http://support.oracle.com/http://support.oracle.com/http://www.oracle.com/technology/documentation/applications.htmlhttp://www.oracle.com/applications/home.htmlhttp://www.oracle.com/education/index.htmlhttp://www.oracle.com/support/http://www.oracle.com/support/http://www.oracle.com/education/index.htmlhttp://www.oracle.com/applications/home.htmlhttp://www.oracle.com/technology/documentation/applications.htmlhttp://support.oracle.com/http://support.oracle.com/


37/39



38/39


Upcoming Webcasts

Date : 28-FEB-2011

Web Conference_id / Key : 8038716 / 1234

Intercall:Dial Toll free Number: http://www.intercall.com/oracle/access_numbers.htm and give Conference_id: 1157813,

Passcode:2254

Program Objectives:

a. Understanding Descriptive Flexfields and its importance in Financials for India.

b. Setting up and understanding various options available.

c. Troubleshooting common issues and resolution for the same

e. Question & Answer Session

Supplementary Transactions in Financials for India.

Date : 07-March-2011

Web Conference_id / Key : 8038719 / 1234

Intercall:Dial Toll free Number: http://www.intercall.com/oracle/access_numbers.htm and give Conference_id: 1157813,

Passcode:2254

Program Objectives:

a. Understanding Purpose of Supplementary Transaction.

b. Setup and Transaction flow.

d. Overview on diagnostic scripts available.

e. Question & Answer Session

Proposed Date and Time: From:23-FEB-2011 , 28-FEB-2011 , 07-MAR-2011

Start Time:- 6:00PM ,Duration approximately 1 hour.


39/39

gl drilldown for financials for india transactions

Documents

oracle corporationproprietary

exclusiveproperty of

new oracle

oracle ebusiness suiterelease

conference5242018 gl

india support

confidential material

conference id