Process Manufacturing - EBS (MOSC)

MOSC Banner

Correct calculate # of processors and processing unit size Subledger Accounting for OPM

edited Dec 23, 2018 4:05AM in Process Manufacturing - EBS (MOSC) 2 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center