Ad 1

Tuesday, August 21, 2012

Value Set 

 Description :


  Value Set contains set of values. It is mainly used for entering junk free data into the application. 
  And not to confuse with validation of values of which this isn't used for any sort of validations.

Example :

  Lets say a concurrent program has three parameters .
  i.    Country 
  ii.   Code
  iii.   Region 

 These values are selected through drop down and user needn't enter any value.


Types of Values Set 

i. None
ii. Independent 
iii. Dependent
iv. Table
v. Special & Pair
vi. Translatable Independent  &
vii.Translatable Dependent


Description 
    
 i. None :  No Validation
ii. Independent :    A Pre defined list of values
iii. Dependent :   Values depend on Independent Value set
iv. Table :    Uses a table from where the values are fetched from
v.  Special : Used to get value from a flex field
vii. Pair :   Used when the need to define the value such that where it depends on Range of Flex fields.
viii. Translatable Independent : Same as Independent value set except that the values are Translatable
ix. Translatable Dependent  : Same as Dependent value set except that the values are translatable.


Example : 
1.  Need to create parameters in a concurrent program where when selected the value for country its dependent states should get displayed in the next parameter .


  

Friday, August 17, 2012

   Multi Org Access Control 

 1. What is MOAC ?

 Ans:  To provide access to multiple operating units from a single responsibility so there by reducing the need to shift to its respective operating unit's responsibility.

2. How to set up MOAC in R12 ?

Ans:   
      MOAC Setup 
  i.  Create Organization Hierarchy  
      Navigation : HRMS Super User --> Define Organization Hierarchy 

     In this screen , we create the organization by name lets say XX_COMPANY1 .
     Where to this XX_COMPANY1 , we assign Vision Corporation and remaining Vision entities as parent and child respectively.

ii.  Create HR Security Profile
     Assign the HR Security Profile to the assigned organization XX_COMPANY1
     it shows as follows :
     XX_COMPANY1
             |
  VISION OPERATIONS                 - Parent 
            |
   VISION SERVICES                      - Child 
            |   
    VISION INSTANCE                    - Child 


 iii.  Now attach the above security profile to MO:Security Profile 

iv.   Then run the Security List Maintenance Concurrent Program .
        Upon completion this completes the operating unit in Multi - Org 


Thursday, August 2, 2012

Oracle Applications AOL


AOL Concepts in Oracle Applications R12  , Flex Fields Creation


 Below article contains the following

i. Creation of Job Key Flex Field
ii. Creation of New Business Group
iii. Attaching new BG to a newly created responsibility with required Profile Options
iv. Creation of Job Flex Field

Below contains the navigation of each step along with the screen shot.


                                                Creation of  Key Flex fields
Job Flex field :-
Navigation: System Administrator à  Application àFlex Field àKey à Segments                                           1.            Search for  Application : Human Resource , FlexField Title : Job FlexField and create a new Job Flexfield .


2.  Next click on ‘Segments’ Button.
  This is where we define or create the segments. Below is the screen shot.     

                                                                   
 Now , we need to create value set for each segment defined above.
 VALUE SET 1: XX_JOB_CODE_VS



VALUE SET 2: XX_JOB_TITLE_VS

3. Then, enter the created value set name under the value set screen and save the record                          


4.Close this screen and return back to the’ Key Flex fields segments ‘. Select the create Flex field ‘XX_DEMO_JOB_KFF’  and check box ‘Freeze Flex field Definition ‘ , which then displays a Caution message as below. Click ‘OK’ to continue. Then click on ‘Compile ‘ Button , which then displays a successfully compilation message.                                                                                                                                                  


5.  Now , change the application by closing the window and select  Application à Validation à Values to search for the Value Set created above.             Search with XX_JOB_CODE_VS and click on Find button to open the values form to enter the values as below .                                                                                                                                                                                                                                                                   


And save the record.
6. Similarly, enter the Job Title for XX_JOB_TITLE_VS value set as above.        

                                                                            
7.  Also Check Mark the ‘ Allow Dynamic Inserts ‘ Box and save the record.
8. Change the responsibility to Human Resource  à Work Structure à Job à Job Group.                                             Here we need to create a Job Group name. And select the ‘XX_DEMO_JOB_KFF’ in the Job Flex Field Structure .                And Save the record.                                                                                                                                         

                                                                           
9. Change the application form to Work  Structure à Job à Description to get the jobs which are defined under this combination.
10. In order to user this Job Key Flex Field to a altogether new Business Group .First we need to create a location for the Business Group.                                                                                                                                                     Navigation : HRMS à Work Structure àLocation               

                                                       
11. Now we can create a Business Group which links to the above location.                                                                          Navigation : Work Structure à Organization à Description                                                                                  Name : Test Demo Corp Business Group                                



                And attach the location created in the below step under the location field and save the record.                        Next select the Business Group Name under  ‘Organization Classification ‘ and save the record.


12. Click on ‘Others ‘ Button and select ‘Business Group Info ‘ field and click on the field. Here we give all the Key Flex fields which we defined and are specific to this business group.  We select all the fields by default and only for ‘Job  Flex Field Structure ‘ we give the Job Flex Field which  we have created above name

13. Create a responsibility ( in similar with the functionality of HRMS ) . Named it as TEST_DEMO_HR1.Navigation : System Administrator à Security àResponsibility à Define


14. Navigate to System Administrator àProfile à System .                                                                                                         Enter the responsibility created TEST_DEMO_HR1 under the responsibility and HR Security for Profile and select the Find button.  Then enter the Business Group ( XX_SAMPLE_BUSINESS_GROUP) created above for Hr Security profile field under Responsibility and SAVE the record. The purpose of this is to attach the Business Group to a particular responsibility and then use this responsibility for the Job Key Flex Field. Next Attach this responsibility to the user  ( with which we log into ).


15. Switch the responsibility to TEST_DEMO_HR1 .Navigate to Work Structure à Job à Description .     
Select New  .  Job Group comes by default and once we click on Name , the Key Flex Field which we created namely XX_DEMO_JOB_KFF . And select job code  and job title values and save the record.


16. Navigate to the People à Enter and Maintain Form and create a new employee .

17. Once in the assignment form , here we get the Job KFF Which we have created and also entered into.
  Below is the screen shot of the records in JOB KFF .



Creation of Key Flex Field for Jobs is complete.