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.
Best answer by Kelum Pradeep Kumara
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
+18Custom 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
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
Hello Kelum,
it works now.
Could you please give me an explanation of that ?
Thanks.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
