Introduction 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 MoreDECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…
Read More