New features in R12 from 11i.
------------------------------
--- Questions and exercises in R12.
--- What are the objectives/exercises that we need to do.
1. Create a AR transaction, then run Create Accounting program, and see what kind
of Journals are created in SLA ???
Make sure the accounting setup options are properly set for the ledger for
which you are createing the transactions for. For ex, the sequencing context
name needs to be created for the appropriate context i.e journal setup.
It is also important to note that once the journal entries are created in the
SLA, they cannot be directly viewed from SLA. Each application will provide an
inquiry screen to query those journal entries.
Then for the same AR transaction, run the Submit Accounting program,which will
basically run the revenue recognition progrm,generates the distributions and
then see the journal entries in SLA.
2. How are profile options "MO:Operating Unit" and "MO :Security Profile"
related ??
If "MO :Security Profile" is defined, then the profile option "MO:Operating Unit"
is ignored.
If "MO :Security Profile" is not defined, then the system will fall back on
the profile option "MO:Operating Unit" and then the system will behave
just like the 11i,where for ex in AR, we will be able to create the trx's
only corresponding to the OU specified by "MO:Operating Unit".
3. How is the multi-org feature achieved in R12 as opposed to 11i ???
In R12, the multi-org feature is acheived thru the "MO :Security Profile"
profile option.
In 11i, lets say in AR, if we have to create a transaction, then that particular
transaction is corr to a particular Opearting unit id,which is dictated by the
profile option MO: Operating Unit. If we have to create a trx corr to
a different OU, then we need to shift to a different resp corr to that
OU and create the transaction. Also you can only see the trx corr to ur OU.
In R12, We can access corresponding to multiple operating units using the
following steps.
Go to HR, and create a Security Profile. Give the organizations that you need
to that security profile.
Come to System administrator and set the value of profile option
"MO: Security Profile " to the value created in the above step.
Once the above step is done, we should be able to create invoices corres
to any operating unit. see below for more inforatiom.
4. How do you create transactions in AR corr to any operating unit???
First thing set the profile options as explained in the above question.
In AR, the batch source is tied to the operating unit. Hence once the above
profile option is set (corr to all Orgs), then you will be able to select any
batch source corr to any operating unit. once you select a source, then the
legal entity field and the OU field(in the more tab) will get populated
accordingly.
As anex, if the "MO: Security Profile " is nullifed, and then you come to the
trx screen, and if you select the source LOV, you will see only sources
corresponding to the OU specified by only "MO: Operating Unit".
The whole point is to able to create transactions for any operating unit,with out
going thru the painful process of changing the responsibilities each time.
So in transactions form ,there is no Operating unit in the more tab
in 11i while there is one in R12.
5. What happened to profile option MO: Top Operating Level ???
In 11i, we had a profile option MO: Top Operating Level , which is not
there in R12. Basically all the multi org reports are still now
running with reporting parameters,reporting level and reporting context.
However now the reporting level willl have values of Ledger or Operating unit.
6. With the introduction of SLA, do we still need to run the program
Journal Import etc to push the transactions to GL ???
No. See below for more details.
In 11i, when data was transferred from subledgers, it was transferred to
GL_interface table, and then the journal import program will push them
into the GL. if there was any errors in the journal import, then the user
had the option of changing the data in the gl interface tables and
then resubmit the program. the one disadvantage of this process is that
the same transaction will have different values in subledger and GL
because of the correction.
In R12, (the transfer to gl, and journal import) are combined into "Transfer
to GL" function. If the Journal import does not complete successsfully, the
data is deleted from the gl_interface tables & SLA tables. This ensures that
the subledger (for ex, AR) and GL are in sync. Hence it is not recommended
to change the profile option "SLA: Submit Journal Import" profile option.
So the best way is to fix the source transaction with in the subledger.
Hence one such error which could cause problems is the accounting setup/account
combination issues. To fix this you could use the disabled account feature
,where if an acount is disabled,then you could give a replacement acccount,
so that the new account is taken.
7. What is the difference/commonality between the 11i SOB and R12 Ledger.
the set of books is combination of COA, Calendar and Currency
while Ledger is combo of COA, calendar, currency, and SLA method.
8. Any new changes as far as the Journal Reversal Criteria is concerned in R12 ??
In 11i, at the set of books level, there is no journal reversal criteria
set specified. That means once you create a Journal Reversal criteria set
it is specific to that set of books.
In R12, there is additional field for journal reversal criteria set in the
Journal Processing area ,where we can set a specific Journal reversal criteria set.
So in summary, a single criteria set can be shared across different ledgers.
9. Are there any changes to the number of AR Interfaces in R12?
So basically unlike in 11i, where we had 5 interfaces (autoinvoice,lockbox,
customer, tax, GL interface), but in R12 ,we only have 3 interfaces namely
(autoinvoice, lockbox, customer).
The GL transfer is no longer there. The transactions transparently flow from
the AR (for ex) to GL. So if you need to transfer the data, basically you
need to transfer from SLA to GL. So there is a program Transfer GL data,but
it is under the application SLA. Similarly Tax interface is replaced by
Tax accounting engine or e-business tax,which means the e-business tax is shared
by all the modules like AP,AR.
10. How do you classify a particular account as Control Account in SLA in R12?
11. Is Create Accounting Program there in all the Oracle Apps Modules ??
Yes, if we look at the Subledger Accounting module (SLA), it is being seen
as a service oriented architecture and hence the same program is used in
different modules. And since differnt modules can use different ledgers,
the parameter ledger is provided so that they can give any ledger they want.
12 Is Revenue Management converted into a new feature/module in R12.
Yes, the revenue management was a feature which was in AR even in 11i. In 11i AR,
you are said to be using the Revenue Management if you set the options
with in the Revenue Policy tab of the system options.
However in R12, the revenue management functionality has been extended with
some additional features and a new module has been created which is now
called BRM(Billing and Revenue Management).
So yes BRM exists only in R12.
Receivables New Features in R12 :
-----------------------------------
What are line level cash applications ??
Line Level cash applications :if the customer has only received one item
and not the other line,then you could just apply the receipt amount to just
one invoice line. To do this, in the applicaitons screen, click on the apply in
detail and apply it to the specific linethat you want.
How is daily revenue rate calculated???
Daily revenue rate is calculated by dividing the revenue for that item
by the total number of days in that duration. If you choose the daily
revenue rate in the accounting rule, then number of periods is disabled.
Only at the time of invoice entry you need to specify the start and end dates
adn the number of days is calculated by the difference between those two.
What is a partial period??
A partial period is a period, whose start date is not the first date of that
period or whose last date is not the last date of that period. As an ex, you
can define a May-09 period,with the start date of 05-may-2009 or a June-09
period whose end date is 29-jun-09
What are the new changes to the R12 Accounting Rule types??
In 11i, there were only two types of accounting rule types
Accounting, Fixed Schedule
Accounting, Variable Schedule
In R12, in addition to the above, two more rule types are introduced
Daily Revenue Rate, All Periods
Daily Revenue Rate, Partial Periods
Multi Org Access :
With Multi org access, it allows you to access multiple organizations data using a
single responsibility.
Are there any new receipt classes in R12.
In R12, there are some new additional receipt classes available. For ex,
there is a new receipt class "AP/AR Netting".
What are the new features in recognizing revenue in R12 ?
Some of the cool features are online accounting and draft accounting.
In R12 ,we do have an option of created the accounting or generating the revenue
entries online or offline. that is we have a Create Accounting option in
the transaction form. The create accounting option allows you to recognize the
revenue for that particular invoice only,this feature is not available in 11i.
Any changes in R12 to the consolidated billing ??
In the payment terms, we are not seeing a cut off region in the R12,while in 11i
it is seen.
In 11i, for all the customer trx, there was no concept of legal entity id at the
transaction level. However in R12, when we create a ledger we associate legal
entities to it. So for ex in AR trx, a legal entity field shows in the form,
which means that particular LE in the main company has performed this transaction.
When you create accounting setups in Accounting Setup Manager, it is recommended
that you assign specific balancing segment values to legal entities. This enables
you to easily identify transactions by legal entity and take advantage of many
legal entity features, such as Intercompany Accounting.
11i AR dunning letters and collections workbench is obsolete in R12. In R12,
they are replaced by Oracle Advanced Collections.
In the approval limits, we can set the approval limits for a Refund as well. Previously
we could only set for adjustments, RWO's, and CM's
In 11i, the oracle advanced collections is represented by separate modules like
Oracle collections agent, leasing agent etc and they are all forms based applications.
In 11i, you need not have to use the oracle advanced collections, and still use
the basic collections functionality i.e like able to look at the customers account,
balances, changing due date etc. All this is done using the native forms.
However in R12, there is no collections module per se, it is only advanced
collections and everything is html based
Payables New Features in R12.
-----------------------------------
* Suppliers are now represented as Trading partners.
See they are created and categorized.
* In 11i, payables invoices were having a header and distributions ,there were no
lines. However in R12, you have the concept of the invoices,lines and distributions.
Basically the advantages of this change are
provides for line level approval
and matching between an invoice line to a PO shipment item.
facilitates the transfer of additional information between AP and FA.
* Payment processing has gotten better than 11i. Since the selection criteria
encompasses the Operating unit, multiple currencies and pay groups, we can manage
fewer payruns.
* There is a new tool called payment manager.,which allows us to create a payment
process request template.
* AR/AP Netting. The netting feature enables the automatic netting of payables and
receivables transaction with in a same business enterprise. The netting process
automatically creates the payables payments and receivables receipts required
to clear the payables invoices and receivables transactions.
AP/AR Netting steps:
1.define netting control a/c(setup>financials>flexfield>key>values)
2.create bank (Setup>payment>Bank and Bank Branches.payment document is not
required for netting bank account
3.go to receivables responsbility, receipt class definition form(setup>
receipts>receipt class). query the 'AP/AR Netting' receipt class
which is a seeded one.
4.attach your bank account in this receipt class
5.go to system options, transaction and customer tabbed region, there enable
'Allow payment of Unrelated Transactions'check box
6.create netting agreement(Receipts>Netting>Netting Agreement)
7.Enter an Invoice in Payables, validate and run create accounting.
8.enter a transaction in receivables.
9.Create Netting Batch(Receipts>Netting>Netting Batch)
10.Query your netting batch and see the status as Complete.also click on view
report icon on right side.click on run push button, you can see the final netting report.
11.Go to view>request>find
You can see 3 concurrent request programs
1.Create Netting batch 2.Settle netting batch 3.Netting Data Extract.
12.Now go to receipts and query the AP/AR netting receipt.
13.Now Go to Tools >view Accounting, you can see Netting control account
(defined in first step) debited and receivable account credited
14.Now go to payables and query your invoce number and click the tab view payments.You can see the payment details and copy the document number
15.Query your copied payment document number.you can see the payment type as Netting
16.Click actions button and enable the check box create accounting
17.Goto tools>view accounting .you can see the accounting entry:
See basically, First you have to create a netting agreement, with netting business rules and transaction
criteria. Transaction criteria means we can associate Payables (Invoice, credit
memo,debit memo) and Receivables(Transaction,credit memo,debit memoe,charge
back etc)
As an example, let us say there is a supplier A with a balance of $100 (invoice)
let us say there is a customer B with a balance of $150 (invoice)
And if we have created a netting batch for these two parties, then since the
AR Balance > $AP Balance ,
then the netting amount would be AP balance which is $100 and hence you would
create a AR receipt for $100, which will in effect make the open balance in
AR equal to $50.
GL New Features in R12 :
---------------------
1. What are Data Access Sets in R12 ?
With the introduction of the data access security feature some additional
security provisions have been made in the R12 (in addition to the security
features in 11i like security rules and cross validation rules).
When you create a ledger, automatically a new data access set is created with
the same name with full ledger access.
If "SLA: Enable Data Access Security in Subledgers" profile option is set Y, then
the user will have access to all the data specified by the data access set profile
option "GL Data Access Set".
Each data access set corresponds to a particular data access set type,which
could have a value of "Full ledger", BSV or MSV.
As an ex, if the value is BSV, your access could be like
Read-only access to the balancing segment value 01
Read-write access to the balancing segment value 03,04
No acccess to the balancing segment value 05.
The data access sets work with the security rules. We know that the security
rules in 11i allow a specific responsibility to access only certain balance
segment values etc. The data access set basically lets you set the access
privileges for different ledgers.
Consider the case,where the security rules provide access to only the balancing
segment value 0 and 03. The data access set provides read only access to
balancing segment values 01, 03. Then when the user logs in he will not be able
to create any journals for any accounting combination.
2. what is the management segment value,BAL,SEG value
In r12, there is a new addition called management segment value (apart from
the other qualifiers).
3. Did recurring journals get any new feature in R12 ??
In Release 11i, you could define recurring journals using the functional currency
or STAT currency.
However in Release 12, you can create recurring journals using foreign currencies.
This is particularly useful if you need to create foreign currency journals that
are recurring in nature. For example, assume a subsidiary that uses a different
currency from its parent borrows money from the parent. The subsidiary can now
generate a recurring entry to record monthly interest payable to the parent
company in the parent’s currency.
4. Any new changes to the intercompany
Intracompany balancing rules ; only a concept in R12 not in 11i.
If you look at a journal,you could see the following on a document,each Journal
is classified by
Journal Entry Description (text)
Account Derivation Rules (account combination)
Journal Line types ( Cr,Dr, $)
In the approval limits, we can set the approval limits for a Refund as well. Previously
we could only set for adjustments, RWO's, and CM's
TAX Module in R12.
------------------
In the 11i world, the taxes were defined specific to each module. For ex, in AR, we
define tax code(corr to tax types) and we secify the tax code hierarchy. Similary
in AP too we define the tax code and there will be tax hieararchy.
However in R12, the taxes have been integrated and a new product called e-business
tax has been created. This module
Create Tax Regime which corresponds to a Tax country like US,UK etc.
Tax Types are always predefined like Sales Tax, Use Tax, Location based tax etc.
Configuration Owner is also predefined,not sure what this is
Create a Tax (in 11i this is called tax code). This is based on a tax regime code,
configuration owner , and tax type.
Create a Tax Status, this is based on tax regime code and Tax. A Tax can have multiple
tax statuses corresponding to Standard rate, zero rate or reduced rates etc.
My understanding is that we can create multiple 0% rates (say)i.e we can
create multiple zero-rate tax rates ,with each zero-rate tax rates corresponding
to different purpose for ex, zero-rate products, zero-rate exports etc. And
all such zero-rate tax rates can be clubbed into a tax status called
zero-rate tax status.
Cash Management New Features in R12.
-----------------------------------
Banks and Bank Accounts :
------------------------
In 11i, the banks,bank accounts were owned by AP. However in R12, the banks are
owned by Cash Management,however the banks forms can still be accessed from AP/AR.
Also the functionality of bank account transfer was part of the Treasury Module,
which is now available as part of the Cash Management.
Monday, 11 April 2011
New features in R12 from 11i
TCA (CUSTOMER INFORMATION)
/* CUSTOMER INFORMATION : Actually for each customer that is created, an account is created as well(hz_cust_accounts) and the corresponding sites are hz_cust_acct_sites. And the customer can make any of these sites as billto,shipto etc. These are called party site uses. And this information goes into hz_cust_site_uses. Not quite sure why two different sets of tables are maintained.?? Actually historically all the customer information is owned and stored by AR.So the data is stored in tables like ra_customers, ra_contacts etc. However since customer information is shared universally by all products a central common repository of customer data is needed which is what is TCA. All the tca tables start with hz_ i.e hz_parties, hz_party_sites etc. And the ra_customers etc tables converted now into view from tables and these views will now base on these hz related tables. A Word About Oracle TCA (Trading Community Architecture). Before we explain the TCA,let us take an example of a company like cisco which uses multiple tools and applications over the years and has generated the customer data in multiple applications(called Source Systems). Hence if it has to answer the question of what are my top 150 customers , then it needs to have a single comprehensive repository of Customer information. Here this single repository of customers will be called Parties. So more than one source system customers will be mapped to Parties or customer to party is a many-to-one relationship. Oracle TCA stores the parties in a table hz_parties. However while creating a customer using the Oracle 11i forms, a record is created both in ra_customers as wells as hz_parties. And it will store the customer id in ra_customers as the orig_system_reference in the hz_parties table. A Party is an entity that can enter into business and can be of type Organization or Person. A Customer is of type Oraganization or Person with whom you have a selling relationship. A customer account represents the business relationship between one party and another. As an ex,you can have a commercial account and reseller account for a party (ex Vision Distribution). Customer Creation in Oracle AR : ------------------------------- This can be done simply from the (customers => summary). While entering the customer information, we need to give a whole bunch of mandatory and optional information like taxpayerid, profile, freight terms(shipping terms). A profile class basically gives us the informationn about how good a customer is (from customers menu), who should be the collector, where the dunning letters and statements to be sent,payment terms, finance charges for overdue invoices etc. Now for each customer we can enter more than one addresses or multiple addresses.The communication and contact information entered for the customer is different from the comm and contact information for each of the customer addresses. Now suppose say we have entered all the information for a customer,like comm,contact etc and also two addresses. Now we open one of these addresses and create a business purpose for this address i.e whether this business should be used as a bill_to or ship_to etc and enter the corresponding sales territory information for the bill to address. */ -- This table stores all the customers that are created. select customer_id,customer_name, customer_number, orig_system_reference,status, party_id, party_type, party_last_update_date from ra_customers where customer_id = 331317 /* While creating the customers, we need to create the customer addresses which are called the locations and they are stored in */ select *--location_id,address1, city,state, country, orig_system_reference, validated_flag,application_id,creation_date from hz_locations where address1 like '700 SILVER SEVEN RD%' order by creation_date desc -- 170, 172 -- Parties are created select * --party_id,party_name,party_number,party_type,validated_flag, orig_system_reference ,creation_date from hz_parties order by creation_date desc /* Party_sites stores the relation ship between the parties and locations and the relation ship is a many-many relationship. i.e 1 party can have many locations(or addresses) and 1 address can be used by many parties.*/ select party_site_id, party_site_number, party_site_name, party_id, location_id, orig_system_reference, creation_date, status from hz_party_sites order by creation_date desc /* The hz_party_site_uses table stores information about how a party site is used. Party sites can have multiple uses, for example Ship-To and Bill-To.*/ select party_site_use_id, party_site_id,site_use_type,application_id, creation_date from hz_party_site_uses /* For every customer that is created, a customer account is also created. In general, each party can have multiple accounts like one for mfg, one for distribution.Similarly an individual can have multiple accounts like personal,family. */ select cust_account_id, orig_system_reference,status,customer_type, party_id,account_number,creation_date from hz_cust_accounts where 1 = 1 --and cust_account_id = 331317 and account_number = '206700' order by creation_date desc select * from ar.hz_cust_acct_sites_all where cust_account_id = 331317 select location,site_use_id, cust_acct_site_id, site_use_code, status,bill_to_site_use_id,orig_system_reference,org_id ,location from ar.hz_cust_site_uses_all where cust_acct_site_id = 501995 -- where cust_acct_site_id = 466132 begin fnd_client_info.set_org_context(fnd_profile.value('ORG_ID')); end; select set_of_books_id, rowid from ar_system_parameters /*So having done all the above stuff, we should be able to succesfully create an transaction batch and an invoice in it. The data goes into the "ra_customer_trx_all" and if the lines are also created, the info goes into "ra_customer_trx_lines_all" Just as we define the banks as internal or external ,even customers can be defined as Internal or External. Internal Customers : Internal means you can define your own company as a customer,so that we can place internal sales orders. External customers : are the which are external. Whether it is internal or external customer, when we are creating a ship_to purpose for a particular address we can associate it to a location which is inventory location. That is we can understand it as, this particular customer will be shipped from this particular inventory location. */ --Difference between bill-to, ship-to ,sold-to etc. : /* Bill-To : is the customer who the order is billed to. he will pay the money Ship-To : is the customer who the order is shipped to . He will get the items,products of the order. Sold-To : is generally the customer who is the main parent company.ex, if the AT&T Cables has placed an order, then AT&T can be the Sold-To company, which is the main parent company. I believe the contacts are only defined for the sites, i.e for the bill-to and ship-to sites. */ /* Parties and Org Id's (Operating Units)*/ If a party is setup in an operating unit under a business group, will the party name be visible to other operating units under a different business group. This makes us feel that the party id is striped by org id. A party is not OU specific. when we create a party it will be visible in all the OU's, but its sites will only be visible in the OU in which they are created i.e. if a party has a party site in X OU,then this site will only be visible in X OU and not in any other OU. Relationship Manager : TCA Registry, which is the single source of trading community information for Oracle E-Business Suite applications. The key entities in the TCA are Parties ,Party sites, customers, Customer accounts, customer account sites, location,contacts, contact points. Bulk Data Import : Import Batch to TCA registry : this program basically imports the data at the party level and NOT the customer level. If you want tcustomer level data to be imported, use the customer interface. There are two kinds of import Party Import and Customer Import. The import that you do in the TCA is Party Import. Customer Import is what you do in AR Receivables. Some of the interface tables that are used in the Bulk data import are hz_imp_parties_int hz_imp_contacts_int After the data is loaded into the interface tables, we run the Import program. One thing we need to remember is that the customer import that we run in the AR does not care about this import. So when the customer import runs, it will create a customer and whenever it creates a new customer, it also creates a new party, even though if there is an associated party existing. This can result in the duplication of the parties. And for the same reason, we have the de-duplication programs. Import Batch to TCA Registry => HZ_BATCH_IMPORT_PKG.import_batch Customer Interface
R12 Supplier Bank – Techno Functional Guide
R12 Supplier Bank – Techno Functional Guide
Three banks you can manage in EBS
- House Bank or internal bank
- External bank for supplier and Customer
- Supplier (or External) bank accounts are created in Payables, in the Supplier Entry forms. Navigate to Suppliers -> Entry. Query or create your supplier. Click on Banking Details and then choose Create. After you have created the bank account, you can assign the bank account to the supplier site.
- Intermediary bank for SEPA payment : An intermediary bank is a financial institution that as a relationship with the destination bank (in this case the supplier bank account you are setting up) which is not a direct correspondent of the source bank (the disbursement bank in AP/Payments), which facilities the funds transfer to the destination bank.
You can enter intermediary bank accounts on Suppliers->Entry->Banking Details->Bank Account DetailsThis is important when paying a foreign supplier from a domestic disbursement account, there may be an intermediary bank used, and it would be set up on the supplier bank account. Although the intermediary bank UI is owned by Payments, the implementation is as embeddable UI components in pages owned by i-supplier Portal (suppliers) and AR/Collections (customers).
Some information- The supplier bank account information is in the table: IBY_EXT_BANK_ACCOUNTS, the bank and bank branches information is in the table HZ_PARTIES.
- Creating a supplier in AP now creates a record in HZ_PARTIES. In the create Supplier screen, you will notice that that Registry_id is the party_number in HZ_Parties.
- The table hz_party_usg_assignments table stores the party_usage_code SUPPLIER, and also contains the given party_id for that supplier. Running this query will return if customer was a SUPPLIER or CUSTOMER
- Payment related details of supplier are also inserted in iby_external_payees_all as well as iby_ext_party_pmt_mthds
- IBY_EXT_BANK_ACCOUNTS, the bank and bank branches information is in the table: HZ_PARTIES.
- The master record that replaces PO_VENDORS is now AP_SUPPLIERS. PO_VENDORS is a view that joins AP_SUPPLIERS and HZ_PARTIES.
- The table that hold mappings between AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID is PO_SUPPLIER_MAPPINGS. Query by party_id.
- The bank branch number can be found in the table: HZ_ORGANIZATION_PROFILES .The HZ_ORGANIZATION_PROFILES table stores a variety of information about a party. This table gets populated when a party of the Organization type is created.
ER Diagram(Bank Model)
Oracle Table Involved- IBY_EXTERNAL_PAYEES_ALL : This stores supplier information and customer information
- IBY_EXT_BANK_ACCOUNTS : This storage for bank accounts
- IBY_EXT_PARTY_PMT_MTHDS : This storage for payment method usage rules.
- IBY_CREDITCARD : stores the credit card information for a customer
- IBY_EXT_BANK_ACCOUNTS :This Stores external bank accounts . These records have bank_account_type = Supplier
- IBY_ACCOUNT_OWNERS :stores the joint account owners of a bank account
- IBY_PMT_INSTR_USES_ALL : This stores data from AP_BANK_ACCOUNT_USES_ALL for payment instruments assignments .This information is stored in the following iPayment (IBY) tables:
Link between Supplier And Banks and TCA table
- The link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id. The link between PO_VENDOR_SITES_ALL and HZ_PARTY_SITES is PO_VENDOR_SITES_ALL.party_site_id.
- When a Supplier is created Record will be Inserted in HZ_PARTIES. When the Supplier Site is created Record will be Inserted in HZ_PARTY_SITES. When Address is created it will be stored in HZ_LOCATIONS
- When a bank Is Created, the banking information will be stored in IBY_EXT_BANK_ACCOUNTS IBY_EXT_BANK_ACCOUNTS.BANK_id = hz_paties.party_id
- When the Bank is assigned to Vendors then it will be updated in HZ_CODE_ASSIGNMENTS.
- HZ_CODE_ASSIGNMENTS.owner_table_id = IBY_EXT_BANK_ACCOUNTS.branch_id.
- The PARTY_SITE_ID column is the link between the tables IBY_EXTERNAL_PAYEES_ALL & PO_VENDOR_SITES_ALL
Driving Bank account associated with a Supplier Site in R12In R12 a Supplier Site is stored, in TCA, as a Party_Site. The Party Site has the Party ID of the Party that represents the Supplier record.
QUERY1..try this
SELECT BANK_ACCOUNT_NAME "Account Name",
BANK_ACCOUNT_NUM "Account Number"
FROM IBY_EXT_BANK_ACCOUNTS
WHERE EXT_BANK_ACCOUNT_ID IN
(SELECT EXT_BANK_ACCOUNT_ID FROM IBY_ACCOUNT_OWNERS
WHERE ACCOUNT_OWNER_PARTY_ID IN
(SELECT party_id FROM hz_party_sites
WHERE party_site_name = 'site code'
)
)
QUERY2..try this
SELECT aba.bank_account_name "BANK_ACCOUNT_NAME",
aba.bank_account_num "BANK_ACCOUNT_NUMBER",
abau.order_of_preference "PRIMARY_FLAG",
aba.currency_code "CURRENCY",
abau.start_date "START DATE",
abau.end_date "END DATE",
pvs.vendor_site_id "VENDOR_SITE"
from iby_payee_assigned_bankacct_v abau ,
ap_supplier_sites pvs ,
iby_payee_all_bankacct_v aba
WHERE abau.ext_bank_account_id = aba.ext_bank_account_id
AND abau.supplier_site_id = pvs.vendor_site_id
AND abau.party_site_id = pvs.party_site_id ;
QUERY3..try this
SELECT HZP.PARTY_NAME "VENDOR NAME"
, APS.SEGMENT1 "VENDOR NUMBER"
, ASS.VENDOR_SITE_CODE "SITE CODE"
, IEB.BANK_ACCOUNT_NUM "ACCOUNT NUMBER"
, IEB.BANK_ACCOUNT_NAME "ACCOUNT NAME"
, HZPBANK.PARTY_NAME "BANK NAME"
, HOPBRANCH.BANK_OR_BRANCH_NUMBER "BANK NUMBER"
, HZPBRANCH.PARTY_NAME "BRANCH NAME"
, HOPBRANCH.BANK_OR_BRANCH_NUMBER "BRANCH NUMBER"
FROM HZ_PARTIES HZP
, AP_SUPPLIERS APS
, HZ_PARTY_SITES SITE_SUPP
, AP_SUPPLIER_SITES_ALL ASS
, IBY_EXTERNAL_PAYEES_ALL IEP
, IBY_PMT_INSTR_USES_ALL IPI
, IBY_EXT_BANK_ACCOUNTS IEB
, HZ_PARTIES HZPBANK
, HZ_PARTIES HZPBRANCH
, HZ_ORGANIZATION_PROFILES HOPBANK
, HZ_ORGANIZATION_PROFILES HOPBRANCH
WHERE HZP.PARTY_ID = APS.PARTY_ID
AND HZP.PARTY_ID = SITE_SUPP.PARTY_ID
AND SITE_SUPP.PARTY_SITE_ID = ASS.PARTY_SITE_ID
AND ASS.VENDOR_ID = APS.VENDOR_ID
AND IEP.PAYEE_PARTY_ID = HZP.PARTY_ID
AND IEP.PARTY_SITE_ID = SITE_SUPP.PARTY_SITE_ID
AND IEP.SUPPLIER_SITE_ID = ASS.VENDOR_SITE_ID
AND IEP.EXT_PAYEE_ID = IPI.EXT_PMT_PARTY_ID
AND IPI.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID
AND IEB.BANK_ID = HZPBANK.PARTY_ID
AND IEB.BANK_ID = HZPBRANCH.PARTY_ID
AND HZPBRANCH.PARTY_ID = HOPBRANCH.PARTY_ID
AND HZPBANK.PARTY_ID = HOPBANK.PARTY_ID
ORDER BY 1,3
Sample Accounts Payable Questionnaire for Client
Sample Accounts Payable Questionnaire for Client
1. Provide and overview of the Accounts Payable operations.
2. Provide samples of vendor master records.
3. Do you differentiate vendor sites which can receive payments and sites which cannot receive payments?
4. Describe the invoice vouchering process.
5. Are recurring expense distributions for fixed or varying amounts?
6. Explain Payment Terms List, Interest Charges, and Discounts?
7. Should invoices be matched completely, partially or both?
8. Explain Invoice Approval Process? Describe the approval process when invoices need to be placed on hold and manually released?
9. What requirement is there to process employee expense reports? Please describe. Provide Sample.
10. What is the current process to generate expense payments to employees?
11. Do your employees have company credit cards? How are company credit cards managed (issued, audited, reconciled, etc.)?
12. List of Supplier / Payment Banks
13. Is there a requirement to use Electronic Funds Transfer?
14. Is there a requirement to use Wire Transfers?
15. Is there a requirement to process Automatic Payments?
16. Is there a requirement to process Manual Payments? If so, is a separate bank account used? 17. Is there a requirement to process Partial Payments?
18. Is there a requirement to process Pre-Payments?
19. Is there a requirement to process Recurring Payments?
20. Is there a requirement to process immediately available ‘Quick Checks’?
21. What is the current procedure for vendor advances?
22. How are vendor advances reconciled when the vendor invoice is submitted?
23. Do you have, or do you require, a priority system for payments? Describe its use.
24. What is your current payment cycle? (How often do you print checks?)
25. If recurring payments are used, what is the normal period cycle for these payments?
26. Is there a requirement to use Computer Generated checks?
27. What is your process to cancel checks?
28. Are all invoices paid in local currency and what currency is used? If not local, list the foreign currencies used.
29. How many payment formats do you have? Provide samples.
30. Do you print the check number on the check/remittance or is it pre-printed?
31. Should a remittance advice note be produced, and when?
32. What is the policy/procedure for handling stop payments?
33. What is the policy/procedure for handling void payments if they have been recorded? 34. What are the requirements for reporting tax payments (e.g. company, rate or tax authority)?
35. Do you have to pay other businesses within the Group
36. Do you use Cash or Accrual Based Accounting?
37. Please provide all copies of Payable reports
38. How long do you do check reconciliation?
2. Provide samples of vendor master records.
3. Do you differentiate vendor sites which can receive payments and sites which cannot receive payments?
4. Describe the invoice vouchering process.
5. Are recurring expense distributions for fixed or varying amounts?
6. Explain Payment Terms List, Interest Charges, and Discounts?
7. Should invoices be matched completely, partially or both?
8. Explain Invoice Approval Process? Describe the approval process when invoices need to be placed on hold and manually released?
9. What requirement is there to process employee expense reports? Please describe. Provide Sample.
10. What is the current process to generate expense payments to employees?
11. Do your employees have company credit cards? How are company credit cards managed (issued, audited, reconciled, etc.)?
12. List of Supplier / Payment Banks
13. Is there a requirement to use Electronic Funds Transfer?
14. Is there a requirement to use Wire Transfers?
15. Is there a requirement to process Automatic Payments?
16. Is there a requirement to process Manual Payments? If so, is a separate bank account used? 17. Is there a requirement to process Partial Payments?
18. Is there a requirement to process Pre-Payments?
19. Is there a requirement to process Recurring Payments?
20. Is there a requirement to process immediately available ‘Quick Checks’?
21. What is the current procedure for vendor advances?
22. How are vendor advances reconciled when the vendor invoice is submitted?
23. Do you have, or do you require, a priority system for payments? Describe its use.
24. What is your current payment cycle? (How often do you print checks?)
25. If recurring payments are used, what is the normal period cycle for these payments?
26. Is there a requirement to use Computer Generated checks?
27. What is your process to cancel checks?
28. Are all invoices paid in local currency and what currency is used? If not local, list the foreign currencies used.
29. How many payment formats do you have? Provide samples.
30. Do you print the check number on the check/remittance or is it pre-printed?
31. Should a remittance advice note be produced, and when?
32. What is the policy/procedure for handling stop payments?
33. What is the policy/procedure for handling void payments if they have been recorded? 34. What are the requirements for reporting tax payments (e.g. company, rate or tax authority)?
35. Do you have to pay other businesses within the Group
36. Do you use Cash or Accrual Based Accounting?
37. Please provide all copies of Payable reports
38. How long do you do check reconciliation?
Oracle Apps Implementation Methodologies(AIM)
Oracle Apps Implementation Methodologies
Unlike product / application development projects, packaged ERP implementations are quite different as we are primarily trying to map the package to the existing business process. Although, there might be a need to create new RICE components (Reports, Interfaces, Conversions and Extensions) which will need additional coding.
Oracle follows and advises their clients to use Applications Implementation Methodology (AIM). However many implementation organizations tend to follow their own methodoloies, which are similar to AIM at a top level but when it comes to actual granular detail they differ a lot. Especially the documenting part differs widely from organisation to organisation. Sometimes, even user organizations have their own implementation methodologies. So, things become interesting and at times frustrating when actually one sits down to do a comparative analysis of the various implementation methodologies and finalise upon the deliverables at different stages.
There are quite a few good blogs on AIM in Richard Byrom's website. One can also download AIM software from the following link below, but do ensure that you do notrun it on IE6.0. This however runs fine on Firefox:
Companies providing Oracle Apps and Oracle BI Consultancy services in India
Companies providing Oracle Apps and Oracle BI Consultancy services in India
Many a time, i have been asked by freinds who are seeking a job change, and sometimes by clients enquiring about organizations that provide consultancy service in Oracle Apps and Oracle BI in India. Though there are many small and big organizations working on Oracle Apps, but only a few top software companies provide the complete range of consultancy services in Oracle Apps and Oracle BI.
I shall try and list some of the organizations here (in no particular order) who are into Oracle BI and Apps in a big way, and would welcome readers to share their information regarding other organizations they are aware of who provide Oracle Apps consultancy and i missed out here.
1. Tata Consultancy Services2. Infosys Technologies
3. Wipro Technologies
4. Satyam Computer Services
5. Accenture
6. IBM
7. Cognizant Technology Solutions
8. Deloitte
9. Oracle Corporation
There are other organizations in India who also provide Oracle Apps and oracle BI services apart from the ones mentioned above, though their scale of operations in India is not as large as the organizations mentioned above. Some of them include, HCL Tecnologies, Sierra Atlantic, Patni Computers, Intelligroup, Polaris Software Lab, Zensar Technologies, GenPact, Birlasoft, Cap Gemini, iGate, etc. Though most of the organizations in India provide basic consultancy services in Oracle Apps, not many of them provide services in Oracle Business Intelligence. Also, some of these organizations predominantly work in some core areas of Oracle Apps like Oracle Process Manufacturing, Oracle CRM, Oracle HCM, Oracle SCM, etc. Many of the MNC's like Deloitte, Cap Gemini, Unisys, Bearing Point are yet to ramp up their India operations upto the levels of TCS, Infosys, Accenture and IBM . In all probability, most of the big MNC's will further consolidate their India operations and outsource substantial part of their development and support work back to India. So, it seems exciting times are ahead of Oracle Apps consultants in India.
(ORACLE EBS SUITE RELEASES)Oracle Apps Marketing for Upgrade projects -
Oracle Apps Marketing for Upgrade projects - A small tip
It has been my observation that a lot of time and effort goes waste knocking the wrong door for Oracle Apps project. Then the question arises, how to know which door to knock. Obviously, one should not waste precious resources uselessly pursuing organizations that are running on a fully supported version of Oracle Apps like R12, 11.5.10, 11.5.9, unless the organization comes to you with a view to upgrade to R12 or 11.5.10. Please refer chart below to find the support time lines for different releases of Oracle E- Business suite and plan accordingly which organizations to target and whom to avoid.
