Put Concurrent Requests on HOLD when we need to bounce the CONC Managers due to some maintenance activity

To put the jobs on hold –
~~~~~~~~~~~~~~~~~~~

update applsys.fnd_concurrent_requests set hold_flag = 'Y',last_update_date = sysdate,last_updated_by = -1 where phase_code = 'P';

 To release job after downtime –

~~~~~~~~~~~~~~~~~~~~~~~

update applsys.fnd_concurrent_requests a set a.hold_flag = 'N' , last_update_date = sysdate, last_updated_by = -1 where phase_code = 'P'
and a.hold_flag = 'Y'
and last_updated_by = -1
and last_update_date > sysdate-1;


Terminate one concurrent Request:

update applsys.fnd_concurrent_requests
set phase_code = 'C',
status_code = 'X',
actual_completion_date = sysdate
where request_id = '&R';

Parent Child relationship for Accounting Flexfield

 SELECT gcc.code_combination_id
      ,ffvc.parent_flex_value
      ,gcc.segment1 Balancing_Segment
      ,gcc.segment,ffvc.description
  FROM gl_code_combinations gcc,
       fnd_flex_value_children_v ffvc,
       fnd_id_flex_segments fifs
 WHERE 1=1
   AND fifs.flex_value_set_id = ffvc.flex_value_set_id
   AND fifs.id_flex_code='GL#'
   AND ffvc.parent_flex_value = NVL(:P_Parent_Flex_value, ffvc.parent_flex_value)
   AND ffvc.flex_value = gcc.segment
   AND fifs.application_column_name = 'SEGMENT'||:P_Segment_Num;

some more imp tables are gl_balances, gl_code_combinations and fnd_flex_norm hierarchy  fnd_flex_values, fnd_flex_value_sets to report on flex values

Accounting Flow

ACCOUNTING Debit /Credit

Balance Sheet ,Income Stmt n Cash Flow Basic logic

There are four main financial statements. They are: (1) balance sheets; (2) income statements; (3) cash flow statements; and (4) statements of shareholders’ equity. Balance sheets show what a company owns and what it owes at a fixed point in time. Income statements show how much money a company made and spent over a period of time. Cash flow statements show the exchange of money between a company and the outside world also over a period of time. The fourth financial statement, called a “statement of shareholders’ equity,” shows changes in the interests of the company’s shareholders over time.

Let’s look at each of the first three financial statements in more detail.

Balance Sheets

A balance sheet provides detailed information about a company’s assets,liabilities and shareholders’ equity.

Assets are things that a company owns that have value. This typically means they can either be sold or used by the company to make products or provide services that can be sold. Assets include physical property, such as plants, trucks, equipment and inventory. It also includes things that can’t be touched but nevertheless exist and have value, such as trademarks and patents. And cash itself is an asset. So are investments a company makes.

Liabilities are amounts of money that a company owes to others. This can include all kinds of obligations, like money borrowed from a bank to launch a new product, rent for use of a building, money owed to suppliers for materials, payroll a company owes to its employees, environmental cleanup costs, or taxes owed to the government. Liabilities also include obligations to provide goods or services to customers in the future.

Shareholders’ equity is sometimes called capital or net worth. It’s the money that would be left if a company sold all of its assets and paid off all of its liabilities. This leftover money belongs to the shareholders, or the owners, of the company.

The following formula summarizes what a balance sheet shows: ASSETS = LIABILITIES + SHAREHOLDERS' EQUITY A company's assets have to equal, or "balance," the sum of its liabilities and shareholders' equity.

A company’s balance sheet is set up like the basic accounting equation shown above. On the left side of the balance sheet, companies list their assets. On the right side, they list their liabilities and shareholders’ equity. Sometimes balance sheets show assets at the top, followed by liabilities, with shareholders’ equity at the bottom.

Assets are generally listed based on how quickly they will be converted into cash. Current assets are things a company expects to convert to cash within one year. A good example is inventory. Most companies expect to sell their inventory for cash within one year. Noncurrent assets are things a company does not expect to convert to cash within one year or that would take longer than one year to sell. Noncurrent assets include fixed assets.Fixed assets are those assets used to operate the business but that are not available for sale, such as trucks, office furniture and other property.

Liabilities are generally listed based on their due dates. Liabilities are said to be either current or long-term. Current liabilities are obligations a company expects to pay off within the year. Long-term liabilities are obligations due more than one year away.

Shareholders’ equity is the amount owners invested in the company’s stock plus or minus the company’s earnings or losses since inception. Sometimes companies distribute earnings, instead of retaining them. These distributions are called dividends.

A balance sheet shows a snapshot of a company’s assets, liabilities and shareholders’ equity at the end of the reporting period. It does not show the flows into and out of the accounts during the period.

Income Statements

An income statement is a report that shows how much revenue a company earned over a specific time period (usually for a year or some portion of a year). An income statement also shows the costs and expenses associated with earning that revenue. The literal “bottom line” of the statement usually shows the company’s net earnings or losses. This tells you how much the company earned or lost over the period.

Income statements also report earnings per share (or “EPS”). This calculation tells you how much money shareholders would receive if the company decided to distribute all of the net earnings for the period. (Companies almost never distribute all of their earnings. Usually they reinvest them in the business.)

To understand how income statements are set up, think of them as a set of stairs. You start at the top with the total amount of sales made during the accounting period. Then you go down, one step at a time. At each step, you make a deduction for certain costs or other operating expenses associated with earning the revenue. At the bottom of the stairs, after deducting all of the expenses, you learn how much the company actually earned or lost during the accounting period. People often call this “the bottom line.”

At the top of the income statement is the total amount of money brought in from sales of products or services. This top line is often referred to as gross revenues or sales. It’s called “gross” because expenses have not been deducted from it yet. So the number is “gross” or unrefined.

The next line is money the company doesn’t expect to collect on certain sales. This could be due, for example, to sales discounts or merchandise returns.

When you subtract the returns and allowances from the gross revenues, you arrive at the company’s net revenues. It’s called “net” because, if you can imagine a net, these revenues are left in the net after the deductions for returns and allowances have come out.

Moving down the stairs from the net revenue line, there are several lines that represent various kinds of operating expenses. Although these lines can be reported in various orders, the next line after net revenues typically shows the costs of the sales. This number tells you the amount of money the company spent to produce the goods or services it sold during the accounting period.

The next line subtracts the costs of sales from the net revenues to arrive at a subtotal called “gross profit” or sometimes “gross margin.” It’s considered “gross” because there are certain expenses that haven’t been deducted from it yet.

The next section deals with operating expenses. These are expenses that go toward supporting a company’s operations for a given period – for example, salaries of administrative personnel and costs of researching new products. Marketing expenses are another example. Operating expenses are different from “costs of sales,” which were deducted above, because operating expenses cannot be linked directly to the production of the products or services being sold.

Depreciation is also deducted from gross profit. Depreciation takes into account the wear and tear on some assets, such as machinery, tools and furniture, which are used over the long term. Companies spread the cost of these assets over the periods they are used. This process of spreading these costs is called depreciation or amortization. The “charge” for using these assets during the period is a fraction of the original cost of the assets.

After all operating expenses are deducted from gross profit, you arrive at operating profit before interest and income tax expenses. This is often called “income from operations.”

Next companies must account for interest income and interest expense. Interest income is the money companies make from keeping their cash in interest-bearing savings accounts, money market funds and the like. On the other hand, interest expense is the money companies paid in interest for money they borrow. Some income statements show interest income and interest expense separately. Some income statements combine the two numbers. The interest income and expense are then added or subtracted from the operating profits to arrive at operating profit before income tax.

Finally, income tax is deducted and you arrive at the bottom line: net profit or net losses. (Net profit is also called net income or net earnings.) This tells you how much the company actually earned or lost during the accounting period. Did the company make a profit or did it lose money?

Earnings Per Share or EPS

Most income statements include a calculation of earnings per share or EPS. This calculation tells you how much money shareholders would receive for each share of stock they own if the company distributed all of its net income for the period.

To calculate EPS, you take the total net income and divide it by the number of outstanding shares of the company.

Cash Flow Statements

