Refresh of Classification Denormalization

On errors running Refresh of Classification Denormalization process execute the following:


1. Run the following query to see if index exists and if so, what is the value of DOMIDX_OPSTATUS column:

select index_name, table_name, STATUS, DOMIDX_OPSTATUS , PARAMETERS, owner
from dba_indexes
where index_name = 'HZ_CLASS_CODE_DENORM_T1'
and owner = 'AR';

2. Then drop and recreate the index.

drop index AR.hz_class_code_denorm_t1 ;

3. Then re-create the index using the following command:

create index AR.hz_class_code_denorm_t1
on AR.HZ_CLASS_CODE_DENORM(CONCAT_CLASS_CODE_MEANING)
indextype is ctxsys.context ;

4. Run the Refresh of Classification Denormalization program.

Oracle Segment Qualifiers for Workflow

GL_BALANCING
GL_ACCOUNT
FA_COST_CTR
GL_INTERCOMPANY
GL_MANAGEMENT
GL_SECONDARY_TRACKING

How to use Oracle Asset Tracking to create fixed asset for rental business

How to use Oracle Asset Tracking to create fixed asset for rental business
1. Define this item as a Normal Item – Serialized (Create Assets unchecked in the Service Tab)
2. Receive this item in a Subinventory Location (Misc Rec/PO Receipt)
3. Just before you want the depreciation to begin, do an “Issue to HZ Location” transaction.
This is simply a user defined ‘Issue out of stores’ inventory transaction where you set this
transaction type as a ‘Issue to HZ Location transaction’ in the CSE Profile
4. Run the “Create Assets: Interface Inventory transaction to FA” concurrent program.
FA_mass_addition is populated and Post Mass addition takes it to FA and depreciation begins.
5. After step3, the item is gone from your inventory to create asset, so you need to move item back to inventory by doing a misc receipt transaction to receive it back to original inventory location.
6. Now pick and ship the serial to the customer with a Loaner transaction sub type. The sold to party is captured in the item instance and the ownership remains as internal party. Install location can also be captured in the installation details.
7. Run the “Interface move transactions to Fixed Asset” concurrent program and it will change the FA location based on the customer location mapping.

u and n in Budgetary Control Results

Budgetary Control Results

Goal

How does one get numerical values in the Budgetary Control Results page to display with ',' and '.' rather than with the letters 'u' and 'n'?

Solution

The 'u' and 'n' characters appear on the Budgetary Control Results page because the profile
ICX: Numeric characters
is not set.

Resp = System Administrator
Nav: Profile > System
Query profile ICX: Numeric characters
Set the profile to the desired value (10,000.00 or 10.000,00)
Save

Oracle HR: Security Rules

Oracle Human Resources Management Systems Configuring, Reporting, and System Administration Guide Release 12.1

Security Rules

Security Overview

Defining which records and information users can access is fundamental to HRMS security.
As part of your implementation plan, you identify who will use Oracle HRMS, what information they require, and how they use it. You can control a user's access to database elements such as records, fields, forms, and functions, and you can also control a user's access to other user records and data.
All Oracle Applications users access the system through a responsibility that is linked to a security group and a security profile. The responsibility is the primary means of defining security. The security group determines which business group the user can access. The security profile determines which records (related to organizations, positions and payrolls) the user can access within the business group. For example, you can restrict a manager's security permissions so that the manager can only access the person records for those employees and workers within a supervisor hierarchy. This restriction enables secure, reliable data access and ensures that only people with the correct permissions can access personal data.
See: Responsibilities

Project Oracle PA Classifications (Class Categories and Class Codes)

You define project classifications to group your projects according to categories you define. A project classification includes a class category and a class code. The category is a broad subject within which you can classify projects. The code is a specific value of the category.
For example, if you want to know the market sector to which a project belongs, you can define a class category with a name such as Market Sector. You can define class codes for this category such as Waste Cleanup, Risk Analysis, and Environmental Engineering.

Oracle Project Accounting: Job Mapping

In Oracle Projects, each person has a primary job assignment that is defined in Oracle Human Resources. For some enterprises, Oracle HRMS jobs and Oracle Projects jobs are the same. But there are many enterprises that use one set of jobs for project management and a different set of jobs for human resources.

Adding a DFF to an OA Framework Page

iProcurement is used as an example.

Here are the steps to enable DFF's on OAF pages. You can do this for any OAF page in Oracle Apps R12.

Start by adding a DFF to Create Purchase Order page in Buyer Work Center. First we need to define the DFF. The steps are as follows:
1. Create a new Value Set.
2. Define Values for the value set created in step 1.
3. Add Value Set to the Flex Field Segment in Application: Purchasing and Title: PO Headers.
4. Freeze and Compile the FlexField definition.

Personalize KFF OAF-Limit Segments

Personalize the KFF to display the Segment List.
Ex: structure code1|segment1's name|segment2's name

In your case it's only structure code1|segment1's name.
If you have more than one structure code then you have to use below construct.
structure code1|segment1's name||structure code2|segment1's name

How to Enable Personalization link for OAF Pages

Set the values of following profiles to enable Personalization Page link in OAF Pages
 

Profile Name	Value
FND: Personalization Region Link Enabled	Yes
Personalize Self-Service Defn	Yes
Disable Self-Service Personal	No