Query: SELECT pu.username,prdt.role_id, prdt.role_name, prd.role_common_name FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd WHERE pu.user_id = pur.user_id AND pu.username = <:P_USERNAME> AND prdt.role_id = pur.role_id AND prdt.role_id = prd.role_id…
Read MoreOverview : Below query to give the organization information in Fusion Query: SELECT hra.organization_id as bu_id ,hro.name organization_name ,hra.business_group_id, hro.* FROM HR_ALL_ORGANIZATION_UNITS_F hra, HR_ORGANIZATION_UNITS_F_TL hro WHERE 1=1 hra.ORGANIZATION_ID =…
Read MoreIntroduction This Query will help to Fetch the IPV Report Data in Oracle Apps. SQL Query: BEGIN fnd_client_info.set_org_context (:p_org); END; SELECT glps.set_of_books_id, msi.organization_id, pov.vendor_id, glps.period_name, api.invoice_num invoice_num, aid.accounting_date invoice_date, DECODE…
Read MoreWhen attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The Forms Client has attempted to reestablish its…
Read MoreBy using below command in controller, we can able to set default value to message Text Input. import oracle.apps.fnd.framework.webui.beans.message.OAMessageTextInputBean; public void processRequest(OssAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String…
Read MoreIntroduction This Query will help to Fetch the Unapplied Receipts Report Data SQL Query: SELECT COMPANY COMPANY, CASE WHEN CUSTOMER_NAME IS NULL THEN ‘ **** Unidentified’ ELSE CUSTOMER_NAME END CUSTOMER_NAME,…
Read MorePlease make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…
Read MoreIntroduction: AP-query to get List of Suppliers which have not made payments since 2 years in Oracle EBS either invoice or payment. Query: select distinct a.vendor_id, b.ORG_ID, a.segment1 SUPPLIER_NUMBER, a.VENDOR_TYPE_LOOKUP_CODE…
Read MoreObjective: Post doing the conversion in Fusion HCM, it is important to reconcile the match between the conversion records and loaded records. In order to match the records, you have…
Read MoreObjective: Post doing the conversion in Fusion HCM, it is important to reconcile the match between the conversion records and loaded records. In order to match the records, you have…
Read More