Oracle Prepayment Invoice Creation in Oracle Apps | Account Payables
By Jag - February 26, 2014
Here in this post, I tried to explain the creation of custom business event in a step by step manner.
Our example will create a business event and through which we will populate a Custom table.
Stage 0: Navigate to System Administrator Responsibility
Move to System Administrator Responsibility and follow the below navigation to reach the Business Events HTML page.
Stage 1: Creation of Business Event
Click the “Create Event” Button as shown in the screen to create a new custom Event
Oracle Payments Funds Disbursement
Payments is a separate module in R12 and has new features, new look and feel (it is now Java page vs an Oracle form in 11i). The module is called as iPayments and the Application Short name is IBY. All the payments table starts with IBY. In this Article, we will be seeing how to do Payments in R12 in a step by step manner. In the example below, we will see how to do a Check Payment Process.
Payments is a separate module in R12 and has new features, new look and feel (it is now Java page vs an Oracle form in 11i). The module is called as iPayments and the Application Short name is IBY. All the payments table starts with IBY. In this Article, we will be seeing how to do Payments in R12 in a step by step manner. In the example below, we will see how to do a Check Payment Process.
Responsibility – Payables Manager
Navigation – Entry – Payments Manager
Click on the Payments Manager as shown above. Clicking this will open an OAF page as shown below
Oracle Payables Invoice Creation | Account Payables
To enter an invoice batch:
1. In the Invoice Batches window enter a unique value in the Invoice Batch Name field. The Invoice Batch Name must be unique across all operating units. This name appears on your reports and helps you locate the batch online.
To enter an invoice batch:
1. In the Invoice Batches window enter a unique value in the Invoice Batch Name field. The Invoice Batch Name must be unique across all operating units. This name appears on your reports and helps you locate the batch online.
Create an item that will be entered in the sales order.
Change the Responsibility to Inventory and Navigate to Items –> Master Items:
When Prompted select the Organization as V1 or M1 which is the Master Organization. Even when M1 is selected which is an inventory Org V1 would be displayed for creating the Item in the Master Org. We want to create the item in M1 and the ship the item from M1.
Enter a name for the Item and Description as shown below.
Let us see the basic structure of the definition of an inventory organization by looking at the data already defined in the Vision database.
Inventory Organization Overview
Note: Do not change any data we see below.
Change the Responsibility to Inventory and Navigate to Setup –> Organizations –> Organizations.
Query by the name ‘Seattle Manufacturing’. This is the organization (organization code M1) we commonly use in the Vision Database to create Inventory transactions, including shipment of sales orders. Notice the entry ‘Inventory Organization’ under Organization Classifications. Place the cursor on that row, and click on the button Others.
Standard API to Split the Delivery detail:
Below Query is used for fetching the Trace File location the server:
SQL FUNCTIONS
LOWER function:
- The lower function converts all letters in the specified string to lowercase.
PgSQL1SQL> SELECT 'ORACLE' String,LOWER('ORACLE') Lower FROM DUAL;
Output:
- If the all employee names( Ename)and job columns was retrieved from the emp table by the below SQL, the value returned would be lower case only, and others columns data will display the normally.
A.I.M | Application Implementation Methodology |Oracle Apps R12
The Method used to Implement Oracle Applications for any Project is called AIM or Application Implementation Methodology.
Phases of AIM:
The Method used to Implement Oracle Applications for any Project is called AIM or Application Implementation Methodology.
Phases of AIM:
- Definition Phase
- Operational Analysis Phase
- Solution Design Phase
- Build Phase
- Transition Phase
- Production Phase
- Gather Business Requirement
- Prepare MD050 Document
- Prepare BR100 setup Document
- Functional setup
- Develop RICE components.
R - Reports -- Reports 6i, 10g
I - Interface -- Programs, SQL, PL/SQL
C - Conversion-- Programs, SQL, PL/SQL
E - Extension -- Forms 6i, 10g - Prepare Documentation.
- MD070: Technical Design Document.
- MD120: Migration Or Installation Document
- TE020: Unit Test Cases Document
- Performance Tuning.
- Prepare sequel queries based on end user requirement.
- AOL -> Application Object Library
- Attend weekly Meeting.
MD070(Module Design): functional Design Document
BR : Business Requirement.
- Is there some kind of logical or physical structure called lock?
- How does the second transaction know when the first transaction has lifted the lock?
- Is there some kind of “pool” of such locks where transactions line up to get one?
- If so, do they line up to return it when they are done with the locking?
- Is there a maximum number of possible locks?
- Is there something called a block level lock? Since Oracle stores the rows in blocks, when all or the majority of rows in the blocks are locked by a single transaction, doesn’t it make sense for to lock the entire block to conserve the number of locks?
- The previous question brings up another question – does the number of active locks in the database at any point really matter?
| Oracle Apps Order to Cash important tables: | ||
| Order entry | ||
| OE_ORDER_HEADERS_ALL | 1 record created in header table | |
| OE_ORDER_LINES_ALL | Lines for particular records | |
| OE_PRICE_ADJUSTMENTS | When discount gets applied | |
| OE_ORDER_PRICE_ATTRIBS | If line has price attributes then populated | |
| OE_ORDER_HOLDS_ALL | If any hold applied for order like credit check etc | |
| Order Booked | ||
| OE_ORDER_HEADERS_ALL | Booked_Flag=Y, Order booked. | |
| WSH_DELIVERY_DETAILS | Status Opened | |
| WSH_DELIVERY_ASSIGNMENTS | WSH_DELIVERY_ASSIGNMENTS.delivery_id will be NULL as still pick release operation is not performed as final delivery is not yet created. | |
| MTL_DEMAND. | ‘Demand interface program’ is triggered in the background and demand of the item with specified quantity is created | |
Changing Password for an Oracle User in R12 Oracle Apps using API
By Jag - February 22, 2014
FND_USER_PKG.CHANGEPASSWORD
/*This article helps in changing the password for Oracle USER using API FND_USER_PKG.CHANGEPASSWORD.
This API is tested in R12.1.3*/
DECLARE
v_user_name VARCHAR2 (100) := 'OPERATIONS';
v_new_password VARCHAR2 (100) := :NEWPASSWORD;
v_status BOOLEAN := NULL;
BEGIN
v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);
COMMIT;
/*This article helps in changing the password for Oracle USER using API FND_USER_PKG.CHANGEPASSWORD.
This API is tested in R12.1.3*/
DECLARE
v_user_name VARCHAR2 (100) := 'OPERATIONS';
v_new_password VARCHAR2 (100) := :NEWPASSWORD;
v_status BOOLEAN := NULL;
BEGIN
v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);
COMMIT;
Script to find Scheduled concurrent programs and request sets
By Jag - February 21, 2014
SELECT
A.REQUEST_ID,
B.USER_NAME,
C.USER_CONCURRENT_PROGRAM_NAME,
C.ARGUMENT_TEXT
FROM
FND_CONCURRENT_REQUESTS A,
FND_USER B,
FND_CONC_REQ_SUMMARY_V C
A.REQUEST_ID,
B.USER_NAME,
C.USER_CONCURRENT_PROGRAM_NAME,
C.ARGUMENT_TEXT
FROM
FND_CONCURRENT_REQUESTS A,
FND_USER B,
FND_CONC_REQ_SUMMARY_V C
Script to Approve PO Requisition
DECLARE
l_itemkey VARCHAR2 (200);
l_po_id NUMBER := :PO_HEADER_ID;
l_po_number VARCHAR2 (200) := :REQUISITION_NUMBER;
BEGIN
SELECT l_po_id || '-' || TO_CHAR (po_wf_itemkey_s.NEXTVAL)
INTO l_itemkey
FROM DUAL;
wf_engine.createprocess ('REQAPPRV',
l_itemkey,
'MAIN_REQAPPRV_PROCESS',
NULL,
:USER_NAME
);
1. How do I find the latest FSG patch that is available?
For the General Ledger Patch List, on MetaLink, click on Knowledge…From The Knowledge Browser tab, quick find Note:159239.1.
2. Is there a way to suppress zero amounts on the FSG Report?
You cannot suppress individual zero amounts in FSG. However, when all the values in a row or column are zero, you can have FSG suppress them all. To do this, make sure the Display Zero option is unchecked on the appropriate Rows or Columns window...
What is Set of Books ? What are the four conditions when you change your SOBs?
Chart of Accounts, Currency & Calendar
It is similar to the bank passbook, used to record all the financial transactions. There could be one primary set of books and many reporting set of books. Defining COA, currency and calendar are pre-requisite to define the SOB.
What is an Invoice? How many types of invoices ar...
There are 9 types of Invoices in AP: Standard, Credit Memo, Debit Memo, Prepayment, Withholding Tax, Mixed Invoice, Expense Report, PO default and Quick Match.
There are 6 types of Invoice in AR : Invoice, Credit Memo, Debit Memo, Chargeback, Deposit and Guarantee.
Chart of Accounts, Currency & Calendar
It is similar to the bank passbook, used to record all the financial transactions. There could be one primary set of books and many reporting set of books. Defining COA, currency and calendar are pre-requisite to define the SOB.
What is an Invoice? How many types of invoices ar...
There are 9 types of Invoices in AP: Standard, Credit Memo, Debit Memo, Prepayment, Withholding Tax, Mixed Invoice, Expense Report, PO default and Quick Match.
There are 6 types of Invoice in AR : Invoice, Credit Memo, Debit Memo, Chargeback, Deposit and Guarantee.
1.
|
What is the Diff between APPS Schema and other Schemas?
Apps schema contains only Synonyms we can't create tables in apps schema,where as other schemas contains tables, & all the objects. Here only we will create the tables and giving grants on created tables. Almost all every time we will conenct to apps schema only. |
2.
|
What is meant by Custom Top and what is the Purpose? Custom Top is nothing but Customer Top, which is created for customer only. we can have multiple custom tops based on client requirement. It is used to store developed & customized components. whenever oracle corp appling patches it will over ride on all the modules except custom top. that's why we will use custom top. |
Accounting For Oracle Receivables | Flow of Accounting Information
By Jag - February 19, 2014
Oracle Accounting for Receivables in R12
Flow of Accounting Information:
If you are using Oracle Order Entry (without customizations), no accounting information is available until you run AutoInvoice. You pass the transactions to Oracle Receivables using the Receivables Interface. You then run AutoInvoice which creates the actual transactions and uses AutoAccounting to derive the segment values for the GL Accounts. If you are using Oracle Projects the account segment values are derived by a Projects’ process also called AutoAccounting and passed as values to Oracle Receivables via the Streamline process, also using AutoInvoice.
1- GL_SETS_OF_BOOKS
2- GL_IMPORT_REFERENCES
3- GL_DAILY_RATES
4- GL_JE_LINES
5- GL_PERIODS
6- GL_JE_HEADERS
7- GL_JE_BATCHES
8- GL_BALANCES
9- GL_CODE_COMBINATIONS
GL_SETS_OF_BOOKS
Stores information about the sets of books you define in your Oracle General Ledger application. Each row includes the set of books name, description, functional currency, and other information. This table corresponds to the Set of Books form.
1. What is MRC and what is its use?
The Multi Reporting Currency Feature allows you to report and maintain records at the transaction level in more than one functional currency. You can do by defining one or more set of books in addition to primary set of books.
2. How is the balance of an invoice derived ?
It is the total invoice amount minus the amount received from the customer. Use application rule set to control how Receivable will reduce the balance due of open debit items when you apply payments.
3. Explain Accounting for invoice in Advance and Arrears.
Accointing for invoice in advance
a) Receivable A/c .....................Dr.
To Unearned revenue a/c
(when we raise the invoice with invoicing rule as advance)
b) Unearned Revenue A/c .............. Dr.
To Revenue A/c
(when we receive the payment, the number of journal entry (b) is depend upon the accounting rules which can be fixed or variable)
Accounting for invoice in arrear
a) Unbilled receivable a/c ....................Dr.
To Revenue a/c
(when we receive the payment of unbilled invoice, the number of journal entry (a) is depend upon the accounting rules which can be fixed or variable))
b) Receivable a/c .........................Dr.
To Unbilled receivable a/c
(when we raise the invoice, with invoicing rule arrear)
4. What is the use of Transaction Flexfield in Autoinvoice ?
Transaction Flexfield actually identifies the the uniqueness among the Multiple lines of a single Invoice
5. What are value sets?
Value sets are the defined as list of possible values for a specific purpose. These are assigned to flexfields. These are the only possible values to be choosen from. This eliminates the data entry errors.
Value set is a set of possible values.
There are 8 value set types:
1.Dependent
2.Independent
3.Table
4. None
5.Pair
6.Translatable Dependent
7.Translatable Independent
8. Special
6. Describe the main tables involved in AR, and what is the data stored in them?
RA_BATCHES_ALL -- Information about Transaction BATCHES RA_CUSTOMER_TRX_ALL -- Header information about Transaction
RA_CUSTOMER_TRX_LINES_ALL -- Lines information about Transaction
RA_CUST_TRX_LINE_GL_DIST_ALL - Distribution information about Transaction
RA_CUST_TRX_LINE_SALESREPS_ALL -- Sales representative of Transaction Information
AR_PAYMENT_SCHDULES_ALL - Information about Payment Schedules
AR_APPLICATION_PAYABLES_ALL
RA_INTERFACE_ERRORS - Errors in AutoInvoice Interface Data
RA_INTERFACE_LINES_ALL - Use this table to enter Header and Lines information in AutoInvoice Interface program
RA_INTERFACE_DISTRIBUTIONS_ALL - Distribution Table in AutoInvoice Interface program
RA_INTERFACE_SALESCREDITS_ALL - Sales Credits information in AutoInvoice Interface
7. What is the importance of Batch Source set up in AR ?
Batch sources control the standard transaction type assigned to a transaction and determine whether Receivables automatically numbers your transactions and transaction batches. You can define two types of transaction batch sources-Manual and Imported
8. What do you mean by HZ_ in customer tables?
These are the tables which come into picture after 11.5.9 because of the TCA. HZ stands for Human Zone(HZ_). Anytihing which is related to the human like Customer profiles, their accounts, locations, relationships are stored in these tables only. From release 11i TCA came into picture in Accounts Recievable module, where oracle has grouped all the customer information at one place. Most important tables in TCA are-
HZ_PARTIES,
HZ_CUST_ACCOUNTS_ALL,
HZ_CUST_ACCT_SITES_ALL,
HZ_CUST_SITE_USES_ALL,
HZ_LOCATIONS,
HZ_PARTY_SITES,
HZ_PARTY_SITE_USES,
HZ_CONTACT_POINTS. few to name.
9. What is the difference between _all, _tl, _vl, _v tables in Oracle Apps ? Also name various other table suffix.
_ALL : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
_TL are tables corresponding to another table with the same name minus the _TL. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column.
_B these are the BASE tables. They are very important and the data is stored in the table with all validations. It is supposed that these table will always contain the perfect format data. If anything happens to the BASE table data, then it is a data corruption issue.
_F these are date tracked tables, which occur in HR and Payroll. For these there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely. The date intervals cannot overlap. Many think they are Secured data. Guess someone from Oracle confirms.
_V tables are the views created on base tables _VL are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV(’LANG’).
_S are sequences, used for finding new values for the primary key of a table.
_A are Audit Shadow Tables
_AVN and _ACN are Audit Shadow Views (when data was changed, and with what values)
10. How many Flex fields are there in AR and what are they?
Required Key Flex fields:
1. Territory Flex field
2. Sales Tax Location flex field
Optional Key Flex fields:
1. Transaction flex field (requied only if Auto Invoicing is enabled)
2. System Items Flex field (If Inventory or OM is installed this should be defined there. other wise, it should be set up in AR).
11. What is FSG and what is its use?
FSG is a powerful and flexible tool you can use to build your own custom reports without programming. FSG is only available with GL. Using Financial Statment Generation (FSG), we can create different financial statement and we will get finacial reports. Oracle Apps std reports does not support for reports such as Income Stmt and Final A/c.So we need to go for FSG to prepare Reports Such as P&loss stmt and balance sheet.FSG is Powerful tool for Reporting.Reporting with FSG is Mix and Modify Reuse and Recylce Activity.
12. What is the difference between conversions and interfaces ?
Conversion is a process by which we transfer legacy data from temporary tables to base tables. Interfaces also does the same but is a daily process and most of the interfaces are automated by scheduling. Example:AutoInvoice. Conversition is on time process this is before instlation, and interface every time process we can run any time.
13. How many reporting currencies can be attached to Primary Set of Books?
We can have a total of 8 SOB's (including the Primary SOB). Therefore, we can have 7 Reporting SOB.
14. What are Different types of transactions in AR?
There are 7 type of transactions in AR-
Invoice,
Debitmemo,
Creditmemo,
Chargeback,
Deposits,
Guarenty, and
Bills Recivable.
15. What is the use of lockboxes?
AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. An AutoLockbox operation can process millions of transactions a month.
AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. You specify how you want this information transmitted and Receivables ensures that the data is valid before creating QuickCash receipt batches.
Steps for lock box are :
1. The first step involves reading and formatting data from your bank file into AutoLockbox tables.
2. The second step involves submitting the validation program which checks data in the AutoLockbox tables for compatibility with Receivables.
3. Once data is validated, it is transferred into QuickCash tables. At this point, you can optionally query your receipts in the QuickCash window and change how they will be applied before submitting the final step,
4. Post QuickCash. Submitting Post QuickCash updates your customer's balances.
16. What are the interface tables used for ar invoices, customers, receipts for conversion process?
Customer interface tables:
ra_customer_interface
ra_contant_phones_interface
ra_customer_banks_interface
ra_customer_profiles_interface
ra_cust_pay_method_interface
Invoice interface tables:
ra_interface_lines_all
ra_interface_sales_credits
ra_interface_distributions
Following are the Validation for Autoinvoice:
1- AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)
2- Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).
3- Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).
4- Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).
5- Primary Sales Representative Validation: Sales representative number to be hardcode to “-3” for “No Sales Credit.”
6- Term Name : Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)
7- Validate Sales Credit Type : Sales Credit to hardcode to “Quota Sales Credit”
8- Inventory Item Validation: Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).
9- Unit of Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table
10- Invoice Tax Code Validation : Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.
11- Invoice GL Date Validation : Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.
Following are the base tables
hz_parties
hz_cust_accounts
hz_cust_acct_sites_all
hz_cust_sit_use_all
hz_party_sites
hz_locations
hz_party_site_uses
hz_customer_profiles
hz_organization_profiles
hz_person_profiles
17. What is Auto Invoicing? Explain?
Auto Invoicing is a process of Importing Invoice related information from External / Internal Sources.External will be your business Legacy Systems like Main Frame / AS400 or Non Oracle ERP systems like SAP / JDE or From Custom Oracle Applications. The data is placed into Interface tables and from there either from Application or from PL/SQL , you can call Auto Invoice Concurrent request to validate and transfer data into AR Transaction tables. The data from these tables can be seen when queries from Transaction Screens.
Auto Invoicing is a process of creating an invoice automatically in AR when a sales order has been shipped and closed. This process is triggered by a concurrent request 'AUTO INVOICE MASTER PROGRAM'. Auto invoicing is used to import the AR invoices direclty into the AR module.
18. What is AUTO Accounting what are the steps for setting up auto accounting?
Auto Accounting is a mechnism for generating defualt accounting flexfields for revenue , receivables, frieght and tax based on the other parameters associated with the invoice you are entering.. since auto accounting looks at the following tables to get the data so please set/define the following depending upon your requirement.
1.Salesrep.
2.Transaction Types.
3.Standard Lines.
4.Taxes.
5.Customer bill-to-site
Receivables uses the Auto Accounting rules to determine the GL Accounts that you Enter manually or import using Auto invoice. Receivables creates the Default accounts for the Receivable, revenue, Freight, Tax, Unerned revenue, Finance charges, Unbilled receivables, Bills receivables, and Auto invoice Clearing Accoutns.You need to define these accoutns before you start entering the transactions in AR. However, you can overide these accounts during the Transaction Entry in AR.Setup Autoaccounting:AR>Setup>Transactions>AutoAccountingSelect the Type of the accoutn you wish to define the auto accoutning.In the Segments Block:Choose the segment for which you wish to assign the Auto accounting.Choose the Table Name : Sales Rep, Trxn Type, Site, Std Lines.If you wish to use a Default Constant value, then enter the value in the Constant Field.
19. what are the standard concurent programs for auto invoice interface and customer interfaces?
Autoinvoice Import Program -- for auto invoice program
Customer Interface Master Conc Program --> for Customer Interface
20. Explain the process of recievables in oracle financials?
AR Complete Cycle (hoping that GL is already implemented)Define Transaction SetupsDefine Receipt and Receipt Application SetupsDefine CustomerCreate an InvoiceCreate a ReceiptApply Receipt to InvoiceReview Customer balances (Collections). The BASIC process of Receivables involves the following:
1. Creation of Customer Invoices.
2. Making the receipts of the customer payments.
3. Remittance fo the same to the bank.
21. How do we segregate debit & credit transactions in Receivables and where we
will do it?
Basically the debit and credit transaction are classified by the transaction class.
22. whether we are defining customer in AR? If it is in AR then how are we placing the order and how the shipment will be done?
Customers and the associated information is stored in TCA structure, which is shared across All oracle application modules. If you add a customer in AR, it gets stored TCA underlying tables. When you want to create an Order in Order Management, the customer LOV displays data from Record Group that is created on TCA tables.
The basic Oracle ERP data model is the single Data model shared (integrated) by multiple application. The owner of the creation of customer is the AR schema and is shared by other application such as OM. These are usually called as shared entities (Supplier,Partners,Items etc)
23. How To Close Periods In AR?
After raising transactions and receiving the RECEIPT amount, transfer the all TRANSATIONS and RECEIPTS to the GENERAL LEDGER. And then only close the PERIOD in AR.
24. Explain about Party and Customer in AR?
Party could be a person or an organization which has no business relation with your entreprise, if you establish a sales relation with a department in a party then that particular department is your customer.
The Multi Reporting Currency Feature allows you to report and maintain records at the transaction level in more than one functional currency. You can do by defining one or more set of books in addition to primary set of books.
2. How is the balance of an invoice derived ?
It is the total invoice amount minus the amount received from the customer. Use application rule set to control how Receivable will reduce the balance due of open debit items when you apply payments.
3. Explain Accounting for invoice in Advance and Arrears.
Accointing for invoice in advance
a) Receivable A/c .....................Dr.
To Unearned revenue a/c
(when we raise the invoice with invoicing rule as advance)
b) Unearned Revenue A/c .............. Dr.
To Revenue A/c
(when we receive the payment, the number of journal entry (b) is depend upon the accounting rules which can be fixed or variable)
Accounting for invoice in arrear
a) Unbilled receivable a/c ....................Dr.
To Revenue a/c
(when we receive the payment of unbilled invoice, the number of journal entry (a) is depend upon the accounting rules which can be fixed or variable))
b) Receivable a/c .........................Dr.
To Unbilled receivable a/c
(when we raise the invoice, with invoicing rule arrear)
4. What is the use of Transaction Flexfield in Autoinvoice ?
Transaction Flexfield actually identifies the the uniqueness among the Multiple lines of a single Invoice
5. What are value sets?
Value sets are the defined as list of possible values for a specific purpose. These are assigned to flexfields. These are the only possible values to be choosen from. This eliminates the data entry errors.
Value set is a set of possible values.
There are 8 value set types:
1.Dependent
2.Independent
3.Table
4. None
5.Pair
6.Translatable Dependent
7.Translatable Independent
8. Special
6. Describe the main tables involved in AR, and what is the data stored in them?
RA_BATCHES_ALL -- Information about Transaction BATCHES RA_CUSTOMER_TRX_ALL -- Header information about Transaction
RA_CUSTOMER_TRX_LINES_ALL -- Lines information about Transaction
RA_CUST_TRX_LINE_GL_DIST_ALL - Distribution information about Transaction
RA_CUST_TRX_LINE_SALESREPS_ALL -- Sales representative of Transaction Information
AR_PAYMENT_SCHDULES_ALL - Information about Payment Schedules
AR_APPLICATION_PAYABLES_ALL
RA_INTERFACE_ERRORS - Errors in AutoInvoice Interface Data
RA_INTERFACE_LINES_ALL - Use this table to enter Header and Lines information in AutoInvoice Interface program
RA_INTERFACE_DISTRIBUTIONS_ALL - Distribution Table in AutoInvoice Interface program
RA_INTERFACE_SALESCREDITS_ALL - Sales Credits information in AutoInvoice Interface
7. What is the importance of Batch Source set up in AR ?
Batch sources control the standard transaction type assigned to a transaction and determine whether Receivables automatically numbers your transactions and transaction batches. You can define two types of transaction batch sources-Manual and Imported
8. What do you mean by HZ_ in customer tables?
These are the tables which come into picture after 11.5.9 because of the TCA. HZ stands for Human Zone(HZ_). Anytihing which is related to the human like Customer profiles, their accounts, locations, relationships are stored in these tables only. From release 11i TCA came into picture in Accounts Recievable module, where oracle has grouped all the customer information at one place. Most important tables in TCA are-
HZ_PARTIES,
HZ_CUST_ACCOUNTS_ALL,
HZ_CUST_ACCT_SITES_ALL,
HZ_CUST_SITE_USES_ALL,
HZ_LOCATIONS,
HZ_PARTY_SITES,
HZ_PARTY_SITE_USES,
HZ_CONTACT_POINTS. few to name.
9. What is the difference between _all, _tl, _vl, _v tables in Oracle Apps ? Also name various other table suffix.
_ALL : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
_TL are tables corresponding to another table with the same name minus the _TL. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column.
_B these are the BASE tables. They are very important and the data is stored in the table with all validations. It is supposed that these table will always contain the perfect format data. If anything happens to the BASE table data, then it is a data corruption issue.
_F these are date tracked tables, which occur in HR and Payroll. For these there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely. The date intervals cannot overlap. Many think they are Secured data. Guess someone from Oracle confirms.
_V tables are the views created on base tables _VL are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV(’LANG’).
_S are sequences, used for finding new values for the primary key of a table.
_A are Audit Shadow Tables
_AVN and _ACN are Audit Shadow Views (when data was changed, and with what values)
10. How many Flex fields are there in AR and what are they?
Required Key Flex fields:
1. Territory Flex field
2. Sales Tax Location flex field
Optional Key Flex fields:
1. Transaction flex field (requied only if Auto Invoicing is enabled)
2. System Items Flex field (If Inventory or OM is installed this should be defined there. other wise, it should be set up in AR).
11. What is FSG and what is its use?
FSG is a powerful and flexible tool you can use to build your own custom reports without programming. FSG is only available with GL. Using Financial Statment Generation (FSG), we can create different financial statement and we will get finacial reports. Oracle Apps std reports does not support for reports such as Income Stmt and Final A/c.So we need to go for FSG to prepare Reports Such as P&loss stmt and balance sheet.FSG is Powerful tool for Reporting.Reporting with FSG is Mix and Modify Reuse and Recylce Activity.
12. What is the difference between conversions and interfaces ?
Conversion is a process by which we transfer legacy data from temporary tables to base tables. Interfaces also does the same but is a daily process and most of the interfaces are automated by scheduling. Example:AutoInvoice. Conversition is on time process this is before instlation, and interface every time process we can run any time.
13. How many reporting currencies can be attached to Primary Set of Books?
We can have a total of 8 SOB's (including the Primary SOB). Therefore, we can have 7 Reporting SOB.
14. What are Different types of transactions in AR?
There are 7 type of transactions in AR-
Invoice,
Debitmemo,
Creditmemo,
Chargeback,
Deposits,
Guarenty, and
Bills Recivable.
15. What is the use of lockboxes?
AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. An AutoLockbox operation can process millions of transactions a month.
AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. You specify how you want this information transmitted and Receivables ensures that the data is valid before creating QuickCash receipt batches.
Steps for lock box are :
1. The first step involves reading and formatting data from your bank file into AutoLockbox tables.
2. The second step involves submitting the validation program which checks data in the AutoLockbox tables for compatibility with Receivables.
3. Once data is validated, it is transferred into QuickCash tables. At this point, you can optionally query your receipts in the QuickCash window and change how they will be applied before submitting the final step,
4. Post QuickCash. Submitting Post QuickCash updates your customer's balances.
16. What are the interface tables used for ar invoices, customers, receipts for conversion process?
Customer interface tables:
ra_customer_interface
ra_contant_phones_interface
ra_customer_banks_interface
ra_customer_profiles_interface
ra_cust_pay_method_interface
Invoice interface tables:
ra_interface_lines_all
ra_interface_sales_credits
ra_interface_distributions
Following are the Validation for Autoinvoice:
1- AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)
2- Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).
3- Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).
4- Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).
5- Primary Sales Representative Validation: Sales representative number to be hardcode to “-3” for “No Sales Credit.”
6- Term Name : Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)
7- Validate Sales Credit Type : Sales Credit to hardcode to “Quota Sales Credit”
8- Inventory Item Validation: Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).
9- Unit of Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table
10- Invoice Tax Code Validation : Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.
11- Invoice GL Date Validation : Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.
Following are the base tables
hz_parties
hz_cust_accounts
hz_cust_acct_sites_all
hz_cust_sit_use_all
hz_party_sites
hz_locations
hz_party_site_uses
hz_customer_profiles
hz_organization_profiles
hz_person_profiles
17. What is Auto Invoicing? Explain?
Auto Invoicing is a process of Importing Invoice related information from External / Internal Sources.External will be your business Legacy Systems like Main Frame / AS400 or Non Oracle ERP systems like SAP / JDE or From Custom Oracle Applications. The data is placed into Interface tables and from there either from Application or from PL/SQL , you can call Auto Invoice Concurrent request to validate and transfer data into AR Transaction tables. The data from these tables can be seen when queries from Transaction Screens.
Auto Invoicing is a process of creating an invoice automatically in AR when a sales order has been shipped and closed. This process is triggered by a concurrent request 'AUTO INVOICE MASTER PROGRAM'. Auto invoicing is used to import the AR invoices direclty into the AR module.
18. What is AUTO Accounting what are the steps for setting up auto accounting?
Auto Accounting is a mechnism for generating defualt accounting flexfields for revenue , receivables, frieght and tax based on the other parameters associated with the invoice you are entering.. since auto accounting looks at the following tables to get the data so please set/define the following depending upon your requirement.
1.Salesrep.
2.Transaction Types.
3.Standard Lines.
4.Taxes.
5.Customer bill-to-site
Receivables uses the Auto Accounting rules to determine the GL Accounts that you Enter manually or import using Auto invoice. Receivables creates the Default accounts for the Receivable, revenue, Freight, Tax, Unerned revenue, Finance charges, Unbilled receivables, Bills receivables, and Auto invoice Clearing Accoutns.You need to define these accoutns before you start entering the transactions in AR. However, you can overide these accounts during the Transaction Entry in AR.Setup Autoaccounting:AR>Setup>Transactions>AutoAccountingSelect the Type of the accoutn you wish to define the auto accoutning.In the Segments Block:Choose the segment for which you wish to assign the Auto accounting.Choose the Table Name : Sales Rep, Trxn Type, Site, Std Lines.If you wish to use a Default Constant value, then enter the value in the Constant Field.
19. what are the standard concurent programs for auto invoice interface and customer interfaces?
Autoinvoice Import Program -- for auto invoice program
Customer Interface Master Conc Program --> for Customer Interface
20. Explain the process of recievables in oracle financials?
AR Complete Cycle (hoping that GL is already implemented)Define Transaction SetupsDefine Receipt and Receipt Application SetupsDefine CustomerCreate an InvoiceCreate a ReceiptApply Receipt to InvoiceReview Customer balances (Collections). The BASIC process of Receivables involves the following:
1. Creation of Customer Invoices.
2. Making the receipts of the customer payments.
3. Remittance fo the same to the bank.
21. How do we segregate debit & credit transactions in Receivables and where we
will do it?
Basically the debit and credit transaction are classified by the transaction class.
22. whether we are defining customer in AR? If it is in AR then how are we placing the order and how the shipment will be done?
Customers and the associated information is stored in TCA structure, which is shared across All oracle application modules. If you add a customer in AR, it gets stored TCA underlying tables. When you want to create an Order in Order Management, the customer LOV displays data from Record Group that is created on TCA tables.
The basic Oracle ERP data model is the single Data model shared (integrated) by multiple application. The owner of the creation of customer is the AR schema and is shared by other application such as OM. These are usually called as shared entities (Supplier,Partners,Items etc)
23. How To Close Periods In AR?
After raising transactions and receiving the RECEIPT amount, transfer the all TRANSATIONS and RECEIPTS to the GENERAL LEDGER. And then only close the PERIOD in AR.
24. Explain about Party and Customer in AR?
Party could be a person or an organization which has no business relation with your entreprise, if you establish a sales relation with a department in a party then that particular department is your customer.