Demantra Solutions - EBS (MOSC)

MOSC Banner

how to keep the mdp_matrix not update if the t_src_sales_tmpl is null

edited Sep 11, 2014 5:00AM in Demantra Solutions - EBS (MOSC) 2 commentsAnswered

We did not to update the sales_data and mdp_matrix records if the t_src_sales_tmpl columns is null

for example,in the table,we have columnsA and columnsB,and it comes from the columnsA1 and columnsB1 in the  t_src_sales_tmpl,

before update

tablecolumnsAcolumnsB
mdp_matrixab

tablecolumnsA1columnsB1
t_src_sales_tmpla1 

update the t_src_sales_tmpl value into the mdp_matrix,then the mdp_matrix update like this:

tablecolumnsAcolumnsB
mdp_matrixa1 

but we need the filed columnsB in the mdp_matrix should not update,we need the result like this:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center