Cash flow statements report a company’s inflows and outflows of cash. This is important because a company needs to have enough cash on hand to pay its expenses and purchase assets. While an income statement can tell you whether a company made a profit, a cash flow statement can tell you whether the company generated cash.

A cash flow statement shows changes over time rather than absolute dollar amounts at a point in time. It uses and reorders the information from a company’s balance sheet and income statement.

The bottom line of the cash flow statement shows the net increase or decrease in cash for the period. Generally, cash flow statements are divided into three main parts. Each part reviews the cash flow from one of three types of activities: (1) operating activities; (2) investing activities; and (3) financing activities.

Operating Activities

The first part of a cash flow statement analyzes a company’s cash flow from net income or losses. For most companies, this section of the cash flow statement reconciles the net income (as shown on the income statement) to the actual cash the company received from or used in its operating activities. To do this, it adjusts net income for any non-cash items (such as adding back depreciation expenses) and adjusts for any cash that was used or provided by other operating assets and liabilities.

Investing Activities

The second part of a cash flow statement shows the cash flow from all investing activities, which generally include purchases or sales of long-term assets, such as property, plant and equipment, as well as investment securities. If a company buys a piece of machinery, the cash flow statement would reflect this activity as a cash outflow from investing activities because it used cash. If the company decided to sell off some investments from an investment portfolio, the proceeds from the sales would show up as a cash inflow from investing activities because it provided cash.

Financing Activities

The third part of a cash flow statement shows the cash flow from all financing activities. Typical sources of cash flow include cash raised by selling stocks and bonds or borrowing from banks. Likewise, paying back a bank loan would show up as a use of cash flow.

Important Reports on Receivables

Transaction Reports

Transaction Register
Incomplete Invoices Report
Past Due Invoice Report
Invoice Exception Report
Aging - 7 Buckets Report
Receipt and Adjustment Report


Receipt Register

Unapplied and Unresolved Receipts Register
Applied Receipts Register
Miscellaneous Receipts Register
Adjustment Register
Adjustment Approval Report
Customer and Billing Reports

Account Status Report

Customer Listing Detail and Summary Reports
Credit Hold Report
Billing History
Billing and Receipt History
Customer Open Balance Letter
Accounting and Reconciliation Reports

Unposted Items Report

AR Reconciliation Report
AR to GL Reconciliation Report

Few Important Query

Get Calendar Information

select calendar_type,
start_date,
end_date,
period_num,
period_name
from fa_calendar_periods
where calendar_type='&calendertype'
order by 2;

Get Depreciation Period :

select book_type_code,
period_name,
period_counter,
period_num,
fiscal_year,
period_open_date,
period_close_date,
calendar_period_open_date,
calendar_period_close_date
from fa_deprn_periods
where book_type_code='&book'
order by 3

How to check AP ,GL, AR periods are closed 

SELECT (SELECT sob.NAME
FROM gl.gl_sets_of_books sob
WHERE sob.set_of_books_id = a.set_of_books_id) "SOB_Name",
a.period_name "Period_Name", a.period_num "Period_Num",
a.gl_status "GL_Status", b.po_status "PO_Status",
c.ap_status "AP_Status", d.ar_status "AR_Status",
e.fa_status "FA_Status"
FROM (SELECT period_name, period_num,
DECODE (closing_status,
'O', 'Open',
'C', 'Closed',
'F', 'Future',
'N', 'Never',
closing_status
) gl_status,
set_of_books_id
FROM gl.gl_period_statuses
WHERE application_id = 101
AND UPPER (period_name) = UPPER ('&period_name')
AND set_of_books_id ='&sob' ) a,
(SELECT period_name,
DECODE (closing_status,
'O', 'Open',
'C', 'Closed',
'F', 'Future',
'N', 'Never',
closing_status
) po_status,set_of_books_id
FROM gl.gl_period_statuses
WHERE application_id = 201
AND UPPER (period_name) = UPPER ('&period_name')
AND set_of_books_id ='&sob' ) b,
(SELECT period_name,
DECODE (closing_status,
'O', 'Open',
'C', 'Closed',
'F', 'Future',
'N', 'Never',
closing_status
) ap_status,set_of_books_id
FROM gl.gl_period_statuses
WHERE application_id = 200
AND UPPER (period_name) = UPPER ('&period_name')
AND set_of_books_id ='&sob' ) c,
(SELECT period_name,
DECODE (closing_status,
'O', 'Open',
'C', 'Closed',
'F', 'Future',
'N', 'Never',
closing_status
) ar_status,set_of_books_id
FROM gl.gl_period_statuses
WHERE application_id = 222
AND UPPER (period_name) = UPPER ('&period_name')
AND set_of_books_id ='&sob') d,
(SELECT fdp.period_name,
DECODE (fdp.period_close_date,
NULL, 'Open',
'Closed'
) fa_status,fbc.set_of_books_id
FROM fa.fa_book_controls fbc, fa.fa_deprn_periods fdp
WHERE fbc.set_of_books_id ='&sob'
AND fbc.book_type_code = fdp.book_type_code
AND UPPER (fdp.period_name) = UPPER ('&period_name')) e
WHERE a.period_name = b.period_name(+)
AND a.period_name = c.period_name(+)
AND a.period_name = d.period_name(+)
AND a.period_name = e.period_name(+)
AND a.set_of_books_id=b.set_of_books_id(+)
and a.set_of_books_id=c.set_of_books_id(+)
and a.set_of_books_id=d.set_of_books_id(+)
and a.set_of_books_id=e.set_of_books_id(+)
ORDER BY 1

