Search Results jtf_fm_ocm_rend_req
Overview
JTF_FM_OCM_REND_REQ is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the fulfillment rendition framework within Oracle's Order Capture and Fulfillment Management modules. Its primary business purpose is to generate and manage renditions — formatted, deliverable outputs such as printed documents, emails, or other rendered content — associated with fulfillment requests. The package bridges the fulfillment request infrastructure (JTF_FM_REQUEST_GRP and JTF_FULFILLMENT_PUB) with the content management structures used to store and version actual document artifacts. In EBS 12.1.1 and 12.2.2, this package is documented as VALID in the ETRM repository and is classified as an "OTHER" API type, indicating it is primarily intended for internal framework consumption rather than as a public, customer-facing API. It depends on FND_API for standard error handling and message conventions, ASO_ORDER_INT for order integration data, and JTF_FM_OCM_REQUEST_GRP for request grouping logic.
Key Procedures and Functions
Two documented program units are exposed by this package:
- CREATE_FULFILLMENT_RENDITION — Creates a rendition record for a fulfillment request. This procedure is responsible for assembling the output artifact associated with a fulfillment request, persisting it into the content management tables, and linking it to the originating request. It is the entry point invoked when an order or fulfillment process requires a deliverable rendition to be generated and stored.
- GET_OCM_REND_DETAILS — Retrieves the details of an Order Capture Management rendition. This procedure or function returns the metadata and content information associated with an existing rendition, enabling downstream processes (such as notifications, printing, or archival) to access the rendered output and its descriptive attributes.
Both units operate within the standard FND_API error-handling paradigm, consistent with EBS framework conventions for returning status and message information to callers.
Tables Accessed
The package reads and writes the following documented tables via APPS synonyms:
- JTF_FM_REQUEST_CONTENTS — Stores the contents associated with fulfillment requests; central to rendition creation and retrieval.
- JTF_FM_REQUEST_HISTORY_ALL — Maintains the history of fulfillment request activity, supporting audit and status tracking for rendition actions.
- IBC_CONTENT_ITEMS and IBC_CITEM_VERSIONS_B — Content item and version tables from the iContent repository, holding the actual rendition artifacts and their versioning metadata.
- FND_LOBS — Stores large binary objects (LOBs) for rendered documents, such as PDFs or other attachment content.
- JTF_FM_TEST_REQUESTS — Used for test fulfillment requests, supporting validation and diagnostic scenarios.
- PLITBLM — The standard PL/SQL integer table type used for passing collections of identifiers into and out of the package.
Usage Notes
JTF_FM_OCM_REND_REQ is invoked primarily through the fulfillment and Order Capture Management framework. Its documented dependents — AMS_CT_RULE_PVT, AMS_FULFILL_PVT, JTF_FM_REQUEST_GRP, and the JTF_FM_OCM_REND_REQ_W wrapper — indicate that it is called during fulfillment execution, marketing campaign fulfillment rules, and request group processing. It is not typically invoked directly by end users via a concurrent program or standard form; instead, it is called programmatically by framework packages (and the _W wrapper) that manage fulfillment request lifecycles. Customizations that require generated renditions to be attached to fulfillment requests, or that need to read existing rendition details, should call this package through its wrapper or the JTF_FULFILLMENT_PUB public layer rather than referencing it directly, to remain aligned with Oracle's supported integration surface.
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REND_REQ, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REQUEST_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REQUEST_GRP, status:VALID,
-
PACKAGE: APPS.JTF_FULFILLMENT_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FULFILLMENT_PUB, status:VALID,
-
PACKAGE: APPS.JTF_FULFILLMENT_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FULFILLMENT_PUB, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REND_REQ, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REQUEST_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_OCM_REQUEST_GRP, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_OCM_REND_REQ, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_OCM_REND_REQ, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ
12.2.2
-
PACKAGE: APPS.ASO_ORDER_INT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ASO_ORDER_INT, status:VALID,
-
PACKAGE: APPS.JTF_FM_OCM_REND_REQ
12.1.1
-
PACKAGE: APPS.ASO_ORDER_INT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ASO_ORDER_INT, status:VALID,
-
SYNONYM: APPS.JTF_FM_TEST_REQUESTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_FM_TEST_REQUESTS, status:VALID,
-
SYNONYM: APPS.JTF_FM_REQUEST_CONTENTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_FM_REQUEST_CONTENTS, status:VALID,
-
SYNONYM: APPS.JTF_FM_TEST_REQUESTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_FM_TEST_REQUESTS, status:VALID,
-
SYNONYM: APPS.JTF_FM_REQUEST_HISTORY_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_FM_REQUEST_HISTORY_ALL, status:VALID,
-
SYNONYM: APPS.JTF_FM_REQUEST_CONTENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_FM_REQUEST_CONTENTS, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ_W
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_OCM_REND_REQ_W, status:VALID,
-
PACKAGE: APPS.JTF_FM_UTL_V
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_UTL_V, status:VALID,
-
PACKAGE: APPS.JTF_FM_UTL_V
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_UTL_V, status:VALID,
-
SYNONYM: APPS.JTF_FM_REQUEST_HISTORY_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_FM_REQUEST_HISTORY_ALL, status:VALID,
-
PACKAGE: APPS.IBC_CITEM_ADMIN_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IBC_CITEM_ADMIN_GRP, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_OCM_REND_REQ_W
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_OCM_REND_REQ_W, status:VALID,
-
PACKAGE BODY: APPS.AMS_FULFILL_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_FULFILL_PVT, status:VALID,
-
PACKAGE: APPS.IBC_CITEM_ADMIN_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IBC_CITEM_ADMIN_GRP, status:VALID,
-
PACKAGE BODY: APPS.AMS_CT_RULE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_CT_RULE_PVT, status:VALID,
-
SYNONYM: APPS.IBC_CITEM_VERSIONS_B
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IBC_CITEM_VERSIONS_B, status:VALID,
-
PACKAGE BODY: APPS.AMS_CT_RULE_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_CT_RULE_PVT, status:VALID,
-
PACKAGE BODY: APPS.AMS_FULFILL_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_FULFILL_PVT, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_REQUEST_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_REQUEST_GRP, status:VALID,
-
SYNONYM: APPS.IBC_CITEM_VERSIONS_B
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IBC_CITEM_VERSIONS_B, status:VALID,
-
PACKAGE BODY: APPS.JTF_FM_REQUEST_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JTF_FM_REQUEST_GRP, status:VALID,
-
SYNONYM: APPS.IBC_CONTENT_ITEMS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IBC_CONTENT_ITEMS, status:VALID,
-
SYNONYM: APPS.IBC_CONTENT_ITEMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IBC_CONTENT_ITEMS, status:VALID,
-
TYPE: APPS.JTF_VARCHAR2_TABLE_32767
12.1.1
owner:APPS, object_type:TYPE, object_name:JTF_VARCHAR2_TABLE_32767, status:VALID,
-
TYPE: APPS.JTF_VARCHAR2_TABLE_32767
12.2.2
owner:APPS, object_type:TYPE, object_name:JTF_VARCHAR2_TABLE_32767, status:VALID,
-
PACKAGE: APPS.JTF_FM_REQUEST_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_REQUEST_GRP, status:VALID,
-
PACKAGE: APPS.JTF_FM_REQUEST_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_FM_REQUEST_GRP, status:VALID,
-
VIEW: APPS.IBC_CITEM_VERSIONS_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IBC.IBC_CITEM_VERSIONS_VL, object_name:IBC_CITEM_VERSIONS_VL, status:VALID,
-
VIEW: APPS.IBC_CITEM_VERSIONS_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IBC.IBC_CITEM_VERSIONS_VL, object_name:IBC_CITEM_VERSIONS_VL, status:VALID,
-
SYNONYM: APPS.FND_LOBS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_LOBS, status:VALID,
-
SYNONYM: APPS.FND_LOBS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_LOBS, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
VIEW: APPS.IBC_CITEMS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IBC.IBC_CITEMS_V, object_name:IBC_CITEMS_V, status:VALID,
-
VIEW: APPS.IBC_CITEMS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IBC.IBC_CITEMS_V, object_name:IBC_CITEMS_V, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
APPS.JTF_FM_OCM_REND_REQ_W dependencies on JTF_FM_OCM_REND_REQ
12.2.2
-
eTRM - IBC Tables and Views
12.1.1
description: IBC_STYLESHEETS stores the associated stylesheets for a given content type. ,