APP-PO-14142 WF_Error-000: ORA-0000 normal [ID 470204.1]

纵横四海

(Pics) Non-AME Requisition Approval Fails with APP-PO-14142 WF_Error-000: ORA-0000 normal [ID 470204.1]

---

Applies to: Oracle Purchasing - Version: 12.0.3 and later   [Release: 12 and later ]
Information in this document applies to any platform.

SymptomsThe following error presents when trying to approve a requisition:

Error:
APP-PO-14142: WF_Error-000: ORA-0000 normal, successful completion

Cause: A SQL error has occurred in WF_Error. The SQL error is ORA:0000: normal, successful completion.

Action: Take note of both this error number and the actions you were trying to perform.
Contact your system administrator for further assistance.



CauseIn the document types form for document type = Purchasing Requisition or Internal Requisition, the field to use AME is populated so the Requisition Workflow is trying to use AME. Since AME  is not properly setup, the workflow fails.
Solution
1. If AME is NOT installed nor will it be used, disable AME:

a- Select a Purchasing Responsibility and go to the Document Types form
- Setup: Purchasing => Document Types

b- Choose "Requisition Purchasing " => Select update icon

c- Review "Approval Transaction Type" field
d- Delete the "PURCHASE_REQ" value from the "Approval Transaction Type" field for Purchase requisitions.
OR
- Delete the "INTERNAL_REQ" value for Internal requisitions.




e- Save changes and retest with new Requisition

2. If AME is going to be used, see Note 563860.1 AME When Submitting Requisition for Approval, Encounter Error APP-PO-14142: WF_Error-000: ORA-0000



该贴已经同步到 纵横四海的微博

虺少

我遇到这个错误 就是因为我想 启用AME 。。。看看  Note 563860.1  能否有帮助，thx