Customizing alert box and blur background
1. Overview This document talks about how to customize the alert box and blur the background screen. 2. Technologies and Tools Used The following technologies have been used to validate…
Read MoreInteractive Grid Validations
1. Overview This document talks about how to validate interactive grid columns dynamically using JavaScript. 2. Technologies and Tools Used The following technologies have been used to validate IG columns.…
Read MoreDynamic Column Label Without Page Submit in Oracle Apex
This document is to set dynamic name to columns without submitting the page. Technology and Tool Used : Oracle Apex Javascripts Use Case : If a requirement arise from user to name columns dynamically based on a select list or a value entered by user then we can achieve with the following code. We can achieve this requirement by simply calling the page item. This only works if we submit the page. The following is to provide without submitting the page. Steps to be followed: Step 1 : Create a page item in apex screen. Step 2 : Create a interactive report in the page Step 3 : Now create a on change dynamic action for the select list to execute javascript and paste the below mentioned javascript . var val = $v(‘P1_YEAR’); // P1_YEAR is name of the LOV item $s(‘C387510987662930270_HDR’, ‘Savings Budget For ‘+val); //C387510987662930270_HDR is the HTML ID of the Column Label this can be obtained by right click of the column lable and clicking inspect Step 4 : Now change the LOV and without submitting the page the column name changes
Read MoreSQL for Inactive Customer Open balance
SQL for Inactive Customer Open balance select * from apps.ap_expense_report_headers_all where report_header_id = ”; select * from hz_cust_accounts where account_number like ‘07724.0M978%’; select hca.account_number ,count(rct.trx_number) ,substr(to_char(rct.trx_Date,’DD/MM/YYYY’),4,2) ,sum(rgl.amount) ,sum(amount_due_remaining) OPEN_BL ,sum(rgl.amount)-sum(amount_due_remaining)…
Read MoreSQL to Extract Chart Of Accounts Mapping Records
SQL to Extract Chart Of Accounts Mapping Records- SELECT DISTINCT GL_FV.flex_value source_flex_value, CFH.parent_flex_value, CFH.child_flex_value_low, CFH.child_flex_value_high, GL_CSM.single_value target_flex_value, ‘N’ summary_flag FROM apps.fnd_flex_values GL_FV, apps.gl_cons_flex_hierarchies CFH, apps.gl_cons_segment_map GL_CSM WHERE GL_CSM.coa_mapping_id = 1320…
Read MoreSQL for Customer Accounts with PO and Bill To Location
SQL for Customer Accounts with PO and Bill To Location SELECT hcsa.LOCATION, hca.account_number ,oeh.order_number,oeh.cust_po_number FROM apps.hz_cust_site_uses_all hcsa, apps.hz_cust_acct_sites_all hcas, apps.hz_party_sites hps, apps.hz_parties hp, apps.hz_cust_accounts hca, apps.oe_order_headers_all oeh WHERE 1…
Read MoreSQL for Customer Account with Price List
SQL for Customer Account with Price List select hca.account_number ,hp.party_name , hps.party_site_number –,hl.city –,hl.state ,qplh.name price_list_name ,trim(to_char(qplh.start_date_active,’DD-Month’))||’-‘||trim(to_char(qplh.start_date_active,’YYYY’)) price_list_effective_date –,qplh.end_date_active ,msib.segment1 bill_code ,msib.description Bill_code_desc ,qpll.operand rate from apps.hz_cust_accounts hca , apps.hz_parties…
Read MoreSQL For Period Close Status snapshot for All Ledgers with All Subledgers
SQL For Period Close Status snapshot for All Ledgers with All Subledgers. SELECT (SELECT sob.NAME FROM apps.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) “SOB_Name”, a.period_name “Period_Name”, a.period_num “Period_Num”, a.gl_status “GL_Status”,TO_CHAR(a.LAST_UPDATE_DATE, ‘MM-DD-YY…
Read MorePoints to Consider before Loading Location HDL file in HCM
Here below is the format of the Location HDL file. METADATA|Location|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|ShipToSiteFlag|BillToSiteFlag|OfficeSiteFlag|ReceivingSiteFlag|ShipToLocationCode|ShipToLocationSetCode|InventoryOrganizationName|LocationCode|LocationName|AddressLine1|AddressLine2|AddressLine3|Country|PostalCode|TownOrCity|MainphoneSubscriberNumber|OtherphoneSubscriberNumber|Description|Region1|Region2|Region3|SourceSystemOwner|SourceSystemId MERGE|Location|COMMON|A|1901/01/01|4712/12/31|Y|Y|Y|Y||||00002|New Delih||Janakpuri|New Delhi India|IN|234432|Delhi|||Delhi||||EBS|HCM_LOCTAION_00002_XXTEST Points to Ponder before loading Locations HDL file: 1. SourceSystemOwner and SourceSytemID must be unique…
Read MoreSteps to start admin server on patch file system in r12.2
To start admin server on patch environment forcepatchfs option should be used as below. Source environment $. /data01/fs1/EBSapps/appl/APPS_Jay1.env cd $ADMIN_SCRIPTS_HOME [applmgr@mercury scripts]$ sh adadminsrvctl.sh start forcepatchfs You are running adadminsrvctl.sh…
Read More