AP to GL Transfer

SELECT details."Vendor_Num", details."Vendor_Name",
details."Prepayment_Num", details."Prepayment_Currency",
details."Prepayment_Amount" "Prepayment_Amount",
SUM (details."Apply_Amount") "Apply_Amount_Sum"
FROM (SELECT pv.segment1 "Vendor_Num", pv.vendor_name "Vendor_Name",
ai1.invoice_num "Prepayment_Num",
ai1.invoice_currency_code "Prepayment_Currency",
ai2.invoice_num "Invoice_Num",
ai2.invoice_currency_code "Invoice_Currency",
aid1.amount "Prepayment_Amount",
NVL (aid2.amount, 0) "Apply_Amount"
FROM ap.ap_invoices_all ai1,
ap.ap_invoices_all ai2,
ap.ap_invoice_distributions_all aid1,
ap.ap_invoice_distributions_all aid2,
po.po_vendors pv
WHERE ai1.set_of_books_id = &sob
AND ai1.invoice_id = aid1.invoice_id
AND ai2.invoice_id(+) = aid2.invoice_id
AND aid1.invoice_distribution_id = aid2.prepay_distribution_id(+)
AND TRUNC (ai1.invoice_date) > TRUNC (SYSDATE - 3650)
AND ai1.invoice_type_lookup_code = 'PREPAYMENT'
AND ai1.cancelled_date IS NULL
-- AND ai1.invoice_num = '071230'
AND aid1.amount + NVL (aid2.amount, 0) <> 0
AND aid1.amount <> NVL (aid2.amount, 0)
AND ai1.vendor_id = pv.vendor_id) details
HAVING (details."Prepayment_Amount" + SUM (details."Apply_Amount") <> 0)
AND (details."Prepayment_Amount" <> SUM (details."Apply_Amount"))
GROUP BY details."Prepayment_Num",
details."Prepayment_Currency",
details."Prepayment_Amount",
details."Vendor_Num",
details."Vendor_Name"

Find Supplier Site Information :

select
pov.vendor_name Supplier,
povs.vendor_site_id,
povs.vendor_site_code Site,
povs.address_line1 A1ddress,
povs.address_line2 A2ddress,
povs.address_line3 A3ddress,
povs.city||', '||
povs.state||' '||
povs.zip A4ddress,
povs.ship_to_location_id,
povs.bill_to_location_id,
povs.ship_via_lookup_code,
povs.freight_terms_lookup_code,
povs.fob_lookup_code
from po_vendors pov,
po_vendor_sites povs
where pov.vendor_id=601
and pov.vendor_id=povs.vendor_id
order by 1

Prepayment AP invoice Details 

SELECT pv.VENDOR_NAME,
ai.invoice_num,
NVL (
DECODE (
SIGN (SUM (amount - NVL (prepay_amount_remaining, amount))),
1,
DECODE (SUM (prepay_amount_remaining), 0, 'Y', NULL),
NULL
),
'N'
)
AS PP_F -- Y is Fully Applied, N is Partially or Not Applied
FROM ap_invoice_distributions_all aid, ap_invoices_all ai, po_vendors pv
WHERE aid.invoice_id = ai.INVOICE_ID
AND pv.VENDOR_ID = ai.VENDOR_ID
AND aid.line_type_lookup_code = 'ITEM'
AND ai.invoice_type_lookup_code = 'PREPAYMENT'
AND ai.INVOICE_ID = :P_INVOICE_ID
AND NVL (reversal_flag, 'N') <> 'Y'
GROUP BY pv.vendor_name, ai.invoice_num
HAVING NVL (
DECODE (
SIGN (SUM (amount - NVL (prepay_amount_remaining, amount))),
1,
DECODE (SUM (prepay_amount_remaining), 0, 'Y', NULL),
NULL
),
'N'
) <> 'Y';

Supplier Bank Account Information

SELECT DISTINCT abau.bank_account_uses_id bank_account_uses_id,
abau.end_date end_date,
abau.external_bank_account_id external_bank_account_id,
abau.primary_flag primary_flag,
abau.start_date start_date,
abau.vendor_id vendor_id, 
abau.vendor_site_id vendor_site_id,
aba.bank_account_name bank_account_name,
aba.bank_account_num bank_account_num,
aba.bank_account_type bank_account_type,
aba.account_type account_type,
aba.currency_code currency_code,
aba.description bank_account_description,
aba.check_digits check_digits,
aba.multi_currency_flag multi_currency_flag,
abb.bank_name bank_name, 
abb.bank_name_alt bank_name_alt,
abb.bank_number bank_number,
abb.bank_branch_name bank_branch_name,
abb.bank_branch_name_alt bank_branch_name_alt,
abb.bank_num bank_num, abb.institution_type institution_type,
abb.bank_branch_type bank_branch_type,
pv.vendor_name vendor_name,
pv.segment1 vendor_number,
pv.vendor_type_lookup_code vendor_type_lookup_code,
pvs.vendor_site_code vendor_site_code,
pvs.address_line1,
pvs.address_line2,
pvs.city,
pvs.zip,
abb.end_date branch_end_date,
aba.inactive_date acct_inactive_date, 
aba.org_id
FROM ap_bank_account_uses_all abau,
ap_bank_accounts_all aba,
ap_bank_branches abb,
po_vendors pv,
po_vendor_sites_all pvs
WHERE abau.external_bank_account_id = aba.bank_account_id
AND aba.bank_branch_id = abb.bank_branch_id
AND abau.vendor_id = pv.vendor_id
AND abau.vendor_id = pvs.vendor_id(+)
AND abau.vendor_site_id = pvs.vendor_site_id(+)

AGIS R12 Setup

Release 12- Advanced Global Intercompany System Setup – Part 1

Posted on April 30, 2009 by Dinesh Nair

OVERVIEW
Part one on setup offers a broad view on how AGIS is Setup in R12

The setups are divided into four parts
1. Environmental setups
2. General Ledger (GL) setups
3. Receivable (AR) setups
4. Payables(AP) setups
5. Advanced Global Intercompany System (AGIS)

Part two on transaction processing discusses the setups those are required for processing the transaction in AGIS

Transaction Processing in AGIS
The summaries of steps those are used for AGIS transaction processing are As follows.

1. Initiation of a transaction by an intercompany organization
2. Completion of accounting from the initiator side
3. Completion of accounting from recipient side
4. Approval of the transaction by the recipient

If the invoicing is opted for, in transaction type setups then,

1. Processing of Invoice from Receivables
(For the initiator subsidiary side)
2. Processing of invoice in Payables
(For the Recipient subsidiary side)

Part three discusses the reports in AGIS and reconciliation features in AGIS

1. Standard reports Available in AGIS
2. econciliation features in AGIS

The setup steps are explained in the subsequent sections, from start to finish

The details of the examples used in this document is as follows,

