R12: PO: Getting APP-PO-14160 Error While Trying to Finally Close Standard Purchase Order
(Doc ID 1995396.1)
Last updated on JANUARY 01, 2021
Applies to:
Oracle Purchasing - Version 12.2.3 and laterInformation 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:
- Responsibility: Purchasing
- Navigate to: Purchase Orders > Purchase Order Summary
- 'Find' Standard Purchase Order that need to be finally closed
- Select Menu > Tools > Control' and apply "Finally Close" control action to the PO
- 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |