Oracle Certification exams

Exam Code Exam Name:-

1z0-001 Introduction to Oracle: SQL and PL/SQL
1z0-007 Introduction to Oracle9i: SQL
1z0-013 Oracle8: Database Administration
1z0-014 Oracle8: Performance Tuning
1z0-016 Oracle8: Network Administration
1z0-020 Oracle8i: New Features for Administrators
1z0-023 Architecture and Administration
1z0-024 Performance Tuning
1z0-025 Backup and Recovery
1z0-026 Network Administration
1z0-030 Oracle9i: New Features for Administrators
1z0-031 Oracle9i:Database Fundamentals I
1z0-032 Oracle9i:Database Fundamentals II
1z0-033 Oracle9i:Performance Tuning
1z0-035 Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade
1z0-036 Managing Oracle 9i on Linux
1z0-040 Oracle Database 10g: New Features for Administrators
1z0-041 Oracle Database 10g: DBA Assessment
1z0-042 Oracle Database 10g: Administration I
1z0-043 Oracle Database 10g: Administration II
1z0-045 Oracle Database 10g: New Features for Oracle8i OCPs
1z0-046 Oracle Datebase 10g: Managing Oracle on Linux for DBAs
1z0-047 Oracle Database SQL Expert
1z0-048 Oracle Database 10g R2: Administering RAC
1z0-050 Oracle Database 11g: New Features for Administrators
1z0-051 Oracle Database: SQL Fundamentals I
1z0-052 Oracle Database 11g: Administration I
1z0-055 Oracle Database 11g: New Features for 9i OCPs
1z0-101 Develop PL/SQL Program Units
1z0-108 Oracle WebLogic Server 10g System Administration
1z0-121 Developer/2000: Build Forms I
1z0-122 Developer/2000: Build Forms II
1z0-123 Developer/2000: Build Reports
1z0-131 Oracle9i, Build Internet Applications I
1z0-132 Oracle9i, Build Internet Applications II
1z0-140 Oracle9i Forms Developer: New Features
1z0-141 Oracle9i Forms Developer: Build Internet Applications
1z0-146 Oracle Database 11g: Advanced PL/SQL
1z0-147 Oracle9i: Program with PL/SQL
1z0-200 Oracle 11i E-Business Essentials
1z0-202 Siebel 8 Consultant Exam
1z0-204 Oracle EBS R12: E-Business Essentials
1z0-208 Oracle Comm. Billing and Revenue Management: Server Developer
1z0-209 Oracle Comm. Billing & Revenue Mgmt: Server Administrator
1z0-211 Oracle 11i General Ledger
1z0-212 Oracle Payables 11i Fundamentals
1z0-213 Oracle Receivables 11i Fundamentals
1z0-216 Oracle EBS R12: General Ledger and Receivables Fundamentals
1z0-221 Oracle 11i Inventory Management Fundamentals
1z0-222 Oracle Purchasing 11i Fundamentals
1z0-223 Oracle Order Management 11i Fundamentals
1z0-231 Implement Oracle Workflow 11i
1z0-232 Oracle 11i Systems Administrator
1z0-233 Oracle 11i Install, Patch and Maintain Applications
1z0-235 Oracle 11i Applications DBA:Fundamentals I
1z0-236 11i Applications DBA Fundamentals II
1z0-241 PeopleSoft Application Developer I: People Tools & PeopleCode
1z0-242 PeopleSoft Application Developer II: Application Engine & Integration
1z0-255 Hyperion Essbase 7.1.2 Consultant
1Z0-257 Hyperion Financial Management4.1 Consultant
1z0-259 Hyperion Planning 4.1 Consultant
1z0-264 Hyperion Essbase Analytics9.3 Developer
1z0-265 Hyperion BI+ 9.3 Administrator
1z0-271 Hyperion Financial Management9.3 Administrator I&II
1z0-272 Hyperion Planning 9.3 Administrator I&II
1z0-273 Hyperion Financial Management 4.1 Administrator I&II
1z0-301 Oracle9iAS: Basic Administrations
1z0-311 Oracle Application Server 10g: Administration I
1z0-312 Oracle Application Server 10g:Administration II
1z0-402 Oracle Enterprise Linux: Fundamentals
1z0-403 Enterprise Linux System Administration
1z0-501 Java Certified Programmer
1z0-615 Siebel 7.7 Consultant Core Exam
1z0-640 Siebel 7.7 Analytics Data Warehouse Dev.Prof.Core Exam
1z1-007 Oracle9i SQL
1z1-031 Oracle9i Database Fundamentals
1z1-033 Oracle 9i Performance Tuning

http://www.aiotestking.com/oracle/

the macro cannot be found or has been disabled because of your macro security settings(BI Publisher office 2010 and 2007)

Recently I have upgraded MS Office from 2007 to 2010. As I work on some BI projects, part of mine set of oracle programs is oracle BI Publisher Desktop, which use Word as report template designer. When I run BI Publisher macros in Word 2010 I got following error:

When I google term it seems that all advices were not useful. Here are two most common errors and how should Word be setup correctly:

Templates were correctly enabled:

But in Windows event viewer, curious error was more than obvious:

The solution

The solution shown here really works (tested on several computers), so I'm writing this down to be more like documentation for future reference to anyone stack on this case. Idea is to remove old *.EXD files from any location in %USERPROFILE% folders that might exists.

Because mine praxis is to have separate %USERPROFILE% folder location then where are OS files (different then partition then C:), exd file was found as shown. In mine case it was only in one folder:

D:\Users\DamirV\Application Data\Microsoft\Forms>dir

Volume in drive D is Data

Volume Serial Number is 505E-794F

Directory of D:\Users\DamirV\Application Data\Microsoft\Forms

01.02.2011  11:45    <DIR>          .

01.02.2011  11:45    <DIR>          ..

12.03.2009  15:17           165.808 MSComctlLib.exd

31.08.2010  10:34            11.776 WINPROJ.box

01.02.2011  11:19             7.168 WINWORD.box

3 File(s)        184.752 bytes

2 Dir(s)  51.699.859.456 bytes free

D:\Users\DamirV\Application Data\Microsoft\Forms>

So all you have to do is:

Rename existing "MSComctlLib.exd" file to "MSComctlLib.exd_bak"

Open Word 2010

Open menu Add-Ins|Oracle BI Publisher|Log On

Last action will create new MSComctlLib.exd file in background:

D:\Users\DamirV\Application Data\Microsoft\Forms>dir

Volume in drive D is Data

Volume Serial Number is 505E-794F

Directory of D:\Users\DamirV\Application Data\Microsoft\Forms

01.02.2011  11:45    <DIR>          .

01.02.2011  11:45    <DIR>          ..

01.02.2011  13:51           167.456 MSComctlLib.exd

12.03.2009  15:17           165.808 MSComctlLib.exd_old

31.08.2010  10:34            11.776 WINPROJ.box

01.02.2011  11:19             7.168 WINWORD.box

3 File(s)        184.752 bytes

2 Dir(s)  51.699.859.456 bytes free

D:\Users\DamirV\Application Data\Microsoft\Forms>

Notice different file size and file date of "MSComctlLib.exd". This is now Office 2010 version of EXD file which was not able to be created because of previous version. And that is all.

The EndIf you have upgraded several Office versions (i.e. 2000->2003->2007->2010), you might find ".EXD" files as well in following folders:

%USERPROFILE%\Application Data\Microsoft\Forms

%USERPROFILE%\Local Settings\Temp\Excel8.0

%USERPROFILE%\Local Settings\Temp\VBE

%USERPROFILE%\Local Settings\Temp\Word8.0

Like in previous example rename them and later (when you are sure that all works) you may delete.

Hope this helps!

Cheers!

Post festum part-IMPORTANT!!!

I have received many asks that people complaint about this issue was resolved and later after some Windows updates, all is back to same problem.

For them I have wrote this part what should help them.

Again first step is to rename all .exd files.

For 64-bit operating systems, type the following:

Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX"

For 32-bit operating systems, type the following:

Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"

Restart your machine.

AR SLA Queries for PSA tables

Below are the queries for AR. Pass on to the team members if anyone needs they can use for remediating AR objects.

-- AR Transactions

SELECT rct.trx_number,

       rct.customer_trx_id,

       rctd.cust_trx_line_gl_dist_id,

       xal.entered_dr,

       xal.entered_cr,

       xal.code_combination_id,

       xah.event_id,

       xal.ae_header_id

  FROM ra_customer_trx_all rct,

       ra_customer_trx_lines_all rctl,

       ra_cust_trx_line_gl_dist_all rctd,

       xla_ae_headers xah,

       xla_ae_lines xal,

       xla_events xet,

       xla_distribution_links xdl

WHERE     xal.ae_header_id = xah.ae_header_id

       AND xet.event_id = xah.event_id

       AND xdl.event_id = xet.event_id

       AND xdl.ae_header_id = xah.ae_header_id

       AND xdl.ae_line_num = xal.ae_line_num

       AND xdl.application_id = 222

       AND xdl.source_distribution_type IN ('RA_CUST_TRX_LINE_GL_DIST_ALL',

                                            'MFAR_DISTRIBUTIONS_ALL')

       AND xdl.source_distribution_id_num_1 = rctd.CUST_TRX_LINE_GL_DIST_ID

       AND rctl.customer_trx_line_id = rctd.customer_trx_line_id

       AND rct.customer_trx_id = rctl.customer_trx_id

       AND rct.trx_number = :p_trx_number;

       -- AR adjustments

SELECT rct.trx_number,

       adj.customer_trx_id,

       adj.adjustment_id,

       xal.entered_dr,

       xal.entered_cr,

       xal.code_combination_id,

       xah.event_id,

       xal.ae_header_id

  FROM ra_customer_trx_all rct,

       ar_adjustments_all adj,

       ar_distributions_all ard,

       xla_ae_headers xah,

       xla_ae_lines xal,

       xla_events xet,

       xla_distribution_links xdl

WHERE     xal.ae_header_id = xah.ae_header_id

       AND xet.event_id = xah.event_id

       AND xdl.event_id = xet.event_id

       AND xdl.ae_header_id = xah.ae_header_id

       AND xdl.ae_line_num = xal.ae_line_num

       AND xdl.application_id = 222

       AND xdl.source_distribution_type IN ('AR_DISTRIBUTIONS_ALL',

                                            'MFAR_DISTRIBUTIONS_ALL')

       AND xdl.source_distribution_id_num_1 = ard.line_id

       AND ard.source_table = 'ADJ'

       AND ard.source_id = adj.adjustment_id

       AND adj.adjustment_id = :p_adj_id

       AND rct.customer_trx_id = adj.customer_trx_id

       AND rct.trx_number = :p_trx_number;

-- Misc Receipts

SELECT cr.receipt_number,

       cr.cash_receipt_id,

       arm.misc_cash_distribution_id,

       xal.entered_dr,

       xal.entered_cr,

       xal.code_combination_id,

       xah.event_id,

       xal.ae_header_id

  FROM ar_cash_receipts_all cr,

       ar_misc_cash_distributions_all arm,

       ar_distributions_all ard,

       xla_ae_headers xah,

       xla_ae_lines xal,

       xla_events xet,

       xla_distribution_links xdl

WHERE     xal.ae_header_id = xah.ae_header_id

       AND xet.event_id = xah.event_id

       AND xdl.event_id = xet.event_id

       AND xdl.ae_header_id = xah.ae_header_id

       AND xdl.ae_line_num = xal.ae_line_num

       AND xdl.source_distribution_type IN ('AR_DISTRIBUTIONS_ALL',

                                            'MFAR_DISTRIBUTIONS_ALL')

       AND xdl.source_distribution_id_num_1 = ard.line_id

       AND ard.source_id = arm.misc_cash_distribution_id

       AND ard.source_table = 'MCD'

       AND xdl.application_id = 222

       AND arm.cash_receipt_id = cr.cash_receipt_id

       AND cr.cash_receipt_id = :receipt_id;

       -- CASH Receipts

SELECT cr.receipt_number,

       cr.cash_receipt_id,

       arp.receivable_application_id,

       xal.entered_dr,

       xal.entered_cr,

       xal.code_combination_id,

       xah.event_id,

       xal.ae_header_id

  FROM ar_cash_receipts_all cr,

       ar_receivable_applications_all arp,

       ar_distributions_all ard,

       xla_ae_headers xah,

       xla_ae_lines xal,

       xla_events xet,

       xla_distribution_links xdl,

       gl_code_combinations gcc

WHERE     xal.ae_header_id = xah.ae_header_id

       AND xet.event_id = xah.event_id

       AND xdl.event_id = xet.event_id

       AND xdl.ae_header_id = xah.ae_header_id

       AND xdl.ae_line_num = xal.ae_line_num

       AND xdl.source_distribution_type IN ('AR_DISTRIBUTIONS_ALL',

                                            'MFAR_DISTRIBUTIONS_ALL')

       AND xdl.source_distribution_id_num_1 = ard.line_id

       AND ard.source_id = arp.receivable_application_id

       AND ard.source_table = 'RA'

       AND xdl.application_id = 222

       AND arp.cash_receipt_id = cr.cash_receipt_id

       AND cr.cash_receipt_id = :receipt_id

       AND gcc.code_combination_id = xal.code_combination_id

       AND gcc.segment1 != '00000000000000'