In this Document
APPLIES TO:
Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
Form:FNDPOMPV.FMB - Update System Profile Values
GOAL
Oracle Receivables (AR): AutoInvoice Information Center > AutoInvoice Setup for Release 12: A Case Study Using a Simple Script > Note 1069294.1
Identify and describe the profile options that impact the behavior of AutoInvoice. This setup is illustrated for use with the case study in Note 1067402.1, Setting Up AutoInvoice for Release 12: A Case Study using a Simple Script.
SOLUTION
1. Security Profile
There are three profile options which govern access to data partitioned by organizations.
MO: Operating Unit
R11i profile option that will be maintained for those products and customers not leveraging Multiple Organizations.
MO: Security Profile
The MO Security Profile controls the list of operating units that a responsibility can access. So you would assign the Security Profile that you just created to this profile option. The lowest level you can set the profile option for is the responsibility level.
MO: Default Operating Unit
This allows you to specify an operating unit that will be the default when you open different subledger application pages. Because users can access multiple operating units, you may want to set up a default operating unit rather than forcing users to constantly have to choose one during data entry. When we talk about the User Preferences later, you can also specify a different default operating unit than the one assigned to this profile option.
2. AR: AutoInvoice Gather Statistics
This profile option determines if the AutoInvoice Master program analyzes and gathers information about the interface tables each time AutoInvoice is run. Analyzing tables ties up system resources, but in some cases may address AutoInvoice performance issues.
If the value for this profile option is set to Yes, or is null, AutoInvoice analyzes the interface tables and gathers statistics. If the value is set to No, AutoInvoice does not analyze the interface tables.
This profile option can be set by the system administrator at the site, application, responsibility, and user levels. The user can also update this profile option.
3. 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. This rate is usually a standard market rate determined by senior financial management for use throughout the organization.
-
Spot Exchange Rate - An exchange rate to perform a conversion based on the rate on a specific date.
-
User Specified Rate - An exchange rate to specify when entering a foreign currency transaction.
References:
Note 277131.1 Order Management How Can We Change The Default Exchange Rate Used By AutoInvoice
4. 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.
5. 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.
Note:
If you are interfacing data from Project Accounting, you need to set this profile to No at the application level for Oracle Projects. This setting will then allow data to be passed into RA_INTERFACE_DISTRIBUTIONS_ALL table for Projects Invoices.
6. Sequential Numbering
Sequential Numbering assigns numbers to documents that you create in Oracle financial products. For example, when you are in a window that creates invoices, each invoice document can be numbered sequentially.
Sequential numbering provides a method of checking whether documents have been posted or lost.
Not all windows within an application can be selected to support sequential numbering.
Sequential Numbering has the following profile option settings:
-
Always Used - You may not enter a document if no sequence exists for it.
-
Not Used - You may always enter a document.
-
Partially Used - You will be warned, but not prevented from entering a document, when no sequence exists.
Only system administrators can change this profile option. Users can see this profile option, but they cannot update it.
This profile option is visible and updatable at the site, application, and responsibility levels.
For further information on setting up profile options, please refer to the Oracle Receivables Implementation Guide Release 12, Oracle Receivables Profile Options A-1.
Still Have Questions?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the
My Oracle Support Receivables Community.
To provide feedback on this note, click on the
Rate this document link.