RXi Sales register completes in warning with Error message " ORA-00936: missing expression"
By Jag - June 28, 2013
While implementing or in Roll out Projects for Accounts Receivables Module. You may face below issue, When you submit the concurrent program for Standard Report " Publish Sales Register", Request ID completes in error where child concurrent program " RX-only : Sales Register" fired along with Publish Sales Register report also completes in Error.
When you check the Log file of " Publish Sales Register" you will find the Error message as "Request xxxxxx (Request ID) failed. Please see the log file for more information. RXi cannot generate the report." Similarly when you check the log file of "RX-only : Sales Register" you will find the Error message as " ORA-00936: Missing expression".
Solution
To over come this issue follow the steps provided in Metalink Note Id: 605599.1 and do the required setup in Order Management.
Required Setup
Access Responsibility : Order Management Responsibility.
Navigation: Setup > System Parameters > Values
Upon selecting the navigation below page appears. Query your operating unit and Select the value from LOV and assign the value to "Item Validation Organization" Parameter. Save the work and close the window.
After performing above setup. Go to Accounts Receivables Responsibility and resubmit the standard report " Publish Sales Register" where you will find that request id completes normal (Desired Output).
When you check the Log file of " Publish Sales Register" you will find the Error message as "Request xxxxxx (Request ID) failed. Please see the log file for more information. RXi cannot generate the report." Similarly when you check the log file of "RX-only : Sales Register" you will find the Error message as " ORA-00936: Missing expression".
Solution
To over come this issue follow the steps provided in Metalink Note Id: 605599.1 and do the required setup in Order Management.
Required Setup
Access Responsibility : Order Management Responsibility.
Navigation: Setup > System Parameters > Values
Upon selecting the navigation below page appears. Query your operating unit and Select the value from LOV and assign the value to "Item Validation Organization" Parameter. Save the work and close the window.
After performing above setup. Go to Accounts Receivables Responsibility and resubmit the standard report " Publish Sales Register" where you will find that request id completes normal (Desired Output).
0 comments