My Oracle Support Banner

WS: WW: Calculated Fields FAQs (Doc ID 627484.1)

Last updated on AUGUST 17, 2021

Applies to:

JD Edwards World World Writer - Version A7.3 cume 4 and later
Generic (Platform Independent)

Purpose

This document contains FAQs and troubleshooting tips when working with calculated fields in World Writer.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Question 1: How do you set up a calculated field?
 Question 2: What are the types of expressions used in a calculation?
 Question 3: Unexpected results occur when using arithmetic┬á operators (+ - * /).
 Question 4: What does the INTEGER operand do?
 Question 5: Error 1495 Field Name is Not Valid when attempting to create a new field.
 Question 6: Error 1763 - Invalid Characters Found - on a calculation that uses a number less that 1.
 Question 7: Error 1766 - Expected a right (or left) parenthesis.
 Question 8: Is there a method to convert an alpha character string to numeric data?
 Question 9: Can SUBSTR or the || (Concatenate symbol) be used on a numeric field?
 Question 10: Can the absolute value for a field be calculated?
 Question 11: Error 1762 - Invalid Field or Function Name.
 Question 12: How do you put a column heading on a calculated field?
 Question 13: How do you data select on a calculated field?
 Question 14: Your field that subtracts a number of days from a julian date field does not work when rolling over to a new year.
 Question 15: How to calculated the number of days difference between two date fields
 Question 16: How to calculate the age of an employee in years and months.
 Question 17: How to determine why Data Selecting on calculated field produces no records?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.