Oracle Apps R12 Techno - Functional: March 2012

Step 1 [Oracle Required/ERP Required]
Defining Set Of Books
Level: Enterprise (needs to be completed for each Set of Books)
Navigator: Setup > Financials > Books > Define
Purpose: Define a set of books and budgetary control options.
Step 2 [Oracle Required/ERP Optional]
Decide how to use Account Generator

Level: Enterprise
Change Responsibility to System Administrator
Navigator: Application > Flexfield > Key > Accounts
Purpose: To define AR system guidelines to control how AR works.
Step 3 [Oracle Optional/ERP Optional]

Define Transaction Flexfield Structure

Level: Operating Unit
Navigator: Application > Flexfield > Descriptive > Segments
Purpose: To record and customize the territory information (Categorizing customer information). Territory Flexfields are also displayed in the Transaction Detail & Customer Detail reports in AR. AR provides a default structure for this territory flexfield.

Step 4 [Oracle Optional/ERP Optional]

Define Descriptive Flexfields

Level: Enterprise
Navigator: Application > Flexfield > Descriptive > Segments
Purpose: To record and report item information. Must design and configure System Item Flexfield before defining items. All Oracle Applications products that reference Items share the System Item Flexfield and support multiple segment implementations. However, this flexfield supports only one structure.

Step 5 [Oracle Required/ERP Required]
Define Organization

Level: Enterprise
Change Responsibility to Receivables Manager
Navigator: Setup > Systems > Organizations > Organizations
Purpose: To define an organization and any related information. Receivables requires that one organization be defined for the application. Oracle provides one default organization entitled ‘Setup Business Group’. For the purposes of Oracle Accounts Receivable only the classification of Business Group must be enabled.
Step 6 [Oracle Required/ERP Required]
Define Sales Tax Location Flexfield structure

Level: Operating Unit
Navigator: Setup > Financials > Flexfields > Key > Segments
Purpose: To perform sales tax calculations and address validation. Also to enter & update locations & associate tax rates. Use this flexfield if customers are charged tax based on shipping address and also if customers’ addresses will be validated.
Step 7 [Oracle Optional/ERP Optional]

Define AutoCash Rule Sets

Level: Enterprise
Navigator: Setup > Receipts > AutoCash Rule Sets
Purpose: To define the AutoCash rule sets AR is to use for receipt applications. AutoCash rule sets determine the sequence of AutoCash Rules that AR uses when automatically applying receipts to open debit items.
Step 8 [Oracle Optional/ERP Optional]

Define Receivable Lookups

Level: Enterprise
Navigator: Setup > System > QuickCodes > Receivables
Purpose: To maintain AR QuickCodes. QuickCodes help speed data entry. Oracle provides some seeded values, but if additional values are needed follow the example below for CREDIT_RATING to create new ones.
Step 9 [Oracle Optional/ERP Optional]
Define Demand Class Lookups

Level: Enterprise
Navigator: Set Up > System > QuickCodes > Demand Class
Purpose: To segregate scheduled demand and supply into groups, so that you can track and consume the groups independently.
Step 10 [Oracle Optional/ERP Optional]

Define Auto Invoice Line Ordering Rules

Level: Operating Unit
Navigator: Set Up > Transactions > AutoInvoice > Line Ordering Rules
Purpose: To define and review ordering rules for invoice lines that are imported into AR using AutoInvoice. AutoInvoice uses these rules to order invoice lines when it groups the transactions that it creates into invoices, debit memos, and credit memos. This is not site specific if Auto Invoice does not exist.
Step 11 [Oracle Optional/ERP Optional]

Define AutoInvoice Grouping Rules

Level: Enterprise
Navigator: Setup > Transactions > AutoInvoice > Grouping Rules
Purpose: To define revenue and credit transactions grouping rules. This form can also be used to review and maintain grouping rules.
Step 12 [Oracle Optional/ERP Optional]

Define Application Rule Sets

Level: Enterprise
Navigator: Setup > System > Application Rule Sets
Purpose: Application rule sets specify the default payment steps for your receipt applications and how discounts affect the open balance for each type of associated charges.
Default is Line First Tax After
Step 13 [Oracle Required/ERP Required]
Define System Options

Level: Operating Unit
Navigator: Setup > System > System Options
Purpose: To define system guidelines to control how AR works. All the data contained in this form is one record in the database. If you need to delete the information in a field on the form use \ Navigate Field Delete. If you use \ Navigate Row Erase the entire record will be erased.
Step 14 [Oracle Optional/ERP Optional]

Set up Flexible Address Formats

Level: Operating Unit
Navigator: Setup > System > Countries
If the standard address format (Country, Address Line 1-4, City, State, Postal Code, Province and County) suits your business needs, you do not need to use the flexible address formats feature.

