Skip to main content

Hello,

 

I created Custom Field in this entity, but when I open my SQL view, it is not there, what should I do?

Should I switch on toggle List Of Values for this CF, or there is other option?

Thanks 

 

 

Hi @Ed22 ,

 

Please tray to add “_CFV” after your view.

 

For example: Customer_order_cfv.

 

CFV means custom field view.

 

Hope it helps

Ozgun Bal


I created Custom Field CF_AAA_CISLO, but I had this error: 

 


@Ed22 if you added the Custom Attribute in the Sales Price List entity, then you should run the below query. Are you getting the CF?

select * from IFSAPP.SALES_PRICE_LIST_CFV

 


it says table or view does not exist


@Ed22 is this the 1st CF created in the SalesPricelIst entity? Did you Publish the entity configuration?

Can you provide a screenshot of the SalesPriceList entity configuration please?


I added this CF in entity SalesPriceListPart, should I add to the SalesPriceList? 

 

 


 


@Ed22 OK, got it now. You need to query the IFSAPP.SALES_PRICE_LIST_PART_CFV view then.


I have still error which is in picture 1: ORA00904 CF$_AAA_CISLO: invalid identifier


@Ed22 can you paste your SQL query here?

I think you are executing more than select * from IFSAPP.SALES_PRICE_LIST_PART_CFV if you are getting the invalid identifier error.


Thank you, I solved this. Problem wasnt in this CF problem was in another CF, I removed wrong CF and it works.


Reply