PO Approval Get Stuck in Pre-Approved Status For Transaportation Arranged (OTM) POs (Doc ID 2295877.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Purchasing - Version 12.1 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Integration of Oracle Purchasing with Oracle Transportation Management (OTM) is setup (as per <Note 810555.1> "How Oracle Purchasing Integrates with Oracle Transportation Management (OTM)).

Whenever Shipping control (Transportation Arranger) is set to either the Buying Organization or Supplier POs submitted for approval are getting stuck in Pre-Approved Status.  If the Shipping Control is not set, the document is approved without errors.

Workflow notifications shows the following error:

  The Document Manager failed with error number 3
  Error Number 3 = Unknown Error.
  Contact your system administrator.


FND Debug log shows:

po.plsql.PO_OTM_INTEGRATION_PVT.HANDLE_DOC_UPDATE.110 1 l_command = APPROVE
po.plsql.PO_OTM_INTEGRATION_PVT.HANDLE_DOC_UPDATE.320.EXCEPTION 4 No data found for document;SQLERRM = ORA-01403: no data found
po.plsql.PO_DELREC_PVT.create_update_delrec.EXCEPTION 4 Exception :005100
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action140.EXCEPTION 4 create_update_delrec not successful;SQLERRM = User-Defined Exception
po.plsql.PO_DOCUMENT_ACTION_PVT.do_actionEND 2 p_action_ctl_rec.return_status = U


Even setting profile 'WSH: FTE Is Enabled' as per <Note 453182.1> and <Note 550811.1>, the error still occurs.

Steps to Reproduce the issue:

  1. Create a new PO
  2. Go to Terms screen and set Transportation Arrangement = "Buyer Organization"
  3. Approve the Purchase order.
  4. PO status is Pre-Approved.
  5. Review workflow notification and it shows the 'The Document Manager failed' error

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