Alternatively, you can associate address styles with countries to enable you to enter addresses in country specific formats throughout Receivables. This lets you enter addresses in the style most appropriate to the country in which you or your customers conduct business. Receivables also offer the functionality to perform country specific validation upon entry of addresses.

To implement flexible address formats; you need to assign an address style to a country in the Maintain Countries and Territories window.
Step 15 [Oracle Optional/ERP Optional]

Maintain Countries and Territories

Level: Operating Unit

Switch responsibility to Receivables Manager

Navigator: Setup > System > Countries
Purpose: To maintain country and territory information. You can create your own address styles by creating a descriptive flexfield.
Step 16 [Oracle Required/ERP Required]
Define Payment Terms

Level: Operating Unit
Navigator: Setup > System > System Options
Purpose: To define system guidelines to control how AR works.
Step 17 [Oracle Optional/ERP Optional]

Assign Reporting Set of Books

Level: Operating Unit
Purpose: To maintain transactions and account balances in multiple currencies.
Step 18 [Oracle Optional/ERP Optional]

Define Accounting Rules

Level: Enterprise
Navigator: Setup > Transactions > Accounting Rules
Purpose: To define Accounting rules to create revenue recognition schedules for invoices. Accounting rules determine when revenue should be recognized. Some accounting and invoicing rules have seeded values, which will be automatically created in the conversion. The seeded values Advance Invoice and Arrears Invoice, are Invoicing Rules and Immediate is an Accounting Rule.
Step 19 [Oracle Required/ERP Required]
Open Accounting periods

Level: Operating Unit
Navigator: Control > Accounting > Open/Close Periods
Purpose: To open and close accounting periods in receivables calendar. AR references the statutes of these accounting periods to control transaction entry creation to GL. Open the appropriate accounting periods based on implementation date.
Step 20 [Oracle Required/ERP Required]
Define Auto Accounting

Level: Operating Unit (non GSL Operating Unit ONLY)
Navigator: Setup > Transactions > AutoAccounting
Purpose: Use this form before entering any transactions to specify how you want AR is to determine the GL accounts for the transactions. Be sure to verify that the accounts listed are still current and valid.
Step 21 [Oracle Optional/ERP Optional]

Set Up Cash Basis Accounting Methods

Level: Operating Unit
Step 22 [Oracle Required/ERP Required]
Define Transaction Types

Level: Operating Unit
Navigator: Setup > Transactions > Transaction Types
Purpose: To define debit memo, credit memo, on-account credit, chargeback, deposit, guarantee, and invoice transaction types. Oracle seeded values are credit memo, invoice, project accounting credit memo, and project accounting invoice. Enter a Transaction Type where Class is equal to Credit Memo before entering a transaction type where Class is equal to Invoice.
If you want to be able to apply debit memos against specific invoices (versus opening up a new receivable) you will need to set up a Transaction Type named Debit Memo but with a class of ‘Credit’. Set the ‘Creation Sign’ to ‘Positive’.
Step 23 [Oracle Required/ERP Required]

Define Invoice (Transaction) Sources

Level: Operating Unit
Navigator: Setup > Transactions > Sources
Purpose: To define debit memo, credit memo, deposit, guarantee, and invoice batch sources. Oracle seeded values are chargeback, debit memo reversal, manual-other, and project accounting invoice. If you create a transaction source with the type ‘imported’ certain setups that are not required for other transaction source types may be mandatory or recommended.
Step 24 [Oracle Required/ERP Required]
Define Collectors

Level: Enterprise
Navigator: Setup > Collections > Collectors
Purpose: To define receivables collectors. Displays active collectors and their descriptions as QuickPick choices in the Set Up Customer Profile Classes, Maintain Customer Profiles, and Record A Call forms. Oracle provides a seeded value of ‘Default’.
Step 25 [Oracle Required/ERP Required]

Define Approval Limits
Level: Operating Unit
Navigator: Setup > Transactions > Approval Limits
Purpose: To define adjustment approval limits for each user. Oracle provides a seeded value of ‘Default’.
Step 26 [Oracle Required/ERP Required]
Define Remittance Banks

Level: Operating Unit
Navigator: Setup > Receipts > Banks
Purpose: To enter bank branches, bank accounts, and payment documents for your set of books.
Step 27 [Oracle Optional/ERP Optional]

Define Distribution Sets

Level: Operating Unit

Navigator: Setup > Receipts > Distribution Sets

Purpose: To create receivables distribution sets for the receipts payments (refunds, revenue from sale of stock, interest income, and investment income)
Step 28 [Oracle Required/ERP Required]
Define Receivables Activities

Level: Operating Unit
Navigator: Setup > Receipts > Receivable Activities
Purpose: Oracle provides seeded values of Chargeback Adjustment, Chargeback Reversal, and Debit Memo Reversal.
Step 29 [Oracle Required/ERP Required]
Define Receipt Classes

