Reporting - EBS (MOSC)

MOSC Banner

Oracle RDF report error ORA-01789 query block has incorrect number of result columns

in Reporting - EBS (MOSC) 1 commentAnswered ✓

Hi ,

I am trying to add new column to existing RDF report query, The query has lexical parameter with UNION ALL that get the query dynamically. Even though I have added the column to dynamic sql clause ,I am getting the below error when I try to add new column to first sql shown below. Can any one please let me know if I am missing anything else here?

SELECT 0    CUSTOMER_TRX_ID

, rpad('a',20,'-') TRX_NUMBER

, 0   TERM_SEQUENCE_NUMBER  

, rpad('a',40,'-') TRX_TYPE

,    rpad('a',80,'-')     TRX_TYPE_NAME

,    'a'   OPEN_RECEIVABLE_FLAG

,    sysdate     TRX_DATE

,    0   SHIP_TO_CUSTOMER_ID

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