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 ?
Solved
Problem with the blank table - Posting Control
+8Best answer by Ravindu Perera
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.
View original
+9This 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.