Level: Enterprise
Navigator: Setup > Receipts > Receipt Classes
Purpose: To define the processing steps that will be required to decide whether receipt is prepared manually or automatically.
Step 30 [Oracle Required/ERP Required]
Define Receipt Methods

Level: Enterprise (For each new Operating Unit, this need to be completed)
Navigator: Setup > Receipts > Receipt Classes
Purpose: To define the processing steps that will be required for the payment methods.
Step 31 [Oracle Required/ERP Required]
Define Receipt Sources
Level: Operating Unit
Navigator: Setup > Receipts > Receipt Sources
Purpose: To define receipt sources. Assign Accounting Flexfield information by selecting a payment method to which receipt and discount activities have been assigned.
Step 32 [Oracle Optional/ERP Optional]

Define Aging Buckets

Level: Enterprise
Navigator: Set Up > Collections > Aging Buckets
Purpose: To define the aging buckets needed to meet the reporting needs. Use aging buckets to review receivables position by the time periods defined.
Step 33 [Oracle Optional/ERP Optional]

Define Statement Cycles

Level: Operating Unit
Navigator: Setup > Print > Statements Cycle
Purpose: To define customer statement cycles. Use statement cycles to determine when statements are sent to customers.
Step 34 [Oracle Optional/ERP Optional]

Define Standard Messages

Level: Operating Unit
Navigator: Setup > Print > Standard Messages
Purpose: To define standard messages that the system will print on the bottom of customers’ statements.
Step 35 [Oracle Optional/ERP Optional]

Maintain Dunning Letters

Level: Operating Unit
Navigator: Setup > Print > Dunning Letters
Purpose: To specify general criteria about dunning letters such as status and review date. Use dunning letters to inform customers of past due invoices, debit memos, and chargebacks.
Step 36 [Oracle Optional/ERP Optional]

Maintain Dunning Letters Sets

Level: Operating Unit
Navigator: Setup > Print > Dunning Letters Sets
Purpose: To group dunning letters into sets. Standard is the default but others can be added.
Step 37 [Oracle Optional/ERP Optional]

Define Territories

Level: Operating Unit
Navigator: Setup > Transactions > Territories
Purpose: To define customer territory combinations Territories can be assigned to customers, salespeople, invoices, and commitments.
Step 38 [Oracle Required/ERP Required]
Define Sales Persons
Level: Operating Unit
Navigator: Setup > Transactions> Salespersons
Purpose: To enter salespersons and assign sales credit to them when invoices are entered.
Step 39 [Oracle Required/ERP Required]
Define System Profile Options

Change responsibilities to System Administrator

Level: Enterprise
Navigator: Profile > System
Step 40 [Oracle Required/ERP Required]

Define Customer Profile Classes
Level: Enterprise
Change responsibilities to Receivables Manager
Navigator: Customers > Profile Classes
Purpose: To define standard profile classes. When a profile class is assigned to a customer, AR defaults in the information entered to the customer’s profile. Oracle provides
seeded value of ‘Default’.
Step 41 [Oracle Required/ERP Required]
Define Customers

Level: Operating Unit
Navigator: Customers > Standard
Purpose: To enter new customers, make changes to existing customer information, and inactivate customers.
Step 42 [Oracle Required/ERP Required]
Define Remit to Addresses

Level: Operating Unit
Navigator: Setup > Print > Remit-To Addresses
Purpose: To maintain customer’s remit-to-addresses. The remit-to address is where the customer sends payments. At least one default remit-to address must be defined before AutoInvoice is run.
Step 43 [Oracle Optional/ERP Optional]

Define Customer Relationships

Level: Operating Unit
Navigator: Customers > Standards
Purpose: Define relationships between customers to control payment and commitment application. You can create relationships between any customers and indicate that the relationship is either one–way or reciprocal. Customer Relationships are established per site business process.
Step 44 [Oracle Optional/ERP Optional]

Define Lockboxes

Level: Operating Unit
Navigator: Setup > Receipts > Lockboxes > LockBoxes
Purpose: To define lockboxes that will be used by Oracle Financials
Step 45 [Oracle Optional/ERP Optional]

Define Transmission Formats

Level: Enterprise
Navigator: Setup > Receipts > Lockboxes > Transmission Formats
Purpose: To define transmission formats used by Oracle Receivables Automatic Lockbox Transmission. Contact your bank for their transmission format.
Step 46 [Oracle Optional/ERP Optional]

Define Receipt Programs

Level: Enterprise/Operating Unit
Navigator: Setup > Receipts > Receipt Classes
Purpose: To create Automatic Receipts, define additional receipt or remittance format program.
Step 47 [Oracle Required/ERP Required]
Define Unit of Measure Classes

Level: Operating Unit
Navigator: Setup > System > Units of Measure > Classes
Purpose: To define and update unit of measure classes used during tracking, issuing, purchasing, and storing inventory items. If not using the inventory module, then you must set up one UOM class. If using the Inventory module, this will be defined in the Inventory setup process.
Step 48 [Oracle Required/ERP Required]

Define Unit of Measure
Level: Operating Unit
Navigator: Setup > System > Units of Measure > UOM

**This is automatically done when the classes are defined**

Purpose: To define and update units of measure for tracking, issuing, purchasing, receiving, and storing inventory items. If not using the inventory module, then you must set up one UOM. If using the Inventory module, this will be done in the Inventory setup process.
Step 49 [Oracle Optional/ERP Optional]

Define Standard Memo Lines

Level: Operating Unit
Navigator: Setup > Transactions > Memo Lines
Purpose: Define standard line items for debit memos, on-account credits, debit memo reversals, chargebacks and invoices.
Step 50 [Oracle Optional/ERP Optional]

Set Up Cross Currency Receipts

Level: Enterprise
This is a profile option setting.
Step 51 [Oracle Required/ERP Required]
Tax Locations and Rates

Level: Operating Unit
Navigator: Setup > Tax > Locations
Purpose: To enter and update your tax locations and their associated tax rates. Used in countries that are not using VAT or Sales Tax tax structure.
Step 52 [Oracle Required/ERP Required]

Define Tax Codes and Rates
Level: Operating Unit
Navigator: Setup > Tax > Codes
Purpose: Use this form to enter tax codes and rates.
Step 53 [Oracle Required/ERP Required]
Define Tax Exceptions

Level: Operating Unit
Navigator: Setup > Tax > Exemptions
Purpose: Use this form to fully or partially exempt a customer or item from a specific tax code.
Step 54 [Oracle Optional/ERP Optional]

Set Up Vendor Extension

Level: Operating Unit

Navigator:

Purpose: To integrate external tax calculations programs with Oracle Applications. These setups are handled within other steps listed (i.e. quick codes, system options, profile options, tax location structure, and tax codes).
Step 55 [Oracle Optional/ERP Optional]

Define Document Sequences

Level: Operating Unit
Navigator: Setup > Financials > Books
Purpose: Document sequence numbers are unique numbers, which can be assigned to transactions in AR. This allows you to account for every transaction entered in AR.
Must be completed by an associate with a System Administrator responsibility. To Implement Document Sequences, you must perform the following setup steps:

Enable the Sequential Profile Option (required-Sys Adm responsibility -Update System Profile Options form)) - Always Used, Partially Used, or Not Used
· Assign a Sequence to a category (required-Sys Adm responsibility )
· For a complete description of Sequential Numbering see Oracle Receivables Reference Manual and the Oracle Applications system Administration Reference Manual)
Step 56 [Oracle Optional/ERP Required]

Provision Reserve Maintenance
Level: Operating Unit
Navigator: Provisioning > Provisioning Maintenance
Step 57 [Oracle Required/ERP Required]
Provision Reserve Maintenance

Level: Operating Unit

Change Responsibility to AR FSSC

Navigator: Provisioning > Provisioning Maintenance
Entering the standard transaction types as provisioning invoice types will ensure the global accounting standards are adhered to and all setups are entered as each OU is created
--------------------------------------------------------------------------------------------------------------------------------------------

General Ledger

Step 1 [Oracle Required/ERP Required]

Define Value Sets

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Financials > Flexfields > Validation > Sets
Purpose: Define a value set. Value Sets are set up for each segment of the Accounting Flexfield.

Step 2 [ Oracle Required/ERP Required]

Define Key Flexfield Segments

Level: Enterprise

Change Responsibility to Application Developer

Navigator: Flexfields->Key->Segments

Purpose: Defines the key flexfield segments that make up the flexfield structure. This form uses the information about the Segments from Step 1, defines rules for each, and enables each segments.

Step 3 [Oracle Optional / ERP Optional]

Define Rollup Groups

Navigator: Setup> Financial > Flexfields >Key >Groups
Purpose: Define Rollup Groups to create summary accounts whose summary balances you can review. You assign parent segment values to rollup groups.

Step 4 [Oracle Required / ERP Required]

Define Accounting Flexfield Values

Level: Enterprise
Change responsibility to General Ledger Super User
Navigator: Setup > Financials > Flexfields > Key >Values
Purpose: This screen is used to enter values for each of the segments defined in Step 2.

Step 5 [Oracle Optional / ERP Optional]

Define Cross Validation Rule

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Rules
Purpose: Define key flexfield cross-validation rules, which check code combinations at journal entry and budget entry.

Step 6 [ Oracle Optional / ERP Required]

Define Key Flexfield Security Rule and Define Security Rule

Level: Enterprise (For each new Set of Books, this will need to be completed)
Navigator: Setup > Financials > Flexfields > Key > Security > Define
Purpose: Define security rules to restrict user access to certain account segment values. These rules also extend security to the standard Trial Balance and Account Analysis reports

Step 7 [Oracle Optional / ERP Optional]

Define Shorthand Aliases

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Aliases
Purpose: Define and maintain shorthand aliases for key flexfields.

Step 8 [Oracle Optional / ERP Optional]

Define Descriptive Flexfields

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Descriptive > Segments
Purpose: Define Descriptive Flexfields

Step 9 [Oracle Required / ERP Required]

Define Calendar Types

Level: Enterprise
Navigator: Setup > Financials > Calendar > Types
Purpose: Define accounting period types. Oracle provides the following seeded values: Month, Quarter, and Year.

Step 10 [Oracle Required / ERP Required]

Define Calendar

Level: Enterprise
Navigator: Setup > Financials > Calendars > Accounting
Purpose: Define the financial calendar

Step 11 [Oracle Required / ERP Required]

Define Currencies

Level: Enterprise (For each new Set of Books, this will need to be completed)
Navigator: Setup > Currencies > Define
Purpose: To enable currencies ISO currencies.

Step 12 [ Oracle Required / ERP Required]

Define Set Of Books

Level: Enterprise (needs to be completed for each Set of Books)
Navigator: Setup > Financials > Books > Define
Purpose: Define a set of books and budgetary control options.

Step 13 [Oracle Required / ERP Required]

Multi-Org Setups

Level: Enterprise (needs to be completed for each Set of Books)

Step 14 [Oracle Optional / ERP Required]

Assign Key Flexfield Security Rule and Assign Security Rule

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Security > Assign
(Alternatively click on Assign button from Step 5)
Purpose: Assign flexfield security rules to an application responsibility.

Step 15 [Oracle Required / ERP Required]

Define Accounting Flexfield Combinations

Level: Enterprise
Navigator: Setup > Accounts > Combinations
Purpose: Define new Accounting Flexfield combinations and to maintain existing Accounting Flexfield combinations.

Step 16 [Oracle Required / ERP Required]

Define Journal Entry Sources

Level: Enterprise
Navigator: Setup > Journal > Sources
Purpose: Define journal entry sources and specify for a given source the whether to import journal reference information from feeder systems.

Step 17 [Oracle Required / ERP Required]

Define Journal Entry Categories

Level: Enterprise
Navigator: Setup > Journal > Categories
Purpose: Define journal entry categories.

Step 18 [Oracle Optional / ERP Required]

Define Suspense Accounts (ONE defined for each SOB, other, other)

Level: Set of Books
Navigator: Setup > Accounts > Suspense
Purpose: Define additional suspense accounts based upon the source and category of journal entries.

Step 19 [Oracle Optional / ERP Required]

Define Intercompany Accounts

Level: Set of Books
Navigator: Setup > Accounts > Intercompany
Purpose: Define additional intercompany accounts.

Step 20 [Oracle Required / ERP Required]

Define Conversion Rate Types

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Currencies > Rates > Types
Purpose: Use conversion rate types to automatically assign a rate when you convert foreign currency journal amounts to functional currency equivalents – GL 21.

Step 21 [Oracle Required / ERP Required]

Define Daily Exchange Rates

Level: Set of Books

Change responsibility to General Ledger Super User

Navigator: Setup > Currencies > Rates > Daily
Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.

Step 22 [Oracle Required / ERP Required]

Define Period Exchange Rates

Level: Set of Books
Navigator: Setup > Currencies > Rates > Period
Purpose: To enter period conversion rates for foreign currencies for consolidation.

Step 23 [Oracle Required / ERP Required]

Define Historical Exchange Rates

Level: Enterprise
Navigator: Setup > Currencies > Rates > Historical
Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.

Step 24 [Oracle Required / ERP Required]

Translate Balances

Level: Set of Books
Navigator: Currency > Translation
Purpose: Translate the journal balance from FJD to NZD for consolidation.

Step 25 [Oracle Optional / ERP Optional]

Define Summary Accounts

Level: Enterprise

Navigator: Setup > Accounts > Summary

Purpose: Create and delete summary accounts.

Step 26 [Oracle Optional / ERP Optional]

Define Statistical Units of Measure

Level: Enterprise
Navigator: Setup > Accounts > Units
Purpose: Define statistical units of measures and assign them to account segment values. User Profile Option Journals: Mix Statistical and Monetary must be set to Yes.

Step 27 [Oracle Optional / ERP Optional]

Define Automatic Posting Options

Level: Set of Books
Navigator: Setup > Journal > Autopost
Purpose: Specify journal batches for automatic posting.

Step 28 [Oracle Required / ERP Required]

Define Concurrent Program Controls

Level: Enterprise
Navigator: Setup > System > Control
Purpose: Control the performance of the Journal Import and MassAllocation/MassBudgeting programs by varying the amount of memory usage This is completed after the Optimizer is run. This screen should be completed by a DBA

Step 29 [ Oracle Required/ ERP Required]

Generate Optimizer

Change responsibility to General Ledger ????

Level: Enterprise
Navigator: Reports > Request > Standard
Purpose: Runs the Oracle GL Optimizer. The Optimizer creates or drops indexes for those segments in the COA that have been marked for indexing. This helps journal entry posting and financial reporting processes run faster. It is recommended that the Optimizer is run at least once a period, or any time a large number of segment values are added, a new COA is defined, summary templates added or deleted.

Step 30 [Oracle Optional / ERP Optional]

Update Storage Parameters

Level: Enterprise
Navigator: Setup > System > Storage
Purpose: Maintain storage parameters for all interim tables and indexes in General Ledger.

Step 31 [Oracle Optional / ERP Optional]

Define Document Sequences

Level: Enterprise
Navigator: Setup > Financials > Sequences > Define
Purpose: Name a new document sequence and define how the sequence numbers each document. See GL Reference Manual for more detail information.

Step 32 [Oracle Optional / ERP Optional]

Assign Document Sequences

Level: Enterprise
Navigator: Setup > Financials > Sequences > Assign

Purpose: Define the documents a document sequence will number and then assign the document sequence to your definition.

Step 33 [Oracle Required/ ERP Required]

Update System Profile Options

Level: Enterprise

Change Responsibility to System Administrator

Navigator: Profile > System
Purpose: To choose which user profile options to include in a particular user profile at the site, application, responsibility, or user level.

Step 34 [Oracle Optional / ERP Optional]

Define Database Links

Level: Enterprise
Navigator: Setup >System > Database Links
Purpose: To define links to other General Ledger databases in order to copy FSG report objects from the linked database into your current database.

Step 35 [Oracle Optional / ERP Optional]

Define Consolidation Mapping

Level: Enterprise
Navigator: Consolidation > Define> Mapping
Purpose: Mapping Subsidiaries to your parent account

Step 36 [Oracle Optional / ERP Optional]

Define Consolidation Mapping Sets

Level: Enterprise
Navigator: Consolidation > Define> Mapping Set
Purpose: Mapping Subsidiaries to your parent account

Step 37 [Oracle Required / ERP Required]

Open/Close Periods

Level: SOBP
Navigator: Setup > Open/Close
Purpose: Change the status of the accounting periods in the set of books.

Step 38 [Oracle Optional / ERP Required]

Journal Reversal Criteria

Level: Set of Books
Navigator: Setup > Journal > AutoReverse

Account Payables

Step 1 [Oracle Required / ERP Required]

Check GL Prerequisites

Level: Enterprise &Operating Unit
Purpose: To define AP system guidelines to control how AP works.

Step 2 [Oracle Required / ERP Required]

Define Profiles

Level: Enterprise

Change responsibility to System Administrator

Navigator: Profile > System
Purpose: To set profile options.

Step 3 [Oracle Required / ERP Required]

Choose Set of Books

Level: Operating Unit

Change responsibility to Payables Manager

Navigator: Setup > Set of Books > Choose
Purpose: This is to ensure AP can use the accounting calendar for day to day transactions.

Step 4 [Oracle Required / ERP Required ]

Define Payment Terms

Level: Enterprise
Navigator: Setup > Invoice > Payment Terms
Purpose: Define payment terms to reflect the way your business is done

Step 5.1 [Oracle Required / ERP Required]

Define Payables Lookups – Pay Group

Level: Enterprise
Navigator: Setup > Lookups > Purchasing
Purpose: Create and maintain Lookups for PAY GROUP. Create additional lookups as business requires.

Step 5.2 [Oracle Required / ERP Required]

Define Payables Lookups – Vendor Types

Level: Enterprise
Navigator: Setup > Lookups > Purchasing
Purpose: Create and maintain Lookups for VENDOR TYPE – this step is already completed for standard Oracle Vendor Types.

Step 5.3 [Oracle Required / ERP Required]

Define Payables Lookups – Source

Level: Enterprise
Navigator: Setup > Lookups > Payables
Purpose: Create and maintain Lookups for SOURCE – this step is already completed for standard Oracle Source Types.

Step 5.4 [Oracle Required / ERP Required]

Define Payables Lookups – TAX TYPE

Level: Enterprise
Navigator: Setup > Lookups > Payables
Purpose: Create and maintain Lookups for TAX TYPE – this step is already completed for standard Oracle Tax Types.

Step 6 [Oracle Optional / ERP Mandatory ]

Define Tax Codes

Level: Operating Unit
Navigator: Setup > Tax > Codes
Purpose: To define the taxes used to record invoice taxes paid to vendors and to tax authorities

Step 7 [Oracle Required / ERP Required ]

Define Financial Options

Level: Operating Unit
Navigator: Setup > Options > Financials
Purpose: Define the options and defaults used throughout Oracle Applications such as Accounts Payable, Purchasing, and Assets. Defaults can be overridden at the time thevendors, employees and other information are entered.

Step 8 [Oracle Required / ERP Required]

Define Payables Options

Level: Operating Unit
Navigator: Setup > Options > Payables
Purpose: Set control options and defaults used throughout, the system of AP, which will simplify vendor entry, invoice entry, and initiating automatic payment processing.
Defaults can be overridden at the time that vendors, invoices, expense report, or payments are entered.

Step 9 [Oracle Optional / ERP Optional]

Define Withholding Tax Groups

Level: Operational
Navigator: Setup > Tax > Withholding > Groups
Purpose: To define a Withholding Tax Group to be used to assign one or more Withholding Tax type tax names to an invoice or distribution line. Must use this form if there is more than one Withholding Tax type tax name to a tax group, otherwise choose Yes in the Create Tax Group in the Withholding Tax Details region of the Define Tax Names form.

Step 10 [Oracle Optional / ERP Required]
Maintain Tax Certificates and Exceptions

Level: Operational
Navigator: Setup > Tax > Withholding > Certificates
Purpose: Define a Withholding Tax type tax name rate exception for a vendor site. Define a certificate to specify a rate exception for the Withholding Tax type tax name for all invoices of a vendor site.

Step 11 [Oracle Optional / ERP Required ]

Define Tolerances

Level: Operating Unit
Navigator: Setup > Invoice > Tolerances
Purpose: Define the matching and tax tolerances to be used to allow for variances between invoice, purchase order, receipt, and tax information. Tolerances determine whether or not the system places matching or tax holds on an invoice during the AutoApproval process.

Step 12 [Oracle Optional / ERP Required ]

Define Invoice Approvals

Level: Enterprise
Navigator: Setup > Invoice > Hold and Release Names
Purpose: Define the invoice approval codes that are used to hold or release invoice payments. Oracle has many seeded values. Use this form to add any additional approval codes that you will need to run your business.

Step 13 [Oracle Optional / ERP Optional ]

Maintain Distribution Sets

Level: Operating Unit
Navigator: Setup > Invoice > Distribution Sets
Purpose: Create and maintain Distribution Sets. Distribution Sets are used to facilitate invoice entry by reducing or eliminating manual entry of invoice distribution lines.

Step 14 [Oracle Required / ERP Required ]

Define Automatic Payment Programs

Level: Enterprise
Navigator: Setup > Payment > Programs
Purpose: Define and view payment programs that are used to create payment documents such as check, or electronic funds transfers (EFT).

Step 15 [Oracle Required / ERP Required]

Define Payment Formats

Level: Enterprise
Navigator: Setup > Payment > Formats
Purpose: Define the payment formats needed to create payment documents

Step 16 [Oracle Optional / ERP Required ]

Define Payment Interest Rates

Level: Enterprise
Navigator: Setup > Payment > Interest Rates
Purpose: Define the interest rate the system uses to calculate and pay interest on overdue invoices.

Step 17 [Oracle Optional / ERP Required]

Define Countries & Territories

Level: Enterprise
Navigator: Setup > Countries
Purpose: Define the interest rate the system uses to calculate and pay interest on overdue invoices.

Step 18 [Oracle Required/ERP Required ]

Set Up Bank Information

Level: Operating Unit WAVE 1 and 2 SITES ONLY!!
Navigator: Setup > Payment > Banks
Purpose: To enter bank branches, bank accounts, and payment documents for your set of books. If you are a Titan site, please refer to the COS/Titan/Financials AP Setup Document for details on mandatory bank setup for use with Titan. Any other additional banks can be defined here.

Step 19 [Oracle Optional / ERP Optional]

Define Expense Report Template

Level: Operating Unit
Navigator: Setup > Invoice > Expense Report Templates
Purpose: To define expense report templates.

Step 20 [Oracle Optional / ERP Optional ]

Run Template Update Script

Level: Operating Unit
Purpose: To set the includes tax flag on the custom expense report templates created using dataload.

Step 21 [Oracle Optional/ERP Required]

Define Locations

Level: Enterprise
Navigator: Employees > Locations
Purpose: Enter each physical site where employees work, and/or addresses for other organizations

Step 22 [Oracle Required / ERP Required ]

Enter Employees

Level: Operating Unit
Navigator: Employees > Enter Employees
Purpose: Enter, maintain, and view basic personal employee information and addresses. Can only use this form if Oracle HRMS is not fully installed.

Step 23 [Oracle Optional / ERP Optional ]

Define Reporting Entities

Level: Operating Unit
Navigator: Setup > Tax > ReportingEntities
Purpose: Define as many reporting entities as your business needs. A reporting entity is any person or organization that has a unique Tax Identification Number (TIN).

Step 24 [Oracle Optional / ERP Optional ]

Define Income Tax Regions

Level: Operating Unit
Navigator: Setup > Tax > Regions
Purpose: Define tax regions if using 1099 Combined Filing Program Reporting. This is only applicable to the US.

Step 26 [Oracle Required / ERP Required ]

Set Up Aging Periods

Level: Enterprise
Navigator: Setup > Calendar > Aging Periods
Purpose: Define the aging periods to use for the Invoice aging Report

Step 27 [Oracle Optional / ERP Optional ]

Define Special Calendars

Level: Enterprise
Navigator: Setup > Calendar > Special Calendar
Purpose: Define period types which the system uses for special functions such as Key Indicator Reporting, recurring payment, period definitions, or period-to-date reporting for withholding taxes. This is completely separate from the periods defined in the Accounting Calendar window for the AP Accounting periods.

Step 28 [Oracle Optional / ERP Optional ]

Define Report Sets

Level: Operating Unit – operational specific to user and country
Navigator: Other > Requests > Set
Purpose: Define and maintain private report sets. A report set consists of reports that you specify to run as a group, either one at a time in order (sequential), or at the same time in any order (parallel). You can view and update your private report sets. Private reports sets are report sets with a defined owner.

Step 29 [Oracle Required / ERP Required ]

Control Period Statuses

Level: Operating Unit – operational – initial set-ups must show the current period all future periods are controlled within country.
Navigator: Accounting > Control Payables Periods
Purpose: Change and review the status of the accounting periods in AP or your set of books.

Step 30 [Oracle Optional / ERP Optional ]

Implement Sequential Numbering

Level: Operating Unit

Change Responsibility to Sysadmin

Navigator:
Purpose: Assigns sequential numbers as voucher numbers to the invoices and payments created. A voucher number is a unique reference to an invoice or payment.
Must be completed by an associate with a System Administrator responsibility.

Step 31 [Oracle Optional / ERP Optional ]

Descriptive Flexfields

Level: Enterprise
Navigator: Setup > Flexfields > Descriptive > Segments

Step 32 [Oracle Required / ERP Required ]

Enter Suppliers

Level: Operating Unit

Change Responsibility to Payables Manager

Navigator: Suppliers > Entry
Purpose: Enter vendors, vendor sites, and vendor site contacts. Define multiple vendor sites for each vendor and multiple personal contacts for each vendor site.

Step 33 [Oracle Optional / ERP Required]

Assigning Benefits Defaults

Level: Enterprise
Navigator: Setup > Organizations
Purpose: To add a default value of NCR Payroll Default to the Setup Business Group organization

Step 34 [Oracle Optional / ERP Required] -- for countries with multiple taxes on a single expense receipt

Set-up P-Card for Procurement

Level: Inventory Org
Navigator: Suppliers > Entry
Purpose: To enable the use of Procurement Cards In order to use P-Cards for Internet Procurement, you must check the box for ‘Procurement Card’ by site under the General Tab.

Step 35 [Oracle Optional / ERP Required] -- for countries with multiple taxes on a single expense receipt

Define Recovery Rules

Level: Operating Unit
Navigator: Setup > Tax > Recovery Rules (MUST BE DONE PRIOR TO TAX CODES (STEP 6)
Purpose: Use a tax recovery rule if the recovery rate varies or there are multiple tax rates on a single receipt or invoice, depending on the following distribution attributes: Distribution account, Invoice date, or Condition (for example, supplier type)

Step 36 [Oracle Optional / ERP Required] -- for countries with multiple taxes on a single expense receipt

Define Tax Groups

Level: Operating Unit
Navigator: Setup > Tax > Groups
Purpose: Use the Tax Groups window to group multiple, conditional taxes. Tax groups let countries with multiple taxes automatically calculate each applicable tax within Payables, Receivables and Oracle Order Management.

Step 37 [Oracle Required / ERP Required ]

Define Reporting Rules (Regional Localizations)

Level: Operating Unit

Change Responsibility to Belgian AP Localizations

Navigator: VAT > Reporting Rules

Purpose: OU specific VAT reporting rules. Load the rules using the dataload sheet attached.

Step 38 [Oracle Required / ERP Required ]

Define VAT Registers (Regional Localizations)

Level: Operating Unit
Change Responsibility to Italian AP Localizations

Navigator: VAT Register
Purpose: OU specific VAT registers. Enter the 4 different VAT Registers.

Step 39 [Oracle Required / ERP Required]

Define Bank Charges

As Payables Manager responsibility

Level: Operating Unit
Navigator: Setup > Payment > Bank Charges
Purpose: OU specific bank charges. Enter the bank charge transfer rules as documented below

Oracle Apps R12 Techno - Functional

Wednesday 28 March 2012

FLEX FIELDS

Thursday 1 March 2012

Navigations- All Modules

Script to update salespersons customer site wise in oracle apps R12

Report Abuse