Correct calculate # of processors and processing unit size Subledger Accounting for OPM
Correct calculate # of processors and processing unit size:
CPU =40
Core =20
Sockets =2
Ram = 128 Physical
SELECT COUNT(DISTINCT xte.entity_id)
FROM xla_events xe
, xla.xla_transaction_entities xte
WHERE xe.application_id = :p_application_id
AND xe.event_status_code IN ('U','N')
AND xe.process_status_code IN ('U','I','E','R','D')
AND xe.event_date <= To_Date('09/01/2014'||' 23:59:59','MM/DD/YYYY hh24:mi:ss')--replace with create_accounting_end_date
AND xe.application_id = xte.application_id
AND xte.entity_code <> 'MANUAL'
AND xte.ledger_id = &primary_ledger_id
AND xe.entity_id = xte.entity_id;