Results for “call_mark”

2 results




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

Overview

XTR_PRT_HEAD_V is a Treasury (XTR) module view in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes print report header layout metadata used by the Treasury reporting engine to control how Treasury reports and documents are formatted and sequenced during output generation. The view is a thin projection over the XTR_PRT_HEAD base table, returning the report header definition records that drive pagination, grouping, column layout, and line placement for a given Treasury report.

The view is part of the Treasury print/reporting infrastructure, which allows administrators to define named report headers, sub-reports, and ordering rules that the concurrent program and reporting framework reference at runtime. Because the object is a view rather than a table, no data is stored separately; all values are read directly from XTR_PRT_HEAD. The ETRM metadata records that the object is not implemented in every database, meaning it exists only where the Treasury reporting schema has been fully deployed.

Underlying Base Objects

The view is defined over a single base table, XTR_PRT_HEAD. The metadata documents no additional referenced base objects, so the relationship is a direct one-to-one projection with no joins, filters, or aggregation logic. Each row returned by the view corresponds to exactly one row in XTR_PRT_HEAD. Because the view text selects all documented columns without a WHERE clause, the view returns the complete set of header definition rows present in the base table.

This simplicity matters for consumers: the view carries the same access characteristics and performance profile as the underlying table, subject to any synonyms or grants applied in the Treasury schema. Any insert, update, or delete must target XTR_PRT_HEAD directly, since the view is read-only for practical purposes.

Key Columns

  • REPORT_NAME and REPORT_SUB — identify the Treasury report and its sub-report grouping to which the header definition belongs.
  • ORDER_NAME — specifies the ordering rule applied when the report content is sequenced, which is the column most relevant to searches referencing "order_name."
  • GRP_NAME and FLD_NAME — define the grouping and field-level context for the header block.
  • SEQ, LAST, CALL_MARK — control sequence position, terminal-row indication, and invocation markers used by the reporting engine.
  • PAGE_MARK, PAGE_SIZE, COL_MARK, LINE_MARK — govern pagination markers, page size, column marks, and line marks in the printed output.

Together these columns describe the presentation contract between the stored report definition and the formatting engine.

Common Use Cases and Queries

The primary use case is auditing or troubleshooting Treasury report layout definitions. A developer or functional analyst may query the view to determine which ordering rule is associated with a report header, or to inspect pagination and column marks for a specific report.

  • Retrieve all header rows for a report: SELECT report_name, report_sub, order_name, grp_name, fld_name FROM xtr_prt_head_v WHERE report_name = :p_report;
  • Investigate ordering rules: SELECT report_name, order_name, seq FROM xtr_prt_head_v WHERE order_name IS NOT NULL ORDER BY report_name, seq;
  • Inspect pagination settings: SELECT report_name, page_mark, page_size, col_mark, line_mark FROM xtr_prt_head_v ORDER BY report_name, seq;

These queries are typically executed in a read-only reporting or diagnostic context. Because the view is not implemented in all databases, availability should be confirmed before relying on it in custom reporting.