Friday, 12 January 2018

Oracle Fusion -4

Fusion Supply Chain Management (SCM) applications are next generation applications that build upon Oracle’s best of breed SCM product suite to address today’s newest business challenges.


Introduction
Of late I have received some feedback/inputs from some of my peers and well-wishers that my articles are getting more tech-savvy with less content (explanation) and more of screenshots. A very valid point considering few of my fast formula related articles but point well taken, going forward will try to keep things simple so as to cater to an audience with practically no hands on experience on the application.
I am sure most of the us (including those who are starting their careers either with EBS or Fusion) must have heard of terms like Lookups, Value-Sets too often and at times do get used to them without actually trying to understand what are they and why are they used.
In this article, I will try to explain what is meant by a lookup, why is it required, how many types of lookups, where it is used and so on…
So let-us start and the first and foremost question is:
What is a Lookup?
The literal meaning of lookup stands as
“an act or instance of looking something up, as information in a reference book or an online database” and the Oracle Fusion definition of Lookup isn’t too far away either, defined in the simplest terms “a lookup is a way to provide validation (using list of values) for a user input field in a user interface”. A typical example could be a field on UI form say Gender which might only allow values like ‘Male’ or ‘Female’. The application would not allow any other value apart from the ones listed in the drop down list attached to the form field.
What are the different types of Lookup?
A Lookup may be classified in multiple ways depending on the UI View Page where the same is defined and also depending upon the various customization levels (namely user, extensible and system).We would discuss both these type of classification here.
Lookup Classification Based on UI View Page Definition
https://lh6.googleusercontent.com/eId9tV7DexrxQGOCMJVClU8Ycy0AAN0oE6XLyOCkZ6PAjtS9ERQJ4wwJcEDu46aXsa9W6Nd-UqCdsqfOiME9PhUgKfv-nBuMmegGD_uM2cvfAUHG-Bymw7M055Lkk3iL2jjpTgnM
Note: A reference data set may be considered as a data partitioning layer. For a set-enabled lookup the lookup-code (a lookup component discussed in detail later) is associated with specific data-set for example if the lookup-code is associated with US (short code for United States Legislation) it would not be used for EU (short code for European Union) and vice versa.
The different lookup types based on this classification are:
a.                   Common Lookups
These are the lookups which got migrated from the Legacy Systems as is (they belonged to the Common Lookups Category in other ERP systems) and are provided to ensure backward compatibility is maintained. They are defined in the Common Lookup View
https://lh6.googleusercontent.com/fr2atV3jQOa3j8Ljq4FjxithWW7wh3Ef5sIxSSEZ79VfWEUdmnV4rUN4Tp4scocqaw2ybBZqWPkNXADIGU88XNOXMABt3Cag7h249R_qZVV_Qw2jOO09gY7UEukTj_gbVImyAG8P
Standard Lookups
Standard lookups are the simplest form of lookup types consisting only of codes and their translated meaning. They are defined in the Standard Lookup View
https://lh4.googleusercontent.com/uOrNvSth9gay8sT2Ps2mxo4tJmF0j6obkHXK-UyQBFcS3PP5FKdRpeyB7fGVJXhRDcZMmOpT5KHhBL69Klfgn2-XyIX35QOX7eTPuZzjXukNy0URZYWlA4pjdCte17xaqIgF4hLq
Set-Enabled Lookups
Set enabled lookup types store lookup codes that are enabled for reference data sharing. At runtime, a set-enabled lookup code is visible because the value of the determinant identifies a reference data set in which the lookup code is present.

https://lh4.googleusercontent.com/nsLOl1KeyRWDJArnLY-YIT2LVDBnQr7wukqzjiPOTh5QteWbx-SdTL5WPx0zt5M58CsjmIRcxM7S6brtaWCFWxXA-kM99ug6XJg8W2_ajbkfgr66IQnO3GBitSe7bNhFCkSLMDCM
Standard, set-enabled, and common lookups are defined in the Standard, Set-enabled, and Common views, respectively. Applications development may define lookups in an application view to restrict the UI pages where they may appear.
In lookups management tasks, lookups may be associated with a module in the application taxonomy to provide criteria for narrowing a search or limiting the number of lookups accessed by a product specific task such as Manage Purchasing Lookups
Components of a Lookup
A Typical lookup comprises of the following elements/attributes:
a.            Lookup Type
Each of the lookup values (referred to as lookup-code) are clubbed into one or another groups depending on their specific use.
For example,
A MAR_STATUS Lookup Type will hold values like Single, Married, Divorced ….etc
Similarly a EMP_CAT Lookup Type will hold values like Full Time Regular, Part Time Regular, Permanent, Temporary..etc
b.       Meaning
This field gives the meaning of the Lookup Type field. While the Lookup Type field holds only a short code (used for internal reference within application) and doesn’t allows spaces in between the Meaning field is the one which gives a more clear understanding of the Lookup Type.
For Example
MAR_STATUS lookup type has Meaning as Marital Status
EMP_CAT lookup type has Meaning as Assignment Category
c.        Description
This field holds the complete description of the lookup type.
MAR_STATUS lookup type has description as Status of Person’s Marriage
EMP_CAT lookup type has description as Employment assignment categories.
d.       Module
Each of the lookup type belongs to one or another module depending on the area where it is used. A lookup which is used for Absence Management would typically have a module name as Absence Management one which belongs to Human Resources ( MAR_STATUS is an example) will have a Module Name as HR ( stands for Human Resource)
e.        Customization Level
Last but definitely not the least important attribute of any lookup this field helps us to identify whether we would be able to edit the lookup values of a lookup. They are of three types namely:
1.       User: A Lookup Type which provides complete control on the lookup values. Adding, Deleting, editing…etc
2.       Extensible: These lookup types have some lookup values which are pre-defined but can be extended to meet business needs. We can add/edit new values but are not allowed to make changes to existing pre-defined ones.
3.       System: You are only allowed to change the Meaning field of the Lookup
If a product depends on a lookup type, the customization level should be system or extensible to prevent deletion. Once the customization level is set for a lookup type, it cannot be modified. The customization level for lookup types created using the Define Lookups page is by default set at the User level.
The various lookup Management tasks which are allowed at various customization layer when captured in a tabular format would look as:
https://lh3.googleusercontent.com/DNgdPq1lsGJUTxtev_lb9oZyibm25R-2gDO5_IQ3rco73vr-Z-UEbMU3_ieftG66sCA1xJCtypUm-g0GnjUU5LKxTHM20kY1FMdSlk67mPt8DPG1EDZjgo9A6_jRnFWFpvIkmIQ0
Till now we only have covered the components of a Lookup Type but just having a lookup type does not make any sense until there are lookup values in it.
So let us spend some time to understand the various attributes of a Lookup Value too
a.            Lookup Code
These are the actual values which are displayed as a List of value items on the user interface. Each value should be unique (for a specific lookup) and there should not be any spaces in between.
‘S’ which stands for Single and
‘M’ which stands for Married are typical examples for MAR_STATUS lookup type
b.       Display Sequence
Each lookup code is assigned a display sequence basis which the value appears in the drop down list. We may change the sequence at any time but care should be taken that no two lookup codes hold the same sequence at any given point of time
c.        Enabled
This attribute ensures whether a particular value would be displayed to the end user or not. If the ‘Enabled’ checkbox is checked than the specific lookup-code maybe used while performing transactions from user interface and if the same is unchecked the same would not be visible on the User Interface.
d.       Start Date
This field holds the date from which a particular lookup-code can be used. It is always advised to have a very early date so that inconsistencies are avoided while performing transactions.
e.        End Date
As the name suggests this field controls the end-date of a lookup-code. If we had a Lookup-code which was used till a particular date but is not supposed to be used post a specific date we may put the same date value here and this would ensure that the lookup-code does not shows up in the List of value post the end-date.
f. Meaning
The actual value which is displayed to the user. For example, ‘Yes’ for lookup-code of ‘Y’ and ‘No’ for lookup-code ‘N’
g.       Description
This field holds the detailed info about a specific lookup-code. The field length is large enough and is used to give a clear idea to consultants and business users about a specific lookup-code.
h.       Tag
One of the most important field which controls lookup code usage legislation wise. Say for example we have three legislations namely US, UK and IN and as per the country specific rules all unmarried individuals in India have a Lookup Meaning as ‘Unmarried’ for India (IN) while for US and UK they are referred to as ‘Single’. In this scenario although both the lookup-codes say U (for unmarried individuals used in India) and S (for individuals based in US,UK) would be present in the MAR_STATUS lookup type but only ‘U’ should be visible for users who belong to India legislation and similarly ‘S’ should be visible to users of ‘US’ and ‘UK legislation. In this scenario the TAG fields comes to the rescue. We would need to tag the legislation code beside the specific lookup-code value (Using a + sign followed by Legislation Code ensures the lookup-code is enabled with the legislation)
Lookup Code
Tag
Impact
U
+IN
Used for India Legislation
S
+US,+UK
Used for US and UK Legislation


Before we do a security comparison between Oracle Fusion and EBS, let us touch base on some fundamentals.

What is Authentication
Authentication is where the user needs to prove their identity using username and password

What is Authorization
Authorization identifies data and actions the user can access   i.e. if the user has the correct permissions then they can perform the requested operation on the data or the screen or the report or the workflow.

Data Security
Controls which data can the users operate upon in the system.

In Oracle EBS, the product has been developed using predefined data security policies in the AOL module and also in each module that uses GL Ledgers or Value Sets or Multi Org Access control.  In case of Oracle R12 E-Business Suite HCM, it uses product specific security called "Security Profiles" which are attached the a responsibility.

However in case of Oracle Fusion Cloud Applications, Oracle have developed a layer named APM. This APM layer sites above Oracle Identity Manager and Oracle Entitlement Server. The data security policies are stored in the data security policy store and are managed using screens APM, i.e. Authorization Policy Manager.
Posted: 19 Oct 2016 04:06 AM PDT
Oracle Fusion Intercompany Cloud training provides with complete setup of accounting configuration with COA rules. The Report summary includes all intercompany transaction columns, and lists information about intercompany transaction lines, grouped by outbound and inbound transactions & intercompany reconciliation reports enable you to reconcile your intercompany receivables and intercompany payables accounts.
Posted: 19 Oct 2016 02:46 AM PDT
Oracle Integration Cloud Service (ICS) is a powerful integration platform in the cloud to enhance the value of your investments in SaaS . Oracle Integration Cloud Service is Oracle's integration platform as a service (iPaas) is a rich monitoring dashboard that provides real-time insight into the transactions, all of it running on an Oracle Cloud. ICS will help customers accelerate their integration projects by pre-integrating with several SaaS Applications and will significantly shorten their time-to-market through a highly intuitive user interface.
Posted: 18 Oct 2016 08:58 AM PDT



