This discussion is archived
1 Reply Latest reply: May 7, 2012 4:26 PM by Nasar RSS

DAC: SELECT COUNT(*) FROM W_GL_LINKAGE_INFORMATION_G

MRERP2 Explorer
Currently Being Moderated
Hello,

We've BIAPPS 7.9.6.1
When I run the incremental process by Execution Plan with only one selected option "Analyze Truncated tables Only",
I see that some tasks work too long time.
For example "SIL_GLLinkageInformationGeneral" have a status "Running", although, in the details of this task I see that Informatica workflow of this task already terminated (DAC status is "completed").
I noticed that while "SIL_GLLinkageInformationGeneral" have a status "Running", in the data base the following SQL
SELECT COUNT(*) FROM W_GL_LINKAGE_INFORMATION_G
is running.
the questions are:
1. what is the functionality of running this SQL by DAC (I don't understand that, because SIL_GLLinkageInformationGeneral fill W_GL_LINKAGE_INFORMATION_G incrementally) ?
2. is the way to prevent the running of SELECT COUNT(*) FROM W_GL_LINKAGE_INFORMATION_G ?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points