, , , ,

Account Generator processes

Applications need to construct Accounting Flexfield combinations automatically for various purposes. The Account Generator feature uses Oracle Workflow technology to provide applications with the ability to construct key flexfield combinations automatically using customized construction criteria. Each site can customize how they want to build key flexfield combinations.
Benefits of the Account Generator using Oracle Workflow
Automatic construction of key flexfield combinations speeds users’ data entry.
Automatic construction of key flexfield combinations improves accuracy of data entry because users do not need to determine what key flexfield combination to enter.
Each site can customize rules for the construction of key flexfield combinations to match the existing way of doing business.

Attention: The Account Generator replaces the Release 10 FlexBuilder feature. Information on upgrading from FlexBuilder is covered later in this chapter.

Use the Account Generator Processes window to assign Account Generator processes to Accounting Flexfield structures.
This window is under the navigation path Application > Flexfield > Accounts in the “System Administrator” responsibility.
To choose your Account Generator process:
1. Select the structure to which you want to assign a process. You can choose the application, flexfield title, structure, and description using View > Find…
2. Specify the Oracle Workflow Item Type containing the process.
3. Specify the process you want to use to generate the accounts.
The default process, as specified in the product-specific documentation, will default in. If you want to use a different process, enter the name of the process you wish to use. For example, if you want to use the process derived from FlexBuilder, specify “Generate Account Using FlexBuilder Rules” instead.
Application  : The application which uses the Accounting Flexfield structure. A list of values is available for this field.
Flexfield Title  : The title of the Accounting Flexfield. A list of values is available for this field.
Structure : The Accounting Flexfield structure for which the Account Generator will be creating combinations.
Item Type : The Oracle Workflow item type which contains the process which will generate the code combinations.
Process : The process within the above item type which will be used to create the code combinations. The default process, as specified in the product-specific documentation, will default in.

/by
, , , , ,

Accounting Flexfield (Chart of Account)

The code you use to identify a general ledger (GL) account in Oracle.
    * Accounting (Key) Flexfield segment one of up to 30 different sections of the accounting flexfield, which together make up a GL account code.
    * Accounting Flexfield structure – the combination of key flexfield segments defined to make up the account code combinations. If a segment(s) is added or removed or re-arranged, the result is a different structure.
The basic steps in defining a key Flexfields are as given below. You may or may not use all the steps. The detailed explanation is being followed after the steps.
1. Define & fix the structure of your COA/AFF or any other flex field.
we ‘ll design a flex field of the form
.new_COA_seg2.new_COA_seg3
2. Define the value sets for all the three segments
Navigation : GL > Set up > Financials > Flex field > Validation > Sets

 

Similarly definie value set for other two segments
3. Define the flex field
Navigation : GL > Set up > Financials > Flex field > key > Segment

Select the application as GL and title as account flexifield. click on OK

Enter the name of new flex field and save it. Click on segments to enter the segments of the FF
 
Enter the name of the new three segments  with the coumn name segmen1, 2 & 3. Assign the corresponding value set. Save it and click on Open to open one segment.

Verify the segment1 contents and modify if necessary. Click on qualifiers

Enter the qualifier as Cost center, Natural account or as required.  Repeat this step for all the segments and close the key flexfield segment window.

enable the fields allow dynamic inserts & cross-validate segments. Also enable the freeze flexfield definition and click on complie.

4. Filling value sets
Navigation : GL > Set up > Financials > Flex field > key > Values

/by
, , ,

Key Things in Oracle Accounts Payables

