Skip to main content
Question

IAL Configuration save fails with "(ORA-00936: missing expression"

  • February 19, 2025
  • 0 replies
  • 23 views

HEAHOSKINSA
Do Gooder (Customer)
Forum|alt.badge.img+1

The following IAL query is accepted by the Developer, but I cannot schedule the update in the Configuration tool. 

 

SELECT COMPANY,
           CONTRACT,
           INVOICE_ID,
           ITEM_ID,
           SERIES_ID,
           INVOICE_NO,
           DEL_IDENTITY,
           DELIVERY_ADDRESS_ID,
           VAT_CURR_AMOUNT,
           NET_CURR_AMOUNT,
           GROSS_CURR_AMOUNT,
           ORDER_NO,
           LINE_NO,
           RELEASE_NO,
           RMA_NO,
           RMA_LINE_NO,
           CATALOG_NO,
           DESCRIPTION,
           INVOICED_QTY,
           SALE_UM,
           INVENTORY_UM,
           CALC_UOM_VOLUME,
           SALE_UNIT_PRICE,
           ACCOUNTING_PERIOD,
           ACCOUNTING_YEAR,
           COMP_CUST,
           PART_PRODUCT_FAMILY,
           OBJSTATE,
           OBJSTATE_HEAD
      FROM IFSAPP.olap_customer_invoice_item
WHERE COMPANY IN ('HH','TJC','CANCO','SS-WJD', 'SS-PD', 'SS-FEW', 'SS-INTSALES', 'SS-LI', 'SS-DV', 'SS-220', 'SS-EAH', 'SS-HOLDINGS', 'SS-NOL', 'SS-OAH', 'SS-USSALES','HHGLOBALELIM','203')

0 replies

Be the first to reply!

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