Solved

Error in creating a Custom Field

  • 18 January 2022
  • 3 replies
  • 281 views

Userlevel 3
Badge +8

Hello,

We’re running apps10 upd8 on cloud. I’m creating a new custom field on the CustomerOrderLine LU. It is a read-only field, type Select, and the select statement is:

SELECT IFSAPP.CURRENCY_RATE_API.Get_Currency_Rate(:contract, 'EUR', 'B', :DATE_ENTERED) from dual

The data type is Number with format Currency.

But at the end it is giving me this error:

I need to use the creation date of the row.

How can I avoid the error ?

Thanks to anyone that can respond.

icon

Best answer by Kelum Pradeep Kumara 19 January 2022, 06:35

View original

3 replies

Userlevel 7
Badge +18

Custom Fields window → Search CustomerOrderLine LU
Go to Approved Details views line (highlighted below)

 

Note that SOURCE_LINE_SHIPMENT_ALT logical is approves state.

RMB  → Disapproved 

This work around will resolve your error.
-Kelum

 

 

Userlevel 3
Badge +8

Custom Fields window → Search CustomerOrderLine LU
Go to Approved Details views line (highlighted below)

 

Note that SOURCE_LINE_SHIPMENT_ALT logical is approves state.

RMB  → Disapproved 

This work around will resolve your error.
-Kelum

 

 

Hello Kelum,

it works now.

Could you please give me an explanation of that ?

Thanks.

Userlevel 7
Badge +18

The view SOURCE_LINE_SHIPMENT_ALT does not contain the field DATE_ENTERED. Therefore you can’t add your custom field to it.

It is easier if you think about this in terms of a SQL statement like below. (It is not how the actual SQL will look like but it is logically the same):

SELECT (SELECT IFSAPP.CURRENCY_RATE_API.Get_Currency_Rate(s.contract, 'EUR', 'B', s.DATE_ENTERED) from dual)

FROM IFSAPP.SOURCE_LINE_SHIPMENT_ALT s

 

This SQL statement will not work since DATE_ENTERED does not exist in view SOURCE_LINE_SHIPMENT_ALT

Reply