Entity association is created between Sales Part and Sales Price List Part.
Then the Custom tab is added in the Sales Part and the binding is added.
But when populating the page, this gives an error saying missing right parenthesis.
IFS Web Version: 22.2.5.20230201103053.0
Date: 2023-06-14T14:55:27.248Z
--------------------------------------------------------------------------------------------------------
Database error occurred. Contact administrator.
Error details: [{"code":907,"message":"ORA-00907: missing right parenthesis"}]
Request Id: 9640c277-ac93-45c6-9a57-641026111b4f
Url: main/ifsapplications/projection/v1/SalesPartHandling.svc/SalesPartSet(CatalogNo='S10362-11-025P',Contract='TEST')/SalesPriceListEntity?$select=CatalogNo,BasePriceSite,PriceListNo,CPurchasePrice,Objgrants,luname,keyref&$skip=0&$top=25
When investigating the SELECT statement generated from the Entity Association, it was noted that a single quotation was missing, when the valid_from_date value is converted to varchar while adding it the key ref.
SELECT A.* FROM (SELECT catalog_no catalog_no, NULL objgrants, 'SalesPriceListPart' luname, 'CATALOG_NO='||catalog_no||'^'||'MIN_DURATION='||min_duration||'^'||'MIN_QUANTITY='||min_quantity||'^'||'PRICE_LIST_NO='||price_list_no||'^'||'VALID_FROM_DATE='||to_char(valid_from_date,'YYYY-MM-DD-HH24.MI.SS)||'^' keyref, price_list_no price_list_no, min_duration min_duration, min_quantity min_quantity, valid_from_date valid_from_date, 'W/\"'||objid||':'||objversion||'\"' etag
FROM SALES_PRICE_LIST_PART) A FETCH FIRST 1 ROWS ONLY
I assume that it could be reason for this error.
Could it be the reason and do you have any idea how to sort it out?
