Search Results po_autocreate_doc
Overview
PO_AUTOCREATE_DOC is an Oracle EBS PL/SQL package owned by the APPS schema that supports the Oracle Purchasing AutoCreate workflow. Its primary business function is to drive the automatic creation of purchase order and blanket agreement documents from approved requisition lines, enforcing the sourcing rules, buyer defaults, and release generation rules configured for the operating unit. The package is classified as a general-purpose (OTHER) API and is not a public, supported interface, so it is typically invoked by Oracle's own requisition processing, workflow, and document action logic rather than by customer code. It is validated in both 12.1.1 and 12.2.2 and references standard SYS objects as well as various APPS synonyms.
Key Procedures and Functions
The ETRM metadata documents 47 procedures and functions. The following representative entries illustrate the package's responsibilities:
- SHOULD_REQ_BE_AUTOCREATED — Evaluates whether a given requisition line qualifies for automatic document creation based on sourcing and profile criteria.
- GET_REQ_INFO — Retrieves requisition line attributes needed for downstream autocreation processing.
- IS_SOURCE_DOC_INFO_OK — Validates that source document information (contract, agreement, or blanket) is complete and usable.
- DOES_CONTRACT_EXIST and GET_SOURCE_DOC_TYPE — Determine whether an existing contract or source document applies and identify its type.
- RFQ_REQUIRED_CHECK and ONE_TIME_ITEM_CHECK — Apply business rules for whether an RFQ is required and whether the requisition line references a one-time item.
- GET_BUYER_FROM_REQ_LINE, GET_BUYER_FROM_ITEM, GET_BUYER_FROM_CATEGORY, GET_BUYER_FROM_SOURCE_DOC, GET_BUYER_FROM_CONTRACT — Resolve the appropriate buyer using the requisition line, item, category, source document, or contract.
- GET_SUPP_INFO_FOR_ACRT, GET_REL_GEN_METHOD, IS_REQ_PCARD_LINE — Retrieve supplier information, determine the release generation method, and identify procurement card lines.
- START_WF_PROCESS, START_WF_LINE_PROCESS, LAUNCH_REQ_LINE_PROCESSING, CONT_WF_AUTOCREATE_REL_GEN — Manage the workflow processes that drive autocreation and release generation.
- INSERT_CAND_REQ_LINES_INTO_TBL — Populates the candidate requisition line table used for subsequent autocreation runs.
Tables Accessed
The package reads and writes the following documented tables via APPS synonyms:
- PO_DRAFTS — Stores the draft purchase order or blanket agreement created during autocreation.
- PO_DOCUMENT_TYPES, PO_DOCUMENT_TYPES_ALL_B, PO_DOC_STYLE_HEADERS — Provide document type and style configuration.
- PO_AGENTS, PO_GA_ORG_ASSIGNMENTS, PO_ASL_ATTRIBUTES — Supply buyer, organization assignment, and approved supplier list data.
- MTL_SYSTEM_ITEMS, HR_LOCATIONS_ALL, PER_ALL_PEOPLE_F, FND_USER — Provide item, location, person, and user reference data.
- ECE_TP_DETAILS — Stores trading partner details used in supplier resolution.
- FINANCIALS_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMS_ALL — Supply operating unit and system-level profile values.
- FND_NEW_MESSAGES — Supports message and notification handling.
Usage Notes
PO_AUTOCREATE_DOC is invoked indirectly through Oracle Purchasing's requisition autocreation and workflow processes rather than being called from EBS forms directly. It is referenced by PO_DOCUMENT_ACTIONS_SV and PO_REQAPPROVAL_LAUNCH, and it is referenced by two other packages, indicating it is a dependency of the autocreate and document action flows. Because it is classified as OTHER, it is not part of the supported public API surface; customizations should avoid calling its procedures directly, as signatures and behavior may change between releases. Administrators typically interact with this functionality through the AutoCreate concurrent program and the Purchasing responsibility, where the package's buyer-resolution, sourcing, and workflow logic executes behind the scenes.
-
PACKAGE: APPS.PO_AUTOCREATE_DOC
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_AUTOCREATE_DOC, status:VALID,
-
PACKAGE: APPS.PO_AUTOCREATE_DOC
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_AUTOCREATE_DOC, status:VALID,
-
PACKAGE BODY: APPS.PO_AUTOCREATE_DOC
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_AUTOCREATE_DOC, status:VALID,
-
SYNONYM: APPS.PO_WF_CANDIDATE_REQ_LINES_TEMP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_WF_CANDIDATE_REQ_LINES_TEMP, status:VALID,
-
PACKAGE BODY: APPS.PO_AUTOCREATE_DOC
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_AUTOCREATE_DOC, status:VALID,
-
SYNONYM: APPS.PO_WF_GROUP_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_WF_GROUP_S, status:VALID,
-
SYNONYM: APPS.PO_WF_GROUP_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_WF_GROUP_S, status:VALID,
-
SYNONYM: APPS.PO_HEADERS_INTERFACE_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_HEADERS_INTERFACE_S, status:VALID,
-
SYNONYM: APPS.PO_WF_CANDIDATE_REQ_LINES_TEMP
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_WF_CANDIDATE_REQ_LINES_TEMP, status:VALID,
-
PACKAGE: APPS.PO_PCARD_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_PCARD_PKG, status:VALID,
-
PACKAGE: APPS.PO_PCARD_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_PCARD_PKG, status:VALID,
-
SYNONYM: APPS.PO_HEADERS_INTERFACE_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_HEADERS_INTERFACE_S, status:VALID,
-
PACKAGE: APPS.PO_INTERFACE_S
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_INTERFACE_S, status:VALID,
-
PACKAGE: APPS.POR_UTIL_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:POR_UTIL_PKG, status:VALID,
-
PACKAGE BODY: APPS.PO_REQAPPROVAL_LAUNCH
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_REQAPPROVAL_LAUNCH, status:VALID,
-
PACKAGE: APPS.PO_INTERFACE_S
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_INTERFACE_S, status:VALID,
-
PACKAGE: APPS.PO_THIRD_PARTY_STOCK_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_THIRD_PARTY_STOCK_GRP, status:VALID,
-
SYNONYM: APPS.PO_LINES_INTERFACE_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_LINES_INTERFACE_S, status:VALID,
-
PACKAGE: APPS.POR_UTIL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:POR_UTIL_PKG, status:VALID,
-
PACKAGE: APPS.PO_DOC_STYLE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_DOC_STYLE_PVT, status:VALID,
-
PACKAGE: APPS.PO_SHARED_PROC_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_SHARED_PROC_PVT, status:VALID,
-
PACKAGE: APPS.PO_THIRD_PARTY_STOCK_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_THIRD_PARTY_STOCK_GRP, status:VALID,
-
SYNONYM: APPS.PO_LINES_INTERFACE_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_LINES_INTERFACE_S, status:VALID,
-
PACKAGE: APPS.PO_SHARED_PROC_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_SHARED_PROC_PVT, status:VALID,
-
PACKAGE: APPS.PO_CURRENCY_SV
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_CURRENCY_SV, status:VALID,
-
PACKAGE: APPS.PO_DOC_STYLE_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_DOC_STYLE_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_DOCUMENT_ACTIONS_SV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DOCUMENT_ACTIONS_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_REQAPPROVAL_LAUNCH
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_REQAPPROVAL_LAUNCH, status:VALID,
-
PACKAGE: APPS.PO_CORE_SV1
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_SV1, status:VALID,
-
PACKAGE: APPS.PO_CURRENCY_SV
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CURRENCY_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_DOCUMENT_ACTIONS_SV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DOCUMENT_ACTIONS_SV, status:VALID,
-
PACKAGE: APPS.PO_CORE_SV1
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_SV1, status:VALID,
-
PACKAGE: APPS.PO_DOC_STYLE_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_DOC_STYLE_GRP, status:VALID,
-
PACKAGE: APPS.PO_DOC_STYLE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_DOC_STYLE_PVT, status:VALID,
-
PACKAGE: APPS.PO_CONSTANTS_SV
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_CONSTANTS_SV, status:VALID,
-
PACKAGE: APPS.PO_CONSTANTS_SV
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CONSTANTS_SV, status:VALID,
-
VIEW: APPS.PO_BUYERS_V
12.2.2
owner:APPS, object_type:VIEW, object_name:PO_BUYERS_V, status:VALID,
-
PACKAGE: APPS.PO_TAX_INTERFACE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_TAX_INTERFACE_PVT, status:VALID,
-
PACKAGE: APPS.PO_GA_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_GA_PVT, status:VALID,
-
PACKAGE: APPS.PO_TAX_INTERFACE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_TAX_INTERFACE_PVT, status:VALID,
-
SYNONYM: APPS.ECE_TP_DETAILS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:ECE_TP_DETAILS, status:VALID,
-
PACKAGE: APPS.PO_CORE_S2
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_S2, status:VALID,
-
SYNONYM: APPS.ECE_TP_DETAILS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:ECE_TP_DETAILS, status:VALID,
-
SYNONYM: APPS.PO_WF_ITEMKEY_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_WF_ITEMKEY_S, status:VALID,
-
SYNONYM: APPS.PO_DOCUMENT_TYPES_ALL_B
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_DOCUMENT_TYPES_ALL_B, status:VALID,
-
SYNONYM: APPS.PO_AGENTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_AGENTS, status:VALID,
-
SYNONYM: APPS.PO_AGENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_AGENTS, status:VALID,
-
SYNONYM: APPS.PO_DOC_STYLE_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_DOC_STYLE_HEADERS, status:VALID,
-
VIEW: APPS.PO_SUPPLIER_CONTACTS_VAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_SUPPLIER_CONTACTS_VAL_V, object_name:PO_SUPPLIER_CONTACTS_VAL_V, status:VALID,
-
PACKAGE: APPS.PO_CORE_S2
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_S2, status:VALID,