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 laterInformation 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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
References |