Sample Script to Schedule concurrent program from back end Procedure xxTTK_schedule_prog is l_conc_id VARCHAR2(500); l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id NUMBER; l_conc_id1 number; l_language VARCHAR2(50); l_territory VARCHAR2(50); l_option_return BOOLEAN;…
Read MoreQuery to find GL Period status SELECT * FROM gl_period_statuses ps, gl_sets_of_books sob, fnd_application_vl fnd WHERE 1=1 and ps.application_id = 101 AND sob.set_of_books_id = (SELECT set_of_books_id FROM org_organization_definitions WHERE ORGANIZATION_CODE…
Read MoreQuery to find Sales Person SELECT hcsu.primary_salesrep_id FROM hz_cust_accounts hca, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE hca.cust_account_id = 940301 AND hca.cust_account_id = hcas.cust_account_id AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id AND hcsu.site_use_code = ‘BILL_TO’…
Read MoreThe landlord has been waiting for us in the house. When we arrived, she was very enthusiastic about introducing us to the interior of the house. The facilities https://rehabliving.net/ inside…
Read MoreQuery to find Third Party Registration SELECT DISTINCT TRIM (TO_CHAR (b.registration_number)) gst_num INTO lv_gst_num FROM jai_party_regs a, jai_party_reg_lines b WHERE 1 = 1 AND a.party_reg_id = b.party_reg_id AND a.party_type_code =…
Read MoreORACLE WEBLOGIC SERVER (WLS) 10.3.6.0.7 — 10.3.6.0.191015: …
Read MoreScript to OE_ORDER_PUB.PROCESS_ORDER ( Sample Script Create Sales Order ) Script PROCEDURE xx_bdg_so_interface ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) IS v_api_version_number NUMBER := 1; v_return_status VARCHAR2…
Read More1. Overview This document talks about how to remove the options from the interactive grid action menus. 2. Technologies and Tools Used The following technologies have been used to achieve…
Read More1. Overview When using Interactive grid, sometimes user don’t want to go with add row button for a new row generation. On those cases, this document shows, how to generate…
Read MoreDescription: The oracle OS user does not have the appropriate privileges on the OS directory, or if the path specified in the database does not match to an actual path,…
Read More