Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Home

About Me

Technically-sophisticated professional with extensive experience in updating server security, executing routine back-ups, and designing and implementing tests of the system to address issues with accessing data

  • Adept at leading the planning, designing, developing, testing, and deploying efficient solutions within Oracle EBS system, in order to satisfy strategic, financial, and operations needs of the organization.
  • Skilled in planning and managing successful projects, mitigating risks, controlling costs, and directing project teams. Instrumental in monitoring routine maintenance of system, implementing the ERP systems, and approving budget.
  • Proven success in analyzing business processes/process re-engineering and recommending solutions. Deft at establishing IT service continuity management strategies, disaster recovery plans and associated test procedures of each critical functional area of the organization.
  • Age: 36
  • Residence: Pakistan
  • Freelance: Available
  • Address: Karachi, PAKISTAN
My Services
Oracle E-Business Suite Upgrade
Oracle E-Business Suite Migration
Oracle Database Upgrade or Migrate
Oracle Maximum Availability Architecture
Performance Evaluation
Pricing
Hire Me On Upwork
$ 35 Hour
  • Database Administration
  • Oracle E-Business Suite Administration
  • Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management
Hire Me on Fiverr
$ 35 Hour
  • Database Administration
  • Oracle E-Business Suite Administration
  • Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management
Hire Team
$ 40 Hour
  • Database Administration
  • Oracle E-Business Suite Administration
  • Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Resume

Resume
Experience
Senior Apps DBA
2022- Present
Senior Apps DBA
Computer & Systems Engineering Company
My role includes infrastructure support, capacity planning, installation, configuration, database design, and migration, up gradation, performance monitoring, security,  database backups, data recovery plan, and procedures including application server administration
Lead Infrastructure Consultant
2020-2021
Lead Infrastructure Consultant
ITANZ Group
Managed Oracle cloud infrastructure, compute, storage, networking, connectivity, and edge service, database management, analytics, integration, and Oracle weblogic clustering environment over Oracle Cloud IAAS.  Collaborated with the Oracle corporation staff for offering technical support to diagnose and troubleshoot common problems.
Professional Freelancer
2020 - 2022
Professional Freelancer
Upwork Inc.
Collaborated with Clients for the Task Related to Oracle Database, Oracle E-Business Suite, Oracle Cloud Infrastructure, Oracle Weblogic
Assistant Director (Databases)
2015-2020
Assistant Director (Databases)
Pakistan Civil Aviation Authority
Managed ERP for implementing the structures effectively, while limiting the resources consumed in the planning process. Improved IT/business processes and investigations to resolve the user’s issues as well as offered user’s training to help the user in operating the system in efficient way.
Education
Newports Institute Of Communication & Economics
2008 - 2011
Newports Institute Of Communication & Economics
Pakistan

Newports Institute Of Communication & Economics offers a B.S. in Computer Science.

Certificate
Oracle University
2013
Oracle University
USA

Oracle E-Business Suite R12 Financials Certified Expert  Consultant, PAYABLES 

Certificate
Oracle University
2014
Oracle University
USA

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional 

Certificate
Oracle University
2011
Oracle University
USA

Oracle Database 11g Administrator Certified Professional 

Certificate
Skills
Oracle Expertise
  • Oracle Databases
  • Oracle E-Business Suite
  • Oracle Weblogic
  • Oracle Cloud Infrastructure
  • Oracle Database Appliances
Languages
  • English
System
  • Linux
    90%
  • Microsoft
    75%
  • SOLARIS
    65%
  • AIX
    60%
Knowledge
  • Installation/Configuration
  • Capacity Planning
  • Data Recovery Plan
  • Oracle Database Migration and Upgrade
  • Oracle ERP Migration and Upgrade
  • Linux and Windows management
  • Performance Evaluation

Blog

November 1, 2017 A Brief Introduction to ADPatch
APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

A Brief Introduction to ADPatch

AutoPatch (adpatch)

“AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.”

 

Modes Of adpatch

There Are Four Modes given Below In which ADpatch Can Be User

  1. Interactive mode
  2. Non-Interactive mode
  3. Test mode
  4. Pre-Install mode

 

Interactive Mode

It is the default mode of ADpatch. We can apply patch in this mode by going into patch directory and simply type adpatch in command prompt and hit enter.

 

Non-Interactive

You can apply Patch in this mode as:

$adpatch Interactive=no

