Oracle Advanced Global Intercompany System (AGIS) Concept and it's Process.

A transaction which takes place between the two balancing segment values between two legal entities is called AGIS.
AGIS  is a new module that allows companies to streamline intercompany processing and facilitates the reconciliation of intercompany transactions.  It replaces global intercompany system(GIS) feature provided by General Ledger in  Release 11i. All setup and transaction data is moved to a new data model and all oracle forms in the global intercompany systems are replaced by browser based user interface pages. changes include:

• Subsidiaries are replaced by intercompany organisations. The Represent trading partners  and can be used as initiators and receipts of Advanced Global Intercompany System Transactions.
• As part of the Grant-based Security Model, intercompany trading partner are mapped to users instead of responsibilites. A user may be given access to many different intercompany trading partners regardless of the responsibility used to log in.
• The intercompany accounts set up in GIS are upgraded as the new intracompany balancing Rules set up in GIS are not upgraded and need to be set up in the new subledger accounting transaction account builder.
• All GIS new and completed Transactions are upgraded as AGIS transacton batches. Generally, for each GIS Transactions, a batch is created.
• Interaction with subledgers facilitating Invoicing using Receivables and payables. 
• Facilitates transactions processing between different legal entities, under one or more ledgers.

Process of AGIS Transaction.
1. Through outbound Transaction window, The initiator will initiate the intercompany transaction. Enter the Transction Type, Initiator Organisation, GL Date, Currency, recipient name with Debit/ Credit amount is entered.
2. Completion of accounting from the Initiator Side and sumbit the batch
3. Through inbound transaction window, The Recipient will complete the accounting for Received AGIS batch Transaction.
4. Then the Recipient will the approve the AGIS batch.
In the Invoicing is opted for, in transaction type setups then,
1. Switch to inititors Receivable Responsibility, Run the auto invoice master Program to process the invoice in Receivables
2. Switch to Recipient Payables Responsibility, Run payables Open interface Import program to Process the invoice in Payables.
3. Create the accounting for your invoice and Transfer to GL.
Setup Steps:
1. Organization Creation

2. Security Set Up for users
3. Transaction Type creations
4. Period Control.
5. Invoicing Option – Receivables Assignment.

6. Invoicing Option – Customer/Supplier Association Definition.
7. Defining system Options

Advanced Global Intercompany Sytem(AGIS) in Oracle Apps

                 Oracle Advanced Global Intercompany System (AGIS)  is a new module that allows companies to streamline intercompany processing and facilitates the reconciliation of intercompany transactions.  It replaces global intercompany system(GIS) feature provided by General Ledger in  Release 11i. All setup and transaction data is moved to a new data model and all oracle forms in the global intercompany systems are replaced by browser based user interface pages. changes include:

• Subsidiaries are replaced by intercompany organisations. The Represent trading partners  and can be used as initiators and receipts of Advanced Global Intercompany System Transactions.
• As part of the Grant-based Security Model, intercompany trading partner are mapped to users instead of responsibilites. A user may be given access to many different intercompany trading partners regardless of the responsibility used to log in.
• The intercompany accounts set up in GIS are upgraded as the new intracompany balancing Rules set up in GIS are not upgraded and need to be set up in the new subledger accounting transaction account builder.
• All GIS new and completed Transactions are upgraded as AGIS transacton batches. Generally, for each GIS Transactions, a batch is created.
• Release 11i GIS profile Options are obsolete and are not upgraded. All options are available on the AGIS System Options page.

Financial Statement Generator(FSG)

It is a reporting tool which is used to configure the financial report as per the organization requirement. It contains five components, they are
             1. Row Set.
             2. Column Set.
             3. Order Set.
             4. Content Set.
             5. Display Set. 
Note: Row set is mandatory Component whereas Column set, Order Set, Content set & Display Set are optional.
Row Set: It determines format & Content of rows in an FSG Report. When you define a row set, you can:
Step 1: Define Row Set. 
Navigation: Reports --> Define --> Row Set. 
You can define a new row set, or use FSG's AutoCopy feature to copy an existing row set, which you can then modify as needed.
Now, Let me illustrate Row set concept by creating a new row set.
Enter the Name and Description for your row set and Say "Define rows" as shown below

Enter a Line number for each row of your row set. The line number controls in which row which content should display. 

Assign accounts - to indicate which general ledger account balances you want to include in the row. You can assign an individual account or range of accounts to each row. Furthermore, you can specify which ledger or ledger set on which you wish to report.
Define calculations - to perform a variety of complex computations in your report. The calculations can refer to any previous rows in a report, including rows you choose not to display.
Specify formatting - to control page breaks, indentation, line spacing, and underline characters.
Secure row set definitions - to only allow specific row sets to be used, viewed, or modified by certain users.

You can assign one of three display types to your account segments in an account assignment. You can override these display types with a content set.
E: (Expand) Expand the range and display all segment values, creating multiple rows from a single row definition. If you enter a parent segment value for your range, FSG displays all child values for that parent. Do not select summary reporting to display all the child values in your report. 
T: (Total) Total the range and display only a total balance for the segment values, limiting the number of rows that appear on your report. If you enter a parent segment value for your range, FSG totals all of the child values for that parent.
If you choose Total for the ledger segment and the ledger segment value is a ledger set, the FSG report totals the ledgers in the ledger set and displays rows for the totals without displaying the individual ledgers.
B: (Both) Expand and total the range and display all segment values and a total balance for the segment values. This option lets you display both detail rows and total rows. If you enter a parent segment value for your range, FSG totals all of the child values for that parent. Do not select summary reporting to display all the child values in your report.
If you choose Both for the ledger segment and the ledger segment is a ledger set or ledger, the FSG report displays both the expanded detail and total rows for the ledger set or ledger.



Save & Close window. Press Add new button to add new row as shown below.

Say Calculations

Save & Close window. Press on Add new button to add new row as shown below 

Press Add new button to add new row as shown below 

Click on Account Assignment and give Low and high Display details under this row.

Save & Close window. Press on Add New button to add new row as shown below 

Click on Calculations 

Save it and close. Enter new line number and line item description.

Click on Calculations, 

Save and close the window.

Step 2:  Define Column Set
It determines format & content of columns in an FSG Report.
Therefore, typical column sets include headings and subheadings, amount types, format masks, currency assignments, and calculation columns for totals.
Navigation: Reports --> Define --> Column Set. 
You can define a new column set, or you can use Pre-defined Column sets. Now i would like use one of the Pre-defined column Set as shown below. Here are some of the existing Column sets

Specify account balance types - to include in the column. For example, you can define a column with actual, budget, or encumbrance amounts.
Create Headings - for your columns. You can also create relative headings, which change depending on the period of interest specified when you run the report.
Define calculations - to perform a variety of complex computations in your report. The calculations can refer to any previous columns in the report, including rows you choose not to display.
Specify formatting - using format masks, which determine how numbers in your report are displayed.
Secure column set definitions - to only allow specific column sets to be used, viewed, or modified by certain users.
Note: Row line labels appear to the left of the first column in your report. Thus, you control the width of the row line items when you set the position of the first column in your column set.

Press down arrow to see next Column position created

Press down arrow to see next Column position created

Close window and Click on Build Column Set and enter how the Column Name should display as shown below

Step 3: Define Report.
A report is defined by specifying the report objects which is used to build the report.
Navigation: Report --> Define --> Report.Enter Report name and title that should display in the Financial report. Specify mandatory fields like Row set, column set, Report Title, Rounding Options and output Options.

Click on Run Report and enable required parameters and submit it.

After click on Submit button you can observe a Request ID generated as shown below

Query the request window, Ensure report completed normal 

and click on View Output

Order Set: It Determines data should display in what order in the report like ascending/descending Order.
Content Set: It is used to Generate reports for multiple departments in a single run.
Display Set: It determines what data should be displayed in the reports.

Ledger Set Concept in Oracle Apps

Ledger set is used to access multiple Ledgers information from single responsibility. Using Ledger set we can group only Ledgers which are having same Chart of Accounts and same Calendars.

Step 1: Define ledger sets
Navigation: Setup --> Financials --> Ledger Sets

Enter Name and Short name and all mandatory info and Save and Close this window.

Step 2: Assign Ledger set to responsibility

Navigation: System Administrator

Profile --> System

Choose responsibility

Profile Option: GL: Data Access Set

Choose Ledger set

If you assign both the profile options: GL Ledger Name & GL Data Access Set System will choose first Data Access set

Step 3: Enter Journal to test the functionality of ledger Set.

Navigation: Journal --> Enter

Enter new Journal

You can choose any Ledgers from here, which are assigned to Ledger set

Note: We have to assign GL: Data access set profile option and Ledger set to all the GL responsibilities, so that we can access all ledgers from any responsibility.

Definition Access Set Concept in Oracle Apps

It is an optional feature, for Security Purpose, which works at responsibility level .
It is used to provide "View","Use", "Modify" access to the various gl definitions.
For example: You can secure Calender, Mass Allocation Formula, FSG reports.. Etc. to allow users to modify, View and Use it.

Setup Step:
1. Create a Definition Access Set.
2. Assign it to one or more responsibilities to Definition Access Set.
3. "Enable Security" Check Box in Respective Form and click on "Assign access" and assign to definition access Set with the proper privileges (View, Use & Modify).

Let's see how to configure Definition Access Set
Step 1: Define Definition Access Set
Navigation: Set up --> Financials --> Definition Access sets --> Define.

Enter Name & Description to Definition Access set and Save it.

Step 2: Assign Definition Access set to Responsibility

Navigation:

Setup --> Financials --> Definition Access Sets --> Assign

Choose Responsibility: General ledger

Security Group: Standard

Choose Definition Access Sets

Automatic Privileges: Enable check boxes for: Use, View and Modify

Save and Close this window

Click on Ok Button and Ensure Program completed normal

Step 3: Enable Security for accounting Calendar

Navigation: Setup --> Financials --> Calendars --> Accounting

Query your accounting calendar

Select check box “Enable Security”

Click on “Assign Access” and Choose "Definition Access set"

Click on " OK" Button and Save it and following note will Appear

Decision window pop's Up, Now click on "Current" Button

Ensure the program completed normal.

Step 4: Query the accounting Calendar to Test the definition access set is working or not

Navigation: Setup --> Financials --> Calendars --> Accounting.

As we have given View, Use and Modify Privileges, you will be have all the right to view, use and modify the calendar data.

Query the definition access form to see the changes.

Data Access Set Concept in Oracle Apps

Data Access Set is an Optional feature for Security Purpose.
It is used to provide "Read Only" or "Read & Write" access to the ledger or balancing segment values or management segment values. It provides security in three Levels.
       1. Ledger Level.
       2. Balancing Segment Values.
       3. Management Segment Values.
Ledger Level: Provides access to Full Ledger (Whole COA)
Balancing Segment Values: Provides access to specific to Balancing segment Values
Management Segment Values: Provides access to specific Management segment Values.
Steps: 
1. Define Data Access Set
Navigation: Setup --> Financials --> Data Access Set.
2. Assign these data access set to a profile option (GL data access Set).

Revaluation Concept in Oracle Apps

It is used to identify unrealized gain/loss amount which occurred due to foreign exchange rate fluctuations. The difference in revaluation will be transferred to unrealized gain/loss a/c. We run revaluation in two modules- i.e., GL & FA. In GL we run the revaluation to know the current asset & liabilities due to fluctuation in the currencies and In assets we run the revaluation to revalue the assets.
Note: Revaluation can be done only before making the payment or before receiving the amount in GL.
Setup Steps:
1. Define “Unrealized Gain (revenue) a/c & Unrealized Loss (Expenses) a/c” at account segment level.
Note: If required assign profile option “GL: Revaluation: Validate Gain & Loss A/c” at responsibility Level.
2. Define exchange rate type
3. Define Exchange rate.
4. Enter foreign currency journal & post it.

Note: If you want to see the changes you change the exchange rate.5. Run Revaluation.
6. Query revaluation journal and post it.

Now, Let see how to configure revaluation concept.

Step 1: Define Unrealized Gain A/c (Qualifier as: Yes, Yes, Revenue, No, No) and Unrealized Loss A/c (Qualifier as: Yes, Yes, Expenses, No, No) at account segment Level.

Navigation: Setup --> Financials --> Flex fields --> Key --> Values.

Step 2: Define Exchange Rate Type

Navigation: Setup --> Currency --> Rate --> Types.

Click on New and add "Rate Type" and " Description".

Step 3: Define Exchange Rates.

Navigation: Setup --> Currencies --> Rates --> Daily.

Click on "Enter by Date Range" button

Say "Apply".

Step 4: For Testing Revaluation Concept, Ensure one foreign currency journal exists. 

Navigation: Journal --> Enter

Step 5: Run Revaluation

Navigation: Currency --> Revaluation.

Enter name and description for revaluation
Currency Options: Choose single currency & USD
Rate Options: Choose Daily Rates & Exchange rate type
Choose Unrealized gain & loss accounts
Choose revaluation ranges

Say " Revalue"

Submit request window will automatically open with program as “Program – Revalue balances”

Fill all parameter details and submit the request.

Click on View --> request and ensure program completed normal

Say "View Output" 

Step 6: Now Query Revaluation Journal and post it

Navigation: Journal --> Enter.

Now, See the change and Post it.