custom-role-and-custom-lookup-creation-in-fusion This document describes how create a custom role and custom lookup in Oracle Fusion. In this document we have listed all the required setup details with screen shot to…
Read MoreThe below query extracts the error details along with interface attributes of Customer Site Usages import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,site_use.* FROM hz_imp_errors…
Read MoreThe below query extracts the error details along with interface attributes of Customer Sites import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,site.* FROM hz_imp_errors err…
Read MoreThe below query extracts the error details along with interface attributes of Customer Contact Points import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,cpt.* FROM hz_imp_errors…
Read MoreThe below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,acc.* FROM hz_imp_errors err…
Read MoreThis blog contains sample payload to upload an image file in AR invoice attachments in Oracle Fusion Applications. During fusion implementation, we might come across a client requirement to upload…
Read MoreThis blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create Contact of Suppliers and…
Read MoreIntroduction This Post Provides the SQL Query that returns HCM Extract Input Values in BI Report Query SELECT TO_DATE (par_val.flow_param_value, ‘YYYY-MM-DD’) FROM pay_flow_instances flow, pay_flow_parameters flw_par, pay_flow_param_values par_val WHERE…
Read MoreIntroduction This Post Provides the SQL Query that returns Employee’s Supervisor Details Query SELECT papf.person_number employee_number, ppnf.full_name employee_name, papf_s.person_number manager_emp_number, ppnf_s.full_name manager_name FROM per_all_people_f papf, per_person_names_f ppnf, per_all_assignments_m paam,…
Read MoreIntroduction This Post Provides the Detail to get HCM Extract Input Values in Fast Formula Sample Fast Formula PERSON_NUMBER_PARAM = GET_PARAMETER_VALUE(‘PERSON_NUMBER’) CHANGES_ONLY_PARAM = GET_PARAMETER_VALUE(‘CHANGES_ONLY’) EFFECTIVE_DATE_PARAM = GET_PARAMETER_VALUE(‘EFFECTIVE_DATE’) L_VALUE =…
Read More