It uses default files to store prompt values and can be applied from patch directory.

 

Test Mode

This mode is purposely used to check what exactly patch will do without actually changing anything.

We can apply patch in this mode as:

$adpatch apply=no

By default apply=yes

 

PreInstall Mode

This mode is used for any upgrade or consolidated update of utilities itself. It is suggested to apply pre-install patch first.

When we apply patch in preinstall mode, it updates all AD utilities before upgrade or update.

We can apply adpatch in this mode as:

$adpatch preinstall=y

 

Options used in adpatch

We have multiple adpatch options and based on the requirement we can use specific options.

Noautoconfig

This options is used to skip the autoconfig execution, whereas by default it executes the autoconfig and updates the configuration file if any template file is added. This option is helpful when we apply multiple adpatch and they are not merged.

$adpatch options=noautoconfig

 

Nocompiledb(without compiling database)

While we apply adpatch, It may create invalid objects and by default adpatch compiles the invalid objects after patch application. But in case you do not want to compile invalid objects to ensure the minimal autopatch time, you can apply adpatch as below:

$adpatch options=nocompiledb

 

Nocopyportion

This option is used to apply adpatch without copying the files present in copy driver. This can be applies as:

$adpatch options=nocopyportion

 

Nocompilejsp

Adpatch also compiles the java server pages(JSP) after completion of patch application and can be skipped using the option nocompilejsp as below:

$adpatch options=nocompilejsp

 

Nodatabaseportion

Nodatabaseportion option is used to skip the adpatch the activity of database driver. It can be used as:

$adpatch options=nodatabaseportion

 

Nogenerateportion

Nogenerateportion option is used to skip the adpatch activity of generate driver portion of the patch  and you can use the option nogenerateportion as below:

$adpatch options=nogenerateportion

 

Maintenance Mode disabled

This option is used to apply patch without enabling maintenance mode. It can be used as:

$adpatch options=hotpatch

 

Nolink

This option is used to skip the relinking and can be used as:

$adpatch options=nolink

 

Nogenform

This option is used to skip the generate form file. It can be used as:

$adpatch options=nogenform

 

Maintainmrc

This Option is used to execute the maintain MRC schema as part of patch. By default maintain MRC is done for standard patch and is disabled for documentation and translation patches.

$adpatch options=nomaintainmrc

 

Noprereq

This option is used to skip the pre-requisite Checks of Patches. This option can be used as below:

$adpatch options=noprereq

 

 

 

November 1, 2017 How to Check Version of Apache in Oracle Apps?
APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

How to Check Version of Apache in Oracle Apps?

Step 1. Goto Oracle Application Home 

$ cd $IAS_ORACLE_HOME/Apache/Apache/bin/

$ pwd

/apps/ebs/apps/tech_st/10.1.3/Apache/Apache/bin

Step 2. Write httpd -v to fetch the Version Details of Apache

$ httpd -v

Server version: Oracle-Application-Server-10g/10.1.3.0.0 Oracle-HTTP-Server

Server built:   Dec 27 2006 02:31:21

November 1, 2017 How To Find Oracle Database 32 bit or 64 bit
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

How To Find Oracle Database 32 bit or 64 bit

Finding Oracle Database Version on your system through Operating System

$ cd $ORACLE_HOME

$ cd bin

$ file oracle

oracle:         ELF-64 executable object file – IA64

Finding Oracle Database Version on your system through SQL Prompt

SQL> select metadata from sys.kopm$ ;

METADATA

——————————————————————————–

0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405

0607080823472347081123081141B0470083000107D0130000000000000000000000000000000000

0000000000000000000000000000000000000000

Here As you can See the Output Contains B4047 which means Database is 64-Bit Version.

If the Output contains B4023 then the Database is 32-Bit Version.

October 20, 2017 Change Date and Time Formats In Oracle Database?
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Change Date and Time Formats In Oracle Database?

Option 1. If We want to change this format to DD/MONTH/YYYY format.

SQL> alter session set nls_date_format=’DD/MONTH/YYYY’;

Session altered.

SQL> select sysdate from dual;

SYSDATE

—————–

20/OCTOBER  /2017

 

Option 2. If we want get the both date and time

SQL> alter session set nls_date_format=’DD/MONTH/YYYY HH24:MI:SS’;

Session altered.

SQL> select sysdate from dual;

SYSDATE

————————–

20/OCTOBER  /2017 17:19:12 –It is 24 hours format.

 

SQL> alter session set nls_date_format=’DD/MONTH/YYYY HH:MI:SS’;

Session altered.

SQL> select sysdate from dual;

SYSDATE

————————–

20/OCTOBER  /2017 05:19:43  –It is 12 hours format.

 

 

October 20, 2017 Application Names in Oracle E-Business Suite R12
APPS DBAInstallations/Configurations-Applications

Application Names in Oracle E-Business Suite R12

  Application ID Application Name Application Short Name Basepath
1 0 Application Object Library FND FND_TOP
2 1 System Administration SYSADMIN FND_TOP
3 3 Application Utilities AU AU_TOP
4 40 Environment Management System EMS EMS_TOP
5 41 Patch Tracking System PTX PTX_TOP
6 50 Applications DBA AD AD_TOP
7 60 Applications Shared Technology SHT SHT_TOP
8 99 Oracle Applications Manager OAM OAM_TOP
9 101 General Ledger SQLGL GL_TOP
10 140 Assets OFA FA_TOP
11 160 Alert ALR ALR_TOP
12 168 Application Report Generator RG RG_TOP
13 170 Service CS CS_TOP
14 172 Telephony Manager CCT CCT_TOP
15 174 XML Gateway ECX ECX_TOP
16 175 e-Commerce Gateway EC EC_TOP
17 177 iSupplier Portal POS POS_TOP
18 178 Oracle iProcurement ICX ICX_TOP
19 185 Treasury XTR XTR_TOP
20 186 Risk Management QRM QRM_TOP
21 190 Application Implementation AZ AZ_TOP
22 191 Applications BIS BIS BIS_TOP
23 200 Payables SQLAP AP_TOP
24 201 Purchasing PO PO_TOP
25 202 Supplier Scheduling CHV CHV_TOP
26 203 Approvals Management AME AME_TOP
27 204 Legal Entity Configurator XLE XLE_TOP
28 205 iAssets IA IA_TOP
29 206 Loans LNS LNS_TOP
30 207 Oracle Imaging Process Management IPM IPM_TOP
31 210 Enterprise Planning and Budgeting ZPB ZPB_TOP
32 222 Receivables AR AR_TOP
33 230 Internet Procurement Enterprise Connector ITG ITG_TOP
34 231 Web Applications Desktop Integrator BNE BNE_TOP
35 235 E-Business Tax ZX ZX_TOP
36 240 Property Manager PN PN_TOP
37 242 Internal Controls Manager AMW AMW_TOP
38 250 Quality QA QA_TOP
39 260 Cash Management CE CE_TOP
40 265 Report Manager FRM FRM_TOP
41 266 Financial Consolidation Hub GCS GCS_TOP
42 270 SEM Exchange (obsolete) EAA EAA_TOP
43 271 Balanced Scorecard BSC BSC_TOP
44 272 Activity Based Management (Obsolete) ABM ABM_TOP
45 273 Value Based Management EVM EVM_TOP
46 274 Enterprise Performance Foundation FEM FEM_TOP
47 275 Projects PA PA_TOP
48 278 Oracle E-Business Suite Diagnostics IZU IZU_TOP
49 279 Sales Foundation AS AS_TOP
50 280 Sales ASN ASN_TOP
51 283 Incentive Compensation CN CN_TOP
52 298 Exchange POM POM_TOP
53 300 Order Entry OE OE_TOP
54 385 Warehouse Management WMS WMS_TOP
55 388 Manufacturing Scheduling WPS WPS_TOP
56 390 Transportation Planning MST MST_TOP
57 396 Sourcing PON PON_TOP
58 401 Inventory INV INV_TOP
59 403 Mobile Applications for Inventory Management MIA MIA_TOP
60 405 Mobile Applications MWA MWA_TOP
61 407 Manufacturing Mobile Applications WMA WMA_TOP
62 410 Shop Floor Management WSM WSM_TOP
63 415 iSettlement ISX ISX_TOP
64 420 Product Development (obsolete) IPD IPD_TOP
65 425 Mobile Quality Applications MQA MQA_TOP
66 426 Enterprise Asset Management EAM EAM_TOP
67 429 Development DNA DNA_TOP
68 430 CADView-3D DDD DDD_TOP
69 431 Advanced Product Catalog EGO EGO_TOP
70 432 Document Managment and Collaboration DOM DOM_TOP
71 435 Financials Common Modules FUN FUN_TOP
72 436 Utility Billing BLC BLC_TOP
73 437 Regulatory Capital Manager (obsolete) RCM RCM_TOP
74 438 Information Technology Audit ITA ITA_TOP
75 440 Project Portfolio Analysis FPA FPA_TOP
76 450 Financial Intelligence FII FII_TOP
77 451 Operations Intelligence OPI OPI_TOP
78 452 Purchasing Intelligence POA POA_TOP
79 453 Human Resources Intelligence HRI HRI_TOP
80 454 Supply Chain Intelligence ISC ISC_TOP
81 455 Product Intelligence ENI ENI_TOP
82 501 Sales Analysis AN AN_TOP
83 502 Budgeting and Planning PBR PBR_TOP
84 505 Financial Analyzer ZFA ZFA_TOP
85 506 Sales Analyzer ZSA ZSA_TOP
86 507 Oracle Profitability Manager PFT PFT_TOP
87 508 Transfer Pricing FTP FTP_TOP
88 509 Risk Manager RMG RMG_TOP
89 510 Contracts Core OKC OKC_TOP
90 511 Customer Care CSC CSC_TOP
91 512 Depot Repair CSD CSD_TOP
92 513 Field Service CSF CSF_TOP
93 514 Support (obsolete) CSS CSS_TOP
94 515 Service Contracts OKS OKS_TOP
95 516 Controlled Availability Product(Obsolete) ME ME_TOP
96 517 Marketing Intelligence BIM BIM_TOP
97 518 Customer Intelligence (obsolete) BIC BIC_TOP
98 519 Scripting IES IES_TOP
99 520 Marketing Encyclopedia System AMV AMV_TOP
100 521 TeleSales AST AST_TOP
101 522 Sales Online ASF ASF_TOP
102 523 Spares Management CSP CSP_TOP
103 524 Contracts Integration OKX OKX_TOP
104 525 Data Query ODQ ODQ_TOP
105 530 Marketing AMS AMS_TOP
106 531 Marketing for Communications (Obsolete) XNM XNM_TOP
107 532 Sales for Communications (Obsolete) XNC XNC_TOP
108 533 Service for Communications (obsolete) XNS XNS_TOP
109 534 Number Portability XNP XNP_TOP
110 535 Provisioning XDP XDP_TOP
111 536 Service Assurance for Communications XNA XNA_TOP
112 537 TeleBusiness for Telecom/Utilities XNT XNT_TOP
113 538 Banking Center (obsolete) FPT FPT_TOP
114 539 Interaction Center Technology IEO IEO_TOP
115 540 Lease Management OKL OKL_TOP
116 541 Contracts for Rights (Obsolete) OKR OKR_TOP
117 542 Install Base CSI CSI_TOP
118 543 Billing Connect (obsolete) CUE CUE_TOP
119 544 Sales Offline ASL ASL_TOP
120 545 Advanced Outbound Telephony IEC IEC_TOP
121 546 IVR Integrator IEV IEV_TOP
122 547 Call Center Connectors IET IET_TOP
123 548 Predictive IEP IEP_TOP
124 549 Content Manager IBC IBC_TOP
125 550 Process Manufacturing Systems GMA GMA_TOP
126 551 Process Manufacturing Inventory GMI GMI_TOP
127 552 Process Manufacturing Product Development GMD GMD_TOP
128 553 Process Manufacturing Process Execution GME GME_TOP
129 554 Process Manufacturing Process Planning GMP GMP_TOP
130 555 Process Manufacturing Financials GMF GMF_TOP
131 556 Process Manufacturing Logistics GML GML_TOP
132 557 Process Manufacturing Regulatory Management GR GR_TOP
133 558 Process Manufacturing Intelligence PMI PMI_TOP
134 559 Process Manufacturing Portal GMW GMW_TOP
135 560 Manufacturing Execution System for Process Manufacturing GMO GMO_TOP
136 600 Global Accounting Engine AX AX_TOP
137 601 Common Modules-AK AK AK_TOP
138 602 Subledger Accounting XLA XLA_TOP
139 603 XML Publisher XDO XDO_TOP
140 660 Order Management ONT ONT_TOP
141 661 Advanced Pricing QP QP_TOP
142 662 Release Management RLM RLM_TOP
143 663 Automotive VEA VEA_TOP
144 665 Shipping Execution WSH WSH_TOP
145 666 Oracle Web Analytics IBW IBW_TOP
146 670 iMarketing (Obsolete) IBA IBA_TOP
147 671 iStore IBE IBE_TOP
148 672 iSupport IBU IBU_TOP
149 673 Payments IBY IBY_TOP
150 674 Bill Presentment & Payment IBP IBP_TOP
151 675 iAuction IBT IBT_TOP
152 676 Sales Intelligence BIL BIL_TOP
153 677 Interaction Center Intelligence BIX BIX_TOP
154 678 eCommerce Intelligence BIE BIE_TOP
155 679 Communications Intelligence BIN BIN_TOP
156 680 Email Center IEM IEM_TOP
157 681 Trade Planning (Obsolete) OZP OZP_TOP
158 682 Trade Management OZF OZF_TOP
159 683 iClaims (Obsolete) OZS OZS_TOP
160 689 CRM Gateway for Mobile Devices ASG ASG_TOP
161 690 CRM Foundation JTF JTF_TOP
162 691 Partner Management PV PV_TOP
163 694 Proposals PRP PRP_TOP
164 695 Collections IEX IEX_TOP
165 696 Universal Work Queue IEU IEU_TOP
166 697 Order Capture ASO ASO_TOP
167 698 Scheduler CSR CSR_TOP
168 699 Interaction Blending IEB IEB_TOP
169 700 Manufacturing MFG MFG_TOP
170 701 Supply Chain Trading Connector for RosettaNet CLN CLN_TOP
171 702 Bills of Material BOM BOM_TOP
172 703 Engineering ENG ENG_TOP
173 704 Master Scheduling/MRP MRP MRP_TOP
174 705 Capacity CRP CRP_TOP
175 706 Work in Process WIP WIP_TOP
176 707 Cost Management CST BOM_TOP
177 708 Configurator CZ CZ_TOP
178 709 E-Records EDR EDR_TOP
179 710 Release Management Integration Kit (Obsolete) RLA RLA_TOP
180 711 Automotive Integration Kit (Obsolete) VEH VEH_TOP
181 712 Project Manufacturing PJM PJM_TOP
182 714 Flow Manufacturing FLM FLM_TOP
183 716 Transportation Execution FTE FTE_TOP
184 718 Site Management RRS RRS_TOP
185 719 Retail Core RRC RRC_TOP
186 722 Demand Planning MSD MSD_TOP
187 723 Constraint Based Optimization MSO MSO_TOP
188 724 Advanced Supply Chain Planning MSC MSC_TOP
189 725 Advanced Planning Foundation(obsolete) RHX RHX_TOP
190 726 Inventory Optimization MSR MSR_TOP
191 747 Genealogy Intelligence GNI GNI_TOP
192 777 Project Contracts OKE OKE_TOP
193 778 Supply Chain Localizations JMF JMF_TOP
194 800 Human Resources PER PER_TOP
195 801 Payroll PAY PAY_TOP
196 802 FastFormula FF FF_TOP
197 803 DateTrack DT DT_TOP
198 804 SSP SSP SSP_TOP
199 805 Advanced Benefits BEN BEN_TOP
200 808 Time and Labor HXT HXT_TOP
201 809 Time and Labor Engine HXC HXC_TOP
202 810 Learning Management OTA OTA_TOP
203 821 iRecruitment IRC IRC_TOP
204 860 Media Interactive MIV MIV_TOP
205 861 iMeeting (obsolete) IMT IMT_TOP
206 862 Service Intelligence BIV BIV_TOP
207 863 Systems Intelligence BIY BIY_TOP
208 864 Hosting Manager(Obsolete) AHM AHM_TOP
209 865 Contracts for Subscriptions (Obsolete) OKB OKB_TOP
210 866 Citizen Interaction Center CUG CUG_TOP
211 867 Complex Maintenance Repair and Overhaul AHL AHL_TOP
212 868 Field Service/Laptop CSL CSL_TOP
213 869 Oracle Sales for Handhelds ASP ASP_TOP
214 870 Contracts Intelligence OKI OKI_TOP
215 871 Contracts for Sales (Obsolete) OKO OKO_TOP
216 872 Install Base Intelligence (Obsolete) XNI XNI_TOP
217 873 Asset Tracking CSE CSE_TOP
218 874 Mobile Application Foundation JTM JTM_TOP
219 875 CRM Self Service Administration JTS JTS_TOP
220 876 Contracts for Procurement (Obsolete) OKP OKP_TOP
221 877 Royalty Management OKT OKT_TOP
222 878 Digital Asset Management IAM IAM_TOP
223 879 Customers Online IMC IMC_TOP
224 880 Quoting QOT QOT_TOP
225 881 Oracle Telecommunications Billing Integrator XNB XNB_TOP
226 882 Fulfillment Services (Obsolete) AMF AMF_TOP
227 883 Field Service/Palm CSM CSM_TOP
228 1292 Project Intelligence PJI PJI_TOP
229 1776 Obsolete Process Operations DUMMY_GMO DUMMY_GMO_TOP
230 3000 iHCConnect HCC HCC_TOP
231 3001 iHCIntegrate HCN HCN_TOP
232 3002 Clinical Transaction Base CTB CTB_TOP
233 3003 Healthcare Intelligence HCP HCP_TOP
234 3004 Healthcare HCA HCA_TOP
235 3005 Healthcare Terminology Server HCT HCT_TOP
236 3006 Oracle Clinical Data Repository CDR CDR_TOP
237 7000 Asia/Pacific Localizations JA JA_TOP
238 7002 European Localizations JE JE_TOP
239 7003 Regional Localizations JG JG_TOP
240 7004 Latin America Localizations JL JL_TOP
241 8301 US Federal Human Resources GHR GHR_TOP
242 8302 Public Sector HR PQH PQH_TOP
243 8303 Public Sector Payroll PQP PQP_TOP
244 8400 Public Sector Financials International IGI IGI_TOP
245 8401 Public Sector Budgeting PSB PSB_TOP
246 8402 Grants Accounting GMS GMS_TOP
247 8403 Labor Distribution PSP PSP_TOP
248 8404 Grants Proposal IGW IGW_TOP
249 8405 Student System IGS IGS_TOP
250 8406 Financial Aid IGF IGF_TOP
251 8407 Contract Commitment IGC IGC_TOP
252 8450 Public Sector Financials PSA PSA_TOP
253 8721 Capital Resource Logistics – Projects IPA IPA_TOP
254 8722 Network Logistics – Inventory CUI CUI_TOP
255 8723 Network Logistics – Purchasing CUP CUP_TOP
256 8724 Capital Resource Logistics – Financials CUF CUF_TOP
257 8725 Mass Market Receivables for Comms CUR CUR_TOP
258 8726 Revenue Accounting CUC CUC_TOP
259 8727 Network Logistics CUS CUS_TOP
260 8729 Network Logistics – NATS (obsolete) CUN CUN_TOP
261 8731 Capital Resource Logistics – Assets CUA CUA_TOP
262 8901 Federal Financials FV FV_TOP
263 13014 EMEA Consulting Localizations CLE CLE_TOP
264 13015 LAD Consulting Localizations CLL CLL_TOP
265 13016 Japan Consulting Localizations CLJ CLJ_TOP
266 13017 APAC Consulting Localizations CLA CLA_TOP
267 20003 CAA Custom Application XXCAA XXCAA_TOP
268 20090 CPG – CDOA CPGC CPGC_TOP
269 20114 University Curriculum OUC OUC_TOP
270 20139 Public Sector Receivables PSR PSR_TOP
271 20159 test TEST TST_TOP
272 20160 Build/syncronize Contracts Repository Text index OKC_REP_TXT_INDEX_SYNC OKC_TOP
273 20161 Optimize Contracts Repository Text index OKC_REP_TXT_INDEX_OPTIMIZE OKC_TOP
274 20180 Call Center CSN CSN_TOP
275 20200 Team 01 Order Entry Demo DEM01 DEM_TOP
October 20, 2017 How to find the Oracle E-Business Suite R12 application URL?
APPS DBAInstallations/Configurations-Applications

How to find the Oracle E-Business Suite R12 application URL?

$ sqlplus apps/appsdrdg

SQL*Plus: Release 10.2.0.4.0 – Production on Fri Oct 20 16:55:32 2017

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select home_url from icx_parameters;

HOME_URL

——————————————————————————-

http://PROD.EBS.COM:8000/OA_HTML/AppsLogin

Contact

Get in Touch
  • Address: Karachi, PAKISTAN
  • Email: askme@SyedSaadAli.com
  • Phone: +92-300-026-5668
  • Freelance: Available
Contact Form