Previous  Next          Contents  Index  Navigation  Glossary  Library

Profile Options in Oracle Projects

During your implementation, you set a value for each profile option in Oracle Projects to specify how Oracle Projects controls access to and processes data. Generally, your System Administrator sets and updates profile values using the System Profile Values window to set up profile options. See: Setting User Profile Options (Oracle Applications System Administrator's Guide).

Users can also update certain profile options that are defined to be updated by end users. Users can set their personal profile options in the Personal Profile Values window.

Overview of User Profile Options

For each profile option, we give a brief overview of how Oracle Projects uses that profile, and tell you which levels you can use to set or update its value.

PA: ADW Collect Top Tasks

Indicates whether the collection program collects dimension and fact table information at the top task level. By default, this profile option is set to No.

Note: You cannot currently collect task-level information if you integrate Oracle Projects with Oracle Project Analysis Collection Pack.

Attention: You should set this profile before you start collecting information for the interface tables. If you change this profile option after you have run the collection process, then you must reload the interface tables using the Refresh Dimension and Fact Tables process.

This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_ADW_COLLECT_TOP_TASKS.

PA: ADW Installed

Indicates if Oracle Project Analysis Collection Pack is installed. This profile is automatically set to Yes when you install Oracle Project Analysis Collection Pack. Oracle Projects does not use this profile option; Oracle Applications Data Warehouse uses it only for integration with Oracle Projects.

Available values are listed below:

Yes Only the core Oracle Projects product (either Oracle Project Billing or Oracle Project Costing) is installed. Oracle Project Analysis Collection Pack functionality will be available.
No Oracle Project Analysis Collection Pack is not installed, and related functions will not be available.
(No value) Equivalent to No
This profile option is visible to the System Administrator at the application level. You cannot update this profile option.

The internal name for this profile option is PA_ADW_INSTALLED.

PA: Allow Cross-Charging in Multi-Org

If you have implemented multiple organization support, this profile indicates whether to allow users to charge expenditure items to projects in other operating units that share the same Business Group, PA Period Type, and Set of Books as the user's operating unit.

Yes User is allowed to charge expenditure items to projects in other operating units that share the same Business Group, PA Period Type, and Set of Books as the user's operating unit.
No User is not allowed to charge expenditure items to other operating units.
(No value) Equivalent to Yes
This profile option is visible to the user and the System Administrator and updatable at the responsibility level.

The internal name for this profile option is PA_CROSS_CHARGE_PROJECT.

PA: Allow Override of PA Distributions in AP/PO

Indicates whether a user is allowed to update the Accounting Flexfield combination that is generated by FlexBuilder for Oracle Projects distributions in Oracle Payables and Oracle Purchasing. Available values are as follows:

Yes User is allowed to update and override the generated Account.
No User is not allowed to update and override the generated Account.
(No value) Equivalent to Yes
This profile option is visible to the System Administrator and updatable at the site, application, responsibility, and user levels.

The internal name for this profile option is PA_ALLOW_FLEXBUILDER_OVERRIDES.

PA: Allowed to Use AMG

Indicates whether you have purchased and are a licensed user of Activity Management Gateway.

Available values are listed below:

Yes Activity Management Gateway has been purchased and licensed. Entitles the user to features and support. You must enable this profile option to use any application that is based on Activity Management Gateway.
No Default value is No, meaning that user does not have access to AMG features or support.
(No value) Equivalent to No
This profile option is visible to the System Administrator and updatable at the site level.

The internal name for this profile option is PA_AMG_LICENSED.

PA: AutoApprove Expense Reports

Indicates whether to automatically approve expense reports submitted from Oracle Personal Time and Expense.

Indicates whether Oracle Projects calls a routing extension when you import an expense report that originates in Oracle Personal Time and Expense.

Yes Oracle Projects automatically imports the expense report into Oracle Projects as an Approved expenditure. You do not need to route or review your expense reports.
No Default value is No; in other words, expense reports are not automatically approved. They require review and approval.
(No value) Equivalent to No
This profile option is visible to the System Administrator and is updatable at the application level.

The internal name for this profile option is PA_PTE_AUTOAPPROVE_ER.

PA: AutoApprove Timesheets

Indicates whether to automatically approve timesheets submitted from Oracle Personal Time and Expense.

Indicates whether Oracle Projects calls a routing extension when you import a timesheet that originates in Oracle Personal Time and Expense.

Yes Oracle Projects automatically imports the timesheet into Oracle Projects as an Approved expenditure. You do not need to route or review your timesheets.
No Default value is No; in other words, timesheets are not automatically approved and require review and approval
(No value) Equivalent to No
This profile option is visible to the System Administrator and is updatable at the application level.

The internal name for this profile option is PA_PTE_AUTOAPPROVE_TS.

PA: Borrowed Lent Percentage Amount

Indicates the percent to use for borrowed and lent revenue for organizations. For example, you company may have a policy that a borrowing organization receives 20% credit for revenue, while the receiving organization gets 80% of the revenue. Assuming your AutoAccounting setup credits the revenue to the lending organizations, your borrowed and lent percentage is 20%.

You can specify any amount greater or equal to zero. If you do not specify a percentage amount, and implement borrowed and lent functions using AutoAccounting, Oracle Projects uses a value of 100 percent when calculating revenue amounts.

This profile option is visible to the System Administrator and is updatable at the site level.

The internal name for this profile option is PA_BORROWED_LENT_PERCENTAGE.

PA: Collection Pack Licensed

Indicates whether you have purchased and are a licensed user of Oracle Project Analysis Collection Pack.

Available values are listed below:

Yes Oracle Project Analysis Collection Pack has been purchased and licensed. Entitles the user to features and support. You must enable this profile option to use any features of Oracle Project Analysis Collection Pack.
No Default value is No, meaning that user does not have access to Oracle Project Analysis Collection Pack features or support.
(No value) Equivalent to No
This profile option is visible to the System Administrator and updatable at the site level.

The internal name for this profile option is PA_ADW_LICENSED.

PA: Cost Distribution Lines Per Set

Indicates the number of cost distribution lines to process in each set. This profile affects the following processes:

A logical unit of work is performed on a set of cost distribution lines before the work is committed. For example, the PRC: Interface Labor Costs to General Ledger process performs the following tasks on a set of cost distribution lines before committing the set to the database:

You can choose any numeric value to set this profile option, as long as it does not cause your system to exceed memory and database rollback segment sizes, and it is large enough to avoid unnecessary database accesses.

If you do not set this profile value, most of the processes use a default of 2000 cost distribution lines per set, but this value is operating system dependent.

This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_NUM_CDL_PER_SET.

PA: Cross-Project Responsibility

Indicates if a responsibility allows Cross-Project access. Available values are as follows:

Yes A holder of this responsibility can view and update any project
No A holder of this responsibility can view and update only those projects for which the holder is assigned as a key member
(No value) Equivalent to No
Oracle Projects predefines a value of Yes for this profile for the Project Billing Super User and Project Costing Super User responsibilities upon installation.

This profile option is visible to the System Administrator and updatable at the responsibility level.

The internal name for this profile option is PA_SUPER_PROJECT.

PA: Debug Mode

Indicates if Oracle Projects reports and processes are run in debug mode. The debug mode enables a tracing feature and causes additional messages to be printed to the log file. Available values are listed below:

Yes System is operating in debug mode
No System is operating in normal mode
(No value) Equivalent to No
Oracle Projects predefines a value of No for this profile upon installation.

This profile option is available at any level.

This profile option is visible to the user and System Administrator and updatable at the application, responsibility, and user levels.

The internal name for this profile option is PA_DEBUG_MODE.

PA: Default Burden Schedule Type

Indicates the default burden schedule type when entering a standard burden schedule using the Burden Schedules form. Valid values are listed below:

Firm Firm schedule type
Provisional Provisional schedule type
Oracle Projects predefines a value of Firm for this profile upon installation.

This profile option is visible to the System Administrator and updatable at the site level.

The internal name for this profile option is PA_IND_RATE_SCHEDULE_TYPE.

PA: Default Expenditure Organization in AP/PO

Indicates the default expenditure organization for project-related information in Oracle Payables and Oracle Purchasing.

You can select any organization that has a classification of HR Organization.

This profile option is visible to the user and System Administrator and updatable at the site, application, responsibility, and user levels.

The internal name for this profile option is PA_DEFAULT_EXP_ORG.

PA: Default Public Sector

Indicates if a project is public sector when a user enters a project using the Projects form. Available values are listed below:

Yes By default, any new project is public sector
No By default, any new project is not public sector
(No value) Equivalent to No
Oracle Projects predefines a value of No for this profile upon installation.

This profile option is visible to the System Administrator and updatable at the site level.

The internal name for this profile option is PA_DEFAULT_PUBLIC_SECTOR.

PA: Display Find Tasks

Indicates whether to display the Find Tasks window when a user chooses Tasks in the Projects, Templates window. Available values are listed below:

Yes Tasks displays the Find Tasks window, and Oracle Projects automatically queries the top tasks (WBS Level = 1)
No Tasks does not display the Find Tasks window
(No value) Equivalent to No
This profile option is visible to the user and System Administrator and is updatable at the site, application, responsibility, and user levels.

The internal name for this profile option is PA_DISPLAY_FIND_TASKS.

PA: Dual Accumulation Mode

Indicates whether to run the Release 10.5 accumulation along with the new summarization in Release 10.7 to provide a transition path when upgrading to Oracle Projects Release 10.7.

Yes Perform both new summarization and old accumulation functions
No Perform only new summarization functions
(No value) Equivalent to No
This profile option is visible to the System Administrator and is updatable at the application level.

The internal name for this profile option is PA_DUAL_ACCUMULATION_MODE.

PA: Expenditure Items Per Set

Indicates the number of expenditure items to process in each set. This profile option affects the following processes:

A logical unit of work is performed on a set of expenditure items before the work is committed. For example, the PRC: Distribute Labor Costs process performs the following tasks on a set of expenditure items before committing the set to the database:

You can choose any numeric value to set this profile option, as long as it does not cause your system to exceed memory and database rollback segment sizes, and it is large enough to avoid unnecessary database accesses.

If you do not set this profile value, most of the processes use a default of 1000 expenditure items, but this value is operating system dependent.

This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_NUM_EXP_ITEMS_PER_SET.

PA: Expenditures Per Set

Indicates the number of expenditures to process in each set. This profile option affects the following processes:

A logical unit of work is performed on a set of expenditures before the work is committed. For example, the PRC: Interface Expense Reports process performs the following tasks on a set of expenditures before committing the set to the database:

You can choose any numeric value to set this profile option, as long as it does not cause your system to exceed memory and database rollback segment sizes, and it is large enough to avoid unnecessary database accesses.

If you do not set this profile value, most of the processes use a default of 500 expenditures, but this value is operating system dependent.

This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_NUM_EXPENDITURES_PER_SET.

PA: Project Costing Installed

Indicates if Oracle Project Costing is installed. For an Oracle Project Costing installation, this profile is automatically set to Yes during installation.

Available values are listed below:

Yes Only Oracle Project Costing is installed. Oracle Project Billing functionality will not be used.
No Oracle Projects, which includes Oracle Project Costing and Oracle Project Billing, is installed.
(No value) Equivalent to No
This profile option is visible to the System Administrator at the site level. You cannot update this profile option.

The internal name for this profile option is PA_PROJECT_COSTING_INSTALLED.

PA: Projects Per Set

Indicates the number of projects to process in each call to AutoAccounting. This profile option affects the following processes:

This profile option affects the amount of memory allocated for processing the specified number of projects through AutoAccounting. A single logical unit of work is performed independently of this profile variable.

You can choose any numeric value to set this profile option, so long as it does not cause your system to exceed memory and database rollback segment sizes, and it is large enough to avoid unnecessary database accesses.

If you do not set this profile value, most of the processes use a default of 100 projects, but this value is operating system dependent.

This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_NUM_PROJECTS_PER_SET.

PA: Receivables Invoice Line UOM

Indicates the unit of measure to use for all invoice lines interfaced from Oracle Projects and created in Oracle Receivables. Oracle Receivables requires a unit of measure for each invoice line. Oracle Projects creates each invoice line with a quantity of 1, a unit of the unit type you specify in your profile option, and an amount equal to the dollar amount of the invoice line as it appears in Oracle Projects.

You need to define a unit of measure class before you define a unit of measure, since Oracle Receivables requires that you associate each unit of measure you define with a unit of measure class. Oracle Projects recommends that you define a unit of measure of Each or EA in Oracle Receivables for use with this profile. You must define a unit of measure and a unit of measure class before you can set this profile option. For detailed information, see the Oracle Receivables User's Guide.

If you are using Oracle Projects without Oracle Receivables, you do not need to set this profile. Oracle Projects uses the value EA.

You can choose from any unit of measure defined in Oracle Receivables.

This profile option is visible to the System Administrator and updatable at the site level.

The internal name for this profile option is PA_AR_INVOICE_UOM.

PA: Rule-Based Optimizer

Oracle Projects does not currently use this profile option, although you can view it using the Application Developer responsibility. The internal name for this profile option is PA_RULE_BASED_OPTIMIZER.

PA: Selective Flexfield Segment for AutoAccounting

Represents the segment number to be picked when building the flexfield select segment that queries the combination table. This is the most selective accounting flexfield segment to be used in AutoAccounting validation.

You set this profile option to the segment number to use. The segment number must start with 1.

This profile option is visible to the System Administrator and updatable at the application level.

Attention: For optimum performance, it is recommended that you set this value.

The internal name for this profile option is PA_SELECTIVE_FLEX_SEG.

PA: Streamline Process Sleep Interval

Indicates the number of seconds that the Streamline process sleeps before it checks the status of its child process.

You can choose any numeric value over 30 to set this profile. If you do not set this profile value, or use a value that is less than 30, a default value of 60 seconds is used. Oracle Projects predefines a value of 60 seconds for this profile upon installation.

This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_STRMLN_SLEEP_INTERVAL.

PA: Summarize Expense Report Lines

Indicates whether expense report lines in an expense report are summarized by code combination ID when you transfer expense reports to Oracle Payables.

Available values are listed below:

Yes Summarize expense report lines in an expense report by code combination ID when transferring expense report to Oracle Payables.
No Each detail expense report cost distribution line becomes an invoice distribution in Oracle Payables.
(No value) Equivalent to No
This profile option is visible to the System Administrator and updatable at the application level.

The internal name for this profile option is PA_SUMMARIZE_EXPENSE_REPORT_LINES.

PA: Tab to Budget Matrix Comments Fields

Indicates how users navigate to the overflow (Change Reason / Comments / Descriptive Flexfield) region of the budget matrix window.

Yes User can tab to the overflow region.
No User cannot tab to the overflow region. User may navigate to the overflow region by clicking on any of the fields there.
(No value) Equivalent to No
This profile option is visible to the System Administrator and updatable at the site, application, responsibility, and user levels.

The internal name for this profile option is PA_BUDGET_MATRIX_TAB_ALLOWED.

PA: Tasks to Display for Expenditure Entry

Indicates which tasks to display in the Task Number list of values when entering pre-approved expenditures in Oracle Projects, supplier invoices in Oracle Payables, and requisitions and purchase orders in Oracle Purchasing.

All Tasks Displays the entire WBS of the selected project
Chargeable Tasks Displays only the chargeable tasks of the selected project
Lowest Tasks Displays only the lowest tasks of the selected project
This profile option is visible to the user and System Administrator and updatable at the site, application, responsibility, and user levels.

The internal name for this profile option is PA_TASKS_DISPLAYED.

Shared Profile Options

This section lists profile options that Oracle Projects shares with other Oracle Applications.

Account Generator: Purge Runtime Data

Setting this profile option to Yes ensures that the Oracle Workflow data used to generate accounting flexfield code combinations using the Account Generator is purged after the Account Generator has completed.

This profile option should always be set to Yes unless you are debugging the Account Generator. It is recommended to set it to No temporarily at the User level. Running the Account Generator with this profile option set to No fills up the workflow tables and slows performance.

Users can see and update this profile option.

This profile option is visible and updatable at all levels.

Tax: Allow Ad Hoc Tax Changes

Choose whether to update rates and amounts assigned to tax codes in the Transactions window in Oracle Receivables, if you defined tax codes in the Tax Codes and Rates window and set Ad-hoc to Yes.

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

The internal name for this profile option is AR_ALLOW_TAX_UPDATE.

Tax: Allow Override of Customer Exemptions

Use this profile option to prevent unapproved exemptions from being entered into Receivables. You can use this profile option to control whether you allow sales tax systems to automatically create unapproved sales tax exemptions during invoice entry. This modification only relates to invoice entry, as AutoInvoice previously allowed you to enter unapproved exemptions when this profile option was set. This profile's default setting is set to Yes at the application level for Oracle Projects.

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

The internal name for this profile option is AR_ALLOW_TRX_LINE_EXEMPTIONS.

Tax: Allow Override of Tax Code

Choose whether to override a system-derived tax code during order or invoice entry. If you override a system-derived tax code, Oracle Receivables will use the rate and amount assigned to the new tax code to determine the tax for the transaction.

You must set this option to Yes to import invoices from Oracle Projects into Oracle Receivables using AutoInvoice. Oracle Receivables automatically sets this option to No for the site level and changes it to Yes for Oracle Projects at the application level upon the installation of Oracle Projects.

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

The internal name for this profile option is AR_ALLOW_TAX_CODE_OVERRIDE.

AR: Transaction Flexfield QuickPick Attribute

Determines the Invoice Transaction Flexfield attribute to display in transaction lists of values throughout Oracle Receivables. This further identifies the invoice based on project information and is displayed under the Reference column in the lists of values.

You can set this profile to display any project information Oracle Projects passes to Oracle Receivables. For example, if you want to select invoices by project number in Oracle Receivables, leave this profile option set to the predefined default value of INTERFACE_HEADER_ATTRIBUTE1.

The segments that you can use from your Invoice Transaction Flexfield are as follows:

SEGMENT COLUMN
Project Number INTERFACE_HEADER_ATTRIBUTE1
Draft Invoice Number INTERFACE_HEADER_ATTRIBUTE2
Agreement Number INTERFACE_HEADER_ATTRIBUTE3
Project Organization INTERFACE_HEADER_ATTRIBUTE4
Project Manager INTERFACE_HEADER_ATTRIBUTE5

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

The internal name for this profile option is AR_PA_CODE.

AR: Use Invoice Accounting For Credit Memos

Choose whether you want to assign your credit memo to the same accounts assigned to the invoice you are crediting.

Oracle Receivables predefines this value as Yes at the site level. You must change this value to No for Oracle Projects invoices at the application level for Oracle Projects. AutoInvoice will reject Oracle Projects credit memos and write-offs if this profile option is not set to No.

Oracle Projects invoices must use the accounting transactions as determined by AutoAccounting in Oracle Projects to correctly debit and credit the unbilled receivables, unearned revenue, and write off accounts for credit memos and write offs.

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

The internal name for this profile option is AR_USE_INV_ACCT_FOR_CM_FLAG.

GL: Set of Books Name

Use this profile option to specify your set of books.

The value for this profile option may be set by the system administrator at the site, application or responsibility level, but it cannot be viewed or updated by the user.

The internal name for this profile option is GL_SET_OF_BKS_NAME.

HR: Security Profile

Use this profile option to point your responsibility to a specific business group.

MO: Operating Unit

Use this profile option to control which operating unit a particular responsibility corresponds to only if you have implemented multiple organization support. See: Multiple Organizations in Oracle Applications Release 10.7.

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

The internal name for this profile option is ORG_ID.

Obsolete Profile Options

Previous releases of Oracle Projects used the following profile options, which are now obsolete:

PA: Enable Employee Accumulation This profile option is no longer needed with the new accumulation model.
PA: Process Responsibility Type We now use the Standard Request Submission request groups for security
PA: Project Amount Column 1-4 This profile option is obsolete with the configurable columns in Project Status Inquiry.
PA: Task Amount Column 1-4 This profile option is obsolete with the configurable columns in Project Status Inquiry.
PA: Task Level This profile option is obsolete with the configurable columns in Project Status Inquiry.

See Also

Profile Options

Personal Profile Values Window

Overview of Setting User Profiles

Common User Profile Options

         Previous  Next          Contents  Index  Navigation  Glossary  Library