Search Results ne_connect_retry_count




Overview
Explore in AI Chat

Overview

XDP_MACROS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that underpins the eCommunication / eCommerce message-handling infrastructure used by Oracle Advanced Supply Chain Planning and Oracle Order Management integrations with external fulfillment systems. The package is declared with AUTHID CURRENT_USER and dates to the 11.5.6 release line (XDPMACRS.pls 120.1). Its principal responsibility is to encapsulate the outbound command lifecycle — construction, transmission, timeout management, retry logic, response retrieval, and audit — that connects EBS business events to external execution systems (typically a fulfillment engine or logistics provider).

An important theme in this package is the handling of configurable adapter attributes that govern communication behaviour. Several public variables map directly to these attributes, including NE_CMD_TIMEOUT, NE_CMD_RETRY_COUNT, NE_CMD_WAIT, NE_NO_ACTIVITY_TIMEOUT, and the dummy keep-alive command attribute. The variable holding the retry count attribute (pv_attrFeRetryCount, mapped to NE_CMD_RETRY_COUNT) is the runtime hook behind the user's search term, ne_cmd_retry_count. Retry behaviour is further governed by pv_AutoRetry and the AUTO_RETRY_ENABLED function.

Key Procedures and Functions

The package exposes 26 documented procedures and functions, summarised by function:

  • SEND_SYNC — synchronously transmits a command and waits for the matching response in a single call.
  • SEND and SEND_HTTP — asynchronous dispatch of a command, with the HTTP variant targeting web-based adapters.
  • GET_RESPONSE, GET_LONG_RESPONSE, and RESPONSE_CONTAINS — retrieve and interrogate the returned payload, including long responses buffered in a CLOB.
  • GET_PARAM_VALUE and GET_ATTR_VALUE — resolve configuration values, including adapter attributes such as the command retry count.
  • NOTIFY_ERROR — raises/handles the package-defined exceptions (e_AdapterNotUpException, e_CommandTimedoutException, e_SessionLostException, e_FEFailureException, e_NotifyError).
  • AUDIT — records command/response traffic for traceability.
  • AUTO_RETRY_ENABLED — determines whether automatic re-transmission applies, driving behaviour derived from NE_CMD_RETRY_COUNT.
  • SEND_CONNECT, APPENDCONNECTCOMMANDS, FETCH_CONNECT_COMMANDS — manage the connect-command list held in g_ConnectCommands.
  • RESETCOMMANDBUFFER — clears the buffered command state between operations.
  • INITDEFAULT, INITFP, INITCONNECTION, INITDISCONNECTION, ENDPROC — setup, connection establishment/teardown, and cleanup lifecycle entry points.

Tables Accessed

The package references XDP_FE_CMD_AUD_TRAILS and its sequence XDP_FE_CMD_AUD_TRAILS_S for writing command audit records through AUDIT. It also relies on the DBMS_LOB, PLITBLM, and UTL_HTTP built-ins for large-object handling and HTTP transport respectively.

Usage Notes

XDP_MACROS is typically invoked from the eCommerce/eCommunication concurrent programs and forms that drive outbound fulfillment messages, and it is referenced by six other packages. The NE_CMD_RETRY_COUNT attribute (via pv_attrFeRetryCount) is set by administrators to control how many times a failed command is re-sent; increasing it, together with NE_CMD_WAIT, improves resilience on unreliable networks, but excessive values prolong batch runtimes.