Oracle Fusion Tax provides a single-point solution for managing your transaction and withholding tax requirements. Oracle Fusion Tax automates transaction tax calculation, tax determination, and tax reporting functions across business documents, such as sales invoices, purchase requisitions, purchase orders, and supplier invoices. With Oracle Fusion Tax, you can model your taxes according to the needs of both local and international tax requirements.
Posted: 24 Oct 2016 05:32 AM PDT
Introduction
I hope most of you must be aware of what a BIP Data Model is and what is meant by a BIP Report. In case some of you are not well versed with the same or would like to re-visit the same do feel free to refer this link here.
I guess it is a very common requirement where we want to send some email notification or report data output to specific business users based on specific schedule but the problem arises when these notification emailers are send even when there is no relevant data. Basically it causes a lot of issues to the end users whose life would be made simpler if we could ensure that they receive an email only when there is some data returned by the Report. This sort of functionality was easily achieved in E-Business Suite by making use of Event Triggers but the same had been troubling Fusion Cloud Consultants for quite some time now but times have changed and what we have been gifted as a part of BI Publisher 11g is ‘Schedule Trigger’
A Schedule Trigger is a Code Snippet which fires when a Report Job is scheduled to run. When a report job is scheduled to run, the schedule trigger executes the SQL statement defined for the trigger. If data is returned, then the report job is submitted. If data is not returned from the trigger SQL query, the report job is skipped. The schedule trigger that we associate with a report job can reside in any data model in the catalog. We do not need to create the schedule trigger in the data model of the report which we want to execute. We can therefore reuse schedule triggers across multiple report jobs.
In this article we will try to create a very simple Schedule Trigger and understand how the same works.
Creating a Schedule Trigger
In order to create a Schedule Trigger:
1.     In the Data Model task pane, we need to click on Event Triggers
https://lh3.googleusercontent.com/0O8IOIml6pkbKUe1jdxOdgkgOJWtBJOyePHffcstwSXiSjrdabp2E-blYU0R35cro8J-AuLUq8cyG7NhkvyT4tbjLUUW_1DLsL7Q3y_hZubHaunUDzEt0WGVgF7UHM770PBsL1fO
2.             Next we need to click on the (+) icon and fill in the following details
https://lh3.googleusercontent.com/a0aCVQ4N-IsA8lpXiceMqky0Fb6Zia6rkLFO1pqco19zzAKa-OvbcfnkBScIrXX9KD9gSkb8R-0tAH5ar8L_oOeO9mQozLPTvi7q2IIkr52UyuJEOuEhxxse0hm9Ra1GZVRCl5KR
Once populated the screen should appear as below:
https://lh6.googleusercontent.com/bMNMJSIR4gcR6SHjnIkc9c9AwFxRpt8jnVHeG7IYFd8ToTGvUlBXVSl9fKXw__-F9mx7WtzX6CwK_mH36DmTC0Um5dOh8jC6U5u62vt7mKdpyEGOLK9hX77Ejed_DPnAnuBy-9H4
3.             Also for each trigger we do have other fields too which are on the lower UI Pane
https://lh3.googleusercontent.com/UcRG0JE1vZHLNlxIH2D67FjGfYIEDhDupFRHx2F6jlGNbHITI51AqidTFeIPf1MHit7bfcrhRnbZMWcSih4O_DSifezRHVkGp6mwCkNNZrQwmGe4sMNA-n2OOU02S9tUnRKqNJLi
Note: pSchedule is a Parameter which has a Static LOV attached to it.
https://lh6.googleusercontent.com/wGOQSxbmSQmcB3fVg-271lLx0VLTwZun-HTttODWdy2z0kBcqYInwOCC4cI2IsuqMKZkbwM-MCNMnlZ6LWmCzPAhItJ8W2z9r3wSNSjq1KE714msmafk3OoVa7C9FEFp4Efkm3_b
Now we will save this Data Model as ‘ScheduleTrigger_dm’.
Using Schedule Trigger
Now we already have a Schedule Trigger Defined and we would proceed to the next step where we will try to use this schedule.
For this we will take an already existing BIP Report (we have a simple report developed named as ‘NoData Report).
https://lh6.googleusercontent.com/SOMT4uyG8K7ou_mcscUrHseqAZRdfPFwRvIVPI7rdjapHUbJ3QoH-RQ8OQHQ1t0BMKXTp8v8iU3DL_O7bVvPelkez8R9fV7IiROtHA2YLHSxVPJvg6eJtG4aEiUzIzPgK2U8BTar
Let us try to schedule the same.
We have two scenarios here.
Scenario 1
We will try to ensure that the schedule is success. For this we would pass a value of  1 to the Success(1)/ Skip(2) parameter of the ScheduleTrigger_dm
We need to fill the populate details on the Schedule Tab
https://lh6.googleusercontent.com/xqYvjqpZuoYiQ1fdFQpBF1muAehf8ltewHZuuG9I6FLUAjAcxT4Rom8IvtG-nwSi_KrdiUEKd5uTLvDozXpyo-FZnd8EQbQPvS0co1HLxWu0U1py5KFQUlLGgry7yhzKxsccqkt_
Next we click on ‘Submit’. Give a Report Job Name (say ‘SuccessSchedule’) and check the result.
https://lh3.googleusercontent.com/QebGxPFQHewT_IZc4CWiSCrgCqAZGGCuyJzGiP_D08WFW7sw6kM0BcahFR34Xqor-UHN23PBHqIm8NPbguknzvt870YRpHZGgWEMvuG6Y10pphSIQpkbfBdjWMOsEWHHZDXJbqMc
Also we may click on ‘SuccessSchedule’ under Report Job Name to get more details:
https://lh5.googleusercontent.com/p_63WB0jnS5oRycuhP_-17QGtF4hdspiAom9EJzYrfxJFWXHgsWZRcGsGquXg2f3zcc9W1rD6PEZtKLQCg-U7u6965v040hrZceQU3gAlwperfW2eb5XbX6znktfu5EERHdOwshA
We can clearly notice that a PDF Output File has got generated as expected.
Scenario 2
For this run we would try to ensure that the Schedule is skipped. As such we will pass a value of 2 for the parameter such that the ( SQL query attached to the Data Model of the Schedule Trigger returns no data)
We would need to populate the following details on the ‘Schedule’ Tab
https://lh4.googleusercontent.com/LFsZnzbteDBC5DVNC9zcrJm5k2tqfHkjvuuPyD4_smYc_38XEAodzwMoJ_y_WrkhVrIqluVLcrgerYJhtni-FWVrvrynJ6EV3h-vCd1yzYVayArZ7kPkqJdkutaiQ1jEU29eRIOl
https://lh4.googleusercontent.com/e7Fl_349kdl88vo3zVVTHKN2_0jU8s0PW1O0oU7_Y47fVXLNEGYpO3nfiMBULQbZ9OVehIY1CBVYH-Ma4JJsyxpGr6C_m3WbCbUe9TXWchHG0u6vT-L2zNJgo6rrGuQ8JJejRF7s
Next we click on ‘Submit’ , give a Report Job Name ( say ‘SkipSchedule’) and check the results
https://lh5.googleusercontent.com/uZHuXDWuy8izqBh9l4ojCh01Dh9VassMwcVKfwO8Nex7WUpjCRj6y2KZppoJWawripDRRq-S8a_vk0m4cUTKxUJfi7GA3Sc9q6O7woPyq0xN1GGCddrYp8GLJPc9ZAYwP8tQXi1a
Also we may click on ‘SkipSchedule’ under Report Job Name to get more details
https://lh4.googleusercontent.com/fTcTV-eFkrggnPOuPeFuBO-yLIPMjb0-Wq3_xMVR-h1pYfDAG5rTpcj2bbYWWpicUSAUf311F5yRTLA_Snmmip-LH-RwVeJTBZquzTHn9G0UvnzsFuG9LSP-1-9FSiZd3hcR1TQR
Inference / Conclusion
So we have seen how using a parameter and passing specific value 1, 2 we may have a successful and skipped schedule run respectively.
https://lh4.googleusercontent.com/n0NmdX_hdozB6M2lD1VGHS1_dg0rMESwxmeKtn2kvUlIfR3eEdStHkSXwmx8dijA1VZIm1FYnkGy2meeprn9DuUxVziDKYL67LhpY7E8nKxNbTs0FDrZ-QbVeCWflxD_-tMLfwpC
So this is how we may use Schedule Trigger while Scheduling a BIP Report and even control when / how to get a particular schedule skipped. We may even use more complex logic and control the behavior of the Scheduled BIP jobs but that would be left to the readers to try and explore.
Posted: 28 Oct 2016 04:33 AM PDT
Introduction
For all the Technical Consultants working with E-Business Suite creating dependent parameters for a Concurrent Program must be a very commonly used feature ( remember using $FLEX$ in the value set definition of one parameter which would fetch value from another parameter on which this parameter would depend) but the same had been a little different till now in Oracle Fusion Cloud Application ( you might still achieve this in an On-Premise deployment using JDeveloper) as neither we have the flexibility of using $FLEX$ in Fusion BIP Data Model nor do we have flexibility of attaching value sets to Fusion ESS jobs but having said so it doesn’t means we have hit a dead end. There is a workaround available where-in we can achieve the same functionality using bind variable feature.
If we use the bind variable (the independent parameter) in the SQL query which is attached to the other parameter (say dependent parameter) we can easily achieve the same.
Let us try to demonstrate the same with a worked example.
Worked Example
For this example, we would create a very simple data model which would fetch data from an Application Base table.
We would not be going through a step-by-step detail on creating a BIP Data Model but concentrate on creation of a dependent parameter here ( for a step-by-step detailed document on how to create a BIP Data Model feel free to refer the link here)
For this example, we will create a data model which would have two parameters:
Parameter 1: Period Type (Independent Parameter)
This may be regarded as the parent parameter (in case you like to say so) which is the independent parameter. We would try to fetch the different ‘Work Relationship’ an individual holds with the organization in this variable. It could hold the following data values:
1.       E: Denotes Employee
2.       C: Denotes Contingent Worker
3.       N: Denotes Non-Worker
4.       P: Denotes Pending Worker
Parameter Detail
Parameter Name
Data Type
Default Value
Parameter Type
Row Placement
Display Label
Period Type
String

Menu (List of Values Legal Employer)

Period Type

https://lh4.googleusercontent.com/IfNf08Sq_BX7rWeFufF83MYhk4ZMGlkKiEkxwjZ3VsVIXTKrvXazI5nLkt-q793zVID83ppAsaQSp9SO8kk8pUNCdMtwxz8_PVdfpB0AbkX0_pQrhKphUxfzwOR_hT_Ire02WZA4
List of Value
Lov Name
Type
Data Source
SQL Query
Associated with Parameter
Period Type
SQL Query
ApplicationDB_HCM
Select distinct period_type from per_periods_of_service
PeriodType
https://lh4.googleusercontent.com/OWT7EVtR5IhN7IAfEA357c2HY0BiDSCoIGq-cOnZ4f1S-l9bxF5PcycnDyDshGaPr2OacEJHmmMhp06HFtqSMNZDO0niTqqbSdEJQSuZTrKjLBsbaGbK_z4DmQXtR-jZQjlCP1s9
Parameter 2: PersonNumber (Dependent Parameter)
This is the second parameter which would list all Person Number depending on the Period Type value selected in the first parameter. Say if Period Type value selected is:
1.       E then it will list all Person Numbers which have an Employee Work Relationship
2.       C then it will list all Person Numbers which have a Contingent Worker Work Relationship
3.       N then it will list all Person Numbers which have a Non-Worker Work Relationship
4.       P then it will list all Person Numbers which have a Pending Worker Work Relationship
Parameter Detail
Parameter Name
Data Type
Default Value
Parameter Type
Row Placement
Display Label
PersonNumber
String

Menu (List of Values PersonNumber)

PersonNumber

https://lh5.googleusercontent.com/o2ZPv5gz2K4S7VApsYAF0uIgRnLnvysBALTUeDwrGX2XFhxk_ipKaJhdLzX1AJw0viBoMnbd4mg1Ean7jyb2y-duZOw8a_AggqG_ba00PHfYSOt20_l5UOtE4SfQHdf91q7Fmg1D
List of Value
https://lh5.googleusercontent.com/EA54MlfjXFWR-UeEH_jG2iZgYUu8NyEqw8gTGbjYXRjbIXVhGNUMEZfqyoyK_UxD-hmdWkMkKvqbgANHHHfugagA1mr8DHBDqRVi-BI16l_ZPNqH__gN6RAkHaCm8P8kdQ8-XSKp
Notice the use of :periodtype bind variable in the SQL query ( this ensures that the PersonNumber parameter is dependent on the value of PersonType parameter)
https://lh4.googleusercontent.com/JWdBXX2GJM5OjLAjMSQ_urmbaVGi9CsvlBSM6h3Io0hwRpWmTRI5oaLyvKf0StTHtIGgBfEY79GgkzFawnFOBvRYR4cBPCh5vy7iASOZYLz8-9kViBmG4-ICfRkLmVXM2_YWSgsb
Now we have the parameters defined. Next let us create a Data Set
Data Set Creation
We would now create a data set based on below details
https://lh3.googleusercontent.com/dJWhirvtjpspTzGs9g_or-QMX3FakJd2fAwGRa7UGnRe6Q2QSAJkWsjryw_2yx_6kapeLzrYJfX85IhRE2CMA6Ud7St2uAsVJkvy3WV5z3DZ54wm4vviX_szRC4TaOcVE05GnUE8
The screen once populated should appear as:
https://lh4.googleusercontent.com/4pWCOHuHH88jSce6vbkISbNlijywIsPLeyrCcC1YLqeyLWB39RDbkMlk8cvm2Ktvi34mTn7r-ekrjv2j8tcS_jnbUJjTykfwi5phS0OIeI3UZ2jLP5eQoq9GParO6wcMJq7xh92W
Next we should save the data model ( give an appropriate name say DependentParameter_dm )
https://lh3.googleusercontent.com/Cv18lPf6Ev-9G7g0MlBdpqt578mlSolcJs5dbd-k7VXn2uzh4QrXbd9S05LJxbBXaRxu81WcmTYzYhmUyTHQ9efk1MaREojxGmHDadqljtaPrJewG6-RGhBdUeu0iqj8kIXRITxq
Now lets try to run the Data Model and view the results
Running / Executing the Data Model
Once we save the data model, we may run the same by clicking on the ‘Data’ tab
For first run lets select the PeriodType as ‘N’ and we could see that the PersonNumber will only list those PersonNumber who have a Non Worker Work Relationship ( It shows 3364 only)
https://lh6.googleusercontent.com/Xd8PxaZq8g2G3aFUfgsFooDYXpqsBibdqIp6M5MafgZDehKJEo-uBXNCl2zJpaV1TNTQQbfCt5N5MQAy1igWryoVrL_k_gs8-98_PusMUcq2oImasjPYDrjKtSGYRRjpSbKRRTDO
Before proceeding lets verify the same from the application
https://lh6.googleusercontent.com/Oqd3GgSOy3WBTIBZOoYgJs-niieDgVdmUkvUz8XEl5ZI7Zd_PNzPQ7inT50J116sVmwpZZKfmKZBofsADnlsWisfDvHbYwB6rMpWZsEwCI7qLTiqmYVNcXxNrJwZS8KbVVGpvdud
We could clearly notice the Worker Type as Nonworker displayed on the Manage Employment.
As a last step lets us try to change the PeriodType to E and search for the same PersonNumber and we should not be able to search this PersonNumber
https://lh5.googleusercontent.com/0GID38A31_KdmQZQMZiO0gildsbpn5vECeuPuVlk77u4DkIpI6QY94ugSdmztoZTwKNvxEwM9bM22XnBs8lgPinbk5Oofl89G8lLSWOjf8DykIVh8IAJMPDo_2F5mxl43f3gGpuy
And that is what the application says too.
Great so we could see that the PersonNumber parameter is dependent on the PersonType parameter and the data which is displayed on the List of Value attached with PersonNumber changes as and when the value of PersonType is changed.
And with this we have reached the end of the article and I hope we were able to learn  how to create dependent parameters in Oracle Fusion Cloud Application. Do try at your end with a different example and let-us know how it goes.
Good Luck!
Posted: 15 Nov 2016 03:44 PM PST
Introduction to Oracle SCM Cloud: Manufacturing seminar demonstrates the how the functional roles of manufacturing engineer, production supervisor and production operator use the Manufacturing application. 
Posted: 15 Nov 2016 09:40 AM PST
Oracle Transportation Management (OTM) training is the most widely used core functional components from a buy perspective. This intensive class covers order management, transportation planning of direct, multi-stop, and multi-leg shipments, the tendering/booking and acceptance process, and visibility.
Posted: 15 Nov 2016 03:45 AM PST
Introduction
Oracle Fusion Global Human Resources has one predefined approval flow. Using Oracle JDeveloper, you can edit a copy of this flow and create additional approval flows for transactions that have different approval requirements.
The following figure shows the predefined approval flow.
1.       When the transaction is submitted, it is routed automatically to the Worklist of the submitter's first-level manager, who is the first approver.
2.       If the submitter's first-level manager approves the transaction, it is routed automatically to the submitter's second-level manager, who is the second approver.
3.       If the submitter's second-level manager approves the transaction, it is committed to the database tables.
Seed1
Security permitting, either approver may edit the transaction. A link to edit the transaction is included in all notifications by default; however, the link can be hidden using personalization. The approval process continues unaltered after the transaction has been edited.
Approval Management configuration options for Oracle Fusion Human Capital Management determine most of the actions that are available to the participants in the approval process. For example:
·  Either approver can reject the transaction. By default, the approval process stops when the transaction is rejected.
·  The second-level manager can push the transaction back to the first-level manager, who then has a second opportunity to review the transaction and either approve or reject it, as appropriate.
·  Insertion of approvers in the approval list is permitted.
·  Approvers can delegate their approval responsibilities to other approvers.
If you change the default settings of the Approval Management configuration options for a task, then different actions or action outcomes become available to this approval flow.
Notifications
The following table summarizes who is notified at each event during the predefined approval flow.
Transaction Event
Transaction Submitter
Approver: First Level Manager
Approver: Second Level Manager
Routed for Approval

Yes
Yes
Rejected
Yes


Pushed Back

Yes

Committed
Yes
Yes
Yes
In addition, either approver can request more information from the other approver, the transaction submitter, or both. Such requests don't affect control of the approval process, but the person from whom information is requested receives a Worklist notification.
Approval Management Default Configuration Options
Approval Management has the following default configuration options for all applications in the Oracle Fusion Human Capital Management family.
Configuration Option
Default Value
Effect of Default Value
Ad hoc insertion of approvers
True
Ad hoc insertion of approvers in the approval list is allowed. Users who add approvers may also modify or remove the approvers that they add.
Allow delegate
True
Approvers can delegate their approval responsibilities to other users. One approver replaces another, but the approver list is otherwise unaltered.
Allow Pushback
True
An approver can push the transaction back to the previous approver, who thereby has a second opportunity to review the transaction.
Allow Reassign
True
Any approver can reassign the approval to a different approver. The approval list is recalculated based on the new approver.
Allow Request Information
True
Approvers can request more information from another approver or the person who submitted the transaction.
Allow Self-Approval
False
The person who submits the transaction can't approve it.
Allow Withdraw
True
The requester or an administrator can withdraw a transaction while the approval process is incomplete. Approvers who have already approved are notified of the withdrawal. The transaction is removed from the worklists of approvers who haven't yet approved.
On Error Notify
Human Resources Application Administrator
A Human Resources Application Administrator is notified automatically when an error occurs.
Period Before Task Expires
None
Approval tasks don't expire.
Period Before Task Escalates
None
Approval tasks aren't escalated to other approvers.
Escalated Approvers
None
Approval tasks aren't escalated to other approvers.
Repeated Approver Frequency
Once per approval
An approver receives one notification per transaction, even when the approver appears multiple times in the approver list.
Re-evaluate Approver List
True
The approver list is regenerated after every response.
Rejection Outcome
Stop All
When an approver rejects a transaction, the approval process stops and the transaction is canceled.

Posted: 15 Nov 2016 02:47 AM PST

