Search Results truncate_string

Overview

CLN_RN_UTILS is a RosettaNet utility package in the Oracle E-Business Suite APPS schema, defined with AUTHID CURRENT_USER. Its primary business function is to support the exchange of RosettaNet business messages in Oracle EBS 12.1.1 and 12.2.2 by converting date and datetime values between the server time zone and the canonical RosettaNet formats, and by providing supporting utilities for XML validation, role resolution, and item configuration. RosettaNet payloads require strict formatting such as YYYYMMDDThhmmss.SSSZ for datetimes and YYYYMMDDZ for dates. This package encapsulates the conversion logic so that outbound messages carry correctly formatted timestamps and inbound messages can be reliably parsed back into Oracle DATE values. The package comprises 22 documented procedures and functions and is referenced by three other packages, indicating it acts as a shared service within the CLN (RosettaNet) integration layer.

Key Procedures and Functions

The conversion routines are the core of the package. CONVERT_TO_RN_TIMEZONE converts a server-time-zone date into the RosettaNet time zone, returning a UTC date. CONVERT_TO_RN_DATETIME converts a server date into the RosettaNet datetime string format; if the input is NULL, SYSDATE is used. CONVERT_TO_RN_DATE_EVENT splits a server date into separate RosettaNet date and time strings. CONVERT_TO_RN_DATE produces only the RosettaNet date string. CONVERT_TO_DB_DATE performs the reverse operation, parsing a RosettaNet date or datetime string into an Oracle DATE; the user search term "convert_to_db_date" refers specifically to this procedure. Additional documented routines include CONVERT_NUMBER_TO_CHAR for numeric-to-character conversion; GET_FROM_ROLE and GET_TO_ROLE for resolving RosettaNet trading-partner roles; VALIDATE_XML and GET_TAG_VALUE_FROM_XML for XML parsing and validation; GET_ITEM_CONFIG_PARAMS and CREATE_ITEM_CONFIG_TAG for item configuration handling; GET_USER_ID for FND user resolution; GETPURCHASEORDERNUM, GETRELNUM, GETREVNUM, CONCAT_PO_RELNUM and CONCAT_PORELNUM_REVNUM for assembling purchase order, release, and revision identifiers; GETTAGPARAMVALUE for retrieving tag parameters; and TRUNCATE_STRING for length-restricted string handling.

Tables Accessed

The package references several tables through APPS synonyms. CLN_RN_VALIDATIONS records RosettaNet validation data, while ECX_DOCLOGS and ECX_TP_HEADERS belong to the XML Gateway/Exchange infrastructure and support document logging and trading-partner header information. FND_USER is read for user identity resolution via GET_USER_ID. HR_LOCATIONS_ALL supplies location data used in partner or address resolution. HZ_CONTACT_POINTS and HZ_PARTIES provide TCA party and contact information required to map RosettaNet partner identifiers to EBS entities. WF_EVENT_T is used in the Workflow event context. The package also depends on PL/SQL-supplied packages DBMS_LOB for large-object handling, and XMLDOM, XMLPARSER, and PLITBLM for XML document construction and parsing.

Usage Notes

CLN_RN_UTILS is typically invoked from the RosettaNet integration layer rather than from standard EBS forms, serving as a programmatic API for outbound message generation and inbound message processing. Because CONVERT_TO_DB_DATE accepts a RosettaNet-formatted string and returns an Oracle DATE, custom integration code, concurrent programs, or message-handler packages should call it whenever an external RosettaNet timestamp must be normalized for database storage. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the calling schema, so callers must themselves hold the necessary privileges on the underlying tables and packages. As with all Oracle EBS customization, the package should be treated as a documented API whose internal implementation may change between patch levels, and direct modification should be avoided in favor of supported extension points.