Saturday, August 4, 2012

Oracle Receivables Setup Steps


Oracle Receivables Setup Steps

This section provides a brief description of each Receivables setup step. Some of the operations listed are optional, but you should perform the required steps in
the order shown to be sure that your system is set up properly.
Step 1 Define Your Set of Books (Required)
You need to define at least one set of books before you can implement and use Receivables. A set of books includes an accounting calendar, a functional currency,
and an Accounting Flexfield structure.
If you previously defined your set of books in the Setting Up Oracle Applications Set of Books section while setting up a different Oracle Applications product,
proceed to the next step.
If you have not defined your set of books, see: Defining Sets of Books to complete the following steps:
Define your Accounting Flexfield
Define your Calendar Period Types
Define your Calendar Periods
Define your Currencies
Define your Accounting Flexfield Combinations (Optional)
Define your Set of Books
Assign your Set of Books to a Responsibility
Define your Daily Conversion Rate Types
Define your Daily Rates (Optional)
You specify which set of books your Receivables installation uses in the System Options window.
Additional Information: If you use the Oracle Applications Multiple Organization Support feature, you can use multiple sets of books for one Receivables
installation. See: Using the Multiple Organization Support Feature.
Step 2 Decide How to Use the Account Generator (Required)
The Account Generator ensures that Receivables substitutes the correct balancing segment values when you generate finance charges or post exchange rate gains
and losses to your general ledger. You need to review the default process that Receivables uses to see if it meets your accounting requirements. You can optionally
customize the Account Generator for each set of books that you have defined. See: Using the Account Generator in Oracle Receivables.
Step 3 Define Your System Items Flexfield Structure (Required)
Proceed to the next step if you previously defined your System Items Flexfield while setting up another Oracle Applications product.
If you have not installed Oracle Inventory or Oracle Order Entry and you want to record and report your item information, you need to define your System Items
Flexfield.
All Oracle products that reference items share the System Item Flexfield and support multiple segment implementation. The system provides a seeded System Item
Flexfield for you (Code = 'MSTK'). You must define a structure for this flexfield rather than creating a new flexfield.
Once you have defined your System Item Flexfield structure, you need to specify your Item Flexfield profile options.
Set the OE: Item Flexfield profile option at the site level to specify the System Item Flexfield structure you want to use. Set this to 'System Items,' which is the
System Item Flexfield structure you have just defined.
Next, set your AR: Item Flexfield Mode profile option to choose your preferred method of entry for this flexfield within Receivables. This default value is
concatenated segment entry. Refer to Step 37 for details on how to set up profile options.
Step 4 Define Your Organizations (Required)
Proceed to sub step 3, Specify your Item Validation Organization Profile Option, if you have previously defined your organizations while setting up another Oracle
Applications product.
1. Define Organization
You need to define at least one organization to use Receivables. This organization lets you use the inventory forms in Receivables if you do not have Oracle
Inventory installed.
2. Define Organization Parameters
You must define the control options and account defaults for your organization before you can define items or perform any transactions. You must assign a unique
short code to your organization and use this code to identify the organization with which you want to work.
3. Specify your Item Validation Organization
You need to set the OE: Item Validation Organization profile option to the organization of the Inventory Organization whose item master you want to use.
If you defined your organization in step 1, set the profile option to this organization. Otherwise, select an organization from the list of values. See: Organizations.
Refer to Step 37 for details on how to set up profile options.
4. Define Items
Once you have set up your Item Flexfield and chosen your Item Validation Organization, you can optionally define your items in the Items window. Proceed to the
next step if you have previously defined your items while setting up another Oracle Applications product. See: Items.
Step 5 Define Your Territory Flexfield (Optional)
You can use Territory Flexfields for reporting purposes. Receivables provides a default structure for your Territory Flexfield. You can associate Territory Flexfields
with salespeople, invoices, commitments, and customer business purposes. See: Territory Flexfield.
Proceed to the next step if you do not want to define Territory Flexfields.
Step 6 Define Sales Tax Location Flexfield Structure (Required, Default)
Receivables uses the customer shipping address to determine the sales tax rate on transactions for all customers in the country you define in the Systems Option
window as your home country. Proceed to the next step if you are not charging your customers tax based on their shipping address.
The seeded Sales Tax Location Flexfield structures are as follows:
Country
State and City
Province and City
City
Province
State, County and City
Proceed to sub-step four if you are planning to use one of the seeded structures, otherwise begin with sub step one.
Attention: If you use a Sales Tax Location Flexfield that contains a segment other than country and wish to set up a flexible address format for
your home country, every component in your Sales Tax Location Flexfield structure must also exist in your flexible address style for that country. See: Flexible
Addresses.
Sub-step one through sub-step three briefly describe how you can create a customized Sales Tax Location Flexfield structure if none of the seeded structures meet
your taxing requirements. For detailed information on customizing your Sales Tax Location Flexfield, see: Customizing Your Sales Tax Location Flexfield in the
Calculating Tax essay.
1. Define Value Sets
Receivables provides several value sets which are used with the seeded Sales Tax Location Flexfield structures. You will either use these for your customized
structure or create your own.
2. Define Key Flexfield Structure
Query 'Sales Tax Location Flexfield' in the Title field of the Key Flexfield region. Receivables provides a six seeded Sales Tax Location Flexfield structures. You
need to create a new customized structure if you do not wish to use any of the seeded structures. You should not simply modify a seeded structure.
3. Define Descriptive Flexfield Context
After defining your customized Sales Tax Location Flexfield structure, you need to define customized contexts for the following descriptive flexfields in the
Descriptive Flexfield Segments window:
Tax Rates Flexfield: This flexfield appears in the Review Sales Tax Rates window.
Item Exception Rate Assignment Flexfield: This flexfield pops up in the Tax Rate field of the Item Tax Rate Exceptions window.
Item Exception Rate Location Flexfield: This flexfield pops up in the Location field of the Item Tax Rate Exceptions window.
Exempt Regions Flexfield: This flexfield pops up in the Location field of the Tax Exemptions window.
Override Sales Tax Rates Flexfield: This field pops up in the Override field of the Tax Locations and Rates window.
4. Define Key Flexfield Segment Qualifiers
Verify that the Tax Account and Exemption qualifiers are set at the correct level for your needs. The Tax Account qualifier determines at which level of your
location flexfield you will assign tax accounts. The Exemption qualifier determines at which level the Receivables tax engine will create automatic exemptions.
5. Define Tax Locations and Rates
Enter and maintain locations for each segment of your Sales Tax Location Flexfield structure and assign tax rates to each location. Receivables uses Tax locations
to validate your customers' shipping address and to determine the proper tax amount. You can either use the sales Tax Rate Interface program to load locations
and tax rates or manually enter them in the Tax Locations and Rates window. See: Tax Locations and Rates.
See Also
Calculating Tax
Implementing Value Added Tax
Implementing US Sales Tax
Using Sales Tax Rate Interface
Step 7 Set Up Flexible Address Formats (Optional)
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 offers 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.
Receivables provides the following address styles:
Japanese
Northern European
Southern European
South American
United Kingdom/Asia/Australasia
You can also create your own address styles and validation rules by defining alternative descriptive flexfield structures.
Proceed to the next step if you are planning to use one of the seeded address styles. For detailed information on how to define your own address styles, see: Using
Flexible Addresses.
Step 8 Maintain Countries and Territories (Optional)
You can view all countries and territories within your system in the Maintain Countries and Territories window.
Use the address style field to assign address styles to countries if you wish to use the Flexible Address Formats feature.
You can identify which countries are part of the European Union (EU) by entering a VAT Member State Code against these countries. The Receivables European
Sales Listing report uses this information to produce a listing of all sales to customers in European Community member states other than your own.
Step 9 Define Your Transaction Flexfield Structure (Optional)
Proceed to the next step if you are not using AutoInvoice.
If you are using AutoInvoice, you need to define your Transaction Flexfields to uniquely identify imported transactions. Because Transaction Flexfields are unique,
you can also use them to link and reference other transaction lines.
If you are using AutoInvoice, the Line and Invoice Transaction Flexfields are mandatory. When you define your Invoice Transaction Flexfield, you must use the
same structure that you used for your Line Transaction Flexfield, but only include those segments that refer to header-level information.
The Link-to and Reference Transaction Flexfields refer to the structure you define for your Invoice Transaction Flexfield, but can be optionally defined if you want
to create a customized form that displays your Link-to and Reference Transaction Flexfield.
Define the structure, segments, and values for your Transaction Flexfield in the Descriptive Flexfield Segments window. Execute a query on the Title field. You can
define your Line Transaction Flexfield, Link-to Transaction Flexfield, Reference Transaction Flexfield and Invoice Transaction Flexfield here.
Suggestion: If you want to query your Transaction Flexfield, you may want to update the Transaction Flexfield information for previously entered transactions.
We advise that you create indexes on your Transaction Flexfield columns if you want to query Transaction Flexfield information in your invoice headers and lines.
Additionally, without indexes the validation portions of the AutoInvoice program can be slow. For complete information about defining Transaction Flexfield
indexes, see: Importing Invoice Information Using AutoInvoice.
Step 10 Define Your AutoCash Rule Sets (Optional)
If you are using AutoCash, you need to define your AutoCash rule set before defining your system parameters or customer profiles classes. AutoCash rules
determine the sequence of application methods Receivables uses when automatically applying receipts to open debit and credit items. See: AutoCash Rule Sets.
See Also
Post QuickCash
AutoCash Rules
Discounts
Step 11 Define Your QuickCodes (Optional)
Receivables provides several default QuickCodes. These are used throughout Receivables to provide validated default values and list of values choices. You can
add or update these to customize your list of values and speed data entry. For example, you can define additional freight carriers that are used by your business.
Below is a list of all user updatable QuickCodes types:
Account Status
Address Categories
Adjustment Reason
Approval Type
Business Purposes for a Customer Address
Canadian Provinces
Collector Actions
Collector Follow Up Action
Credit Memo Reason
Credit Rating for Customers
Customer Class
Customer Credit Risk
Customer Relationship Type
Customer Response Reason
Define Freight Carriers
Demand Class
FOB (free on board)
Invoice Reason
Job Titles for Customer Contact
Mandatory Field Prompt for Message Dictionary
Possible Outcomes of a Customer Call
Reverse Payment Reason
Special Instructions
Tax Exemption Reason
Tax Rate Exception Reason
Tax Types
Titles For Contact Persons at Customer Sites
Type of Data to Include in a Specific Bucket
Types of Communication Used in Contacting Customers
Types of Documentation to Send to Customers with this Relationship to Primary Customer
Types of Messages
Types of Standard text usage
See Also
Defining Receivables QuickCodes
Freight Carriers
Step 12 Define Your AutoInvoice Line Ordering Rules (Optional)
If you are using AutoInvoice, you need to specify how you want to order and number your transaction lines after they have been grouped into invoices, debit
memos, and credit memos. Receivables provides many attributes that you can use to define your line ordering rules. See: AutoInvoice Line Ordering
Rules and Importing Transactions Using AutoInvoice.
Step 13 Define Your AutoInvoice Grouping Rules (Optional)
If you are using AutoInvoice, you need to specify how you want to group transaction lines. In order for transaction lines to be part of one transaction, certain
attributes must be identical. Receivables provides many attributes that you can use to define your grouping rules. See: Grouping Rules and Importing Transactions
Using AutoInvoice.
Step 14 Define Your System Options (Required)
Define your accounting, discount, tax, and invoice system options to control how Receivables works. For example, you can determine whether to charge your
customers Sales Tax or Value Added Tax (VAT). If you choose Sales Tax, Receivables supports location based Sales Tax for your home country only. You also
define your default (i.e. home) country in the System Options window. See: Defining Receivables System Optionsand Calculating Tax.
You can also specify a default Application Rule Set in the System Options window. An Application Rule Set determines how Receivables reduces the balance due
for debit items and their associated charges when you apply payments in the Applications window or by using Post QuickCash. Receivables only uses this rule set
if none is assigned to the debit item's transaction type. See: Receivables Application Rule Sets.
You can update the Default Country in this window at install time, provided you have not entered any customer addresses.
Attention: If you will be using flexible address formats to enter and validate your customer address information, we recommend that you implement the seeded
Sales Tax Location Flexfield structure, Country - No Validation. Alternatively, if you use a Sales Tax Location Flexfield that contains a segment other than country
and wish to set up a flexible address format for your home Country, every component in your Sales Tax Location Flexfield structure must also exist in your flexible
address style for that country. See: Using Flexible Addresses.
Below is a list of optional system options. All other system options are required. No default values are provided.
AutoCash Rule Set
Tax Registration Number
Accounting Flex Tuning Segment
System Items Tuning Segment
Territory Tuning Segment
SQL Trace
Purge Interface Tables
Unallocated Revenue Account*
* Required if your Accounting Method is Cash Basis.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 15 Define Your Payment Terms (Required, Default)
You must specify the payment terms to associate with your invoices, debit memos and commitments to determine your customer's payment schedule. You can also
include tiered discounts for early payment. Receivables provides a predefined payment term, '30 NET'. See: Discounts and Payment Terms.
Step 16 Define Your Accounting Rules (Optional)
If you want to recognize revenue over multiple accounting periods, you must define accounting rules. Receivables lets you define as many accounting rules as you
want. If you use an accounting rule, you must associate it with an invoicing rule. Invoicing rules determine when to book your receivables. Receivables provides
two invoicing rules: 'Bill in Advance' and 'Bill in Arrears'.
When you use accounting rules, you also need to define the appropriate periods to which your rule refers. You enter these periods in the Calendar window and
they must refer to the same period type as your accounting rule. For example, if you are using an accounting rule that recognizes revenue monthly from Jan-93
through Jun-93, you must define periods from Jan-93 through Jun-93 where the period type is 'Month.' These periods must be defined in the same calendar as
your accounting periods.
Attention: If you have an accounting period type that is not 'Month' and you use AutoInvoice with Oracle Order Entry, you should update the Period field for the
predefined IMMEDIATE accounting rule to the same period as your accounting period type.
See: Accounting Rules and Defining Calendars.
Step 17 Open Your Accounting Periods (Required)
Maintain the accounting periods to control transaction entry, receipt application, and posting. Receivables provides the following period statuses: Not Opened,
Future, Open, Close Pending, and Closed. See: Opening and Closing Accounting Periods.
Step 18 Define Your AutoAccounting (Required)
Define all of your AutoAccounting account structures that Receivables uses. Receivables creates default revenue, receivables, freight, tax, suspense, unbilled
revenue, and unearned revenue accounts based on the information you enter for your AutoAccounting structures.
See: AutoAccounting and Using AutoAccounting.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 19 Set up Cash Basis Accounting (Optional)
If you are not using the Cash Basis accounting method, you can skip this step.
If you are using the Cash Basis method of accounting, you must perform various steps in addition to setting your Accounting Method system option to 'Cash Basis'.
For more information, see: Using Cash Basis Accounting.
One of the steps to set up Cash Basis Accounting requires that you define transaction types. Transaction types are discussed in more detail in the next step.
Step 20 Define Your Transaction Types (Required, Default)
Define the transaction types that you assign to your invoices, debit memos, commitments, chargebacks, credit memos, and on-account credits. Receivables uses
transaction types to default payment term, account, tax, freight, creation sign, posting, and receivables information. Receivables provides two predefined
transaction types: 'Invoice' and 'Credit Memo'. See: Transaction Types.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 21 Define Your Transaction Sources (Required, Default)
Define the transaction sources that you will assign to your invoices, debit memos, commitments, credit memos, and on-account credits. Receivables uses
transaction sources to control your transaction and transaction batch numbering, to specify your default transaction type, and to select validation options for
imported transactions. Before you can define a transaction source for your invoices, you must define transaction sources for your credit memos. Receivables
provides the following predefined transaction sources: 'MANUAL-OTHER', 'DM Reversal,' and 'Chargeback'. See: Transaction Batch Sources.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 22 Define Your Collectors (Required, Default)
Define collectors to assign to your customers through credit profile class assignments. You can use the customer account review windows and collection reports to
alert your collectors of their customer's past due items. Receivables provides a single collector called 'DEFAULT.' See: Collectors.
Step 23 Define Your Adjustment Approval Limits (Required)
Assign adjustment approval limits to each user to control adjustments made to invoices, debit memo, and chargebacks. Receivables lets you assign approval limits
by currency. These limits are used in the Adjustments, Approve Adjustments, and Receipts windows. See: Adjustment Approval Limits.
Step 24 Define Your Remittance Banks (Required)
Proceed to the next step if you have already defined your remittance banks in Oracle Payables.
Define all of the banks and bank accounts you use to remit your payments. You can define as many banks and bank accounts as you want, but each bank account
must refer to one currency. Receivables requires that you enter a cash account for each bank account. See: Defining Banks.
Step 25 Define Your Distribution Sets (Optional)
Define distribution sets if you have non-invoice related transactions and you want to use a predefined revenue distribution set. To speed data entry, revenue
distribution sets can also be assigned to receivables activities with a type of Miscellaneous Cash. See: Distribution Sets and Entering Miscellaneous Transactions.
Step 26 Define Your Receivables Activities (Required)
You must define receivables activities to link accounting information to your adjustments, finance charges, and miscellaneous cash transactions. See: Receivables
Activities.
Step 27 Define Your Receipt Classes (Required)
Define receipt classes to specify whether receipts are created manually or automatically. For manual receipts, you can specify whether to automatically remit it to
the bank and/or clear your accounts. For automatic receipts, you can specify a remittance and clearance method, and whether receipts using this class require
confirmation. See: Receipt Classes and Automatic Receipts.
Step 28 Define Your Payment Methods (Required)
Define the payment methods to assign to your receipt classes. When you define your payment methods, you must enter a receipt class, remittance bank
information, and the accounts associated with your payment receivables type. You can also specify accounts for confirmation, remittance, factoring, bank charges,
and short-term debt. See: Payment Methods.
Step 29 Define Your Receipt Sources (Required)
Define the receipt sources that you assign to receipts. When you define a receipt source, you can enter a default receipt class and payment method. See: Receipt
Sources.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 30 Define Your Aging Buckets (Optional)
You can define additional aging buckets to use when aging your receivables. Aging buckets are used by the Customer Aging window, statements, and the Credit
Snapshot and Aging reports. Aging buckets can include pending adjustments, items that are past due, not past due, current, due in the future, and in dispute.
See: Aging Buckets.
Step 31 Define Your Statement Cycles (Optional)
If you want to send your customers statements, define statement cycles and statement dates. The dates you associate with each statement cycle are the dates for
which you plan to generate statements for your customers. You can then assign statement cycles to your customers in the Customer Profile Classes window.
See: Statement Cycles, Using Statements and Assigning Profile Classes to Customers.
Step 32 Define Your Statement Messages (Optional)
To customize your statements with personal messages, define statement messages. These messages automatically print on the bottom of your statements. Use the
Print Statements window to assign statement messages and submit statements for printing. See: Standard Messages and Printing Statements.
Step 33 Define Your Dunning Letters (Optional)
To send your customers dunning letters to inform them of past due items and finance charges, define dunning letters. Receivables provides three predefined letters
named 'STANDARD1' through 'STANDARD3' and ten user definable letters named 'USER1' through 'USER10'. You can customize each dunning letter by
printing variables that are specific to each customer. These variables can be included in the text of the letter. Dunning letters must also be grouped into dunning
letter sets (see Step 34). See: Dunning Letters.
Step 34 Define Your Dunning Letter Sets (Optional)
If you want to send your customers dunning letters, you must define dunning letter sets. Dunning letter sets let you combine a sequence of dunning letters into one
group and increase the severity of each letter that you send. You can assign dunning letter sets to your customers in the Customer Profile Classes window.
Receivables provides one letter set named 'STANDARD,' which includes the three STANDARD letters described in the previous step. See: Creating Dunning
Letter Sets.
Step 35 Define Your Territories (Optional)
If you have defined your Territory Flexfield and want to create customized reports, you can define your Territory Flexfield combinations. Receivables lets you
assign Territory Flexfields to salespeople, invoices, and customer business purposes. See: Territories.
Step 36 Define Your Salespeople (Required, Default)
Define the salespeople you assign to your invoices, debit memos, and commitments to allocate sales credits. If you do not want to assign sales credits to a
transaction, you can enter 'No Sales Credit'. See: Salespersons.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 37 Define Your Profile Options (Required)
For each Receivables application, specify values for your personal profile options. Profile options determine default values for some Receivables operations, how
Receivables processes data control and control which actions a user can perform. Your system administrator determines which profile options you can choose.
You can use the Personal Profile Values window to set profile options only at the user level. System administrators use the System Profile Values window to set
profile options at the site, application, responsibility, and user levels. Receivables defaults all profile options at the site level.
See: Overview of Receivables User Profile Options.
For more information, please refer to Update Personal Profile Options in the Oracle Applications User's Guide and Update System Profile Options in the Oracle
Applications System Administration User's Guide.
Step 38 Define Your Tax Codes and Rates (Required)
If your Tax Method in the System Options window is set to 'VAT', you should enter the tax codes and tax rates you want Receivables to use when calculating tax
for your transactions. Tax codes can be assigned to customers, customer site uses, and standard memo lines. See: Tax Codes and Rates.
If your Tax Method in the System Options window is set to 'Sales Tax', you must define at least one tax code with a type of 'Location' in the Tax Codes and Rates
window. Receivables will use this tax code to calculate your location based tax. Enter a name for your location tax code, enter a type of 'Location,' and a tax
account. This account cannot be updated once you have committed your change. You can, however, enter additional 'Location' tax codes for different date ranges.
For either Tax Method, you may wish to set up an 'International', zero-rated tax code to assign to foreign addresses.
For complete information on setting up tax codes for VAT and Sales tax, see: Implementing Value Added Tax and Implementing U.S. Sales Tax. For information
about setting up tax codes for Canadian Sales Tax, see:Implementing Canadian Sales Tax.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 39 Define Your Customer Profile Classes (Required, Default)
You must define customer profile classes to categorize your customers based on credit, payment terms, statement cycles, automatic receipt, finance charge,
dunning, and invoicing information. When you initially set up your customers, you assign each customer to a profile class. To customize the profile class for a
specific customer, use the Customer Profile Classes window. Receivables provides the predefined customer profile class 'DEFAULT'. See: Defining Customer
Profile Classes.
Step 40 Define Your Customers (Required)
Proceed to the next step if you have already defined your customers while setting up another Oracle Applications product.
You must define your customers and customer site uses to enter transactions and receipts in Receivables. When you enter a new customer, you must enter the
customer's name, profile class and number (if automatic customer numbering is set to No). You can enter addresses, contacts, site uses and telephone numbers for
your customers. You will be required to enter all the components of your chosen Sales Tax Location Flexfield when entering customer addresses in your home
country. You define your Sales Tax Location Flexfield and home country in the System Options window. See: Entering Customers and Calculating Tax.
Step 41 Define Your Remit-To Addresses (Required)
Define remit-to addresses to inform your customers where to send their payments. Associate each remit-to address with one or more state, country and postal
code combinations. For example, if you want your customers in California and Nevada to send their payments to a specific address, enter the remit-to address and
associate the states CA and NV with this address. Remit-to addresses are assigned based on the bill-to address on the transaction.
If you do not wish to set up a remit-to address for each location, you can set up one remit-to address with a default assignment. This will be used for all locations
or for any locations that do not have specific location assignments.
To set up a default remit-to address, enter the remit-to address, navigate to the assignment region then, using the list of values in the Country field, select 'Default
Value'. Move to the next field and select the 'DEFAULT' state from the list of values. Then save your record. See: Remit-To Addresses.
Suggestion: It is a good idea to set up a default remit-to address, even if you have other remit-to addresses defined, because Receivables can use this address if
the bill-to location on the transaction is not covered by any other remit-to address assignment. This may happen, for example, when you use new customers.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 42 Define Your Customer Relationships (Optional)
If you want to restrict receipt application to related customers only, define relationships between your customers and set the system option 'Allow Payment of
Unrelated Invoices' to No. When you create relationships, customers can also apply invoices to related customer commitments. Receivables lets you define one
way and reciprocal relationships between your customers. See: Creating Customer Relationships.
Step 43 Define Your Customer Banks (Optional)
If you want to create automatic receipts, you need to define your customer banks and bank accounts. With automatic receipts, Receivables transfers funds directly
from your customer's bank to your remittance bank on the receipt maturity date. See: Defining Banks and Automatic Receipts.
Step 44 Define Your Lockboxes (Optional)
To use the AutoLockbox program to automatically record receipts from your banks, define your lockboxes. For each lockbox, enter the lockbox number, bank
name, batch source, bank account, bank origination number and cash account. See: Lockboxes.
Step 45 Define Your Transmission Format (Optional)
To use the AutoLockbox program, define your transmission file format. A transmission format is required to successfully import receipt information from your bank
into Receivables. Receivables provides two standard transmission formats that you can modify: Default and Convert. See: Transmission Formats and Using
AutoLockbox.
Step 46 Define Your Receipt Programs (Optional)
To use the Automatic Receipts feature, define the receipt programs you will use to send paper and electronic documents to your customers and remittance
banks. See: Automatic Receipt Programs and Automatic Receipts.
Step 47 Define Your Unit of Measure Classes (Optional)
Proceed to the next step if you have already defined your units of measure classes while setting up another Oracle Applications product.
Use the Units of Measure Classes window to define and update groups of units of measure with similar characteristics (for example, Volume or Length). A class
consists of a base unit of measure and other assigned units of measure. Use this window to define the base unit of measure for each class. See: Unit of Measure
Classes.
Step 48 Define Your Units of Measure (Required, Default)
Proceed to the next step if you have already defined your units of measure while setting up another Oracle Applications product.
Use the Units of Measure window to define one or more units of measure. Each item that you define in Receivables must have a primary unit of measure that you
will have defined in this window. The number of units of measure that you define in this window depends on the variety of physical characteristics of your
organization's inventory. See: Units of Measure.
Step 49 Define Your Standard Memo Lines (Optional)
To enter predefined lines for debit memos, on-account credits and invoices, define standard memo lines. When you define your standard memo lines, you can
specify whether a line is for charges, freight, line, or tax. Receivables also lets you define one chargeback and one debit memo reversal line. See: Standard Memo
Lines.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 50 Define Your Item Tax Rate Exceptions (Optional)
To assign special tax rates to items shipped to specific addresses, define your item exceptions for specific Location Flexfields. In order for Receivables to use these
exception rates, you should not assign tax codes to your customers or their site uses. See: Tax Rate Exceptions and Calculating Tax.
Step 51 Define Your Tax Exemptions (Optional)
To partially or fully exempt your customers or items from specific tax rates, define customer and item tax exemptions. See: Tax Rate Exceptions and Calculating
Tax.
Attention: If you use the Oracle Applications Multiple Organization Support feature, you need to perform this step for each of your operating units. For more
information about multiple organizations, refer to the Multiple Organizations in Oracle Applications manual.
Step 52 Define Document Sequences (Optional)
By assigning unique numbers to documents, you can account for each transaction you enter and the document that accompanies it.
To enable sequential numbering, set the Sequential Numbering profile option to either 'Always' or 'Partially Used'. You must then define and assign categories and
sequences for each transaction type, payment method, adjustment, and finance charge activity that you use. See: Implementing Document Sequences.

