select SEGMENT1 Company, apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id 1, —– Position of segment segment1 —- Segment value ) Company_desc, SEGMENT2 Location, apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id 2, —–…
Read MoreSELECT TO_CHAR(hca.account_number) account_number, ( SELECT name FROM apps.hr_operating_units hou WHERE hou.organization_id = hcasa.org_id ) organization_name, hca.status account_status, hl.address1, hl.address2, hl.address3, hl.address4, hl.city, hl.postal_code, hl.state, hl.province, hl.county, hl.country, hcsua.site_use_code business_purpose, hcsua.location…
Read Moreselect (SELECT hou.NAME FROM apps.hr_operating_units hou WHERE 1 = 1 AND hou.organization_id = aps.org_id ) ou_name, (SELECT paym.payment_method_code FROM APPS.iby_ext_party_pmt_mthds paym WHERE IEPA.ext_payee_id = paym.ext_pmt_party_id and aps.vendor_site_id = iepa.supplier_site_id –AND…
Read MoreSELECT DISTINCT rcta.trx_number invoice_number, –gd.gl_date, hp.party_name customer_name, rctla.line_number, rctla.description, rctla.uom_code, rctla.quantity_invoiced qty, rctla.unit_selling_price unit_price, rctla.revenue_amount amount, ( SELECT jtl.tax_rate_percentage FROM apps.jai_tax_lines jtl WHERE rcta.trx_number = jtl.trx_number AND rctla.line_number = jtl.trx_line_number…
Read MoreSELECT gjst.user_je_source_name source, ( SELECT gjct.user_je_category_name FROM apps.gl_je_categories_tl gjct WHERE gjh.je_category = gjct.je_category_name AND language = ‘US’ ) category, gjh.name batch_name, gjh.description header_description, gjl.je_line_num, gjl.description line_description, CASE WHEN gjl.entered_dr IS…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER. cbv.address_line1,…
Read MoreINTRODUCTION This blog explains how we cancel approved requisition in oracle apps PROCEDURE CANCEL_REQUISITION (P_BATCH_RUN_ID IN NUMBER,P_REQUISITION_NO IN VARCHAR) AS X_REQ_CONTROL_ERROR_RC VARCHAR2(500); LN_USER_ID NUMBER; …
Read MoreINTRODUCTION This blog explains how we validate Third Party Registration in oracle apps –****************************************************** — Checking Third Party Registration(GST) –****************************************************** BEGIN SELECT DISTINCT TRIM (TO_CHAR…
Read MoreINTRODUCTION This blog explains how we validate Bill to customer in oracle apps –****************************************************** — Bill To Customer Address Validation –****************************************************** BEGIN SELECT hcas.cust_acct_site_id –hcsu.site_use_id …
Read MoreCategory Location Start/Stop Logfiles $INST_TOP/logs/appl/admin/log Log files for OPMN and OHS processes $IAS_ORACLE_HOME/ instances//diagnostics/logs Weblogic Nodemanager $FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log Apache Logs $IAS_ORACLE_HOME/instances//diagnostics/logs/OHS/EBS_web_/*log OPMN Logs $IAS_ORACLE_HOME/instances//diagnostics/logs/OPMN/opmn/ Weblogic Logs $IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager $EBS_DOMAIN_HOME/servers/oa/logs/ $EBS_DOMAIN_HOME/servers/forms/logs/ $EBS_DOMAIN_HOME/servers/AdminServer/logs/* $EBS_DOMAIN_HOME/sysman/log/*
Read More