-Initiator Subsidiary-‘Blink AGIS INV ORG’. This organization is a part of BCR Singapore Legal Entity. This Legal Entity uses 001 balancing segment value. The user that is having access to initiator subsidiary is called BCR_S

-Recipient Subsidiary–‘Blink AGIS INVJ ORG’. This organization is a part of BCR Japan Legal Entity. This Legal Entity uses 002 balancing segment values. The user having access to initiator subsidiary is called BCR_J

PART ONE- AGIS SETUP

Welcome to the Advanced Global Intercompany System (AGIS) setup

Description of the setup that is used in this viewlet is as follows
One ledger called Blink ledger.
Two legal entities under that ledger called BCR Singapore legal entity and BCR Japan legal entity. Two operating units Blink AGIS Singapore OU, Blink AGIS Japan OU respectively.

*Note: Setting up of receivable setup is mandatory, for using invoicing functionality. And for setting up of receivables mandatory that inventory Organization are created as well.

The transactions in this example are assumed to be happening from BCR Singapore to BCR Japan. For theses two create
Two employees: BCR Singapore and BCR Japan
Two Users : BCR_S and BCR_J
Create receivables and GL Responsibilities.

As the first step we should define employees in HRMS. These employees are used later on in the AGIS security setups.

Navigation: HRMS, Progress Admin S&L>>People>>Enter and Maintain

Define an employee ‘BCR, Singapore’ .This person will be attached to the user initiating the transaction in AGIS. In our example transaction gets initiated by BCR Singapore

Similarly create another employee (Recipient) BCR Japan and Save your new creations.

Create a users like BCR_S & BCR_J. Note the Person attached to this User is (BCR, Singapore) he is now the contact Person

Next step is to define Custom responsibilities like GL Super User, AP Super User, AP Super User, HRMS Management, OM, & AGIS Super user Resposibilities and attach it to our users.

Our next setup in AGIS set id to define a business group

Login to HRMS Responsibility and create Business group called Blink AGIS, Which you will later require to attach with the operating Units.

Navigation:
HRMS Management>>HRMS Manager>>Work Structures>>Organization>>Description

Click on Other button at line Level and set the Business Group settings:

Next step is to set some of the system profile options.
Navigation: System Administrator>>Profile>>System

Profile options where set for
1. HR: Business Group,
2. HR: Security,
3. MO: operating Unit,
4. MO: security profile,
5. MO: Default Operating Unit Profile,
6. GL Ledger name
One might already know, If MO: Security profile is defined the MO: Operating unit profile becomes redundant.

In this part we will see about GL ,AR, AP, setups

Now our next step is to create Legal entities namely BCR Singapore legal entity and BCR Japan legal entity of which one will be Our Initiator and other will be Recipient for our Intercompany transactions.

In BCR General Ledger Super User Responsibility

*Note: When you create our business group HRMS security profile gets automatically created with the same name of our Business Group.

Navigation: Setup>>Financials>>Accounting Setup Manager>>Accounting Setup

Click on Legal Entity tab in Accounting Setup Manager page to create new legal entity. Fill in all the mandatory columns like Territory, Legal Entity Name, Organization name, RCB Number and Legal Address. The screen shot below shows the sample of legal entity creation. Values such as Place of Registration, Inspection date, Primary Activity, Secondary Activity, Type of Company, and Fiscal year end are optional fields.

Similarly Create BCR Japan Legal Entity. And query the names in Legal entity form for confirming the creation of legal entities.

Our next step in the process is to create a valid ledger. Here I have a valid ledger called Blink Ledger highlighted on the screen shot below. Now attach the legal entities we have created in the previous step to this valid ledger.

In the screen shot below you can see the legal entities attached to the Ledger. Then define the operating unit by clicking the Operating unit update icon as shown below.

Create Operating units Namely ‘Blink AGIS Singapore OU’ and ’Blink AGIS Japan OU’. While creating attach the business group we created in the initial steps. (Blink AGIS)

Query the operating Units as show below for confirming the creation. Here you can see your operating units, Short code, Business group to which they are attached and the corresponding legal entities they are assigned to

So far what is covered is assignment of Legal entities and Operating units to Ledger.

