Intro:-This script will provide all related Bom Routing department details. Code:- SELECT xep.legal_entity_id “Legal Entity ID”, xep.name “Legal Entity”, hr_outl.name “Organization Name”, hr_outl.organization_id “Organization ID”, …
Read MoreIntro:-This script will provide all related Form Personalization details. Code:- SELECT ffv.form_id “Form ID”, ffv.form_name “Form Name”, ffv.user_form_name “User Form Name”, ffv.description “Form Description”, …
Read MoreExternal table Data load with Delimiter Introduction: to upload the data with the delimiter and special character. Cause of the issue: In the control file having issue to load…
Read MoreFeature Oracle Database 12c, 19c, 21c Introduction: Oracle is by far the leader in all key leading research reports for On-prem and Cloud Database Management Systems. Oracle is…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data Organization contact details. Cause of the issue: Business wants to reach the organization contact…
Read MoreIntroduction: This blog has the SQL loader using external Table. Cause of the issue: Business wants to load the data with a field having multiple line we can use this…
Read MoreSample 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 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 More