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 OCTOBER 13, 2022
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!