R12 XLAACCPB PRC: Create Accounting Program Performance Is Slow During Month End (Doc ID 1512335.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Performance issue with "PRC: Create Accounting" program


SELECT /*+ leading(evt) use_nl(ent) index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=5529420] reverted bug6369888 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=6369888] modified hint bug9192859 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=9192859]
  DISTINCT evt.entity_id
  FROM xla_events evt
  ,xla_transaction_entities ent
  ,xla_event_types_b xet
  ,xla_event_class_attrs eca
  ,xla_evt_class_orders_gt xpo
  WHERE ent.application_id = :1
  AND ent.ledger_id = :2
  AND evt.application_id = :3
  AND evt.entity_id = ent.entity_id
  AND xet.application_id = evt.application_id
  AND xet.event_type_code = evt.event_type_code
  AND eca.application_id = xet.application_id
  AND eca.entity_code = xet.entity_code
  AND eca.event_class_code = xet.event_class_code
  AND eca.event_class_group_code = NVL(:4, eca.event_class_group_code)
  AND evt.event_type_code NOT IN ('FULL_MERGE', 'PARTIAL_MERGE')
  AND evt.process_status_code IN ('I','E', 'R',DECODE(:5,'N','D','E')
  ,DECODE(:6,'N','U','E')
  )
  AND evt.event_status_code IN ('U',DECODE(:7,'F','N','U'))
  AND evt.on_hold_flag = 'N'
  AND evt.event_date <= :8
  AND ent.entity_code <> :9
  AND NVL(evt.budgetary_control_flag,'N') = 'N'
  AND xet.event_class_code = xpo.event_class_code
  AND xpo.processing_order = :10

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms