Results for “get_dso_period_profile”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.FII_AR_UTIL_PKG is a shared PL/SQL utility package body in the Oracle E-Business Suite Financial Intelligence and Enterprise TRM (FII) application family. Its principal business function is to supply the common analytical and setup logic required by the Accounts Receivable (AR) reporting components, most notably Days Sales Outstanding (DSO) and related receivables trend analyses. The package acts as a reusable service layer: it resolves operating unit context, retrieves profile-driven setup values, manages the display and global currency conventions, and constructs the dynamic SQL predicates and materialized-view filters consumed by the AR analytical reports.

The package is validated and resides in the APPS schema. The ETRM repository records no incoming database references — the object is not referenced by any database object — but it is referenced by twenty-five other packages, confirming its role as a foundational dependency in the FII reporting stack. It is classified as OTHER, indicating it is an internal utility rather than a published public API.

Key Procedures and Functions

Twenty-two documented procedures and functions are exposed. They fall into four functional groups.

• Session and global state: RESET_GLOBALS clears package-level state between executions; BIND_VARIABLE supports dynamic SQL binding; INSERT_INTO_DEBUG_TABLE writes diagnostic output for troubleshooting.
• Setup and parameter resolution: GET_PARAMETERS collects report parameters; GET_DSO_SETUP_VALUE and GET_DSO_TABLE_VALUES read DSO configuration; GET_DSO_PERIOD_PROFILE and GET_TREND_VIEWBY resolve period and trend-viewing preferences; GET_SEC_PROFILE resolves the security profile.
• Organizational and currency context: POPULATE_PARTY_ID; DETERMINE_OU_LOV; GET_BUSINESS_GROUP; GET_CURR; GET_PRIM_GLOBAL_CURRENCY_CODE; GET_SEC_GLOBAL_CURRENCY_CODE; GET_DISPLAY_CURRENCY; GET_DSO_PERIOD_PROFILE; GET_SEC_PROFILE.
• Data preparation and SQL generation: POPULATE_SUMMARY_GT_TABLES populates global temporary tables used for report aggregation; GET_FROM_STATEMENT, GET_WHERE_STATEMENT, and GET_MV_WHERE_STATEMENT construct the FROM, WHERE, and materialized-view filter clauses used by the DSO queries.

Procedure parameters are not documented in the source metadata and are therefore not reproduced here.

Tables Accessed

The package reads and writes the following documented objects, primarily through APPS synonyms:

• AR_SYSTEM_PARAMETERS_ALL — Accounts Receivable system options used to establish report defaults.
• FII_AR_DSO_SETUP — DSO configuration maintained by the FII setup UI.
• FII_TIME_ENT_PERIOD and FII_CURRENCIES_V — period and currency definitions used by the time and currency APIs (FII_TIME_API, FII_UTIL).
• PER_ORGANIZATION_LIST, PER_SECURITY_PROFILES, and HR_OPERATING_UNITS — organization and security profile resolution for operating unit and LOV determination.
• BIS_OBJ_PROPERTIES and BIS_QUERY_ATTRIBUTES — the BIS (Business Intelligence System) metadata layer that defines report object attributes.
• GL_SETS_OF_BOOKS — ledger context; ALL_TABLES, DUAL, and PLITBLM — dictionary lookups and PL/SQL table infrastructure.

Usage Notes

FII_AR_UTIL_PKG is an internal utility rather than a user-facing API. It is normally invoked indirectly by the AR analytical report packages and concurrent programs that make up the FII receivables analytics suite, and it is referenced by twenty-five dependent packages. Because it depends on BIS PMV parameter structures (BIS_PMV_PAGE_PARAMETER_REC, BIS_PMV_PARAMETER_TBL, BIS_PMV_PARAMETERS_PUB) and on FND_PROFILE, it is best treated as read-only from a custom-code perspective. Customers extending DSO or receivables trend reporting should call the parent report packages rather than this utility directly, and should avoid invalidating it, as a change in status would cascade to all twenty-five dependent objects.