Community Menu

KBACE Login

Oracle E-Business Suite Blog

Information and Articles related to the Oracle E-Business Suite

View video overview of moving Categories and Courses in OLM here >>

Within OLM, moving a Category from one place to another is easy.  You can just select the radio button that corresponds to the Category you wish to move, hit the move button, and then choose the location you'd like to move it to before applying your changes.

In contrast, moving a Course requires a few extra steps that may not be all that intuitive for new OLM Administrators.

Here's a quick overview on the steps it takes to move a Course from one Category to another within your Oracle Learning Management Catalog:

  • First, make a mental note of the name of the Category you are going to move your Course to;
  • From the main Catalog page, navigate to the Category that currently contains the Course you wish to move;
  • Click the blue Details icon that corresponds to the Course that is going to move;
  • Navigate to the Categories link on the left-hand navigation menu;
  • Click the Add button;
  • Type the name (or at least the partial name) of the Category that you wish to move the Course too and hit the Tab key on your keyboard;
Side Note: The entry in this field corresponds to a list of values (all of your Categories), so OLM must find the name in its list before you continue).  If OLM doesn't automatically recognize the title that you entered, it may pop open a search window.  You can use the % character as a wild card to find your Category.
  • Click Apply;
Now your Course is listed in multiple Categories.  It will appear in the Primary Category (the name that has the target icon next to it), and any other Category that appears on the list (including the one you just added).
 If you truly want to move the Course and not have it show up in two places, continue on with the next steps:
  • Click the Set Primary Category button;
  • Enter the name of the Category you just added to the Course (see the Side Note paragraph above if you have any issues);
  • Click the Apply button;
  • Click the Remove icon for any Category that is listed that you do not wish to have your Course appear in.  Only the Category set as the Primary Category cannot be removed from the list;
  • Click the Yes button to confirm that this is really what you want to do.
Viola!  Your Course is moved.

View video overview of moving Categories and Courses in OLM here >>

Welcome to 12.1 Upgrade

Posted by: Martha Ho in Release 12.1 on

Martha Ho

Welcome to 12.1 Upgrade.

More to come...

Martha

 


I'm pleased to announce that we're going to begin our own internal upgrade to the Oracle E-Business Suite Release 12.1 on April 27th 2009!  During this project, the KBACE team will be keeping everyone up-to-date on their progress, including: 

  • Any issues that are encountered during the upgrade;
  • An overview of newly available features;
  • Updates on any Service Requests that are opened;
  • Overviews of any bugs that are found;
  • Information on available patches;
  • Tips, tricks, and lessons learned during the upgrade. 
Stay tuned for updates!   

 


Find a DFF Attribute Using SQL

Posted by: Chris Lynch in Untagged  on

Chris Lynch

Forget about that PUI - the FND tables will give you everything that you need. 

select fdu.application_column_name
      ,fdu.end_user_column_name
from   fnd_descr_flex_column_usages fdu
      ,fnd_descriptive_flexs fdf
where  fdu.descriptive_flexfield_name = fdf.descriptive_flexfield_name
and    fdf.application_table_name = 'PER_ALL_ASSIGNMENTS_F'
order by 1,2


APPLICATION_COLUMN_NAME        END_USER_COLUMN_NAME         
------------------------------ ------------------------------
ASS_ATTRIBUTE1                 Union Seniority Date
ASS_ATTRIBUTE2                 Acquisition Company                       

2 rows selected.

It even works for Job information:

select fdu.application_column_name
      ,fdu.end_user_column_name
from   fnd_descr_flex_column_usages fdu
      ,fnd_descriptive_flexs fdf
where  fdu.descriptive_flexfield_name = fdf.descriptive_flexfield_name
and    fdf.application_table_name = 'PER_JOBS'
and    descriptive_flex_context_code = 'US'
order by 1,2

APPLICATION_COLUMN_NAME        END_USER_COLUMN_NAME         
------------------------------ ------------------------------
JOB_INFORMATION1               EEO Category                 
JOB_INFORMATION2               Survey Benchmark             
JOB_INFORMATION3               FLSA Code                    
JOB_INFORMATION4               Job Group                    
JOB_INFORMATION5               Line of Progression          
JOB_INFORMATION6               Salary Code                  
JOB_INFORMATION7               EEO Function                 
JOB_INFORMATION8               IPEDS Category               

8 rows selected.

/*CL*/


If you've worked with the User Productivity Kit (UPK) and integrated voiceover, you know that the file size can become quite large.  As a result, it takes a long time to import into Oracle Learning Management and can actually result in a failed import where the contents of the UPK  SCORM-compliant zip file never actually unzips onto your content server.

 There is a workaround that you can use to get this content to import quickly into OLM if you're able to get direct FTP access to your content server.   You'll need to use an FTP program that supports Secure FTP (i.e., CoreFTP or CuteFTP), and you'll need to work with your technical team to get login credentials to your content server and to ensure that your FTP user will have permission to change / modify / write to directories that are created in OLM through the Administrator interface.

