R12: PO: Getting APP-PO-14160 Error While Trying to Finally Close Standard Purchase Order

Last updated on APRIL 10, 2017

Applies to:

Symptoms

When attempting to Finally Close Standard Purchase Order (SPO), the following error occurs

Error

APP-PO-14160: Document action not completed successfully
Cause: You attempted to perform a document action that is incompatible with the document status.

Steps to reproduce:

1. Responsibility: Purchasing
2. Navigate to: Purchase Orders > Purchase Order Summary
3. 'Find' Standard Purchase Order that need to be finally closed
4. Select  Menu > Tools > Control' and apply "Finally Close" control action to the PO
5. Getting APP-PO-14160 Error

FND Debug captured following error:
- module = po.plsql.PO_DOCUMENT_CHECKS_PVT.check_final_close70.EXCEPTION
- message_text = -979: ORA-00979: not a GROUP BY expression;SQLERRM = ORA-00979: not a GROUP BY expression

Another Example of FND Logging:

-979: ORA-00979: not a GROUP BY expression;SQLERRM = ORA-00979: not a GROUP BY expression
p_sequence = 0
x_return_status = U
End of subprogram.
check_qty_rcv_but_not_deliv not successful;SQLERRM = User-Defined Exception
p_sequence = 0
x_return_status = U
End of subprogram.
Back in GRP package. Returning to the caller
unexpected error in po_submission_check;SQLERRM = User-Defined Exception
x_return_status = U
x_online_report_id is null
Return value = FALSE
End of subprogram.
manual_close_submission_check not successful;SQLERRM = User-Defined Exception
p_action_ctl_rec.return_status = U
p_action_ctl_rec.return_code is null
p_action_ctl_rec.online_report_id is null
unexpected error in action call;SQLERRM = User-Defined Exception
p_action_ctl_rec.return_status = U
p_action_ctl_rec.return_code is null
p_action_ctl_rec.functional_error is null
p_action_ctl_rec.error_msg = po.plsql.PO_DOCUMENT_ACTION_CLOSE.manual_close_submission_check:120:unexpected error in po_submission_check -  po.plsql.PO_DOCUMENT_ACTION_CLOSE.manual_close_po:120:manual_close_submission_check not successful -  po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

Cause