mad_sagittarian
Member
Hello All,
We are trying to update Route Code in P43090 using Orchestration.
Process Flow is -
1. Create custom UDC with
Description 01 = Branch/Plant
Description 02 = Supplier Number
Special Handling = Route Code to Update
2. Search P43090 with filters as Branch/Plant (step 1), Supplier (step 1) and Blank Route Code
3. Update Route Code = UDC Route Code (step 1) for the records found in step 2.
Orchestration Design
1. Data Request - To fetch UDC records
2. Data Request to fetch F43090 records for Branch-Supplier-Blank Route Code combination
3. Form Request on P43090 to update Blank Route Code records
The issue is there can be multiple records in UDC for Branch-Supplier combination. Each combination can have multiple records in P43090. So orchestration should see all UDC records and each corresponding P43090 record. below are two issues -
1. It is not updating any record in P43090
2. But when I hard code 'Route Code' to update (Special Handling in UDC) -> then also it updates only 1st combination of Branch-Supplier records in P43090.
Please see attached document for screenshots.
My question would be, is this even possible using orchestration? The frustration thing is, this could be achieved using custom UBE in no time.
Thanks in advance.
Thanks,
Andy
We are trying to update Route Code in P43090 using Orchestration.
Process Flow is -
1. Create custom UDC with
Description 01 = Branch/Plant
Description 02 = Supplier Number
Special Handling = Route Code to Update
2. Search P43090 with filters as Branch/Plant (step 1), Supplier (step 1) and Blank Route Code
3. Update Route Code = UDC Route Code (step 1) for the records found in step 2.
Orchestration Design
1. Data Request - To fetch UDC records
2. Data Request to fetch F43090 records for Branch-Supplier-Blank Route Code combination
3. Form Request on P43090 to update Blank Route Code records
The issue is there can be multiple records in UDC for Branch-Supplier combination. Each combination can have multiple records in P43090. So orchestration should see all UDC records and each corresponding P43090 record. below are two issues -
1. It is not updating any record in P43090
2. But when I hard code 'Route Code' to update (Special Handling in UDC) -> then also it updates only 1st combination of Branch-Supplier records in P43090.
Please see attached document for screenshots.
My question would be, is this even possible using orchestration? The frustration thing is, this could be achieved using custom UBE in no time.
Thanks in advance.
Thanks,
Andy