Pin_inv_accts - Deadlock During Invoice Of Multiple Bills Of Different Bill Info(s) Of Same Account. (Doc ID 2067054.1)

Last updated on FEBRUARY 28, 2024

Applies to:

Goal

Created a parent account (having 3 child sub-ordinate accounts) with pay type as invoice and having two separate services with separate 2 bill info(s).
Generated separate 2 bills of above 2 services having separate 2 bill info(s).

Bills are created successfully with child accounts usage charges rolled up to parent bills.

But now, while running pin_inv_accts for above 2 bills poid as below:

pin_inv_accts -file -verbose

only 1 invoice is getting generated and other 1 invoice is failing with DEADLOCK error on account balance groups during PCM_OP_WRITE_FLDS on the invoice object.

CM DM->FM opcode PCM_OP_WRITE_FLDS, opflags=0x20020

Solution

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