Search Results create_order

Overview

CSF_DEBRIEF_CREATE_ORDER is an Oracle E-Business Suite (EBS) PL/SQL package body owned by the APPS schema that serves as a service-desk and field-service integration utility. Its documented purpose is to convert customer debrief information captured during an interaction — a service request, a field visit, or a call-centre conversation — into a sales order within Oracle Order Management. The package name derives from the "debrief" concept in Oracle TeleService and Field Service, where an agent or technician records the outcome of a customer contact and, where a sale results, a quote or order must be generated programmatically.

The header comment block records the source file as csfpodcb.pls and shows that the body was reviewed and modified by Ildiko Balint in August 2000, with the packaged file revision stamped 115.5 on 5 December 2000. The object therefore originates in the early 11i codebase and remains deployable in the 12.1.1 and 12.2.2 releases. The ETRM classification for this object is OTHER, indicating it is a product-specific wrapper rather than a formally published public API. It is not referenced by any other documented package within the ETRM inventory.

Key Procedures and Functions

The package body exposes a single documented procedure, CREATE_ORDER. Internally this procedure is a staging and hand-off routine: it populates a quote header record of type ASO_QUOTE_PUB.Qte_Header_Rec_Type, together with associated line, payment, shipment, and tax-detail collections, and then passes order header and line structures of type ASO_ORDER_INT.Order_Header_rec_type to the Oracle Order Management order-capture interfaces.

The procedure accepts a broad set of inbound attributes covering currency, customer party, inventory item, quantity, unit of measure, order type, quote header, price list, employee, customer account, and shipment. It returns the newly created order header identifier, a standard return status, a message count, and message data — the conventional EBS API out-parameter convention. The body declares dedicated local variables to capture the Order Management return status, message count, and message data separately from the ASO return values, allowing the ASO quote and OM order outcomes to be evaluated independently.

Tables Accessed

The supplied ETRM metadata does not enumerate base tables reached through APPS synonyms for this object. Because the procedure operates through the ASO_QUOTE_PUB and ASO_ORDER_INT packaged interfaces rather than through direct DML, its table footprint is inherited from those packages. In practice this means the Oracle Quoting and Order Management interface tables — quote headers and lines, order headers and lines interface — are the principal persistence points, with pricing, payment, shipment, and tax detail records written as subordinate collections. Direct inserts or updates against service, order, or quoting base tables are not documented in the package source excerpt.

Usage Notes

This package is an integration-layer component rather than an end-user API. It is typically invoked from Oracle TeleService or Field Service debrief flows, where a customer interaction results in an orderable line and the application must create the corresponding order without exposing the user to the Order Management interface directly. Customisations that extend debrief-to-order behaviour may call CSF_DEBRIEF_CREATE_ORDER.CREATE_ORDER from a form trigger, a workflow activity, or a concurrent program wrapper.

Because the object is classified as OTHER and is not referenced elsewhere in the documented package inventory, integrators should treat the procedure signature as internal and confirm its signature against the deployed package before relying on it in custom code. In 12.1.1 and 12.2.2 deployments, any custom invocation should honour the standard EBS error-handling pattern: inspect the return status and iterate over the message count to retrieve all messages via FND_MSG_PUB.