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 laterInformation 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
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. ~ 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. ~ ...
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 |