Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

BI Publisher and Union Select (11.1.1.5.0)

edited Mar 28, 2012 1:36AM in Design Tools & Output Technologies - JDE1 (MOSC) 6 commentsAnswered
Hi I amtrying to union select two tables. This worked under BIP 10G, but I cannot get it to work in 11G and I cannot find any hint in the documentation.

Any help greatly appreciated.

Here the SQL I am trying (without the union it works fine):

Table Union:

select  F4211.DCTO as DCTO,
  F4211.CO as CO,
  F4211.AN8 as AN8,
  F4211.TRDJ as TRDJ,
  F4211.NXTR as NXTR,
  F4211.UORG as UORG,
  F4211.AEXP as AEXP,
  F4211.ECST as ECST,
  F0101.ALPH as ALPH
 from  F0101 F0101,
  F4211 F4211
 where   F4211.AN8=F0101.AN8

union select  F42119.DCTO as DCTO,

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