When approving an internal requisition the following error appears :
ORA-00976 LEVEL,PRIOR, or ROWNUM not allowed here in Package PO_DOCUMENT_CHECKS_PVT Procedure CHECK_REQUISITIONS.
Question
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
When approving an internal requisition the following error appears :
ORA-00976 LEVEL,PRIOR, or ROWNUM not allowed here in Package PO_DOCUMENT_CHECKS_PVT Procedure CHECK_REQUISITIONS.
In most cases this error is coming due to the location value is incorrect.
for example you have location_id = 100 , location_code = AE while expecting ” UNITED ARABEMIRATES ” value.
follow this step to include the country inside address information of a location :
1- Open location form. from Setup –> Organization –> Locations
2- Query about the location above.
3- Update the address information to include the Country, then save.
Now try to approve your internal requisition.
Please test this solution on test environment first. once everything is working fine then move it to appropriate environment.
I HAD THE SAME PROBLEM AND IT’S SOLVEd AFTER UPDATIN THE location Country.
thanks for help