Search Results convert_to_uccnet_date




Overview
Explore in AI Chat

Overview

M4U_UCC_UTILS is a private PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, associated with the CLN (Supply Chain/Inventory) product family and the EGO_ITEM business entity. Its name derives from its dual role: "M4U" denotes the Message for UCCnet framework, Oracle's XML Gateway-based messaging solution for electronic trading partner communication, while "UCC" refers to UCCnet, the data synchronization network (later subsumed into GS1) used by retailers and suppliers to exchange item catalog data such as product descriptions, dimensions, and pricing. The package provides low-level helper routines that are invoked from M4U XML Gateway message maps, the declarative transformation objects that translate between Oracle's internal data model and standardized UCCnet XML message structures.

The package declares AUTHID CURRENT_USER, meaning its unqualified references resolve against the calling schema's privileges rather than the definer's, a common pattern for packages executed in the context of the invoking session. It defines a set of constants that pin the integration to specific UCCnet conventions: an application ID of 431, a party type of 'I' (indicating an individual or internal party), a party site name of 'UCCNET', a document type of 'M4U', and a collection point of 'APPS'. These constants ensure consistent addressing information is applied whenever messages are constructed.

Key Procedures and Functions

The documented API surface comprises eleven procedures and functions:

  • CONVERT_TO_UCCNET_DATE — converts an Oracle DATE value into the string representation required for UCCnet date fields.
  • CONVERT_TO_UCCNET_DATETIME — extends the same conversion to include time components, producing a UCCnet-formatted date-time string.
  • CONVERT_TO_DATE — performs the inverse operation, parsing a formatted string back into Oracle's native date type.
  • GET_LOOKUP_MEANING — retrieves the descriptive meaning for a given FND lookup type and lookup code combination, allowing message maps to emit human-readable values instead of internal codes.
  • GET_SYS_DATE — returns the current system date, typically used to stamp outbound messages with a consistent timestamp.
  • GET_TIME and GET_TIME_ZONE — supply time and time-zone values needed to complete UCCnet date-time fields.
  • GET_GUID — generates a globally unique identifier, a mandatory element in UCCnet/GDSN messaging for uniquely identifying documents and data pools.
  • PROCESS_CATALOGUE_ITEM_STATUS — handles the status processing of catalogue items as part of the item synchronization workflow.
  • FORMAT_INDUSTRY_EXT_STRING — formats industry-specific extension strings appended to UCCnet messages, supporting trading-partner-specific attributes.
  • VALIDATE_UCCNET_ATTR — validates item attributes against UCCnet rules prior to message publication.

Tables Accessed

The package references four objects, all through APPS synonyms. WF_SYSTEMS supplies the local system name, consistent with the package's g_local_system variable declaration typed against wf_systems.name. ECX_TP_HEADERS holds XML Gateway trading partner metadata and is consulted for partner addressing and configuration. HR_LOCATIONS_ALL provides location and address information, likely used when constructing party-site or GLN-related address data. DUAL is used for trivial single-row evaluations such as retrieving the system date.

Usage Notes

M4U_UCC_UTILS is not intended for direct invocation by end users. It is called from M4U XML Gateway message maps during outbound catalogue publication and inbound acknowledgment processing, and it is referenced by seven other packages, indicating it acts as a shared foundation within the M4U integration layer. Customizations should preserve the documented signatures, as changes ripple across those dependent objects. The header comment indicates the package has been stable since at least 2006 (version 120.1), and it remains documented in ETRM for 12.2.2.