Profile Options and Security Functions

During implementation the system administrator sets up security functions and profile options.

Profile Options

During implementation, you set a value for each user profile option to specify how Oracle Cost Management controls access to and processes data.

Generally, the system administrator sets and updates profile values. See: Setting User Profile Options.

Implementing Profile Options Summary

The table below indicates whether you (the User) can view or update the profile option and at which System Administrator levels the profile options can be updated: at the user, responsibility, application, or site levels.

A Required profile option requires you to provide a value. An Optional profile option already provides a default value, so you only need to change it if you do not want to accept the default.

  User Sys Admin Sys Admin Sys Admin Sys Admin    
Profile Option User User Resp App Site Required Default Value
CST: Accrual Age In Days - - Yes - Yes No Last Activity Date
CST: Allow Early Inventory Period - - - - Yes No No
CST: Category Accounts Definition Level - 0 0 0 Yes No Subinventory
CST: Cost Rollup - Include Phantom's This Level Material/MOH Costs - 0 Yes Yes Yes No Yes
CST: Cost Rollup - Wait For Table Locks - - Yes Yes Yes Yes None
CST: Cost Update Debug Level 0 Yes Yes Yes Yes Yes None
CST:Exchange Rate Type - - - - Yes Yes None
CST: Item Category for Inflation Adjustment Columbia Only n/a n/a n/a n/a n/a n/a n/a
CST: Item Category Set for Inflation Adjustment Columbia Only n/a n/a n/a n/a n/a n/a n/a
CST: Maintain Cost Privilege - Yes Yes Yes Yes No Yes
CST: Mark Zero Cost Records As Error During Cost Collection - Yes Yes Yes Yes No No
CST: Negative Accrual - 0 0 0 Yes No No
CST: Period Summary - - - - Yes No Automatic
CST: Price Index for Inflation Adjustment Columbia Only n/a n/a n/a n/a n/a n/a n/a
CST: Ship or Closure Date - Yes Yes Yes Yes No OM Order Line Closure Date
CST: Transfer Pricing Option - - - - Yes No No
CST: Use Serializable Isolation Level for Valuation Reports - Yes Yes Yes Yes No No
CST: View Cost Privilege - Yes Yes Yes Yes Yes None
Yes You can update the profile option
- You can view the profile option value but you cannot change it.
0 You cannot view or change the profile option value.
CST: Accrual Age In Days

Indicates whether to use the last receipt date or last activity date for age in days calculation.

Last Activity Date: A PO distribution's age in days is determined by the last invoice date or last receipt date, whichever occurs at last.

Last Receipt Date: A PO distribution's age in days is always determined by the last receipt date.

CST: Allow Early Inventory Period Close

This profile option determines whether an inventory accounting period can be to closed earlier than the period end date specified.

Yes: The period is allowed to be closed earlier than the period end date.

No: The period is not allowed to be closed earlier than the period end date.

CST: Category Accounts Definition Level

Indicates the definition level for category accounts.

Subinventy: The category accounts are defined at subinventory level.

Cost Group: The category accounts are defined at cost group level.

CST: Cost Rollup - Include Phantom's This Level Material/MOH Costs

This profile option determines if a phantom subassembly's this level material and material overhead cost should be rolled up into final assembly's cost.

Yes: The phantom subassembly's this level material and material overhead cost will be rolled up into final assembly's cost.

No: The phantom subassembly's this level material and material overhead cost will not be rolled up into final assembly's cost.

CST: Cost Rollup - Wait For Table Lock

Indicates whether the cost rollup waits until the desired information in Cost Management tables is available:

Yes: The program will continually attempt to lock the tables.

No: The program tries 10 attempts to lock tables before ending rollup request.

CST: Cost Update Debug Level

Indicates none or the level and type of debug messages to print in the cost update log file.

Regular: Every subroutine.

Extended: Every SQL statement.

Full: Same as Extended and keeps any temporary data in the database.

CST: Exchange Rate Type

