Received Error Message When Running Autocreate To Create PO From Requisition
(Doc ID 3069758.1)
Last updated on JANUARY 30, 2025
Applies to:
Oracle Purchasing - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
Received Error Message when running Autocreate to create PO from Requisition
APP-PO-14142: AUTOCREATE_DOCUMENTS-008: ORA-0000: normal, successful completion
STEPS
-------
1) Purchasing Responsibility
2) Open Autocreate Form
3) query out existing requisition
4) Click Automatic
5) gets error: APP-PO-14142: AUTOCREATE_DOCUMENTS-008: ORA-0000: normal, successful completion
FND Debug shows:
po.plsql.PO_PDOI_LINE_PROCESS_PVT.default_txn_header_id.50 1 End OU ID is null due to invalid ship_to_organization_id
po.plsql.PO_PDOI_ERR_UTL.add_fatal_error.BEGIN 2 Start of subprogram.
po.plsql.PO_PDOI_ERR_UTL.add_error.BEGIN 2 Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.add_to_errors_tbl.BEGIN 2 err_name = PO_PDOI_INVALID_SHIP_TO_ORG_ID
....
po.plsql.PO_PDOI_POSTPROC_PVT.process.0 1 inside loop
po.plsql.PO_PDOI_POSTPROC_PVT.process.0 1 num of records fetched: 1
po.plsql.PO_PDOI_POSTPROC_PVT.process.20 1 interface_header_id: 2145438, processing header_id: 1493258, action: ORIGINAL
po.plsql.PO_PDOI_POSTPROC_PVT.post_validate.BEGIN 2 Start of subprogram.
po.plsql.PO_PDOI_POSTPROC_PVT.post_validate.20 1 failed Check 2
po.plsql.PO_PDOI_ERR_UTL.add_fatal_error.BEGIN 2 Start of subprogram.
po.plsql.PO_PDOI_ERR_UTL.add_error.BEGIN 2 Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.add_to_errors_tbl.BEGIN 2 err_name = PO_PDOI_INVALID_NUM_OF_LINES
.....
po.plsql.PO_INTERFACE_S.post_process_pdoi_autocreate.BEGIN 2 Start of subprogram
po.plsql.PO_INTERFACE_S.post_process_pdoi_autocreate.020 1 x_document_number
po.plsql.PO_INTERFACE_S.post_process_pdoi_autocreate.020 1 x_number_lines 0
po.plsql.PO_INTERFACE_S.wrapup.BEGIN 2 Start of subprogram.
po.plsql.PO_INTERFACE_S.wrapup.END 2 End of subprogram.
po.plsql.PO_INTERFACE_S.post_process_pdoi_autocreate.END 2 End of subprogram.
po.plsql.PO_INTERFACE_S.create_pdoi_po.END 2 End of subprogram.
po.plsql.PO_INTERFACE_S.create_documents.150 1 Sourcing to FPH-2 Ends
po.plsql.PO_INTERFACE_S.create_documents.150 1 Create_documents: number of records processed: 0
po.plsql.PO_INTERFACE_S.create_documents.180 1 Update Source Attributes End: interface:PO:Source: AUTOCREATEDoc: STANDARDNeg:
po.plsql.PO_INTERFACE_S.create_documents.END 2 End of subprogram.
per.resource.HRKPI.hr_kpi_extlib.event 2 begin
per.resource.HRKPI.hr_kpi_extlib.event 1 #event_name#WHEN-VALIDATE-RECORD*formname*POXBWVRP
per.resource.HRKPI.hr_kpi_extlib.event 2 end
Start FV PLD ...... 1 FV.pld
po.plsql.po_message_s.AUTOCREATE_DOCUMENTS.008.EXCEPTION 4 ;SQLERRM = ORA-0000: normal, successful completion
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |