How to use ASDL response parameters in a second ASDL in the same CSDL? (Doc ID 1459096.1)

Last updated on JUNE 10, 2022

Applies to:

Goal

There is a scenario within ASAP that we need to store ASDL response parameters to use it in a second ASDL in the same CSDL. Please take into consideration that most of these parameters are Required/Mandatory. We found that a possible solution would be creating an auxiliary database and store the response parameters from the first ASDL in those databases.
We would store the parameters in a format as follows: (Work_Order ID, Parameter, Param_Value) so that the ASDL2 could look up the requested value from ASDL1 in the DBs and use it as entry values.

Is this a good approach? What are the performance concerns with this solution? Is there any other option to fulfill this scenario?
 

Solution

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