Indicates how to convert foreign currency. The options are period average rate or period end rate.

This profile is also used to control the exchange rate type used for the Margin Analysis Report, the Material Distribution Report, and the WIP Distribution Report. When entering a foreign exchange rate for one of these reports, you must specify the exchange rate type. For reporting profit and loss results, different countries use different financial standards. For example, U.S. companies convert using the period average rate, and Australian companies use the period end rate.

CST: Item Category for Inflation Adjustment

Ignore this unless you are using the Colombia responsibility.

See: Oracle Financials for Colombia User's Guide.

CST: Item Category Sets for Inflation Adjustment

Ignore this unless you are using the Colombia responsibility.

See: Oracle Financials for Colombia User's Guide.

CST: Maintain Cost Privilege

This profile option is used in the security function when you define, update, or delete cost information. The profile option must be set to Yes to submit the Purge Standard Cost Update History concurrent program.

Yes: Profile option is enabled.

No: Profile option is disabled.

CST: Mark Zero Cost Records As Error During Cost Collection

Transactions with zero actual cost that are not reported to Oracle Projects are flagged with an error status by the Cost Collection Manager based on the value set for the profile option CST: Mark Zero Cost Records As Error During Cost Collection. Zero cost transactions are flagged with an error when this profile value is set to 'Yes'.

CST: Negative Accrual

This profile option is used to control negative accrual amounts for Purchase Orders during the period end accrual process. Profile option values include:

No: The application does not accrue negative amounts for purchase orders at period end (default).

Yes: The application accrues negative amounts for purchase orders at period end..

CST:Period Summary

This profile option is used to indicate if period summarization is performed when the closing an accounting period using the Inventory Accounting Periods window. The values are:

Automatic: Period summarization process is performed automatically when the period is closed. The status of the period becomes Closed after the summarization process is completed. This is the default value.

Manual: When a period is closed, the period summarization process is not automatically launched. The status of the period is Closed not Summarized. You must run the Period Close Reconciliation report if you want to calulate summarization data -and at that point the status becomes Closed.

See: Period Summarization Process and Period Close Reconciliation Report.

CST: Price Index for Inflation Adjustment

Ignore this unless you are using the Colombia responsibility.

See: Oracle Financials for Colombia User's Guide.

CST: Ship or Closure Date

This profile option is used to select the accounting date for which COGS for a ship only order is recognized. Profile option values include:

Sales Order Issue Date

OM order line closure date (default)

CST: Use Serializable Isolation Level for Valuation Reports

This profile option is used to set database transaction isolation level to serializable. Costing as-of-date valuation reports (including Period Close Reconciliation Report) could compute incorrect rollback quantity if transactions are being created or updated by other processes when running concurrently. This profile option ensures that the output of valuation reports is correct with expected rollback quantity. Serializable mode operates so it appears as if no other users are modifying data in the database. The transaction will view the database as of the time the transaction starts and does not recognize any updates running by other processes and users.

No: The environment runs normally. This is the default value.

Yes: Uses serializable isolation level for valuation reports.

CST: Transfer Pricing Option

This profile option is used to enable transfer price functionality for intercompany accounting. See: Transfer Price Costing Your choices are:

No: Transfer price costing is disabled. This is the default value.

Yes, Price Not As Incoming Cost: The incoming cost to the receiving organization is the shipping organization's inventory cost.

Yes, Price As Incoming Cost: The incoming cost to the receiving organization is based on the transfer price.

Note: For intercompany transfers between process and discrete inventory organizations, the incoming cost of an item is equal to its defined transfer price. This cost rule applies regardless of the value specified in the profile option CST: Transfer Pricing Option. The cost processor always assumes a profile option value of 'Yes, Transfer Price as Incoming Cost'. Profile option values of No or Yes, Price Not as Incoming Cost are ignored in these transfers.

CST: View Cost Privilege

This profile option determines whether certain costing reports indicate display cost information.

Related Topics