CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Selecting from F0413 fails due to decimal places

Hi Team,

I'm from the functional team and we are facing this issue

the ERs are as follows:

  1. passing amount and Currency to BSFN DecimalTriggerGetByCurrency. it's JPY and amount is {-123}
    because JPY doesn't have decimals, the BSFN return the amount as {-123}. I'm saving this value in a variable of dd PAAP
  2. F0413.Select and I'm passing the variable PAAP of the value {-123} and the Currency
    I can see the value in the debugger is passed as {-123}
  3. When runing the UBE, the selection fails. when look into the log i got this select statement
    SELECT * FROM CRPDTA/F0413 WHERE ( RMPAAP = -12300.000000 ) ORDER BY RMPYID ASC

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