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 JULY 12, 2017

Applies to:

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

Symptoms

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.

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