The employment level entered is not eligible for the element Statutory Deductions Error

                  Error - Employment level entered is not eligible for the element Statutory Deductions

When hiring an employee if the below error occurs. Then we have to follow a few steps to avoid this error.

ERROR:

The message is ORA-20001: The employment level entered is not eligible for the element Statutory Deductions on YYYY-MM-DD. Details: You cannot grant the element to the payroll relationship, terms or assignment unless it meets the element eligibility criteria and has an element costing record. Ensure that a suitable element costing rule exists for the element, and that the eligibility criteria for a person matches those defined on the costing rule. ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 468 ORA-06512: at line 53 .

To avoid this error we have to follow the below steps:

1. Set up and maintenance --> Elements

2. Search for the "Statutory Deductions" Salary Element

3. Click on Statutory Deductions

4. Please make sure the effective as-of date is correct

4. Select "Element Eligibility" on the left-hand side and click on the Actions dropdown

5. Click on Create Element Eligibility

6. Fill in all the required information and submit.

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath  

Credential sent Process to employees/Users in oracle cloud HCM

                              Credential sent Process to employees/Users in oracle cloud HCM

To send the credentials email notification or resend the welcome mail, need to follow the below steps:

1. Use the CredentialsEmailSent flag to No in User.dat HDL for the employees we want to send notifications to.

User.dat

METADATA|User|PersonNumber|CredentialsEmailSent

MERGE|User|1234|N

2. Run the schedule process "Send User Name and Password E-Mail Notifications"

To Stop credential email notification or sending welcome mail for the employees, need to follow the below steps:

1. Use the CredentialsEmailSent flag to Yes in User.dat HDL for the employees we want to stop notifications.

User.dat

METADATA|User|PersonNumber|CredentialsEmailSent

MERGE|User|1234|Y

2. Run the schedule process "Send User Name and Password E-Mail Notifications" which will send a notification to only Employees with CredentialsEmailSent set to N

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath 

BIP Refresh Process

                                                             BIP Refresh Process

Login with a BI Administrator user and execute the following steps in order to clear the BI Cache:

1. Clear BI Publisher Cache:

Administration --> BI Publisher --> Manage BI Publisher --> System Maintenance --> Manage Cache --> Clear Object Cache

2. Clear cache for the integration between BI Publisher and OTBI

Administration-- > BI Publisher --> Manage BI Publisher --> Integration --> Oracle BI Presentation Services --> Clear the  BI Subject Area Metadata Cache

3. Clear OTBI Cache:

Administration-- > Issue SQL --> type :  "Call SAPurgeAllCache();" --> Click "Issue SQL" (you should see a message like "Operation SAPurgeAllCache succeeded!")

4. OTBI Reload Files and Metadata:

Administration-- > Maintenance and Troubleshooting --> Reload Files and Metadata

5. Logout --> Clear browser cache --> Restart browser

6. Login and retest  

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath                                               

How to get Current User Person ID in Oracle cloud HCM SQL

                                        Current User Person ID - SQL

Below is the SQL to get the  login / Session user person Id in oracle cloud HCM :

HRC_SESSION_UTIL.GET_USER_PERSONID

Ex:

SELECT HRC_SESSION_UTIL.GET_USER_PERSONID FROM DUAL

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath

SQL to get the UDT values

                                              SQL to get the UDT value

select

fuci.value

from

ff_user_tables fut

,ff_user_column_instances_f fuci

,ff_user_columns fuc

,ff_user_columns_tl fuct

,ff_user_rows_f furf

where 1=1

and fut.user_table_id = fuc.user_table_id

and fuc.user_column_id = fuct.user_column_id

and fut.user_table_id = furf.user_table_id

and fuci.user_row_id = furf.user_row_id

and fuci.user_column_id = fuct.user_column_id

and fut.BASE_USER_TABLE_NAME ='TABLE_NAME'

and fuct.USER_COLUMN_NAME IN ('COLUMN_NAME')

and furf.ROW_LOW_RANGE_OR_NAME IN ('ROW_NAMES')

