SEQUENCE HZ_ACCOUNT_NUM_S IS INCREASED WHEN AUTOMATIC CUSTOMER NUMBERING IS OFF (Doc ID 2283200.1)

Last updated on APRIL 04, 2025

Applies to:

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

Symptoms

On : 12.2.5 version, APIs

ACTUAL BEHAVIOR
---------------
While using the API hz_cust_account_v2pub.create_cust_account to create new customers, the value of the standard sequence hz_account_num_s is increased even though the 'customer number' is provided as an input parameter to the API. Ideally hz_account_num_s should only be increased inside the API if the 'customer number' is not passed as an input and Automatic customer numbering is on.

EXPECTED BEHAVIOR
-----------------------
Sequence HZ_ACCOUNT_NUM_S is jumping and it shouldn't as the following setup is created:
Automatic Customer Numbering check box not enabled
Automatic Site Numbering check box not enabled

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the query to identify the sequence HZ_ACCOUNT_NUM_S
2. Run the API hz_cust_account_v2pub.create_cust_account
3. Re-run the query for the sequence HZ_ACCOUNT_NUM_S

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the hz_account_num_s sequence keeps increasing with each call to the API and there are problems in maintaining a sequence for new customer number.