Oracle iExpense Implementation Steps


Oracle iExpense Implementation Steps


1) Set the tax Codes to be Uses in iExpenese
Payables - > Setup- > Tax - > Codes
2) Set the Hierarchy for Tax Code Defaulting
Payables - > Setup- > Options - > Payables
Here template mean expense template .
http://docs.google.com/File?id=df82pvfb_74fbtrrcg5_b
3) For Project based expenses set the Expenditure type to be used in iExpense
Project ->Setup - >Expenditures - > Expenditure Type
To use a expenditure type it has to be assigned to Expenditure type class of "Expense Reports"
Share Report Abuse Next Blog»
http://docs.google.com/File?id=df82pvfb_75gbmrczgr_b
4 ) Payables Manager: Setup > Options > Financials
Expense Clearing Account ->This will be a default liability account for iExpenses expenses reports imported into Oracle Payables
http://docs.google.com/File?id=df82pvfb_76db5ch5ch_b
5) Payables Manager: Setup > Options > Payables
http://docs.google.com/File?id=df82pvfb_77g84qm3c4_b
Internet Expenses users can specify a reimbursement currency that is different from your company functional currency only if Oracle Payables is set up for multiple
currencies
6) Payables - > Setup - > lookup - > Purchasing
http://docs.google.com/File?id=df82pvfb_34fmgbbmfk_b
7) Setup the signing limits
Paybles - > Employees- > Signing Limits
Expense Report goes to the Person defined here based on the cost center and the signing limit for approval
http://docs.google.com/File?id=df82pvfb_78hfxd4vgn_b
8 ) Setup Employee as suppliers
http://docs.google.com/File?id=df82pvfb_80xgbk5ndz_b
9 )Create Expense Templates
Paybles - > Setup - >Invoice - > Expense Report Templates
http://docs.google.com/File?id=df82pvfb_37fqg5g4dk_b
Define Expense Items and assign then to Expense categories and for project based expense assign them against the project expenditure type . You can define
policy and assign the policy schedule here and , dictate if justification is always mandatory or only with the policy violations . Default GL Accounts to ease the
data entry for the users .
10)
Paybles - > Setup - > Options -> Payables
http://docs.google.com/File?id=df82pvfb_79df5nx4ds_b
Set the Default Expense Template to be Used here , and mention if the prepayment can be applied against expense report by checking the apply advances
check box .
11 ) To Show project and task on iExpense , do the changes in AK Developer and enable the node display .
http://docs.google.com/File?id=df82pvfb_39fb2dmxxd_b
12) Log on to Internet Expenses Setup and Administration
A - > Create Policy Schedules for your Expense Categories .
B - > Setup the expense field you want to enable or disable .
C -> Setup the Accounting flexfield to enabled , to let users update the default segment value .
13 )
A) -> Make sure all expense approving managers are set up as Oracle users.
B) -> Make sure every employee is assigned to one Oracle user only!
C) -> Submit the Synchronize WF LOCAL tables process regularly to update the Workflow resource information
14 ) Technically some of the customization which can be done of iExpenses are
A) OA Framework Customization on the Page
B) Customize Project Expense Report Account Generator (PAAPWEBX)
C) Customize expense approval workflow by default it follow employee supervisor hierachy
15) Some of the important Profiles in iExpenses are given below , use them as per your requirement
OIE:Allow Credit Lines Yes
OIE:Allow Non-Base Pay No
OIE:Approver Required Yes, with Default
OIE:CC Approver Req No
OIE:CC Payment Notify Yes
OIE:Carry Advances Forward Yes
OIE:Enable Advances Payables
OIE:Enable Approver Yes
OIE:Enable Bar Code
OIE:Enable Cost Center Read-only
OIE:Enable Credit Card No
OIE:Enable DescFlex Lines Only
OIE:Enable Expense Allocation Splitting Yes
OIE:Enable Expense Allocations Automatically-enabled, with Online Validation
OIE:Enable Policy
OIE:Enable Project Allocations Yes
OIE:Enable Project Expenditure Organization Yes
OIE:Enable Tax Yes
OIE:Grace Period 30
OIE:Purpose Required No
OIE:Report Number Prefix XXX-EXP:
16) Once the expense report is approved it can be imported into payables by running the expense report import program which will load as a Payable invoice of
type "Expense Report"

