My Oracle Support Banner

OZF_RESALE_PUB.Start_Payment API Error: "ORA-20002: 3122: Duplicate item 'OZFRSIFD/16032-2007-0706-112944' could not be created. in Package OZF_RESALE_WF_PVT Procedure Start_Batch_Payment" (Doc ID 468348.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle Trade Management - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

Runtime error while invoking Public API, OZF_RESALE_PUB.START_PAYMENT.

Error occurred while calling ozf_resale_pub.start_payment API and can't change Indirect Sales Management (IDSM) batch status from processed to closed through API call, the following error occurs:


Error

I : 1 MSG : ORA-20002: 3122: Duplicate item 'xxxxx/16032-2007-0706-112944' could not be created. in Package OZF_RESALE_WF_PVT Procedure Start_Batch_Payment

I : 2 MSG : Please enter a valid batch status.
 


Steps To Reproduce
The issue can be reproduced at will with the following steps: use ozf_resale_pub API as below.
1.insert sell out data into ozf_resale_batches_all / ozf_resale_lines_int_all

2. call ozf_resale_pub.start_process_iface(p_api_version
,p_init_msg_list
,p_commit
,p_validation_level
,p_resale_batch_id
,x_return_status
,x_msg_data
,x_msg_count);

3. call ozf_resale_pub.start_payment(p_api_version
,p_init_msg_list
,p_commit
,p_validation_level
,p_resale_batch_id
,x_return_status
,x_msg_data
,x_msg_count);
-------------------------------------------------------------------------------
gets the above error.

ADDITIONAL INFORMATION
After I get a error message in the calling of ozf_resale_pub.start_payment, if I run 'Initiate payment' in the standard IDSM window, it is working fine, and status is changed to Closed.

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
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.