BLOG

COGS (Cost of Goods Sold) in Oracle E-Business Suite Release 12

Deferred COGS is a new feature introduced in Oracle E-Business Suite Release 12. The basic fundamentals behind the enhancement are that the COGS are now directly matched to the Revenue. Prior to this enhancement, the value of goods shipped from inventory were expensed to COGS upon ship confirm, despite the fact that revenue may not […]

Read More

Monitoring Exadata with ASH and AWR

In Oracle 11gR2, additional Exadata cell-related system events have been added to the normal system event-based dynamic performance views. There are 58 different cell-related or Flash Cache related wait events available: SQL> l 1 select name from v$statname 2* where name like ‘%cell%’ or name like ‘%flash cache%’ SQL> / cell physical IO interconnect bytes […]

Read More

MOAC (Multiple Organization Access Control) in Oracle E-Business Suite Release 12

With the release of EBS R12, Oracle has released some new features on how data is accessed through the applications and standard programs by the use of Multiple Organization Access Control (MOAC). MOAC allows you to create a security group which can contain many operating units and assign that to the User’s responsibility. All the […]

Read More

How to Enable Attachments in Oracle E-Business Suite Release 12

Recently on an Oracle EBS R12 project, the client had a requirement to enable the attachment functionality on one of the WIP forms.  I would like to share 4 steps that can be done to enable attachments to work on just about any Oracle EBS form. First, verify that you have the “Application Developer” responsibility […]

Read More

Monitoring Exadata with Statistics

In Oracle 11gR2, additional Exadata cell-related system events have been added to the normal system event-based dynamic performance views. There are 58 different cell-related or Flash Cache related wait events available:   SQL> l 1 select name from v$statname 2* where name like ‘%cell%’ or name like ‘%flash cache%’ SQL> / cell physical IO interconnect […]

Read More

Monitoring Exadata Cell Servers with Metrics

Cell Server Metrics Metrics are recorded observations of run-time properties and internal instrumentation values in the storage cell and its components, such as cells, cell disks, grid disks, etc. CellCLI> list metricdefinition where objectType=’CELLDISK’ <detail> CellCLI> list metricdefinition where objectType=’GRIDDISK’ <detail> The “detail” clause at the end of the listing will show additional details about […]

Read More

Exadata: Using cellcli and dcli

Using CELLCLI Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type “cellcli”. Within cellcli, a wide range of commands can be invoked to monitor the cell. Macintosh-7:~ jclarke$ ssh [email protected] [email protected]’s […]

Read More

Upgrading Exadata to 11.2.0.3 and Applying BP14

Upgrading Exadata to 11.2.0.3 and Applying Bundle Patch 14 In this blog, I’ll walk you through the abbreviated steps to apply Bundle Patch 14 on our Exadata X2-2 Quarter Rack.  I say “abbreviated” because I’m simply going to bullet all the steps – this is no substitute for reading the various README files. For BP14, […]

Read More

Whatever we ask them to do, we know they'll deliver a solution and not leave us hanging.

Tony Deller Manager Data Center Technical Engineering