Bills And Items Created By PCM_OP_CREATE_OBJ With opflags=0x100 During Billing (Doc ID 1144833.1)

Last updated on MARCH 27, 2019

Applies to:

Symptoms

During billing (in fm_bill_utils_bill.c for bills and fm_bill_item_assign.c, for items), bills and items are created with the opcode PCM_OP_CREATE_OBJ with the opflags set to 0x100, which means create and read back the entire object.

As a consequence, the dm_oracle makes an insert statement followed immediately by a select statement => heavy performance issues: oracle impact, network between dm_oracle and the database, network between cm and dm_oracle busy.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.