By 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 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 MoreSELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,fnd_concurrent_programs_tl fcpt ,fnd_responsibility_tl frt ,fnd_responsibility frs WHERE frgu.unit_application_id = fcp.application_id AND frgu.request_unit_id = fcp.concurrent_program_id AND frg.request_group_id = frgu.request_group_id AND…
Read MoreObjective : Sometimes having a requirement to build the BIP report to display records other than English (ex: Arabic, French, German etc). In Order to build such a report, you…
Read More/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20), tax_reg_num VARCHAR2(50), status VARCHAR2(1), message VARCHAR2(1000)); / set serveroutput on;…
Read More