Blanket Agreement Stuck In Process Doc_error_num 3(Po Approve)

Get error message when trying to approve Blanket Purchase Agreement. Document number is NNNNNNN Errors: The Document Manager failed with error number 3. Error Number 3 = Unknown Error. Contact your system administrator. Error Messages: POXDM-290: Subroutine poxdmaction() returned erro PORAR-020: Subroutine poraradarchivedocument() re PORAR-070: Subroutine porarlines() returned error PORAR-210: ORA-00001: unique constraint (PO.PO_LI Cause The cause of this problem is still undetermined, most likely is due to data corruption due to the mismatch of archival data latest sequence number in the archive tables. Solution To implement the solution, please execute the following steps: a. Set 'Archive on' from "Approve' to 'Print' for the document type 'Standard Purchase Order' . In order to do so, take the following steps: 1. Navigate Setup: Purchasing: Document Types 2. Query up 'Standard Purchase Order' 3. Set 'Archive on' to 'Print' b. Then retry the approval from SQLPLUS as follow SQL>exec wf_engine.startprocess('wf_item_type','wf_item_key'); ex: exec wf_engine.startprocess('POAPPRV','161-474'); SQL>commit c. Run the Workflow Background program. Select System Administrator responsibility. Navigate: Request: Run Set the parameters Item Type = PO or Requisition Approval; Processed Deferred = Yes; Process Time Out = Yes. Process Stuck = Yes, if the Process Stuck parameter is available d. Check if the document gets approved now. e. Reset 'Archive on' from "Print' to 'Approve' for the document type 'Standard Purchase Order' . In order to do so, take the following steps: 1. Navigate Setup : Purchasing : Document Types 2. Query up 'Standard Purchase Order' 3. Set 'Archive on' to 'Approve'[@more@]so such!

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/208621/viewspace-906706/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/208621/viewspace-906706/