Once you're setup with access to directly place your UPK files onto the Content Server, here are the steps that I've found to work best:

  • Unzip your published SCORM-compliant UPK files into a directory on your PC;
  • Hit CTRL + A on your keyboard to select all of the files that you've unzipped (making sure that you're at the root level where the imsmanifest.xml file resides);
  • Hold down the CTRL key and de-select the tpc folder;
  • Re-zip only the selected files and folders into a new "slimmed down" zip;
  • Go into OLM as an Administrator and import this slimmed down zip from your content tab - be sure to make note of the folder you create when importing so that you can find it in the next step;
  • Log into the Content Server directly from your FTP program and navigate to the content directory to find the new folder that you created;
  • Upload the tpc folder inside your newly created folder;
  • Now all of your content will be properly hosted on your Content Server and you can continue to publish the Learning Object and assign it to the appropriate Offering in your Catalog as usual.

 I actually got a shout out in Metalink for helping on this one! ;-)

(Doc ID: 735653.1) 


When Responsibilities are initially granted to the Oracle Learning Management Administrator, only reporting functionality is enabled.

To grant the remaining functions required to create and modify the Learning Catalog, you must add roles to the user through User Management.

Important you must add the Learning Management roles to the user directly from the original sysadmin login. Just having the User Management or System Administrator responsibility assigned to another account is not good enough.

View Metalink Doc ID: 343999.1

Oracle Learning Management uses Learner Access to determine which individuals and groups have the ability to view and enroll in any given Class or view and subscribe to any Learning Path, Learning Certification, Forum, or Chat.

Local access to a Catalog object may be defined by Assignment (some combination of Organization, Job, and or Position) or by Learner (an actual named person that exists within Oracle HR). For example, you could grant access enroll in a Class with manager approval to everyone in the Vision Organization, all Senior Programmers, or only John Smith.

Administrators have the ability to grant Learner Access at any level of the Catalog hierarchy (except for Session). Each object inherits (and potentially adds to) the learner access designated for its parent object.

In the case of a conflict, Learner Access that is specified at the highest level is always enforced.

For example, Learner Access that is specified at the top Category level will always prevail if there is a conflict with a Subcategory, Course, Offering, Class, Learning Path, Learning Certification, Forum, or Chat.

You must define a Learner Access model before learners are able to view or enroll in any catalog object. Through the concept of inheritance, you may open up the catalog for everyone with a login, define individual Learner access for each class, or specify any combination of access in between.

In order for Learner Access to apply to a Class, you must specify that it is restricted by checking off the Restricted box in the enrollment section when you set up the Class, Learning Path, Learning Certification, Forum, or Chat.

If you do not select the Restricted option then the object will only be subject to approval rules set for the entire system and anything that you've defined for Learner Access at any level above the Class will be ignored.

Strategies for Implementing an Effective Learner Access Model

Understanding the Restricted Checkbox

In practice, I think the Restricted checkbox is a bit of a misnomer and has been known to cause confusion among Administrators during initial rollouts. It may be better to personalize this field to say "Enable Learner Access" instead, as it really is telling OLM to check to see what Learner Access settings have been set and / or inherited for this specific Class. This designated access may really not be restricting anything at all, but could instead be opening up access for self enrollment.

The Importance of Planning Ahead

It is very important to carefully plan your Learner Access strategy before rolling out OLM. If you do not set a Class to look at Learner Access when you create it by making sure to check the Restricted checkbox, it will not be possible to change this setting after someone has enrolled (or been enrolled) in that Class. It is (sometimes unfortunately) possible to uncheck this Restricted checkbox on a Class after you have initially set it (even after enrollments have occurred), but there is no turning back.

If you find yourself in a situation where you have neglected to enable Learner Access on a Class where it is necessary, you must create a new copy of this Class and end date the initial Class in order to implement the necessary Learner Access.

Thus, as a best practice, it is recommended that you enable Learner Access for every single Class that you create within Oracle Learning Management even if you do not think that you will ever need to modify Learner Access in the future. By following this advice, you reduce the risk of requiring tedious, manual updates if unforeseen changes in your Learning delivery models or content pricing structures should occur (i.e., bringing in content from a third-party vendor that requires manager approval because of added costs).

Always keep in mind that Learner Access that is specified at the highest level wins out in the case of a conflict with access that is defined at a lower level. It is also not possible to exclude specific Learners or groups of Learners through Learner Access (i.e., you cannot specify that everyone except for John Smith has the ability to self-enroll in a training Class).

When defining a model that makes sense for your specific organization, you should be sure to specify Learner Access at the:

  • Highest level that makes sense so that you do not have to needlessly update multiple child objects
  • Lowest level that makes sense so that you do not have to rework all of your settings when you add in new objects that have different security needs

Stop Waiting on those Batch Processes

Posted by: Chris Lynch in Untagged  on

Chris Lynch
 

Don't you just hate it when batch processes like Payroll, BEE, and BENMNGLE take up all the threads and your report sits there pending for what seems like an eternity?  There is something you can do about it. 


<< Start < Prev 1 2 3 4 5 6 7 Next > End >>