Launch Management workflow fails on Launch Import promo history in batch mode (Doc ID 2182727.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Customer is on 12.2.4.1. and has 2 issues with Launch Management
1. When the customer uses the Launch Management and selects Now, nothing happens. No combination is created and no history loaded. The workflow Launch Ongoing Request keeps waiting at check valid realtime request ()at that point.

2. When the customer uses the Batch mode, the combination is created and data/history is copied but the workflow fails on Launch Import promo historybatch. Customer is not loading the history data, but this workflow fails at this step. The reason it fails is due to the fact that Launch Import Promo History batch step has no level selected in the transfer step and hence errors. The level value is missing from that Transfer Step.
 



In the the workflow Launch Request Batch , for the step Launch Import Promo History steps needs the following selected

Interface Launch Management - PTP
Level ----> Launch Managment - Promotion _History

However the customer does not see the Launch Management -PTP integration interface in their installation at all. This is because they only have DM installtion and they can only see the Launch Management -DM interface.

Customer then applied the patches
19945449
 18139794

Then tested the issue again multiple times after the patch application.

Attached the latest T_EP_LAUNCH table.

1st Test: Tried to Launch an Item at an existing combination. The request name in t_ep_launch is 'PN Test NPI 1'. Used Launch Mode as 'Now' and the request seems to be processed correctly. It created the combincation and copied the history too.

2nd Test: Tried to Launch an Item at an existing combination. The request name in t_ep_launch is 'PN Test NPI 2'. Used Launcch mode as 'Batch' and ran the workflow 'Launch Request Batch', then it created the combination and copied the history, but again, it gave error at the same place like earlier. 'Launch Import Promo Hist Batch' becase there is still no Level selected for that transfer step and there are no values exists to select too.

3rd test. Tried to Launch an Item at an existing combination.The request name in t_ep_launch is 'Hwy Test NPI 2'. Used the launch mode as 'Now' and it showed the message as 'Validation Success' and after that, it is not moving any further.I have not done anny changes after the first test but it seems that the old problem still exists.

Attached the Collaborator log file too.

Form the 1st test, I see the below from the collaborator log file. Looks like after creating the combination and copying the history from the first test(Launch Mode as 'Now'), it error out doing the the Promo History copy. We dont have the PTP module here. Looks like the workflow error out and never coming back to process the next rquests.

Schema ID: 1734
Schema name: 'Launch Request Realtime'
Step ID: 'Step15'
Step name: 'Launch Promo Hist Realtime'

Error description 'Program internal error:'
2015-12-01 10:51:33,021 EST [WFProcess_1] ERROR dpweb.general: ######################################################################################
2015-12-01 10:51:33,029 EST [Mail_Thread] ERROR workflow.steps: MailThread:run()::No Sender or Reciever
2015-12-01 10:51:33,037 EST [Mail_Thread] ERROR workflow.steps: MailThread:run()::No Sender or Reciever

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms