Seed Data Concurrent Program

Use of the Replicate Seed Data Concurrent Program

The use of the Replicate Seed Data Concurrent Program is to populate the Installed modules to be populated with the Seeded values, so that the module can be worked upon with.

Seed data replicaiton program works in two modes

Single organization - Pariticular Operating Unit.
All Organizations - This mode applies when the seed data replication program is executed without an
operating unit.

Make sure no user is logged in while running this program.

Whenever new organizatios are created, it should be provided with seeded data from all relevant modules
for normal integration among the modules and to get functionalities of the module being used.
Eg- If you are not going to use Oracle Purchasing module , the seeded vendors inforamtion is required other modules to choose.

AR Profile Options

AR: Allow Update of Existing Sales Credits
This profile option determines whether a user can update existing sales credits or if additional sales credit records need to be created to maintain an audit trail.

AR: Application GL Date Default
This profile option determines how Receivables determines the default GL Date when you apply receipts. Choose one of the following values:

Later of Receipt GL date and Invoice GL date:
Choose this value to use either the receipt GL date or the invoice GL date, whichever is later, as the default GL date for your receipt applications. This is the default value.

Later of Invoice GL date, and Current date:
Choose this value to use the receipt GL date, the invoice GL date, or the current date, whichever is later, as the default GL date for your receipt applications.This profile option can be set by the system administrator at the site, application, and responsibility levels but cannot be updated by the user.

AR: Automatic Contact Numbering
If you want to require users to provide a value for the Contact Number field, then enter No.If you enter Yes or leave this profile option blank, then Receivables automatically assigns a number to the field, and users cannot change it.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels.


AR: Bills Receivable Batch Source
This profile option determines the default bills receivable transaction batch source to use for bills receivable transactions. Enter a bills receivable batch source that you previously defined to default to the Bills Receivable window and the Bills Receivable Transaction Batches window.This profile option can be set only at the user level and can be updated by the user.

AR: Bills Receivable Batch Source
This profile option determines the default bills receivable transaction batch source to use for bills receivable transactions. Enter a bills receivable batch source that you previously defined to default to the Bills Receivable window and the Bills Receivable Transaction Batches window.This profile option can be set only at the user level and can be updated by the user.


AR: Change Customer on Transaction
This profile option determines whether you can update customer names in the Transaction windows. If this option is Yes, you can update the bill–to and ship–to names of customers on your transactions.Note: You cannot update the customer bill–to or ship–to information if the transaction is a chargeback, has activity against it, or has been posted, even if this profile option is set to Yes.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.


AR: Change Customer Name
This profile option allows you to change the party name in the customer standard form when set to Yes. When this option is set to no you cannot change the party name in the customer standard form once it is entered.

AR: Commit Between Validations in Lockbox
This profile option determines whether the AutoLockbox program will commit (save) after validating each record in a Lockbox transmission. If you set this profile option to No, AutoLockbox will only commit after validating all of the records in the transmission. This profile option can be set by the system administrator at the site, application, and responsibility levels.

AR: Create Bank Charges
This profile option determines whether users can create bank charges when entering receipts in Receivables. Other operations that this profile can affect include the following:

QuickCashPostBatch
The value for this option can be set by the system administrator at the site, application, and responsibility levels, but cannot be updated by the user.

AR: Credit Limit Selection
Use this profile option to enable cross currency credit check. By default, this profile option is set to Single. If this profile option is set to Single, your credit exposure will include only those transactions with currency that match the currency of the central credit limit. If this profile option is set to Multi, you can set up a central credit limit in one currency and calculate the exposure for all transactions.

AR: Customer Merge Commit Size
This profile option determines how many site uses are included in a merge set when you run the Customer Merge program from the Standard Request Submission windows. This profile option is not used when you submit the program from the Customers Merge window. A merge set contains one or more pairs of customer accounts to merge and is created based on these two rules, with the first rule taking precedence: Site uses for a customer account cannot be split between two merge sets.

AR: Customer Text Last Successful
This profile option stores the last successful run date of the customer text data creation and indexing process . You must run this customer text data creation and indexing process to acquire good search results in the Text tabbed region of the Find/Enter Customers window.

AR: Customers – Enter Alternate Fields
This profile option controls whether users can enter information in the Alternate Name field in the Customers and Customer Addresses windows. This field lets you enter a phonetic representation of a customer name. Alternate names are used primarily in Japan to enter and sort customer information using Kana characters.Receivables also uses this information when you choose Customer Name Sort as a parameter when printing certain Receivables reports (for example, the Customer Listing – Detail or Summary report). Refer to the AR: Sort Customer Reports by Alternate Fields profile option in this section.

AR: Debug Level for PostBatch
This profile option determines whether PostBatch is run in debug mode. If this option is set to Yes, enter one of the following values to indicate how extensive the debugging information saved to the log file will be:-Save only the most severe messages and errors (default setting).-Save messages that indicate entering and exiting various functions.–Save any useful and informative messages.-Save all other debug messages, including printing values of several important variables.


AR: Default Exchange Rate Type
This option determines the default exchange rate to use when converting foreign currency transactions to your functional currency. Valid values are:

Corporate Exchange Rate –
An exchange rate you define to standardize rates for your company. This rate is usually a standard market rate determined by senior financial management for use throughout the organization.

Spot Exchange Rate – An exchange rate you enter to perform a conversion based on the rate on a specific date.

User Specified Rate – An exchange rate you specify when entering a foreign currency transaction.

AR: Deposit Offset Account SourceThis option indicates which accounting source to use for a deposit’s offset account. Receivables can use either AutoAccounting or the deposit’s transaction type as the accounting source for the offset account.

AR: Disable Receivable Activity Balancing Segment SubstitutionThis profile option lets you disable balancing segment substitution for receivable activities. This profile option does not affect the gain, loss, and rounding accounts that you define at the system options level.The default value is No. If you set this profile option to Yes, then you must define a suspense account in the event that your activities and original transactions do not post to the same balancing segment value.This profile option affects these activities:

Activity Applications These options are receipt write–off activity, short term debt, and claims investigation. See: Oracle Receivables Doc Update RELEASE 11i - Using the Account Generator in Oracle Receivables.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels but
cannot be updated by the user.


AR: Enable Debug Message Output
Use this profile option to help resolve errors that can occur when generating iReceivables pages, such as web pages that appear with missing fields or data that displays incorrectly. This profile option activates a debugging program that inserts comments into your HTML source files to help your system administrator determine the cause of any errors. This profile option can be set only at the user level and can be updated by the user.

AR: Enable SQL TraceUse this profile option to activate SQL Trace, a program that creates a log file of each SQL procedure performed while executing Oracle Receivables functions. If this profile option is enabled and a SQL–related error occurs, Oracle Applications developers and your system administrator can use the log file the program creates to identify the cause. Accept the default setting of No for optimum performance during normal day–to–day processing. Enable this profile option before reproducing and researching SQL errors.


AR: Enable Debug Message Output
Use this profile option to help resolve errors that can occur when generating iReceivables pages, such as web pages that appear with missing fields or data that displays incorrectly. This profile option activates a debugging program that inserts comments into your HTML source files to help your system administrator determine the cause of any errors. This profile option can be set only at the user level and can be updated by the user.


AR: GL Transfer Balance Test
This profile option controls whether the General Ledger Interface program will reject debit and credit balances that are not equal before posting to the general ledger. Available values are:Yes: Receivables will reject unbalanced debits and credits before posting to the general ledger. These rejected unbalanced debits and credits will be listed in the Unposted Items Report which runs automatically during the posting program.No: Receivables will not reject unbalanced debits and credits before posting to general ledger.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels but cannot be updated by the user.

AR: Include Receipts at Risk in Customer Balance
This profile option controls whether Receivables displays items at risk and includes them when calculating customer account balances in the Account Details, Account Overview, and Customer Account windows.Set this option to No if you do not want to view items at risk in these windows or include them when calculating the balance due.

AR: Invoices with Unconfirmed Receipts
This profile option lets you choose whether to adjust or credit invoices selected for automatic receipt. You can adjust transactions that have been approved, but not confirmed. The options available are:Adjust:^(Further explanation forthcoming)Adjust and Credit:^(Further explanation forthcoming)Credit:^(Further explanation forthcoming)None:^(Further explanation forthcoming)The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.

AR: Item Flexfield Mode
This profile option lets you choose the format to use for entering flexfield information for Line Items for commitments in the Transactions and Item Tax Rate Exceptions windows. Available values are:Always Pop a Flexfield Window: The item flexfield always pops up as you navigate through the field.Concatenated Segment Entry: The item flexfield never pops up as you navigate through the field. Instead, you can type the item flexfield information directly into the field.No Window for a Single Segment Flexfield: The item flexfield will only pop if it has more than one segment enabled.The value you specify for this profile option at the user level takes precedence over the value that is set for this profile option by the system administrator at the site, application, responsibility, or user level.

AR: Mask Bank Account Numbers
Use this profile option to control the display of bank account numbers in Receivables windows. If you accept credit cards as payment for open debit items, Receivables displays the credit card number in the Bank Account field of the Customers, Transactions, and Receipts windows. You can limit access to this information by displaying only a portion of the number.No Masking: Do not mask any portion of the number.Mask – First Four Digits Visible: Show only the first four digits of the number. Display the remaining digits as asterisks(*).Mask – Last Four Digits Visible: Show only the last four digits of the number. Display the preceding digits as asterisks (*).The value you specify for this profile option at the user level takes precedence over the value that is set for this profile option by the system administrator at the site, application, responsibility, or user level.

AR: Maximum Lines per AutoInvoice Worker
This profile option lets you set a maximum number of lines per AutoInvoice worker.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user. This profile option has no default value.

AR: Oracle Exchange Database Link Name
This profile option lets you enter the name of the database link between Oracle Exchange and Receivables when they are on two separate database instances. Set this profile option in Receivables after you create the database link to Exchange. You must set this profile option if you want to integrate your Exchange billing data with Receivables.The value for this option can be set by the system administrator at the site level only, and cannot be updated by the user. This profile option has no default value. Please refer to the Oracle Exchange and Oracle Sourcing System Operator Implementation Guide, Release 6.2.2 and above, for complete information on the Oracle Exchange Billing integration with Receivables.

AR: Override Adjustment Activity Account Option
This profile option lets you choose whether you can override the default adjustment account when entering or updating manual adjustments and when updating automatic adjustments. These changes must be made before posting to the general ledger.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.

AR: Receipt Batch Source
This is the default receipt source for the Batch field in the Receipts and Receipt Batches windows. Only Receipt sources with a Receipt Source Type of ’Manual’ will be displayed in the list of values. The value that you specify for this profile option at the user level takes precedence over the value that is set for this profile option by the system administrator at the site, application, responsibility, or user level.

AR: Sort Customer Reports by Alternate Fields
This profile option controls whether Receivables will sort information using the value of the Alternate Name field in the Customers window when you run certain reports. To use this option, the AR: Customers Enter Alternate Fields profile option must also be set to Yes. Reports that can use this option include: the Customer Profiles Report, Receipt History Report, Applied Receipts Register, Unapplied Receipts Register, Automatic Receipts Awaiting Confirmation, Print Statements, Transaction Register, and the Customer Listing Detail and Summary reports.

AR: Transaction Batch Source
This profile option determines the default invoice source that will appear in the Batch field of the Transaction and Credit Memo windows. Receivables only displays batch sources with a Transaction Source Type of ’Manual’ in the list of values for this option.The value you specify for this profile option at the user level in this window takes precedence over the value set for this profile option by the system adminis
trator at the site, application, responsibility, or user level.

AR: Update Due Date
This profile option determines whether you can update the due date (payment schedule) of a transaction in the Installments and Account Details windows. Available values are:Yes: Receivables lets you update the due date of a debit item to any date that is greater than the transaction date of this item. If you change the due date of your debit item.

AR: Use Invoice Accounting For Credit Memos
This profile option determines whether to assign your credit memo to the same accounts that are assigned to the invoice you are crediting.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.