Org ID Setting in Oracle R12 From Backend


Org ID Setting in Oracle R12 From Backend

BEGIN
dbms_application_info.set_client_info(101);
END;
• In this example 101 is the ORG_ID for the Operating Unit or you could have used FND_GLOBAL.APPS_INITIALIZE to set your context.
In R12 you can set your SQL session context for a single OU with the following:
BEGIN
execute mo_global.set_policy_context('S',101);
END;
• The ‘S’ means Single Org Context
• 101 is the ORG_ID you want set
Also In R12 you can set your SQL session context for multiple OU’s with the following:
BEGIN
execute mo_global.set_org_access(NULL,111,‘ONT’);
END;

Single Query For P To P Cycle


Single Query For P To P Cycle

SELECT a.org_id "ORG ID",
e.vendor_name "VENDOR NAME",
UPPER (e.vendor_type_lookup_code) "VENDOR TYPE",
f.vendor_site_code "VENDOR SITE",
f.address_line1 "ADDRESS",
f.city "CITY",
f.country "COUNTRY",
TO_CHAR (TRUNC (d.creation_date)) "PO DATE",
d.segment1 "PO NUMBER",
d.type_lookup_code "PO TYPE",
c.quantity_ordered "QTY ORDERED",
c.quantity_cancelled "QTY CANCALLED",
g.item_description "ITEM DESCRIPTION",
g.unit_price "UNIT PRICE",
(NVL (c.quantity_ordered, 0) - NVL (c.quantity_cancelled, 0)
) *
NVL (g.unit_price, 0) "PO Line Amount",
(SELECT DECODE (ph.approved_flag, 'Y', 'Approved')
FROM po.po_headers_all ph
WHERE ph.po_header_id = d.po_header_id) "PO STATUS",
a.invoice_type_lookup_code "INVOICE TYPE",
a.invoice_amount "INVOICE AMOUNT",
TO_CHAR (TRUNC (a.invoice_date)) "INVOICE DATE",
a.invoice_num "INVOICE NUMBER",
(SELECT DECODE (x.match_status_flag, 'A', 'Approved')
FROM ap.ap_invoice_distributions_all x
WHERE x.invoice_distribution_id = b.invoice_distribution_id)
"Invoice Approved?",
a.amount_paid,
h.amount,
i.check_number "CHEQUE NUMBER",
TO_CHAR (TRUNC (i.check_date)) "PAYMENT DATE"
FROM ap.ap_invoices_all a,
ap.ap_invoice_distributions_all b,
po.po_distributions_all c,
po.po_headers_all d,
po.po_vendors e,
po.po_vendor_sites_all f,
po.po_lines_all g,
ap.ap_invoice_payments_all h,
ap.ap_checks_all i
WHERE a.invoice_id = b.invoice_id
AND b.po_distribution_id = c.po_distribution_id(+)
AND c.po_header_id = d.po_header_id(+)
AND e.vendor_id(+) = d.vendor_id
AND f.vendor_site_id(+) = d.vendor_site_id
AND d.po_header_id = g.po_header_id
AND c.po_line_id = g.po_line_id
AND a.invoice_id = h.invoice_id
AND h.check_id = i.check_id
AND f.vendor_site_id = i.vendor_site_id
AND c.po_header_id IS NOT NULL
AND a.payment_status_flag = 'Y'
AND d.type_lookup_code != 'BLANKET';

Oracle Order Managment 11i and R12 Tables


Oracle Order Managment 11i and R12 Tables
ORDER MANAGEMENT
Un Changed = 148
New Tables = 2
Deleted = 0


  11iTABLES R12TABLES
1 OE_ACTION_PRE_REQS OE_ACTION_PRE_REQS
2 OE_ACTIONS_IFACE_ALL OE_ACTIONS_IFACE_ALL
3 OE_ADJ_ATTRIB_EBS_LOG OE_ADJ_ATTRIB_EBS_LOG
4 OE_AK_GEN_OBJECTS_CFG OE_AK_GEN_OBJECTS_CFG
5 OE_AK_OBJ_ATTR_EXT OE_AK_OBJ_ATTR_EXT
6 OE_AK_OBJ_WF_ITEMS OE_AK_OBJ_WF_ITEMS
7 OE_AK_OBJECTS_EXT OE_AK_OBJECTS_EXT
8 OE_APPROVER_LIST_MEMBERS OE_APPROVER_LIST_MEMBERS
9 OE_APPROVER_LISTS OE_APPROVER_LISTS
10 OE_APPROVER_TRANSACTIONS OE_APPROVER_TRANSACTIONS
11 OE_ATTACHMENT_OBJECT_REFS OE_ATTACHMENT_OBJECT_REFS
12 OE_ATTACHMENT_OBJECT_REFS_TL OE_ATTACHMENT_OBJECT_REFS_TL
13 OE_ATTACHMENT_RULE_ELEMENTS OE_ATTACHMENT_RULE_ELEMENTS
14 OE_ATTACHMENT_RULES OE_ATTACHMENT_RULES
15 OE_AUDIT_ATTR_HISTORY OE_AUDIT_ATTR_HISTORY
16 OE_BLANKET_HEADERS_ALL OE_BLANKET_HEADERS_ALL
17 OE_BLANKET_HEADERS_EXT OE_BLANKET_HEADERS_EXT
18 OE_BLANKET_HEADERS_HIST OE_BLANKET_HEADERS_HIST
19 OE_BLANKET_LINES_ALL OE_BLANKET_LINES_ALL
20 OE_BLANKET_LINES_EXT OE_BLANKET_LINES_EXT
21 OE_BLANKET_LINES_HIST OE_BLANKET_LINES_HIST
22 OE_BLANKET_ORG_ASSIGN OE_BLANKET_ORG_ASSIGN
23 OE_CC_PROCESSOR_TEMP OE_CC_PROCESSOR_TEMP
24 OE_CONC_REQUEST_IFACE OE_CONC_REQUEST_IFACE
25 OE_COPY_LINE_SORT_TMP OE_COPY_LINE_SORT_TMP
26 OE_CREDIT_BALANCES_ALL OE_CREDIT_BALANCES_ALL
27 OE_CREDIT_CHECK_RULES OE_CREDIT_CHECK_RULES
28 OE_CREDIT_EXPOSURE_TEMP OE_CREDIT_EXPOSURE_TEMP
29 OE_CREDIT_HIERARCHY_TEMP OE_CREDIT_HIERARCHY_TEMP
30 OE_CREDIT_SUMMARIES OE_CREDIT_SUMMARIES
31 OE_CREDITS_IFACE_ALL OE_CREDITS_IFACE_ALL
32 OE_CUST_ITEM_SETTINGS OE_CUST_ITEM_SETTINGS
33 OE_CUST_TOTAL_AMTS_ALL OE_CUST_TOTAL_AMTS_ALL
34 OE_CUSTOM_ACTIONS OE_CUSTOM_ACTIONS
35 OE_CUSTOMER_INFO_IFACE_ALL OE_CUSTOMER_INFO_IFACE_ALL
36 OE_DEF_ATTR_CONDNS OE_DEF_ATTR_CONDNS
37 OE_DEF_ATTR_DEF_RULES OE_DEF_ATTR_DEF_RULES
38 OE_DEF_CONDITIONS OE_DEF_CONDITIONS
39 OE_DEF_CONDITIONS_TL OE_DEF_CONDITIONS_TL
40 OE_DEF_CONDN_ELEMS OE_DEF_CONDN_ELEMS
41 OE_DEFAULT_ACTIONS OE_DEFAULT_ACTIONS
42 OE_DOC_SEQUENCE_AUDIT OE_DOC_SEQUENCE_AUDIT
43 OE_DROP_SHIP_SOURCES OE_DROP_SHIP_SOURCES
44 OE_EM_INFORMATION_ALL OE_EM_INFORMATION_ALL
45 OE_EVENT_ATTRIBUTES OE_EVENT_ATTRIBUTES
46 OE_EXP_INTERFACE_ERRORS OE_EXP_INTERFACE_ERRORS
47 OE_EXPOSURE_INTERFACE OE_EXPOSURE_INTERFACE
48 OE_FOLDER_EXTENSIONS OE_FOLDER_EXTENSIONS
49 OE_HEADER_ACKS OE_HEADER_ACKS
50 OE_HEADERS_EBS_LOG OE_HEADERS_EBS_LOG
51 OE_HEADERS_IFACE_ALL OE_HEADERS_IFACE_ALL
52 OE_HOLD_AUTHORIZATIONS OE_HOLD_AUTHORIZATIONS
53 OE_HOLD_DEFINITIONS OE_HOLD_DEFINITIONS
54 OE_HOLD_RELEASES OE_HOLD_RELEASES
55 OE_HOLD_SOURCES_ALL OE_HOLD_SOURCES_ALL
56 OE_INVOICE_NUMBERS OE_INVOICE_NUMBERS
57 OE_ITEM_CUST_VOLS_ALL OE_ITEM_CUST_VOLS_ALL
58 OE_LINE_ACKS OE_LINE_ACKS
59 OE_LINE_SETS OE_LINE_SETS
60 OE_LINES_EBS_LOG OE_LINES_EBS_LOG
61 OE_LINES_IFACE_ALL OE_LINES_IFACE_ALL
62 OE_LOT_SERIAL_NUMBERS OE_LOT_SERIAL_NUMBERS
63 OE_LOTSERIAL_ACKS OE_LOTSERIAL_ACKS
64 OE_LOTSERIALS_IFACE_ALL OE_LOTSERIALS_IFACE_ALL
65 OE_NOTES_OBJECT_REFS OE_NOTES_OBJECT_REFS
66 OE_NOTES_OBJECT_REFS_TL OE_NOTES_OBJECT_REFS_TL
67 OE_NOTES_RULE_ELEMENTS OE_NOTES_RULE_ELEMENTS
68 OE_NOTES_RULES OE_NOTES_RULES
69 OE_ORDER_HEADER_HISTORY OE_ORDER_HEADER_HISTORY
70 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_ALL
71 OE_ORDER_HEADERS_ALL_EFC OE_ORDER_HEADERS_ALL_EFC
72 OE_ORDER_HOLDS_ALL OE_ORDER_HOLDS_ALL
73 OE_ORDER_LINES_ALL OE_ORDER_LINES_ALL
74 OE_ORDER_LINES_HISTORY OE_ORDER_LINES_HISTORY
75 OE_ORDER_NUMBER_SOURCES OE_ORDER_NUMBER_SOURCES
76 OE_ORDER_PRICE_ATTRIBS OE_ORDER_PRICE_ATTRIBS
77 OE_ORDER_SOURCES OE_ORDER_SOURCES
78 OE_PAYMENT_TYPES_ALL OE_PAYMENT_TYPES_ALL
79 OE_PAYMENT_TYPES_TL OE_PAYMENT_TYPES_TL
80 OE_PAYMENTS OE_PAYMENTS
81 OE_PAYMENTS_HISTORY OE_PAYMENTS_HISTORY
82 OE_PAYMENTS_IFACE_ALL OE_PAYMENTS_IFACE_ALL
83 OE_PC_ASSIGNMENTS OE_PC_ASSIGNMENTS
84 OE_PC_CONDITIONS OE_PC_CONDITIONS
85 OE_PC_CONDITIONS_TL OE_PC_CONDITIONS_TL
86 OE_PC_CONSTRAINTS OE_PC_CONSTRAINTS
87 OE_PC_EXCLUSIONS OE_PC_EXCLUSIONS
88 OE_PC_RSET_SEL_COLS OE_PC_RSET_SEL_COLS
89 OE_PC_RSETS OE_PC_RSETS
90 OE_PC_RSETS_TL OE_PC_RSETS_TL
91 OE_PC_VALIDATION_PKGS OE_PC_VALIDATION_PKGS
92 OE_PC_VTMPLT_COLS OE_PC_VTMPLT_COLS
93 OE_PC_VTMPLTS OE_PC_VTMPLTS
94 OE_PC_VTMPLTS_TL OE_PC_VTMPLTS_TL
95 OE_PRICE_ADJ_ASSOCS OE_PRICE_ADJ_ASSOCS
96 OE_PRICE_ADJ_ATTRIBS OE_PRICE_ADJ_ATTRIBS
97 OE_PRICE_ADJ_EBS_LOG OE_PRICE_ADJ_EBS_LOG
98 OE_PRICE_ADJS_HISTORY OE_PRICE_ADJS_HISTORY
99 OE_PRICE_ADJS_IFACE_ALL OE_PRICE_ADJS_IFACE_ALL
100 OE_PRICE_ADJUSTMENTS OE_PRICE_ADJUSTMENTS
101 OE_PRICE_ATTRIB_EBS_LOG OE_PRICE_ATTRIB_EBS_LOG
102 OE_PRICE_ATTS_IFACE_ALL OE_PRICE_ATTS_IFACE_ALL
103 OE_PROCESSING_MSGS OE_PROCESSING_MSGS
104 OE_PROCESSING_MSGS_TL OE_PROCESSING_MSGS_TL
105 OE_PURGE_ORDERS OE_PURGE_ORDERS
106 OE_PURGE_SETS OE_PURGE_SETS
107 OE_REASONS OE_REASONS
108 OE_RESERVATION_SETS OE_RESERVATION_SETS
109 OE_RESERVTNS_IFACE_ALL OE_RESERVTNS_IFACE_ALL
110 OE_RETROBILL_REQUESTS OE_RETROBILL_REQUESTS
111 OE_RSV_SET_DETAILS OE_RSV_SET_DETAILS
112 OE_SALES_CREDIT_HISTORY OE_SALES_CREDIT_HISTORY
113 OE_SALES_CREDIT_TYPES OE_SALES_CREDIT_TYPES
114 OE_SALES_CREDITS OE_SALES_CREDITS
115 OE_SELECTED_ITEMS OE_SELECTED_ITEMS
116 OE_SETS OE_SETS
117 OE_SYS_PARAMETER_DEF_B OE_SYS_PARAMETER_DEF_B
118 OE_SYS_PARAMETER_DEF_TL OE_SYS_PARAMETER_DEF_TL
119 OE_SYS_PARAMETERS_ALL OE_SYS_PARAMETERS_ALL
120 OE_SYSTEM_PARAMETERS_ALL OE_SYSTEM_PARAMETERS_ALL
121 OE_SYSTEM_PARAMS_UPG OE_SYSTEM_PARAMS_UPG
122 OE_TRANSACTION_TYPES_ALL OE_TRANSACTION_TYPES_ALL
123 OE_TRANSACTION_TYPES_TL OE_TRANSACTION_TYPES_TL
124 OE_UI_QUERIES_TL OE_UI_QUERIES_TL
125 OE_UI_QUERY_COLUMNS OE_UI_QUERY_COLUMNS
126 OE_UPGRADE_DISTRIBUTION OE_UPGRADE_DISTRIBUTION
127 OE_UPGRADE_ERRORS OE_UPGRADE_ERRORS
128 OE_UPGRADE_LOG OE_UPGRADE_LOG
129 OE_UPGRADE_PC_ATTR_MAP OE_UPGRADE_PC_ATTR_MAP
130 OE_UPGRADE_PC_CONDNS OE_UPGRADE_PC_CONDNS
131 OE_UPGRADE_PC_SCOPE OE_UPGRADE_PC_SCOPE
132 OE_UPGRADE_PC_TEMP OE_UPGRADE_PC_TEMP
133 OE_UPGRADE_WF_ACT_MAP OE_UPGRADE_WF_ACT_MAP
134 OE_UPGRADE_WF_HIST_TEMP OE_UPGRADE_WF_HIST_TEMP
135 OE_UPGRADE_WF_OBS_CODES OE_UPGRADE_WF_OBS_CODES
136 OE_UPGRADE_WF_VLD_CYC OE_UPGRADE_WF_VLD_CYC
137 OE_UPGRADE_WSH_IFACE OE_UPGRADE_WSH_IFACE
138 OE_WORKFLOW_ASSIGNMENTS OE_WORKFLOW_ASSIGNMENTS
139 OM_ID_LIST_TMP OM_ID_LIST_TMP
140 OM_SETUP_VALID_ENTITIES OM_SETUP_VALID_ENTITIES
141 OM_SETUP_VALID_ERRM OM_SETUP_VALID_ERRM
142 OM_SETUP_VALID_PROF_OPT OM_SETUP_VALID_PROF_OPT
143 OM_SETUP_VALID_REP OM_SETUP_VALID_REP
144 ONT_DBI_CHANGE_LOG ONT_DBI_CHANGE_LOG
145 ONT_PRICE_ADJ_TEMP_ONT ONT_PRICE_ADJ_TEMP_ONT
146 ONT_PRT_MARGIN_ANA_ERR ONT_PRT_MARGIN_ANA_ERR
147 ONT_PRT_MARGIN_ANALYSIS ONT_PRT_MARGIN_ANALYSIS
148 ONT_WF_SKIP_LOG ONT_WF_SKIP_LOG
149   OE_CC_TEMP
150   OE_SCH_ID_LIST_TMP