Next step would be to define Inter-company Balancing Rules. Options to define inter- company rules would be visible, If and only if the inter company option is enabled.

Clink on Update icon to define Intercompany balancing rule

Under Intercompany company accounts link, there is a link called ‘Define Relationships’ where one can create relationship between various legal entities. This is the place where GL is noticed of ‘from where’ and’ to where’ the transactions are going to flow.In case, define the relationships for the BCR Singapore Legal Entity to BCR Japan Legal entity. As of now reverse way transactions is not happening so only one way relationship (Singapore LE to Japan LE) would suffice.

Define the relationship here. There are two parties in a relationship. First one is the Transacting Entity and the second is Trading Partner Entity.

Note: The relationship can be defined individual / multiple Balancing segment values of the transacting and trading entity.

Now we have just finished the required setups in GL for AGIS. Before entering AR setup the prerequisite is to have a Inventory organization.

Below screen shots will tell you the creation of INV organization:

Complete the Accounting Information, Receiving Information, Inventory Information to complete the INV. Organization creation.

Now set the following system profile option at this responsibility level
Profile options where set for
1. HR: Business Group,
2. HR: Security,
3. MO: operating Unit,
4. MO: security profile,
5. MO: Default Operating Unit Profile,
6. GL Ledger name
*Note: When you create our business group HRMS security profile gets automatically created with the same name of our Business Group.

Now we will move on to Payables setups.

In AP Define Financial Options,Payable Option, and System profile Option.setting up of Financial & payables options are more are less similar to 11i.

Login to Intercompany Super user responsibility assigned to our user. The First step is defining organizations. These are the organizations which will be used by AGIS

Navigation: Intercompany Super user>>Setup>> Organization

Define Organization as shown below.

Similarly create organization for Japan legal entity also. And Query the same in organization form for confirming your creation. Note that in the above Screen while creating organization select ‘Yes’ for enabled column. This flag indicates that this organization is enabled for intercompany transactions. Without this processing of transactions in those organizations, through AGIS is not possible

Next Step is to security definition. Security is defined as, which user/person will have access to which and how many intercompany organizations
Navigation: Intercompany Super User>>Setup>>security

Query the Person name and the Respective organization on which the person should be given access. And enable “Yes” for the options as shown below

In the same way shown above give access for BCR_S to Singapore Org. and BCR_J to Japan Org.

Next set is to define Transaction types in AGIS.
Your transaction type will decide whether invoicing is required for the transaction and manual approval is required.

Our next step inthe process is to define AGIS system options

Next we will define invoicing options

Under invoicing option Define Receivable Assignment and Customer/Supplier association as shown in the below screen shots

Example setup of one of the operating unit is shown in figure.
Note that Receivables Transaction Type and Receivables Memo lines can be linked only id Receivable setups are complete.If those setups are not complete then trhe LOV will not appear.The values like “Intercompany” , “Global Intercompany” respectively are seeded values in Receivables. These have been specifically seeded in Receivables for AGIS

In the above step definition of Customer/ Supplier Association is done.There are two tabs in the setup.
1.Customer/Supplier association tab to define the Association
2.Trading partner tab to reviewthe earlier Created association.

The second step in the creation of customer supplier association is selection of customer and entering a “Bill To Site” for the customer
Note that both are mandatory.

With this we have completed AGIS setup required for processing AGIS transactions We will discuss on AGIS Transaction process in the next part.

AGIS – Transaction Processing

Now we are ready with the setups for processing AGIS transaction. Login using Initiator Account . In our example BCR_S (Singapore is the initiator) and select Outbound transaction

This is the first form for data entry. notice the Transaction type, Initiator fields entered at the top of the screen.

In the second half, Receipient Details are entered.

The next screen is to complete accounting from the initiator side. Click on Add line button and enter The second effect of transaction from initiator side.

Once the transaction entry is complete click On Submit button.
After submition you can see the status of the transaction appears as “Submitted” which is Shown below

Now Login as Recipient. in our example BCR_J (Japan is Our Recipient)
and click on Inbound transaction as shown below

Query for the same batch number. And you will find the Status of the trasaction appears as “Received” for the Recipient.

Click on update icon for entering Recipient side accounting information.

About these ads