Oracle Reports (MOSC)

MOSC Banner

value set used by report is throwing ora-24345 error

edited Feb 19, 2020 3:21AM in Oracle Reports (MOSC) 3 commentsAnswered

I created a custom value set for a custom report

the value set is based on a view I created called BSDM THIRD PARTY

CREATE OR REPLACE FORCE VIEW APPS.BSDM_THIRD_PARTIES_V

(

   THIRD_PARTY_ID,

   THIRD_PARTY_TYPE,

   THIRD_PARTY_NUMBER,

   THIRD_PARTY_NAME

)

AS

   SELECT v.VENDOR_ID,

          'S',

          v.SEGMENT1,

          VENDOR_NAME

     FROM AP_SUPPLIERS v

   UNION ALL

   SELECT hca.CUST_ACCOUNT_ID,

          'C',

          hca.ACCOUNT_NUMBER,

          P.PARTY_NAME

     FROM HZ_CUST_ACCOUNTS hca, HZ_PARTIES P

    WHERE P.PARTY_ID = HCA.PARTY_ID;

I created a value set based upon this view which I then tested and it tested successfully but when I use it within my report definition parameter and select on this parameter -- I get ora-24345 a truncation or null fetch error occurred

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