{tab Preview | green}
By the end of this training you will learn to:
Navigating to the LearnCenter.
Configure system and local options.
Select fields for user profiles.
Creating and managing groups and user accounts.
Assigning administrator permissions using user roles.
Create supervisors.
Validation of role, configuration and permission settings.
How to Utilize the standard reports tab.
How to View and format reports.
Utilization of the custom reports tab.
How to Utilize BI reports.
Distribute a report.
{tab Course Contents | orange}
{tab-l1 Day 1 | orange} 
Oracle Learn Cloud Course Overview 
Oracle Learn Cloud Introduction
Reviewing Training Goals
Reviewing Implementation Steps
Exploring Use Cases
Exploring Use Cases vs. Implementation Steps
Reviewing User Perspectives
Working with Sub LearnCenters
Examining Considerations for Using Sub LearnCenters
Creating Sub LearnCenters
Copying Sub LearnCenters
Describing the Difference between Copying and Sharing Sub LearnCenter Items
Managing Sub LearnCenters from the Visual Manager
Inactivating Sub LearnCenters
Configuring LearnCenter Pages and Display Content and Containers
Examining the Anatomy of the LearnCenter Page
Describing the User vs. Administrator Interface and Page Editor
Configuring the LearnCenter Page Display
Displaying Resources on the LearnCenter Page
Displaying Content via Dynamic Objects (Containers) on the Page
Uploading and Inserting Web-Based Training (WBT)
Defining the Difference between Uploading, Importing and Inserting Content
Describing the Process for Making WBT Content Available
Viewing Samples of the FTP Site
Simulating Uploading WBT Content Files to the FTP Site
Importing SCORM Content to the LearnCenter
Defining Properties and Previewing SCORM Content
Inserting an Existing Course into a LearnCenter Page
Working with the Resource Manager
Describing the Purpose of the Resource Manager
Uploading Resources
Defining Types of Files and Size Limits
Utilizing the Resource Manager
Working with Resources & Folders
Uploading a File and a New Version of a File
Sharing Files to Individuals and LearnCenters
Creating Courses with Course Editor
Describing the Procedures for Creating Courses with Course Editor
Managing a LearnCenter Course
Working with the Course List
Editing the LearnCenter Content
Creating Categories for Containers
Examining How Categories can be Used in the LearnCenter
Creating Categories and Sub Categories
Mapping Categories to Containers
{tab-l1 Day 2 | green} 
Creating Assessments and Surveys
Examining Considerations for Assessments and Surveys
Describing Different Question Types
Using the Assessment Wizard
Creating and Managing Questions and Answers Manually
Creating Assessments and Surveys Manually
Using Random Question Selection from Categories
Creating Instances
Defining Messages and Notices for Containers
Describing the Use of Messages and Notices
Customizing Default Message Templates
Customizing a Message Template (for Enrollments)
Copying Messages
Inactivating Messages
Creating ILT / VILT and Enrollments
Creating Locations
Creating Instructors
Creating ILT Events, Tracks, and Sessions
Copying Sessions
Creating Enrollments
Creating VILT Events and Enrollments
Reviewing the Bulk Loader
Creating Assignments
Defining the Purpose of Assignments
Creating an Assignment
Assigning Assignments to Users (from Administrator to Supervisor)
Completing Assignments as a User
Reviewing and Grading Assignments
Grading Assignments from the Gradebook
Customizing Notices and Notifications
Creating Learning Plans
Describing the Purpose of the Advanced Learning Module and Learning Plans
Creating a Learning Plan
Mapping Items to a Learning Plan
Including ILT in Learning Plans
Sequencing Items in a Learning Plan
Assigning the Learning Plan to Users
Creating Skills 
Creating a Skill
Mapping Items to the Skill
Assigning Skills to Users
Creating Job Profiles
Defining Job Profiles
Creating a Job Profile
Mapping Items to a Job Profile
{tab-l1 Day 3 | red} 
Creating Course Catalogs
Describing the Purpose of a Course Catalog
Creating and Mapping Categories
Selecting the Dynamic Object to display the Items Mapped to a Specific Category
Reviewing Reference Materials
Exploring Post Session Learning
Reviewing Reference Materials
Reviewing Additional Oracle Learning Options
Oracle Learn Cloud Overview
Learn Introduction
Training Goals
Implementation Steps
Use Cases
Use Cases vs. Implementation Steps
User Perspectives
Identifying Basic Navigation
Working with Management Password
Working with Management Menu
Navigating the Control Panel and the Options Section
Setting System and Local Options
Defining the Difference between the Root LearnCenter and Sub LearnCenters
Configuring System-level LearnCenter Settings
Defining Security Options
Selecting Fields for User Profiles
Selecting Standard User Profile Fields
Creating Custom User Profile Fields
Creating and Managing User Accounts
Creating User Accounts Manually
Inserting Existing Users into LearnCenters
Listing Steps to Bulk Import User Accounts
Enabling Self-Registration
Creating User Accounts via Self-Registration
Managing User Accounts
Creating Groups
Defining the Purpose of Groups
Creating a Single Level Group and Sub Groups
Editing Groups
Assigning Users to Groups
{tab-l1 Day 4 | blue} 
Assigning Administrator Permissions via User Roles
Creating User Roles
Assigning Permissions to a Role
Editing User Roles
Assigning Users to a User Role Individually or by Group
Managing User Roles
Inactivating and Activating User Roles
Creating Supervisors
Defining the Role of a Supervisor
Designating the Supervisor
Assigning Supervisor Permissions
Specifying Supervisees
Displaying My Team
Validating Role, Configuration, and Permission Settings
Setting Reporting Configurations
Managing Insight Reporting Permissions
Managing Supervisor Permissions
Utilizing the Standard and Custom Reports Tab
Using List of Standard Reports
Identifying Insight Reporting Icons
Using Save As Feature and Adding a New Folder
Managing Reports
Adding, Editing, and Deleting a Folder
Using More Actions
Viewing and Formatting Reports
Enabling Interactivity
Hiding and Showing Columns
Editing Features
Utilizing BI Reports
Examining Report Phases
Identifying the BI Reporting Features
Running BI Reports
Scheduling BI Reports
Viewing BI Reporting History
Distributing a Report
Scheduling a Saved Report
Sharing a Saved Report
Viewing the Details of a Shared Report
Identifying Dynamic Objects for Insight Reporting
Running an Insight Report via My Team
{/tabs}
{tab Enroll | orange}
{tab Training Hours | red}
Start Date: 
Training Schedule: 
Timing: 12:00 NOON GMT | 08:00 AM EST | 5:00 AM PST | 7:00 AM CST | 6:00 AM MST | 5:30 PM IST | 01:00 PM GMT+1
{tab Audience | blue}
System Administrator
Developer
{/tabs}
Posted: 11 Nov 2016 09:03 AM PST
Introduction
Profile management provides a framework for developing and managing talent profiles that meet your industry or organizational requirements. Profiles summarize the qualifications and skills of a person or a workforce structure such as a job or position.
Profiles are valuable for tracking workers' skills, competencies, and accomplishments, and for various talent management activities, such as career planning, identifying training needs, performance management, and in the recruitment process for identifying job requirements and suitable applicants.
You can configure Oracle Fusion Profile Management to meet your business requirements using these components: the content library, profiles and profile types, content subscribers, educational establishments, instance qualifier sets, and rating models.
You create person profiles for individual workers and model profiles for workforce structures, such as jobs or positions. The profile type that you select for the model profile determines the information that you complete for the profile. For example, a person profile might contain information about a person's education, language skills, competencies, and activities and interests. A job profile might contain information about the requirements for the job, such as competencies, language skills, degrees, or certifications.
By default, any changes to a talent profile aren't subject to approval. When you edit a talent profile, all changes are visible immediately on the talent profile. HR specialists and implementers can enable approvals for each content type so that worker edits on the worker's talent profile require approval.
In this article we will try to find out about approval rules pre-defined in Fusion environment and the corresponding impact in-case you wish to enable approvals for same.
Enabling Approvals
HR Specialists and Implementers may enable custom approvals for person profile type. We can define approval rules for each content section related to the person profile type. When a worker submit changes for all the approval-enabled content through the Edit Skills and Qualifications Page of the worker’s talent profile, notification is sent to approvers based on default approval rules.
To Enable the Custom Approval rules for the person profile type, select the Person Profile Type on the Manage Profile Types page and click Edit.(below screenshots shows how to navigate there)
Login to application with proper user credentials (HCM_IMPL in this case which has Admin privileges)
FPM1
Once you click on login this would take you to the Homepage. Click on the Navigator icon and then choose ‘Setup and Maintenance’ link as shown below:
FPM2 
This would take us to a new page where we need to search for ‘Manage Profile Types
FPM3
A mouse click on the same will take you to a new page where you will be able to view the various profiles. This same Page even allows creation of new profiles, but we would concentrate on the Person Profiles.
FA4
In the above screen we could see that the Person (Code) is Selected and next we would click on the Edit Button (Highlighted in Yellow Color) and this would take us to a new page which would display all the content items associated with Person Profile as shown below:
FPM5
The ‘Enable Custom Approval Rules’ Checkbox should be selected to ensure that any edits/changes/modifications made to any of the content items go through approvals.
There are delivered approval rules which are already in place which comes into effect once the checkbox is selected and we would discuss about the same in next section.
Seeded Approval Rules in Profile Management
Before we try to understand the default approval rules, we should make ourselves aware of the navigation where the setups are defined.
We need to select ‘Manage Task Configurations for Human Capital Management’ task from the ‘Setup and Maintenance’ link as shown:
                                
FPM6
A mouse click on the task would take us to the BPM worklist area:
FPM7
Next, we need to select the ‘ProfileCoreHumanTask’:
FPM8
Once you click on the Task it will take you to the General Properties tab as shown:
FPM9
Next select the Assignees Tab and select the Blue circular dot (Go To Rule)
                      
FPM10
Once you click on the same it would show all the rules associated with the selected task.
FPM11
We could see that there are 5 rules which are preconfigured and a detailed description of the same follows:
PersonProfileApprovalRequired
Attribute Name
Attribute Values
IF
Task.payload.transactionApprovalRequest.attribute2 equals ignore case “PERSON_APPROVAL_REQD”
List Builder
Supervisory
Response Type
Required
Number of Levels
1
Starting Participant
HierarchyBuilder.getManager(“supervisory”,Task.payload.transactionApprovalRequest.Requestor,-1,null,null)
Top Participant
HierarchyBuilder.getPrincipal(“corp”,-1,””,””)
Auto Action Enabled
False
Auto Action
null
Rule Name
“PERSON_PROFILE_APPROVAL_REQD”
What the rule means is that if the Attribute2 which determines the type of approval being followed has a value as ‘PERSON_APPROVAL_REQD’ ( case insensitive values meaning irrespective of the same being either in uppercase, lowercase or Initcap or even mixed ones the condition becomes true as long as the value matches) then it would follow a supervisory approval where the first approval will be required from the requestor( individual who initiated the transaction) and end at the immediate supervisor of the individual on whom the transaction is being performed. 
Screenshot: 
FPM12
PersonProfileAutoApproval
Attribute Name
Attribute Values
IF
Task.payload.transactionApprovalRequest.attribute2 equals ignore case “PERSON_AUTO_APPROVAL”
List Builder
Supervisory
Response Type
FYI
Number of Levels
1
Starting Participant
HierarchyBuilder.getManager(“supervisory”,Task.payload.transactionApprovalRequest.Requestor,-1,null,null)
Top Participant
HierarchyBuilder.getManager(“supervisory”,Task.payload.transactionApprovalRequest.Requestor,-1,null,null)
Auto Action Enabled
True
Auto Action
Posted: 12 Dec 2016 10:48 AM PST
Introduction
Oracle Fusion HCM Cloud Application is slowly getting more user friendly (customer insights, issues and feedbacks) are heard seriously by the Product Development Team and sincere efforts are made to incorporate the same into the product. OTBI is also gaining popularity every passing day and with Release 12 Oracle has released some new Subject Areas of which “Human Capital Management - Approval Notification Archive Real Time” needs special mention.
This subject area provides real time information on completed approvals of various tasks transactions that are part of Fusion HCM. The tasks transactions comprise from various categories like compensation, payroll, core hr, absence/accrual, talent management and so on. In Release 12, only the completed tasks are rendered. The information that is available for reporting includes the business process name, category, who initiated the approval, task details like number, description, initiation date, status, each approver the task was assigned to, and assigned by, expiration date, count of tasks and so on.
The ‘Transaction ID’ attribute can be used to get details of the transaction from other subject areas. For example: ‘Transaction ID’ corresponds to ‘Assignment ID’ in the Assignment Event approval task. The Assignment ID provides details of the corresponding history changes of the event. The Time dimension allows reporting on various approval notification tasks based on various time periods.
Oracle has released a list of all available HCM Related Subject Areas along with details like the business questions which they are supposed to answer. Do have a look at the same in the table below.
Hope this helps…….
Subject Area Name
Subject Area Description
Key Business Questions (tied to the key business questions from the primary Fusion navigation page)
Primary Fusion Navigation
Historical Reporting
Time Dimension Anchoring Transaction Date
Special Considerations
Workforce Management Absence Real Time
This subject area provides absence information about workers. The objective of this subject area is to report on worker absence details such as absence plans, absence categories, absence types, absence reasons, status of the absence plan, and absence certifications.
This subject area also includes maternity leave information such as expected date of child birth, actual date of birth, and planned return date. You can use the Time dimension to report on worker absence history or future dated absences. The latest worker assignment and work-relationship data will be displayed.
• What are the various Absence Plans, types, and categories in the organization?
• Which Business unit has recorded the largest number of leaves during the year?
• What is the average leave taken by Department/Location?
• Can I get the list of workers who have taken more than N number of absences in the quarter?
• Which workers have taken the more than N number of days leave duration?
• Can I report on the pattern count of absence type during different months of the year? For example: December has maximum Vacation absences
• What is the count of absences by type and status?
Navigator -> Person Management -> Tasks -> Absences -> Manage Absence Cases
Yes
"Assignment Absences Details"."Date Start"

Accrual Real Time Subject Area
This subject area provides absence accrual information for the worker. The objective of this subject area is to report on absence plan balances for workers. You can report on accrual details for Incremental and Front Loaded plans. The reported  balances are as of the latest accrual process run date.
In addition to accrual details, you can report information related to accrual balance such as adjustments, carryovers, and time taken. You can use the Time dimension to report on worker accrual history. The latest worker assignment and work-relationship data will be displayed.
• What are the various Accrual Methods employed in the organization?
• Which are the various accrual plans and the total number of accruals against them?
• Can I report on details of accrual plans such as carryover limit, accrual rate, accrual ceiling?
• Can I get a breakup of accruals of workers by accrual methods, and plans?
• Can I get a trend report on the summary of accruals by years, and accrual methods?
Navigator -> Person Management -> Tasks -> Absences -> Manage Absence Records
Yes
"Employee Plan Participation Details"."Balance Calculation Date"

Workforce Management - Worker Assignment Real Time Subject Area
This is the primary subject area to report workers’ current assignment information.  A worker can have multiple active or inactive assignments. This subject area provides details of all the worker assignments, including their start and end dates, assignment type, status type, status, and working hours. Important metrics such as the total assignment count, headcount, and FTEs can be reported by Business Units, Department, Location, and Manager.