--and to_number(:{PARAMETER.value})  between (cast(furf.ROW_LOW_RANGE_OR_NAME as float))  and furf.ROW_HIGH_RANGE

--and to_number(:{PARAMETER.value})  between furf.ROW_LOW_RANGE_OR_NAME and furf.ROW_HIGH_RANGE

order by furf.DISPLAY_SEQUENCE

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath

Get UDT Information from SQL

                                            Get UDT(USER DEFINED TABLE) Information from SQL

 

UDT Table:

SELECT

 fut.user_table_name

,fut.base_user_table_name

,fut.range_or_match

,fut.user_key_units

,fut.user_table_id p_user_table_id

,ldg.name ldg_name

,'UserDefinedTable' metadata

FROM

 ff_user_tables_vl fut

,per_legislative_data_groups_vl ldg

WHERE 1=1

--AND fut.legislative_data_group_id = ldg.legislative_data_group_id

AND fut.user_table_id = :P_UDT

 

UDT Column:

SELECT

 fuc.user_column_name

,fuc.base_user_column_name

,fuc.data_type

,fuc.formula_id

,'UserDefinedTableColumn' metadata

FROM

 ff_user_columns_vl fuc

WHERE 1=1

AND fuc.user_table_id = :P_USER_TABLE_ID

 

 

 

UDT Rows:

SELECT

 fur.row_name

,fur.display_sequence

,TO_CHAR(fur.effective_start_date,'YYYY/MM/DD') row_effective_start_date

,TO_CHAR(fur.effective_end_date,'YYYY/MM/DD') row_effective_end_date

-- ,fur.row_high_range

-- ,fur.row_low_range_or_name

 

,DECODE(fut.range_or_match,'M','',fur.row_high_range)              row_high_range

,DECODE(fut.range_or_match,'M',fur.row_name,fur.row_low_range_or_name)              row_low_range_or_name

 

,'UserDefinedTableRow' metadata

FROM

ff_user_tables_vl fut

,ff_user_rows_vl fur

WHERE 1=1

AND fur.user_table_id = :P_USER_TABLE_ID

AND fut.user_table_id = fur.user_table_id

 

Column Instance:

SELECT

'UserDefinedTableColumnInstance' metadata

,fut.user_table_name

,fut.base_user_table_name

,fut.range_or_match

,fut.user_key_units

,display_sequence

,fur.row_name

,TO_CHAR(fur.effective_start_date,'YYYY/MM/DD') row_effective_start_date

,TO_CHAR(fur.effective_end_date,'YYYY/MM/DD') row_effective_end_date

,fur.row_high_range

,fur.row_low_range_or_name

,fuc.user_column_name

,fuc.base_user_column_name

,fuc.data_type

,fuc.formula_id

,fuci.value udt_value

,TO_CHAR(fuci.effective_start_date,'YYYY/MM/DD') col_inst_eff_start_date

,TO_CHAR(fuci.effective_end_date,'YYYY/MM/DD') col_inst_eff_end_date

FROM

 fusion.ff_user_tables_vl fut

,fusion.ff_user_columns_vl fuc

,fusion.ff_user_rows_vl fur

,fusion.ff_user_column_instances_f fuci

WHERE 1=1

--AND (fut.legislative_data_group_id = :P_LDG OR :P_LDG  IS NULL)

AND fut.user_table_id = :P_USER_TABLE_ID

AND fut.user_table_id = fuc.user_table_id

AND fut.user_table_id = fur.user_table_id

AND TRUNC(SYSDATE) BETWEEN fur.effective_start_date AND fur.effective_end_date

AND fuc.user_column_id = fuci.user_column_id

AND fur.user_row_id = fuci.user_row_id

AND TRUNC(SYSDATE) BETWEEN fuci.effective_start_date AND fuci.effective_end_date

 

Parameter(P_USER_TABLE_ID) LOV SQL for above SQL:

SELECT

user_table_name

,user_table_id

FROM

ff_user_tables_vl

 

UDT HDL Format Report:

 https://drive.google.com/file/d/1gnkepEqUgAQj657U0K20Owl-l_Ui4BZV/view?usp=sharing 

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath