Solved

Problem with the blank table - Posting Control

  • 30 September 2019
  • 1 reply
  • 413 views

Userlevel 5
Badge +8
One of the customers that am working on encountered the following scenario:
Background:
When adding a new line on the Posting Control Details Specification Screen, the Work Center For Routing List Of Values dialogue is blank. When clicking Populate, and error appears "missing expression: Failed executing query (ORA-00936: missing expression)". If the work center is manually typed in, the rest of the data related to the work center will appear. It is only not available in the LOV.
Steps to recreate scenario:
1. Go to “Posting Control” and Search for M209 RMB on M209 for Dept and click “Details”
2. In the Details window, click on Indirect Job per Site 200|120 which uses C47 for the Specification Control Type. Select “Details Specification”.
3. In the Details Specification window, create a new line (+ or F5).
4. Use the List of Values to obtain a Work Center value - a blank table opens!
5. When clicking Populate, the error message appears: "missing expression: Failed executing query (ORA-00936: missing expression)".
Please advice on a possible solution ?
icon

Best answer by Ravindu Perera 30 September 2019, 12:55

View original

1 reply

Userlevel 4
Badge +9
This issue would be observed when there is a problem with the view comments. Re-run the view comments. Dictionary and security should be refreshed. Your problem should be resolved.

Reply