Oracle Accounts Payable’s is part of Oracle Financials, which is part of Oracle’s E-Business Suite.
Oracle Payables business process flow is setup, suppliers, invoices and payments, inquiry and reporting and period-end processing. The Oracles Payables business flow is setup, supplier entry, invoice entry, payments or disbursements generation, inquiry and reporting and period-end processing. Each organization must define its specific operating environment.
What are all the Modules Interacting with AP? 
Cash Management
Oracle iExpenses
General Ledger
Oracle Assets
Subledger Accounting (R12)
HRMS
Project Accounting
Purchasing/iprocurement
Global Accounting Engine (11i)
Define Payment Terms and their Types
Payment Terms are defined to automatically create payment schedule lines for an invoice.  The due date for every invoice    shall be determined by the Payment Term associated with it. Multiple scheduled lines and multiple levels of discount can be defined in payment terms. There is no limit to number of Payment Terms that can be defined for an organization.
While scheduling, the payment term determines the following with regard to an invoice:
a.    Number of installments in which the invoice needs to be settled
b.    Amount in each installment
c.    Due Date of each installment
d.    Discounts available for early payment of each installment.
Navigation: Setup> Invoice> Payment Terms
The due date of every installment is determined by TERMS DATE BASIS. The Terms Date can be any of Invoice Date, Invoice Received Date, Goods Received Date or Systems Date. In a case where the PO Payment term differs from the Invoice payment term, the payment term which has better ranking shall take precedence. Changing the Payment Terms in an invoice after the payment lines are scheduled changes the scheduled payment lines. 
What is terms date basis?
Terms Date Basis is to calculate due date.
Due date is calculated 4way. Eg: payment term is 30days
  • Due date = Sysdate + 30days
  • Due date = Invoice date + 30days
  • Due date = Goods Receive Date + 30days
  • Due date = Invoice Received date + 30days
How many types of Invoices we can create in Oracle Payables?
A. Standard
B. Debit Memo
C. Credit Memo
D. Pre-Payment
E. Expense Report
F. Withholding Tax Invoice
G. Miscellaneous Invoice
What are the types of Invoice Matching in AP
Invoice matching can be two-way (invoice to PO), three-way (invoice to PO to receipt) and four-way (invoice to PO to receipt to inspection of goods)
What is the difference between Debit and Credit Memo?
Debit Memo will raise the Customer.
Credit Memo will raise the Vendor.
How many Holds AP have?
System Holds: Tax, Quantity Match, Po amount with Invoice Amount
Manual Holds: Invoice Limit, Hold on Invoice

Can you Release Manual Holds? If Yes, How?
Yes. Holds – Release Holds

How many ways you can pay the Invoice Amount?
Apply in Full
Schedule Payments
Installments

How many key flexfields are there in Payables?
No key flexfields in PO,AP
What are the mandatory setups in AP?
1- Financial Options
2- Define Suppliers
3- Define Payment Terms
4- Define Payment Methods
5- Define Banks and Banks Accounts And Banks Accounts Documents
6- Open AP Accounts Periods
What is pay date basis?
The Pay Date Basis for a supplier determines the pay date for a supplier’s invoices.
• Due
• Discount
What are the Payment Methods available?
• Check – You can pay with a manual payment, a Quick payment, or in a payment batch.
• Clearing – Used for recording invoice payments to internal suppliers.
• Electronic – You generate an electronic payment file that you deliver to your bank to create payments. Use Electronic if the invoice will be paid using EFT or EDI.
• Wire – Used to manually record a wire transfer of funds between your bank and your supplier’s bank.
What is the difference between quick payment and manual payment?
Quick Payment: It allows you to make a single payment against one or more invoices at a time to one supplier through payables.
Manual Payment: This is the process of entering the check details which has been paid manually in some emergency requirements into the payment form and selecting the invoices of the concerned supplier and check whether the total of the invoices and the paid amount at the header are same and save.
What are Aging Periods?
Aging periods are nothing but the periods that we setup to control and maintain the supplier outstanding bill towards the invoice. From this we can able to study the due date of the supplier form the generation of invoice.
Steps to transfer the data from AP to GL
 R12
     a) Run Create Accounting with the parameter Transfer to GL as Yes.
     b) Run Create Accounting with the parameter Transfer to GL as No and run Tranfer Journal
        Entries to GL.
        1. Create Accounting
        2. Transfer to GL (includes Journal Import)
        3. Post to GL
     Parameters:
        a. Error Only : Yes (Only erred events will be picked up. Try to use No)
        b. Report : In Detail (if we make it detail then it will show with the detail output.)
 11i
     a) If AX is installed
         Submit AX Posting Manager.
         1. Translate Events
         2. Tranfer to GL
         3. Journal Import
         4. Post to GL.
     b) If AX is not installed
         1.Payables accounting process
         2.Payables transfer to general ledger
         3.Journal import
         4.Post journals
Oracle Technical AP Tables
What are the Interface Tables in AP?
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP_INTERFACE_CONTROLS
————————————–
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT
AP_SUPPLIER_INT_REJECTIONS
What is the API to cancel single AP Invoice?
AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE
What is the API to find invoice status?
AP_INVOICES_PKG.GET_APPROVAL_STATUS
/by