My Oracle Support Banner

Party Number is Being Created Even When Profile HZ: Generate Party Number is Set to NO, causing HZ_PARTY_NUMBER_S to Increment Incorrectly (Doc ID 1619672.1)

Last updated on MAY 20, 2024

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.


You have certain responsibilities which always have the Party Number generated by the System, when creating Parties and you have certain responsibilities which always supply the Party Number. When the Party Number is supplied, the sequence PARTY_NUMBER_S is incorrectly being incremented, causing you to "lose" numbers.

You have HZ_PARTY_NUMBER_S set to NOCACHE and INCREMENT BY 1, technically you should only lose Party Numbers generated by the system when a transaction rolls back.




To view full details, sign in with your My Oracle Support account.

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

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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