1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Fatal pl sql error occured

Discussion in 'Oracle Forms and Reports' started by jagadekara, Aug 5, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I have one rdf in that 2 groups are there. first group giving some ar records.
    Then we have a data link between two groups with column customer_trx_id.
    second group giving line details like description, quantity , rate and total value.

    If total value is in negative value, then report giving the following error.

    REP-1401: '': Fatal PL/SQL error occurred. REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1401: '': Fatal PL/SQL error occurred.

    So what may be the issue?

    Note that below points:

    There is one summary col in second group which source as total_value column.
    Also in first group one more summary col which source as second group summary column.

    I gave abs(total_value) for testing, then report is completed normal.
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Have you looked at the PL/SQL in the report definition?
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks DTSIGuy,

    we have one formula column to display amount in words.
    So there I gave abs(total_value) then resolved.

    For my client amount in words not required minus as of now.
    So not a problem now.