R12: PO: Getting APP-PO-14160 Error While Trying to Finally Close Standard Purchase Order (Doc ID 1995396.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Purchasing - Version 12.2.3 and later
Information in this document applies to any platform.
POXVDCKB.pls

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms