Party Number is Being Created Even When Profile HZ: Generate Party Number is Set to NO, causing HZ_PARTY_NUMBER_S to Increment Incorrectly
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.
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.
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