Document Manager Failed With Error Number 3 and POXDM-270: PODUS-090: PODUS-270: PODUS-220: ORA-1403 Causing Purchase Orders to Get Stuck in Pre-Approved or In Process (Doc ID 754953.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Listing of Document Manager Error Number 3 Issues and Troubleshooting Tips - <Note 754953.1>

A document manager error number 3 occurs while attempting to approve a standard purchase order, causing it to get stuck in process or pre-approved.

      Failed activity: Approve the PO (APPROVE_PO)
      Error Stack:
      Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.APPROVE_DOC,
      POAPPRV, 7654321-123456, 321321, RUN)
      Error Message: User-Defined Exception

Sysadmin error:

      POXDM-270: Subroutine poxdmact ion() returned error
      PODUS-090: Subroutine podus auths() returned error
      PODUS-270: Unknown code:
      Cause: PODUS-220: ORA-1403: no data found

Fnd log messages shows the below error:

2700: Entered Version_Attachments
2701: p_business_document_type : PA_CONTRACT
2702: p_business_document_id : 12345
22703: p_business_document_version : 3
2704: p_include_gen_attach : N
2710:doc version is: -99
2741:attch doc id is: 7654123
2742:effective_from_type is: PA_CONTRACT
2743:effective_from_id is: 774340
22744:effective_from_version is: 0
2745: Deleting OKC_CONTRACT_DOCS ref. records
3100: Leaving Version_Attachments because of EXCEPTION: ORA-1403: no data found


Steps to reproduce:
  1. Create a purchase order
  2. Add terms.
  3. Add a Supporting document. Approve PO.
  4. Add the same supporting document once again.
  5. Create a revision and approve the purchase order

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.