Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Commitment Control>Budget Transfers>Lines: PC BU Prompt Table Lookup

edited Dec 4, 2012 1:01AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 5 commentsAnswered ✓
On navigation: Commitment Control>Budget Transfers>Lines: there is a PC BU prompt table lookup that invokes a SQL that needs to be tuned.  The prompt table uses view PC_BU_GL_VW which results in multiple entries for the same PC BU.   Has anyone else had this problem?

SQL associated with the view:

SELECT DISTINCT B.BUSINESS_UNIT_GL
 , %Substring(A.SETCNTRLVALUE, 1, 5)
 , %Substring(A.SETCNTRLVALUE, 1, 5)
 , D.DESCR
  FROM PS_SET_CNTRL_REC A
  , PS_PC_INT_TMPL_GL B
  , PS_BUS_UNIT_TBL_FS D
 WHERE A.SETID = B.SETID
   AND A.RECNAME = 'PC_INT_TMPL_GL'
   AND D.BUSINESS_UNIT = A.SETCNTRLVALUE

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center