Skip to main content
Solved

Error in creating a Custom Field

  • January 18, 2022
  • 3 replies
  • 358 views

Forum|alt.badge.img+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.

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 

This work around will resolve your error.
-Kelum

 

 

View original
Did this topic help you find an answer to your question?

3 replies

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+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

 

 


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • January 19, 2022
Kelum Niranjana wrote:

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.


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 485 replies
  • January 19, 2022

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


Did this topic help you find an answer to your question?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings