You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with finds captures authorization custom layout

edited Mar 20, 2020 7:32PM in Reporting and Analytics for ERP

Summary

Length() not returning correct value when used with sum()

Content

Hi Experts,

 

We are in oracle fusion 19D.

We are using Oracle Business Intelligence 11.1.1.9.0

I have a persisting issue with executing the following script on etext template

LENGTH(/FundsCaptureInstruction/InstructionGrouping/PayeeBankAccount/BankAccountNumber
+ SUM(NVL(PayeeAccount/FundsCaptureOrder/ PayerBankAccount/BankAccountNumber,0)))

What I observed is that:

/FundsCaptureInstruction/InstructionGrouping/PayeeBankAccount/BankAccountNumber
+ SUM(NVL(PayeeAccount/FundsCaptureOrder/ PayerBankAccount/BankAccountNumber,0)) seem to be converting the output to scientific notation.

 

EG

Let’s say,

PayeeAccount/FundsCaptureOrder/ PayerBankAccount/BankAccountNumber returns two acount numbers 123452325 as well as  6352323650.

 and  /FundsCaptureInstruction/InstructionGrouping/PayeeBankAccount/BankAccountNumber returns the account 125335532

123452325 +6352323650 =6475775975

125335532+6475775975 = 6475775975

 

at this point what the system does is that 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!