My Oracle Support Banner

Duplicate Errors Displayed When Calling Multiple Times TCA API Procedure (Doc ID 2952744.1)

Last updated on JULY 11, 2023

Applies to:

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

Symptoms

When calling multiple times an TCA API Procedure, duplicate errors are displaying. This can be replicated by using below steps:

1. First time when TCA SCRIPT is called, an ERROR reported from fnd_msg_pub

  lv_party_id:XXXX1 --lv_return_status:E --- Error: ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B.


2. The second time when the  TCA SCRIPT is called (no changes done in the script)
  Now the error is reported 2 times from fnd_msg_pub

  lv_party_id:XXXX2 --lv_return_status:E --- Error: ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B.
  lv_party_id:XXXX2 --lv_return_status:E --- Error: ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B. ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B.


3. Each time when the TCA SCRIPT is called again, an additional error message is reported from fnd_msg_pub

  lv_party_id:XXXX3 --lv_return_status:E --- Error: ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B.
  lv_party_id:XXXX3 --lv_return_status:E --- Error: ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B. ~ ...
  lv_party_id:XXXX3 --lv_return_status:E --- Error: ~ Invalid value for orig_system. Please enter orig_system value from HZ_ORIG_SYSTEMS_B. ~ ...

 

4. An additional error line is displayed each time when executing the TCA SCRIPT.

 

The following is an example for running the hz_party_v2pub.create_person when the orig_system is invalid.



The expected result would be having the ERROR reported ONLY ONCE as occurring in STEP 1 (even if calling the TCA SCRIPT multiple times).



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


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