Search Results gen_xml_body_strategy

Overview

APPS.IEX_STRATEGY_DIAG_REPORT is a diagnostic utility package in the Oracle E-Business Suite Advanced Collections (IEX) module. Its purpose is to produce a structured diagnostic report that describes the configuration and behavior of a collections strategy — the rules-based engine that determines when and how delinquent customers are contacted, dunned, or referred to a work item. The package assembles strategy metadata (strategies, templates, work items, work skills, delinquency data, and customer/resource context) and renders it as XML output, which is then emitted to a concurrent program log or output file. The implementation is a standard EBS PL/SQL diagnostic pattern: a MAIN driver procedure orchestrates header, body, and closing-tag generation, while localized helpers handle logging, LOB printing, and string escaping.

The body carries the version identifier iexstdgb.pls 120.4 2011/05/04. The noship designation confirms it ships as a support/diagnostic artifact rather than as a customer-facing product API, and it is referenced by zero other packages, so it is a leaf-level module invoked only externally.

Key Procedures and Functions

• MAIN — Entry point that drives the diagnostic report generation for a given strategy, sequencing the XML sections.
• WRITELOG — Writes a message to the diagnostic log, gated by the PG_DEBUG level; delegates to IEX_DEBUG_PUB.LogMessage.
• FORMAT_STRING — Escapes XML-reserved characters in a string, replacing ampersands and the </> sequences so that embedded data does not break the generated XML. This is the routine most likely to appear in a user search for "format_string".
• GET_RESOURCE — Resolves resource information used in the report body.
• GEN_XML_HEADER_DATA_STRATEGY — Emits the XML header and strategy-level attributes.
• GEN_XML_BODY_STRATEGY — Emits the strategy body content.
• GEN_XML_BODY_WI — Emits the work-item body section.
• GEN_XML_BODY_AUTO_WI — Emits the automatic work-item body section.
• GEN_XML_CORPT_STR_LIST — Emits the list of strategies for a corporate/collector context.
• GEN_XML_APPEND_CLOSETAG_STY — Appends the strategy closing element.
• PRINT_CLOB — Iterates a CLOB line by line using DBMS_LOB.INSTR and DBMS_LOB.SUBSTR, writing each extracted line to the EBS file log.

Tables Accessed

All access is via APPS synonyms. Strategy definition tables include IEX_STRATEGIES, IEX_STRATEGY_TEMPLATES_TL, IEX_STRY_TEMP_WORK_ITEMS_B, IEX_STRATEGY_WORK_ITEMS, IEX_STRATEGY_WORK_SKILLS, and IEX_STRATEGY_WORK_TEMP_XREF. Delinquency and dunning context come from IEX_DELINQUENCIES_ALL, IEX_DUNNINGS, and AR_PAYMENT_SCHEDULES_ALL. Customer and resource context is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, and JTF_RS_RESOURCE_EXTNS. IEX_APP_PREFERENCES_B supplies application preference values that influence report behavior. The package is read-only against these objects.

Usage Notes

This is a diagnostic/support tool invoked through a concurrent program or by support engineers running the routine manually in a test or investigation scenario. Output is written to the concurrent manager log file, not to a persistent application table. Because it is classified as OTHER and referenced by no other packages, it should not be embedded in custom code as a dependency. EBS 12.1.1 and 12.2.2 behave identically here; the CLOB and DBMS_LOB calls are release-independent, and the online patching model in 12.2.2 does not alter runtime behavior of the package.