ORA-02304: invalid object identifier literal
ORA-02304: invalid object identifier literal Cause: An attempt was made to enter an object identifier literal for CREATE TYPEthat is either: – not a string of 32 hexadecimal characters –…
Read MoreORA-02266: unique/primary keys in table referenced by enabled foreign key
ORA-02266: unique/primary keys in table referenced by enabled foreign key Cause: An attempt was made to truncate a table with unique or primary keysreferenced by foreign keys enabled in another…
Read MoreInventory Location,Item Master Organization,Inventory, Sub Inventory Item Class and Item Creation
Inventory Location,Item Master Organization,Inventory, Sub Inventory Item Class and Item Creation Step 1: Login as Application User Step 2: you will be in home page as below Step 3: we…
Read MoreFusion HCM – Query for Element Entry Details
SELECT * FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, per_person_types_tl per_typ, per_legal_employers ple, pay_rel_groups_dn payrel, pay_assigned_payrolls_dn papd, pay_all_payrolls_f pay, pay_element_entry_values_f peevf, pay_input_values_f pivf, pay_element_entries_f peef, pay_element_types_f petf, pay_entry_usages…
Read MoreFusion HCM – Query for Personal Payment Method Details
SELECT per_pay.* FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, pay_pay_relationships_dn pay_rel, pay_personal_payment_methods_f per_pay, pay_org_pay_methods_f org_pay, pay_bank_accounts bnk_act, per_legislative_data_groups ldg, per_person_types_tl per_typ, per_legal_employers ple WHERE asg.person_id = peo.person_id AND ser.person_id…
Read MoreFusion HCM – Query for OTL Time Entries Details
SELECT papf.person_number emp_id, TO_DATE (TO_CHAR (sh21.start_time, ‘DD/MM/YYYY’), ‘DD/MM/YYYY’ ) start_time, TO_DATE (TO_CHAR (sh21.stop_time, ‘DD/MM/YYYY’), ‘DD/MM/YYYY’ ) stop_time, sh26.attribute_category elements, sh27.status_value, ROUND (SUM (sh21.measure), 2) measure FROM per_all_people_f papf, per_all_assignments_m asg, …
Read MoreFusion HCM – Query for Absence Accrual Balance
SELECT peo.person_number emp_id, aapft.NAME absence_plan_name, acc_ent.end_bal balance FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, per_person_types_tl per_typ, per_legal_employers ple, anc_absence_plans_f_tl aapft, anc_absence_plans_f aapf, anc_per_accrual_entries acc_ent WHERE asg.person_id = peo.person_id AND…
Read More