Search Results ce_forecast_pay_orgs_v




Overview
Explore in AI Chat

Overview

The CE_FORECAST_PAY_ORGS_V view is a Cash Management (CE) database object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented as a retrofitted object, meaning it was introduced or adapted to preserve backward compatibility with earlier EBS releases while conforming to the multi-org architecture used in Release 12. The view supplies the set of payroll organizations that participate in cash forecasting, exposing organization, business group, and general ledger set of books attributes in a single, consolidated result set.

Its principal role is to feed the organization selection lists used in the Cash Management cash forecasting and cash positioning functionality. By presenting payroll business groups alongside their associated ledger (set of books) information, the view allows the application to determine, for a given payroll organization, the correct ledger and currency under which forecast activity should be recorded. The leading literal 'PAY' value in the first column (aliased as APP_SHORT_NAME) identifies the row source as the Payroll application, distinguishing these entries in a shared or union-based organization framework.

Underlying Base Objects

The documented base objects referenced by the view are:

Structurally, the view text is a UNION ALL of two SELECT DISTINCT branches. The first branch joins PAY_ALL_PAYROLLS_F to CE_HR_BUS_GRPS_V and GL_SETS_OF_BOOKS on BUSINESS_GROUP_ID and SET_OF_BOOKS_ID, producing rows where a ledger is assigned to the payroll. The second branch selects payroll business groups where GL_SET_OF_BOOKS_ID IS NULL, returning NULL for the ledger name and description and falling back to the business group currency. This dual-branch design ensures that payroll organizations with no ledger assignment still appear. The LEGAL_ENTITY_ID column is defined as TO_NUMBER(NULL) in both branches, indicating the column is retained for interface compatibility rather than populated with a legal entity value.

Key Columns

  • APP_SHORT_NAME — Literal 'PAY', identifying the source application as Payroll.
  • ORG_ID — The business group identifier (BG.BUSINESS_GROUP_ID), the organization key for the row.
  • NAME — The business group name.
  • SET_OF_BOOKS_ID — The general ledger set of books (ledger) identifier associated with the payroll; may be null in the second union branch.
  • SET_OF_BOOKS_NAME — The ledger name, or null when no ledger is assigned.
  • CURRENCY_CODE — The ledger currency when available, otherwise the business group default currency via NVL.
  • DESCRIPTION — The ledger description, populated only when a ledger is joined.
  • LEGAL_ENTITY_ID — Defined as TO_NUMBER(NULL); reserved for compatibility and not currently supplied.

Common Use Cases and Queries

Typical use is to populate organization lists in Cash Management forecasting, where the calling form or concurrent program requires the ledger and currency context for each payroll organization.

SELECT app_short_name, org_id, name, set_of_books_id,
       set_of_books_name, currency_code
FROM   apps.ce_forecast_pay_orgs_v
ORDER BY name;

To restrict to organizations with an assigned ledger:

SELECT org_id, name, set_of_books_id, currency_code
FROM   apps.ce_forecast_pay_orgs_v
WHERE  set_of_books_id IS NOT NULL;

To resolve the ledger for a specific organization:

SELECT name, set_of_books_name, currency_code
FROM   apps.ce_forecast_pay_orgs_v
WHERE  org_id = :p_org_id;

Because the view depends on HR security and business group resolution, query results are subject to the security profile of the connecting user. All access should be performed through the APPS schema or a synonymed custom schema with appropriate grants.