This subject area includes past and future dated assignment information. By default only a worker’s current assignment information as of today’s date is retrieved. You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE = ‘date’ (give the correct date format) to reset the default as-of date to report on assignment information in the past or future.

This subject area does not report a history of assignment changes.  You can use Workforce Management – Work Assignment Event Real Time subject area to report a history of assignment changes.
• What is the current assignment information for a worker?
• What is the current employee headcount by employee category or assignment status?
• What is the current headcount by job, department, grade, location, business unit, legal employer or bargaining unit?
• What is the headcount of hourly or salaried employees?
• What is the headcount by payroll?
• What is the FTE, headcount, assignment count by Location, Country etc?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Employment
No
"Worker Assignment Details"."Effective Start Date"

Workforce Management - Worker Assignment Event Real Time 
This subject area includes worker assignment changes (past, present, and future) including hires, transfers, assignment changes, promotions, manager changes, and termination. Actions performed on worker’s assignments can be reported using this subject area. Assignment events are identified by HR Actions and HR Action Reason dimensions which group assignment events by Action Type, Action, and Action Reason.  For example, you can use Action Type ‘Promotion’ to retrieve all promotions and use ‘Terminate Work Relationship’ to retrieve all worker terminations.

This subject area includes important assignment metrics to monitor assignment events. For example you can monitor Number of hires, Headcount of promotions, Number of transfers, Termination Full Time Employees (FTE), and Rehire counts.

You can use the Time dimension or Assignment Event Effective Start/End Date to report assignment history. Time dimension allows you to roll up assignment events by week, month, quarter, or year. With Effective Start and End date, you can see a worker’s complete assignment history with associated job, department, grade, location, business unit and legal employer information.

This subject area includes future dated assignment changes, such as hires and terminations. By default only a worker’s assignment history as of today’s date is retrieved.  You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE = ‘future date’ to reset the default as-of date and include future-dated assignments.

The assignment detail information in Worker dimension reflects the worker’s current assignment information.
• What is an employee's assignment history in the chronological order?
• What is the count of transfers into a Business Unit or Department?
• What is the headcount of terminations by categories such as voluntary and involuntary?
• What are the various reasons for worker terminations under both voluntary and involuntary categories?
• What is the count of terminations by various termination reasons?
• What are the Hire, rehire, transfer, termination counts by Business Unit, Department, Location, Manager etc
• What is the total number of promotions between two dates for a worker?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Employment
Yes
"Assignment Event Details"."Effective Start Date"

Workforce Management -Work Relationship Real Time Subject Area
This subject area provides information on employees’ primary and non-primary work relationships in the organization. Employment information associated with an employee’s primary work relationship such as the employee’s start date, adjusted service date, original date of hire, last working date, or termination date is available for reporting along with the other common dimensions such as Business Unit, Job, Department, Location, Position, and Grade. You can also report employee length of service by days, months, or years in this subject area.  
• What are the primary work relationship details of the worker?
• When did the worker join the organization?
• When was the worker’s original hire date?
• What is the Business Unit, location, department, etc of a worker in his primary assignment?
• How long is the worker employed in the organization; can I get the details by number of days, months, and years?
• What is the projected termination date for a worker?
• What is the rehire recommendation for a worker before the worker got terminated?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Work Relationship
No
"Work Relationship Details"."Work Relationship Creation Date"

Workforce Management - Person Real Time 
This subject area is used to report workers’ personal information such as worker address, emergency contacts, phone numbers, email address, national ID, religion, ethnicity, and work permit. This subject area is often used in conjunction with the other HCM subject areas to combine workers’ personal information, assignment, and compensation or benefit information.

This subject area only includes the worker’s latest personal information as of today.  However, you can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE = ‘history date’ to reset the default as-of date and include history data or future effective dated changes.
• What is the distribution of my workers by ethnicity, gender, nationality, or religion?
• What is the count of workers by work permit to various countries?
• What are the worker contacts’ phone numbers?
• What are the passport details of the worker?
• How many workers have work permits?  How many workers’ work permits will expire?
• What is the worker’s citizenship?
• What is the worker’s ethnicity and religion?
• What is the worker’s national ID?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Person
No
"Person Details.Effective Start Date"

Workforce Management - Documents of Record Real Time 
This subject area provides real-time information on workers’ documents that are part of their employment.  Organizations have the onus of maintaining the data about the legal documents of workers during the tenure of their employment and sometimes even after the worker is no longer employed. Document of Records subject area can be used to track workers’ legal documents such as Driving License, Income Tax returns, and their details.

You can use Time dimensions to report on the start and end time period of the document.
• What are the various documents that an employee has submitted and the pending documents?
• Which are the documents that are ending their validity period and hence must be renewed?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Document Records
Yes
"Document of Record Details"."Date From"

"Document of Record Details"."Date To"

Workforce Management - Employment Contract Real Time
This subject area is used to report on worker contract information including contract type, employment term status, duration of contract, and projected end date. It can be used to report on contract information for all workers including part time, full time, or contingent workers.

Key employment contract metrics such as number of contracts, number of extensions, contract duration, and extension duration are available for reporting.

This subject area does not include employment contract history and only the latest contract information as of today can be retrieved. You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE = ‘future date’ to reset the default as-of date and include future-dated or historical contract information.
• How many contracts does a worker have?
• What is the number of contracts by contract types and statuses?
• What is the duration of a worker's contract?
• What is the duration of a worker's contract extension?
• Which BU/Department has the highest number of contracts?
• How many contracts are going to expire?
• How many contracts have expired?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Employment
No
"Employment Contract Details"."Effective Start Date"

Workforce Management - Checklist Real Time
This subject area provides real time information on the on-boarding and off-boarding worker checklists. Checklist setup information can be reported as can the checklist and tasks that are allocated to workers. Information includes their status, performer, and dates. You can also report on ‘planned days’ and ‘actual days to complete the task’ using this subject area.

The Time dimension is split into two folders to retrieve the checklist details based on both the checklist task actual start date and end dates. History details related to tasks can be reported based on the two Time dimensions. Allocated checklist tasks that do not have an actual start or end date will be excluded when these time dimensions are included in a query.
• What are the various checklist categories, and the action names in the organization?
• What are the tasks to be performed during a worker on-boarding and off-boarding?
• Which allocated tasks are taking longer than planned?
• What is the status of certain tasks for each worker?
• Do some performers complete tasks quicker than others?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Allocated Checklists
Yes
"Checklist Task Details.Actual Start Date"

"Checklist Task Details.Actual End Date"

Workforce Management - Workforce Trend Real Time
This subject area allows reporting on headcount and Full Time Employee (FTE) information at the start and end of the period. Some of the metrics available for reporting include Active, Inactive, Suspended headcount, and FTE.
This subject area can be joined with Workforce Management - Worker Assignment Event Real Time to include terminations and therefore calculate turnover.
• What is the headcount for the last 3 years?
• Which months in the year has a high attrition rate?
My Workforce -> Person Management -> Tasks -> Personal and Employment -> Manage Employment
Yes
None

Workforce Management - Position Real Time
This subject area is used to report on the various positions in the organization. The total number, FTE, and headcount can be reported against each position. It can be used to calculate position occupancy.

You can use a SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE = ‘date’ (give the correct date format) to reset the default as-of date and retrieve past and future-dated position counts.
• What is the occupancy of my positions?
• What are the various positions available under each job?
• Which positions have not been filled in the organization?
• What is the hiring status of a specific position?
• What are the valid grades associated with each position?
My Workforce ->  Workforce Structures ->  Manage Position
No
"Position Details.Effective Start Date"

Workforce Management - Vacancy Real Time
This subject area provides real time information on the job vacancies in the organization. The requisitions opened to fill the vacancies are available for reporting. The vacancy details can be analyzed using the number of openings, and the number of hires by business unit, department, and country.
Use the Time dimension to report on the history data related to the vacancies filled as of that time period.
• What are the various job openings available as of current date?
• List the details of job requisitions created to fill the job openings
• What is the numbers of jobs filled by each year over the last 5 years?
NA
Yes
"Requisition.Creation Date"

Compensation - Salary Details Real Time 
This subject area provides real-time information on workers’ current salaries.  This subject area can be used to analyze workers’ salaries. The Salary details of the workers can be compared by various important dimensions such as Performance rating, Assignment manager, and Location. Salary basis, salary components, current and prior salary amounts, and salary metrics are available for reporting. Key information includes Current and Prior Salary, Annualized FTE Salary, Salary Change Amount, Salary Change Percentage, Compa-Ratio, and Quartile. Reports can be created in worker local currency or in a user-preferred currency.

This subject area does not include worker salary history.  By default, reporting is as of the current date.
• What is the average salary by location and job?
• What is each worker's current salary?
• How is each worker's salary distributed by component?
• What is the distribution of salary by quartile by country or job?
• Which workers have not had a salary adjustment in over 12 months?
• What is the current cost of base pay by organization?
• What percentage of total salary is attributed to each salary component?
• Which workers have a compa-ratio under 80 or over 120?
Navigator -> Person Management -> Tasks -> Compensation -> Manage Salary
No
"Salary Details"."Salary change date"

Compensation - Salary History Details Real Time 
This subject area provides real time information on workers’  salary history.  This subject area can be used to analyze workers’ salaries. The Salary history details of the Workers can be compared by various important dimensions such as Performance rating, Assignment manager, and Location. Salary basis, salary components, current and prior salary amounts, and salary metrics are available for reporting. Key information includes Current and Prior Salary, Annualized FTE Salary, Salary Change Amount, Salary Change Percentage, Compa-Ratio, and Quartile. Reports can be created in worker local currency or in a user-preferred currency.
• What is the salary change percent for the workers over the last 5 years?
• Which year in the last 10 years has the most number of workers getting a salary raise?
• How does the performance rating of the worker relate to the salary change over the years?
Navigator -> Person Management -> Tasks -> Compensation -> Manage Salary
Yes
"Salary History Details"."Salary change date"

Compensation – Workforce Compensation Real Time 
This subject area provides real time reporting on compensation data awarded during Workforce Compensation cycles. This subject area includes only data available during the plan cycle as of the HR data extraction date or last refresh date, such as worker assignment and salary details. Key information includes compensation amounts, eligible salary, target amounts and worker budget amounts for all components; custom columns, promotions and performance rating details available or given during a plan cycle.
A single report can be created for one or multiple compensation plans, cycles, and budget pools. Reports can be created in the plan corporate currency or in a user-preferred currency. Worker level data can be reported on in worker local currency.
• What is the Count of Eligible Workers in the Compensation Plan?
• What is the Average Worker Level Budget Amount?
• What is the average amount allocated by each manager?
• Which workers were not allocated compensation?
• What are the Target and Actual Compensation Amounts for Workers?
• How does the amount budgeted for each worker compare to the amount allocated?
• What is the average allocation amount or change percentage by performance rating?
• How much was allocated for each component?
•  Which workers received promotion during the compensation cycle?
Navigator -> Person Management -> Tasks -> Compensation -> Manage Compensation
Yes


Compensation – Workforce Compensation Budget Real Time 
This subject area provides real-time reporting on budget pool data linked to a Workforce Compensation plan. The Worksheet Details form an important role for budgeting for a the Compensation Plan. The Compensation Plan details, Budget Pool details, Various Compensation Components, Worksheet Details, distribution of available budget amounts and total allocated amounts are available for reporting. Worker promotion and performance rating details also are available, which can be leveraged to correlate the Planned Budgeting. Reports can be created in the plan corporate currency or in a user-preferred currency.
• What are the various Budget pools available for Compensation Plan?
• What is the Budget Amount specified per the Compensation Worksheet?
• What is the Actual Distribution Budget Amount?
• What is the Count of Workers included in Budgeting?
• What is the Overall Budget Amount for a Compensation Plan?
• What is the Actual Budget Spent by a Manager in the Compensation Plan?
• Can I compare the Budget Distribution by the Performance Ratings of the Workers?
• What is the Percentage spent by Budget pools in a Compensation Plan?
• Which Workers do not have the Compensation Budget allocated?
• In a Compensation Plan, what is the Average Budget amount?
• Can I Compare the Budget Amount by Business Unit, Location, and Assignment Manager?
Navigator -> My Team -> Workforce Compensation
Yes


Compensation - Stock Details Real Time
This subject area provides real time information on the stocks granted to the workers. Information like the type of grant, grant name, grant value, and validity period related to the stocks are available for reporting.
The metrics available for reporting include Total shares, exercisable shares, exercised shares, vested shares, and unvested shares.
Time dimension can be used to report on the stock details granted to the workers across time periods.
• What are the various stock grants allotted to the workers in the organization?
• What stocks have provided a profit to the workers during the last 3 years?
Navigator -> Team Compensation -> <select worker> -> Company Stock
Yes
"Stock Details.Original Grant Date"

Benefits – Setup Real Time 
This subject area provides real time information on various object definitions in employee benefits. The setup data related to benefit program, plan types, various plan names and details, the options to enroll to plans, the eligibility criteria to enroll, dependent coverage for a plan, and the effective dates for enrollment can be reported.
The latest setup data related to benefits can be reported using this subject area. Since time dimension is not available, history data related to benefits setup cannot be reported.
• What are the various benefit programs?
• List the benefit plans under each program
• What are the options available for dependant enrollment in a plan?
• Can I report on the plans and their effective start and end dates?
Navigator -> Benefits Administration -> Plan Configuration
No


Benefits – Potential Life Events Real Time 
This subject area provides real time information on all the potential life events for a person. Also, this subject area can be used to report on the life events that are currently in progress for a person. The worker information related to job, grade, position and so on can be reported along with the life events information.
The Time dimension can be used to report on the person life events over the time period.
• What are the various potential life event reason codes?
• List the life events, statuses, and the counts.
Navigator -> Benefits Administration -> Enrollment
Yes
"Potential Life Event Reason for Person Details"."Life Event Occurred Date"

Benefits – Enrollments Real Time 
This subject area provides real time information on employee enrollment to the benefit plan(s). The enrollment to a benefit plan can happen from explicit election by the employee or automatic/default enrollment as mandated by the organization. All the benefit enrollments, details like relationship name, benefit program, plan type, and plan name can be reported. The benefit plan enrollment details such as eligible amount, coverage period, the annual enrollment rate, enrollment status, and tax rate, can be reported.
The Time dimension can be used to report on the employee benefit enrollment over a period of time.
• List the various benefit plans to which the employee enrollment exists by years
• Can I get a trending report on the participant costs for benefit plans?
• Can I get the count of employee enrollments across business units?
• Can I report on the count of workers having benefit plan enrollment by enrollment method?
• Can I list the workers who are eligible to enroll dependants for a plan but have not done so far?
Navigator -> Benefits Administration -> Enrollment
Yes
"- Enrollment Results"."Enrollment Coverage Start Date"

Benefits – Enrollment Opportunities Real Time 
This subject area provides real time information on the choices available for the worker to enroll into various benefit programs or plans. The eligibility to enroll, the plan options available for the worker to enroll, and life event associated with benefits that have occurred to the employee can be reported.
The Time dimension can be used to report on the benefit enrollment opportunities available for the employees over the time period.
• What is the count of eligible workers for a benefit plan?
• Can I report on all the benefit programs and the plans available for enrollment to the workers?
• Which enrollment plan has the highest eligibility count?
• What are the various plan options available for the benefit plan?
Navigator -> Benefits Administration -> Enrollment
Yes
"Eligible Person Details"."Effective Start Date"

Benefits – Action Items Real Time 
This subject area provides real time information on action items for participants to enroll in a benefit plan or to designate coverage for a dependent or beneficiary. For example: a dependent requires date of birth, and Enrollment certification required. The benefit life events and the person details in benefit life events can also be reported.
The Time dimension can be used to report on the action items, life events over a time period.
• What are the various action items for a participant to enroll in a benefit?
• What is the action items required to designate coverage for a dependant or beneficiary?
• What is the count of life events status?
Navigator -> Benefits Administration -> Enrollment
Yes
"Person in Life Event Details"."Life Event Occurred Date"

Payroll – Retroactive Pay Real Time 
This subject area provides real time information on payroll retroactive processing. You can report on retroactive adjustments to analyze employees’ past earnings, deductions, based on changes to pay rates and benefit elections. You can also report on both regular and supplemental payroll details related to earnings and deductions for retroactive periods. Use the Time dimension to report on the retroactive payroll processing across different time periods by various payrolls and the workers. The worker details such as job, location, business unit, and department display the current data.
• What is the total retroactive amount by various payroll elements?
• List the top 5 departments liable for retroactive employer tax credit amount.
• Which employees have not received the retroactive pay in a payroll cycle?
• What are the total taxable benefit hours and the corresponding amounts for employees processed in retroactive pay?
Navigator -> Payroll Calculation -> View Payroll Process Results
Yes
"Payroll Retroactive Process Details.Payroll Actions Effective Date"

Payroll – Payroll Run Results Real Time 
This subject area provides real time information on payroll run results. You can report on payroll run results for the entire payroll process or for a single worker. In addition, you can report on payroll details such as standard working hours, standard earnings, deductions, and benefits, as well as Employer charges based on the running of the payroll, and tax deductions.
The Time dimension can be used to report on the payroll data across different time periods by the organizations and the workers.
• List the payroll, element run results along with their input values for all the workers by the line manager.
• What is the total amount incurred by the employer as payroll charges?
• What are the average standard earnings by various jobs?
• List the voluntary versus involuntary deductions by various locations.
Navigator -> Payroll Calculation -> View Payroll Process Results
Yes
"Payroll Run Results Details.Payroll Actions Effective Date"

Payroll – Payroll Run Costing Real Time 
This subject area provides real time information on payroll running costs. You can report on the various processes in a payroll flow, and their running costs. You can also report on the amounts debited and credited in the payroll process, the process mode, payment type, currency, payroll relationship details, payroll flows, and payroll process information.
Use the Time dimension to report on the payroll costs and their values across different time periods.
• What are the various costs in a payroll process?
• What is the trend of costs incurred in payroll over a particular year?
• What is the variation between payroll costs for workers by departments and countries?
Navigator -> Payroll Calculation -> View Payroll Process Results
Yes
"Payroll Run Costing Details.Payroll Actions Effective Date"

Payroll – Payments Distribution Real Time 
This subject area provides real time information on payroll payments distribution. You can report on the payments distribution activity comprising several tasks related to making payments. You can also report on payroll payments made as part of a normal payroll cycle flow or as a standalone process, as well as the source and the target bank accounts used in the payments distribution.
Use the Time dimension to report on the payroll payments distributions across different time periods. The worker details such as job, location, business unit, and department display the current data.
• What are the various types of payment distribution types and their amounts for a particular month?
• List the number of payments made from same bank accounts and different bank accounts.
• What is the amount distributed for each payroll in a year?
• Can I get a trend of the third party payment methods and their respective amounts in a year?
Navigator -> Payroll Calculation -> View Payroll Process Results
Yes
"Payment Distribution Details.Pre/Payment Effective Date"

Payroll – Payments Costing Real Time 
This subject area provides real time information on costs of payroll payments. You can report on account types, source types, debit and credit values, and their currencies related to payroll payment details. In addition, you can report on the payroll process flow, payroll relationship details, personal payment methods to workers, legislative data group, and department.
Use the Time dimension to report on the payroll payment costs across different time periods. Worker details such as job, location, business unit, and department display the current data.
• What are the various account types in payroll costs of payment?
• List the account type with debit and credit values.
• List the payroll process source type in costing of payments.
• Can I get a trend of payments costing by country and department?
Navigator -> Person Management -> Tasks -> Payroll -> Manage Costing for a Person
Yes
"Payroll Payment Costing Details.Effective Date"

Payroll – Element Entries Real Time 
This subject area provides real time information on employees’ element entries. Elements are building blocks of compensation and benefits. Elements can represent earnings, such as salary and wages, or deductions, such as taxes and voluntary deductions. Elements are associated with an employee, and this association is called an element entry. This subject area can be used to report on all the element entries of all employees or a specific element such as base salary to analyze the salary paid to each worker.
Use the Time dimension to report on workers’ payroll element entries and their values across different time periods. Worker details such as job, location, business unit, and department display the current data.
• How many element entries are there in a payroll?
• List the payroll, element entries and their input values for all the workers for a line manager.
• Which element entry value has the highest value in a payroll?
Navigator -> Person Management -> Tasks -> Payroll -> Manage Element Entries
No


Payroll – User Defined Tables Real Time
This subject area provides real time information on user defined tables in payroll. You can report on the payroll data such as wage codes, shift differentials, or the amounts of certain deductions etc that are stored in the Payroll custom tables.
• What are the various User-Defined Tables defined in Fusion HCM?
• List a detailed report that displays the rows, columns and the corresponding values of a specific User-Defined Table.
Navigator -> Payroll Calculation -> Manage User-Defined Tables
No


Payroll – Payroll Interface Inbound Records Real Time
This subject area provides real time information on payroll and its data that are processed by third party providers. You can report on inbound data like payroll name, period, earnings, deductions, leave information, messages, payments and payroll information of the workers processed by vendors.
• What are the various payroll activities outsourced by the organization?
• What payrolls are processed by the vendors?
• What percentage of workers have their payrolls processed by vendors?

No
"Payroll Interface Inbound Records.Start Date"

Payroll – Personal Payment Details Real Time
This subject area provides real time information on the worker’s personal payment methods related to payroll payments. The personal payment methods can be based on actual amounts, percentage, or a combination of both. All these are available for reporting. The critical information of bank, branch, and account details can also be reported. The personal payments that are future dated is also available for reporting.
Use the Time dimension to report on the worker's personal payments over a period of time.
• What are the various payment methods and the corresponding values preferred by the workers?
• List the percentage distribution of amounts by various payroll payments in the organization year on year.
Navigator -> Person Management -> Tasks -> Payroll -> Manage Personal Payment Methods
No
"Personal Payment Method.Personal Payment Method Effective Start Date"

Payroll – Payroll Balances Real Time 
This subject area allows reporting on payroll balances. Payroll balances can be all categories of earnings, and deductions. payroll balances at all levels such as assignment, term, and relationship are available for reporting. The balances can be reported for the workers for all the payroll runs.
• What   is the earnings and deductions balances for the current year?
   • Can I compare the various earnings and their balances, as well the   deductions and their corresponding balances for the recent payroll?
   • Which are the top 5 departments in their earnings?
   • What tax is the highest deduction for the workers during the last 3   financial years?
Navigator -> Payroll Calculation -> View Payroll Process Results
Yes
"Payroll Balance Details.Effective Date"

Workforce Performance - Performance Rating Distribution Real Time 
This subject area provides real time information on workers’ performance ratings and their distributions based on performance documents and the ratings. The minimum, maximum, and the actual distribution of the performance ratings for a performance document period can be reported using this subject area, as well as the performance ratings of workers.
Use the Time dimension to report performance ratings distribution history details. The worker details such as Job, Grade, Business Unit, Position, and Location display current data.
• What is the minimum and maximum performance ratings distribution for a performance document?
• What is the actual distribution of the performance rating for a performance document period vs the targeted distribution?
• Which performance document review periods have their actual rating distributions fall within the target rating distributions?
Navigator -> Performance -> Search Performance Document 

Navigator -> Performance -> Tasks -> Manage Target Ratings Distribution  
Yes
"Performance Document.Performance Document Valid To Date"

Workforce Performance – Performance Rating Real Time 
This subject area provides real time information on workers’ performance ratings based on performance documents. The worker performance self assessment and evaluations given by the manager or other participants are available in this subject area. Performance ratings include the overall rating and individual section rating in a performance document for example, competencies, and goals. You can also report on the rating model. In addition, this subject area can be used to report on the details of the questions and answers provided by various participants involved in the worker’s performance evaluation.
Use the Time dimension to report performance rating history. The worker details such as Job, Grade, Business Unit, Position, and Location display the current data. However, the worker evaluation details such as performance document name, participants, rating on individual sections of the performance document, questions and answers, and overall rating are dependent on the time dimension.
• Who are the various participants in a worker’s performance evaluation?
• What are the ratings and comments provided by manager, worker and other participants?
• What are the questions posed and answers provided by various participants?
• How many evaluations are participants asked to participate in, who have responded and who have not?
• What is the trend of performance rating for a worker over successive years?
• How many workers rated themselves lower or higher than the manager or other participants?
• What is the average rating for a worker over time, across all participants?
• What is the rating model used for each performance document evaluation?
Navigator -> Performance -> Search Performance Document  
Yes
"Performance Document.Performance Document Valid To Date"

Workforce Performance - Performance Task Status Real Time 
This subject area provides real time information on worker’s performance tasks and their statuses based on performance documents. The performance tasks associated with the performance template can be reported using this subject area, as well as completed and pending tasks for the worker or manager. Task details such as due date, completion date, task sequence, evaluation participant, and completed by, can be used for reporting. This subject area doesn't include workers who have not created performance documents.
Use the Time dimension to report performance task history. Worker details such as Job, Grade, Business Unit, Position, and Location display the current data. However, details such as performance document name, tasks,and task details, are dependent on the time dimension.
• Which workers have completed performance evaluation for a performance document period?
 • What are the various tasks for performance documents and what status are they in?
• What is the total number of tasks for a worker?
• Who by role and name owns a task and what is the status of the task?
• What are the counts of performance tasks by statuses for a performance document period name?
• Which tasks were bypassed or reset and who bypassed or reset it?
Navigator -> Performance -> Search Performance Document 

Navigator -> Performance -> Tasks -> Update Performance Tasks
Yes
"- Performance Task Status Details.Due Date"

Workforce Performance – Performance Document Status Real Time 
This subject area provides real time information on worker’s performance documents. The performance appraisal period document template, status of the performance document, performance evaluation by the manager including the comments, and employee comments regarding the appraisal can be reported along with the other regular information of the employee such as business unit, job, department, and location.
Use the Time dimension to report performance appraisal period documents history. The worker details like Job, Grade, Business Unit, Position, and Location display the current data. However, the worker evaluation details like performance document name, status, and comments, are dependent on the time dimension.
• Which workers have completed performance evaluation for a performance document period?
• What is the percentage of appraisal documents by various statuses for the selected review period?
Navigator -> Performance -> Search Performance Document 
Yes
"Performance Document.Performance Document Valid To Date"

Workforce Performance - Performance Document Eligibility Real Time
This subject area provides real time information on the worker’s eligibility to create or not create the performance document period. For a specific performance document appraisal period, the measures like the total eligibility count, count of documents created by workers can be reported.
The percentage of workers created versus not created related to performance documents can be reported.
The actual eligibility criteria that determines the condition for worker eligibility to create or not create performance documents is not available for reporting
Time dimension is not available for reporting in this subject area, however, the count of eligibilities and the actual documents created for each of the performance documents are available for reporting.
• What percentage of eligible workers have not created the performance document for the appraisal period?
• What is the performance document status including no status for missing documents for performance documents managed by eligibility?
• Which documents exist that are no longer eligible?
Navigator -> Performance -> Tasks -> Determine Worker Eligibility for Performance Documents 
Yes
"Performance Document Eligibility Details.Eligibility Creation Date"

Workforce Goals - Goal Status Overview Real Time
This subject area provides real time overview information on the status of workers’ performance and development goals.  You can report on Goal Plans assigned to the workers, the goals within the goal plans, their statuses, the source of the goals such as HR, Manager, and the categories of goals such as Career and Customer Satisfaction. In addition, you can report on the details of individual goals, such as completion percentage, start and end dates, priority of the goal, and goal measurement value.

Use the Time dimension to report on the goals created by workers across different time periods. Worker details such as Job, Grade, Business Unit, Position, and Location display the current data. Goals data is based on the Time dimension.
• How many goal plans are there?
• Which are the goals within a goal plan?
• How many goals do workers have?
• Can I report on all the performance and development goals assigned to a worker with their current status?
• How many workers have no goals created grouped by the assignment manager?
• Which goals plans have been assigned to a worker?
• How many goals have no goal plan?
Navigator -> Goals 
Yes
"Goal Management Process Details.Actual Completion Date"

Workforce Goals - Goal Tasks Real Time 
This subject area provides real time information on the worker goal tasks. The tasks can be reported for both performance and development goals. You can report on task-related information such as task type, name, status, start date, target completion date, and completion percentage. In addition, you can report on the goal details related to both performance and development goals like status, category, and success criteria.
Use the Time dimension to report on the goals and tasks details across different time periods. Worker details such as job, grade, business unit, and location, display current data. Goals and tasks data are based on the time dimension.
• How many performance goals and related tasks are there?
• How many goal tasks does a worker have?
• Can I report on all goals, tasks, and their statuses by managers?
• Which tasks have not been completed beyond the target completion date?
Navigator -> Goals -> Tasks
Yes
"Performance Goals - Additional Attributes.Target Completion Date"

Workforce Goals – Target Outcomes Real Time 
This subject area provides real time information on the target outcomes of worker goals. The target outcomes related to both performance and development goals can be reported. The profile data includes content type and content item details. You can report on the target outcome details that are based on the talent profile items. In addition, you can report on the goal details such as category, status, success criteria, and completion percentage.
Use the Time dimension to report on the target outcomes of goals across different time periods by workers. The worker details such as job, grade, business Unit, and department, display the current data. Goals and target outcomes data is based on the time dimension.
• How many goals have target outcomes?
• List all the goals and their target outcomes for workers?
• How many target outcomes are there across all the goals for workers?
• What is the target and actual rating levels for the target outcome records by workers?
Navigator -> Goals -> Target Outcomes
Yes
"Performance Goals.Actual Completion Date"

Workforce Goals - Goal Alignments Real Time 
This subject area provides real time information on worker goal alignment details. You can report on goals for workers, the organization, the manager, and colleagues using Worker Goal details such as category, status, success criteria, and completion percentage.
Use the Time dimension to report on the goals alignment details across different time periods by workers. Worker details such as job, grade, business unit, and location, display the current data. Goals data is based on the time dimension.
• How many aligned goals does a worker have?
• Can I list the number of aligned manager goals, organization goals, and colleague goals for a worker?
• Can I list the number of aligned goals by business unit or department?
• Which organization goals have the highest and least number of worker goals aligned with them?
• Can I have a list of all the colleagues with which a worker’s goal is aligned?
Navigator -> Goals 
Yes
"Goal Alignment Details.Actual Completion Date"

Workforce Career Development – Development Goals Overview Real Time
This subject area provides real time information on development goals of the worker.  You can use this subject area to report on the count of goals, completed goals, goals in progress, overdue goals, sum measurement of target, and actual values of the goals. With this new subject area customers need not employ the Goal Status Overview subject area to report on the development goals.
The Time dimension can be used to report on the goals created by workers across different time periods. Worker details such as Job, Grade, Business Unit, Position, and Location display the current data. Goals data is based on the Time dimension.
• List the Development Goal Plans and the corresponding Development goals assigned to the workers
• What is the percentage of goals without a goal plan?
• List the deviation between the target and actual goal measurement values by workers
• What is the percentage of goals completed versus in progress for the current year by Business Unit?
Navigator -> Career Development
Yes


Workforce Succession Management – Plan Candidates Real Time 
This subject area provides real time information about the candidates that have been added to various succession plans. The succession plans can be based on incumbent or job. You can report on the talent profile information of the candidates such as competencies, degrees, certifications, readiness for the job, and career preferences. You can also report other details such as department, job, position, grade, career preferences, and work requirements. In addition, you can report on succession plan details such as plan name, plan type, owner of the plan, and plan status.
• How many candidates are on a succession plan by various readiness statuses?
• What is the average number of plans by candidate for current year?
• List all the candidates and their readiness status for each succession plan.
• How many candidates are on plans outside the department?
• Which succession plans do not have candidates?
• List the details of succession plans, incumbents, and the candidates.
• Can I report on the talent profile details of the candidates?
Navigator -> Succession Plans
No
"Owner.Creation Date"

Workforce Succession Management – Job Plans Real Time 
This subject area provides real time information on succession plans based on Job. Succession Plans created for key jobs can be reported using this subject area. You can report on the incumbents of the jobs for which the succession plans are created. You can also report on other incumbent details such as department, grade, career preferences, and work requirements. In addition, you can report on succession plan details such as plan name, plan type, owner of the plan, and plan status.
• How many plans do not have any incumbents?
• How many incumbents are in critical Jobs?
• What is the percentage of distinct critical jobs with no succession plans?
• List the incumbents of a job plan that are in high risk of loss or high impact of loss.
• List the details of incumbents that are in multiple succession plans.
Navigator -> Succession Plans
No
"Owner.Creation Date"

Workforce Succession Management – Incumbent Plans Real Time 
This subject area provides real time information on the succession plans created for workers. The workers who have succession plans created for them are referred to as ‘incumbents’. An incumbent can have one or multiple succession plans created for them. You can report on incumbent details such as department, job, position, grade, career preferences, and work requirements. In addition, you can report on Succession plan details such as plan name, plan type, owner of the plan, and plan status.
• List all Incumbent based succession plans with incumbent details.
• How many incumbent succession plans are there?
• List all incumbents with multiple succession plans created for them.
• How many incumbent succession plans are created in each business unit?
Navigator -> Succession Plans
No
"Owner.Creation Date"

Workforce Succession - Position Plan Real Time
This subject area provides real time information on succession plans based on Position. Succession Plans created for key positions can be reported using this subject area. You can report on the incumbents of the positions for which the succession plans are created. You can also report on other incumbent details such as department, grade, career preferences, and work requirements. In addition, you can report on succession plan details such as plan name, plan type, owner of the plan, and plan status.
• How many plans do not have any incumbents?
• How many incumbents are in critical Positions?
• What is the percentage of distinct critical positions with no succession plans?
• List the incumbents of a position plan that are in high risk of loss or high impact of loss.
• List the details of incumbents that are in multiple succession plans
Navigator -> Succession Plans
No
"Owner.Creation Date"

Workforce Profiles – Model Profile Real Time 
This subject area provides real time requirements on model profiles. You can use this subject area to report on real time requirements of workforce structures such as jobs and positions related to model profile data. You can also report on model profile data such as educational degrees, competencies, work requirements, membership, licenses and certifications, languages, honors, and other content for various workforce structures.

You can use the Time dimension to report on model profiles across different time periods. Details such as job, position, and department display the current data. Model profile data is based on the time dimension.
• What are the work requirements for a job?
• What are the various competencies required for a position and what are the target levels for the competencies?

• How many languages are required for all jobs?
• Which jobs require certifications?
What are the job profiles associated with a specific job or position?
What are the active or inactive job profiles?
Navigator -> Profiles
Yes


Workforce Profiles - Person Profile Real Time
This subject area contains person profile details related to educational degrees, competencies, career preferences, membership, certifications, languages, potential, and risk of loss. This subject area also contains custom person profile content. This subject area also contains custom person profile content. You can use this subject area to analyze person skills inventory, education level, potential, and risk of loss by common dimensions such as business unit, job, location, and legal employer.
This subject area also includes person profile history. You can use the Time dimension to report on person profile items that may have changed or added over a time period. At the summary level, you can analyze person skills and certifications change over time.
• What are the workers’ competencies by business unit, job function and location?
• Who are the workers who have a particular competency, language skill or certification?
• What are the competency strengths and weakness in the organization?
• How many workers have high, medium, or low potential for a particular manager, department, grade, or position?
• Who are the high-potential workers who have a high risk of loss by department?
• What are the career preferences of the workers?
Navigator -> Profiles
Yes


Workforce Talent Review - Talent Review Meeting Real Time
This subject area focuses on the performance and potential of the worker. The objective of this subject area is to report on the strengths, needs, and development opportunities for a worker, and to identify the talent pool in the organization. The worker readiness for new assignments or jobs can also be reported.

The assessment of the worker by the manager or any other participant can be reported on various areas like worker performance, potential of the worker, the risk of loss, and the impact of loss. The ratings awarded to the worker by all the participants in the areas mentioned above are available for reporting along with the calibrated ratings also. The Profile data of the worker which aids in talent review is also available for reporting.

Based on the talent review, the 9 box performance versus potential grid with the worker count against each of the boxes can be derived using the data from this subject area.
Use the Time dimension to report on the history data related to worker’s talent review, the assessment, ratings, and notes.
This subject area focuses on the performance and potential of the worker. The objective of this subject area is to report on the strengths, needs, and development opportunities for a worker, and to identify the talent pool in the organization. The worker readiness for new assignments or jobs can also be reported.

The assessment of the worker by the manager or any other participant can be reported on various areas such as worker performance, potential of the worker, the risk of loss, and the impact of loss. The ratings awarded to the worker by all the participants in the areas mentioned above are available for reporting along with the calibrated ratings. The Profile data of the worker which aids in talent review is also available for reporting.

Based on the talent review, the 9 box performance versus potential grid with the worker count against each of the boxes can be derived using the data from this subject area.

Use the Time dimension to report on the history data related to worker’s talent review, the assessment, ratings, and notes.
• What is the impact of loss and risk of loss of a worker?
• What is the calibrated score of worker in talent assessment areas of potential and performance?
• Can I report on the assessment details of the workers by all the participants in the talent review meeting?
• What is the trend of the talent review assessment scores of the worker by last 3 years?
• Can I report on the worker profile items like competencies, degrees, certifications etc along with the worker’s assessment of potential, performance ratings?
• What is the count of workers in the 9 box grid of performance versus potential?
• Is the worker’s impact of loss correlated to the calibrated performance or potential rating?
Navigator -> Talent Review
Yes
"Talent Review Meeting Details.Meeting Date"

Workforce Talent Review - Talent Review Tasks Real Time
Talent Review Tasks subject area provides real time information on the tasks that are created and assigned to the workers as part of the talent review meeting outcome. The tasks can be created by the line managers/HR Managers. The task assignees will be the workers in the organization. Details related talent review meeting and tasks such as meeting name, task owner name, task name, status, priority, start, end and due dates for the tasks and tasks counts are available for reporting.
The Time dimension allows reporting on the task details based on various time periods.
• What percentage of workers have completed vs not completed the tasks assigned to them in the organization?
• Can I report on the various tasks and the assignment counts of these to the workers for a specific talent review meeting?
Navigator -> Talent Review -> <Meeting Name>  -> Manage Notes and Tasks
Yes
"Task Details.Start Date"

Workforce Management - Reported Time Cards Real Time
This subject area provides real-time data, including web clock and other time collection device entries, from reported worker time cards. Data available for reporting includes status, dates, manager, and project name. Time card details also available for reporting include ID, start and end dates, number of time cards created within the period, number of reported hours, and time card status.

Use the Time dimension to report over a period. Metrics related to worker absence information is also available for reporting.
• What percentage of the workers have created time cards for a specific period?
• What is the breakdown of the various hours reported in the time cards like reported, absence, labor, overtime hours?

No
"Reported Time Card Details.Time Card Creation Date"

Workforce Management - Processed Time Cards Real Time
This subject area provides real-time data, including web clock and other time collection device entries, from processed worker time cards for comparison with reported time cards. Processed details available for reporting include calculated date, time entry status for transfer to payroll, and calculated hours.

Use the Time dimension to report on processing details over a period
• What is the ratio of processed to reported time cards?
• What percentage of reported hours were approved as payroll hours?

No
"Processed Time Card Details.Time Card Creation Date"

Workforce Management - Historical Reported Time Cards Real Time
This subject area supports reporting on time cards created from all types of time entry like punch, and duration for employees and contingent workforce. The time cards associated with the various employee projects are available for reporting along with the status, dates, manager, and project name. The time card details like ID, start and end dates, number of time cards created within the period, number of hours reported, the status of the time card can be reported. Use the Time dimension to report over a time period. Metrics related to absence information of the worker is also available for reporting.

This subject area allows reporting on the historical time cards created by the workers.Workers can create time cards, enter data, save, and submit the time cards. A snapshot of the time card is taken each time the worker does an activity on the time card. For example, a snapshot is taken whenever the user status on the time cards is changed.
You can report on the ‘snapshot’ history of the worker time cards.
The history related to worker time cards, projects worked, absence entries, reported hours, and statuses, can also be reported.
• What is the trend of the time cards created and submitted over the last 5 years?
• Which business units have maintained a ratio of 90 percent and above in submitting their time cards consistently?

Yes
."Historical Reported Time Card Details.Time Card Creation Date"

Workforce Management - Historical Processed Time Cards Real Time
This subject area can be used to report on the time cards processed. The time cards reported versus processed can be compared. The time cards processed details such as calculated date, time entry status to payroll transfer, and processed hours are available for reporting. Use the Time dimension to report on the time cards processing details over a time period.
This subject area also allows reporting on historical processed time cards.
The time cards reported by the workers can be based on the snap shots of various user status criteria. These time cards are processed based on the various versions.
Historical Time cards and processed hours associated with projects, payroll and absences of the workers is also available for reporting.
• What percentage of the reported hours were processed and transferred to payroll during the last two years?
• Which projects had the maximum billable hours over the last few years?

Yes
"Historical Processed Time Card Details.Time Card Creation Date"

Workforce Management - Scheduler Profiles Real Time
This subject area provides real-time schedule management data to support schedule adaptions to meet forecasted workload demand.
Report on the managers who manage planned and published schedules as well as schedulers assigned to act on behalf of managers. Also report on data such as scheduler profile name, description, and effective start and end dates.


No


Workforce Management - Planned Schedules Real Time
This subject area provides real-time planned schedules data. Report on planned schedule details per manager, such as the schedule start and end dates, shift types, and shift start and end times. Also report on details such as the schedule profile name, group manager, and worker details.
• For a given scheduling group, how many resources are required on a specific date or over a specific range of dates?
• For a given scheduling group, how many resources are scheduled on a specific date or over a specific range of dates?
• For a given scheduling group, what is the staffing difference on a specific date or over a specific range of dates?
• For a given worker, how many hours are scheduled on a specific date or over a specific range of dates?
• For a given scheduling group, how many hours are scheduled on a specific date or over a specific range of dates?
• For a given scheduling group, on a specific date or over a specific range of dates, list the workers where their scheduled hours are greater or less than reported hours (where time cards exists), and the difference between the times.
• List the workers and their shifts for the specified date range.
• List the workers and their shifts that end within the specified time period on the specified date.
• List schedule details and details about shifts and workers associated with the planned schedules.

No
."Planned Schedule Details.Schedule Start Time"

Workforce Management - Published Schedules Real Time
This subject area provides real-time published schedules data. Report on published schedule details per manager, such as the schedule start and end dates, shift types, and shift start and end times. Also report on details such as the schedule profile name, group manager, and worker details. Compare planned and published schedules.
• For a given scheduling group, how many resources are required on a specific date or over a specific range of dates?
• For a given scheduling group, how many resources are scheduled on a specific date or over a specific range of dates?
• For a given scheduling group, what is the staffing difference on a specific date or over a specific range of dates?
• For a given worker, how many hours are scheduled on a specific date or over a specific range of dates?
• For a given scheduling group, how many hours are scheduled on a specific date or over a specific range of dates?
• For a given scheduling group, on a specific date or over a specific range of dates, list the workers where their scheduled hours are greater or less than reported hours (where time cards exists), and the difference between the times.
• List the workers and their shifts for the specified date range.
• List the workers and their shifts that end within the specified time period on the specified date.
• List schedule details and details about shifts and workers associated with the published schedules.

No
."Published Schedule Details.Schedule Start Time"

Workforce Learning - Learning   Management Real Time
This subject area provides real time information on learning items, learning events, learning assignments, owners of the learning items and the actual  learners. Learning items can be of type course,  tutorial, class, or video. Learning items can be assigned to the workers by the manager/HR/Peer or can be self driven. Metrics available for reporting include Learning Item count,   Recommended count, Require count, and Attempt count.
The Time dimension on the Learning Items folder allows your to report on all the learning items and related information for the workers across time periods.
• Which learning items are the   most popular, i.e. the most number of attempted/completed count during the   year?
   • Which learning item has the least successfully completed rate?
   • Which BU's produce maximum number of learning items during the   quarter?
   • Can i get the comparison for a learning by recommended , like, attempted   and completed counts?
Navigator ->  Learning -> Manage Catalog

Navigator ->  Learning ->   Manage Learning Assignment
Yes
"Time - Learning Item   Creation Date"."Date"

Human Capital Management - Approval Notification Archive Real Time
This subject area provides real time information on completed approvals of various tasks transactions that are part of Fusion HCM. The tasks transactions comprise from various categories like compensation, payroll, core hr, absence/accrual, talent management and so on.
In Release 12, only the completed tasks are rendered.
The information that is available for reporting includes the business process name, category, who initiated the approval, task details like number, description, initiation date, status, each approver the task was assigned to,  and assigned by, expiration date, count of tasks and so on.

The ‘Transaction ID’ attribute can be used to get details of the transaction from other subject areas. For example: ‘Transaction ID’ corresponds to ‘Assignment ID’ in the Assignment Event approval task. The Assignment ID provides details of the corresponding history changes of the event.
The Time dimension allows reporting on various approval notification tasks based on various time periods.
• What is the average time taken across task categories between the initiation and completion of tasks during the current month?
• List the business processes and the corresponding count of tasks against them.

Yes
"Approval Notification Details.Initiated Date"






Oracle Fusion Workforce Compensation delivers the ability to create both straightforward or complex and highly differentiated pay programs while providing simplified decision-making and consistent messaging to your workforce. Oracle Fusion Workforce Compensation is built to offer extensive client-driven configuration options and simplified screen designs offered by the Oracle HCM Cloud platform. The plan is available for use and you can start a plan cycle. Line managers can access the plan from the workforce compensation work area at any time during the period that worksheet is available to managers. Compensation managers can access the plan from the administration work area to view plan data even after the data is transferred to HR
This video demonstrates How to Manage and Configure Plan Details in Fusion Compensation Workbench: 

No comments:

Post a Comment

CREATING A SUPPLIER IN R12 (Functional and SUPPLIERS IN TCA)

Who is a Supplier? Let us now understand who is a Supplier with the help of a simple example: We consider us as a business, who sell...