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.
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.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:
- Create a new PO
- Go to Terms screen and set Transportation Arrangement = "Buyer Organization"
- Approve the Purchase order.
- PO status is Pre-Approved.
- Review workflow notification and it shows the 'The Document Manager failed' error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms