Search Results accounting_error_code

Overview

PSB_AE_HEADERS is a reporting view within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite. PSB provides budget formulation, submission, and approval functionality for public sector organizations, and it depends on Oracle Subledger Accounting (SLA) and General Ledger (GL) infrastructure to create and transfer accounting entries. PSB_AE_HEADERS exposes the accounting event header records that PSB generates during budget accounting, presenting the top-level identity, category, period, and status attributes of each accounting event created by the PSB budget accounting engine. In the ETRM metadata, PSB is flagged as obsolete, meaning the module is no longer actively supported in current EBS releases, but the objects may remain in upgraded or legacy environments. The view is defined as a synonym-style wrapper that filters PSB_AE_HEADERS_ALL by the operating unit context passed through the USERENV('CLIENT_INFO') session value, which is the standard multi-org security mechanism in EBS. The column list includes ACCOUNTING_ERROR_CODE, which is the column most directly associated with the user's search term. This column indicates whether the accounting event completed successfully or encountered a processing error, and it is central to diagnosing accounting failures during budget-to-GL transfer cycles.

Underlying Base Objects

The view is defined with a SELECT over the table PSB_AE_HEADERS_ALL. The ETRM metadata for this object does not document any other referenced base objects, so PSB_AE_HEADERS_ALL is the sole documented dependency. PSB_AE_HEADERS_ALL is the multi-organization table that stores accounting event header information for every operating unit, while PSB_AE_HEADERS applies a WHERE clause restricting rows to the current organization. The security predicate compares NVL(ORG_ID, ...) against the organization identifier decoded from the first ten characters of CLIENT_INFO, using a sentinel value of -99 for records with a null ORG_ID. This means the view returns only rows belonging to the operating unit in which the session is currently working, plus any records explicitly stored with ORG_ID equal to -99. Because PSB_AE_HEADERS is a view rather than a table, no data is duplicated; DML must target PSB_AE_HEADERS_ALL directly, and the view is intended for read-only reporting and integration queries.

Key Columns

• AE_HEADER_ID — Primary identifier for the accounting event header record.
• ACCOUNTING_EVENT_ID — Links the header to the originating accounting event in the SLA event model.
• SET_OF_BOOKS_ID — Identifies the ledger (set of books) to which the accounting entry will be transferred.
• AE_CATEGORY — Classifies the accounting event type, such as budget or encumbrance-related categories.
• PERIOD_NAME and ACCOUNTING_DATE — Define the GL period and date for the accounting entry.
• CROSS_CURRENCY_FLAG — Indicates whether the event involves a cross-currency accounting scenario.
• GL_TRANSFER_FLAG and GL_TRANSFER_RUN_ID — Show whether the entry was transferred to GL and by which transfer run.
• GL_TRANSFER_ERROR_CODE — Records errors encountered during the GL transfer step.
• ACCOUNTING_ERROR_CODE — Records errors encountered during the accounting creation step for the event.
• GL_REVERSAL_FLAG — Indicates the event is a reversal entry.
• BUDGET_VERSION_ID, GL_BUDGET_SET_ID, BUDGET_YEAR_ID, BUDGET_STAGE_ID — Relate the event to PSB budget versioning and GL budget structures.
• ORG_ID — Operating unit identifier used by the view's multi-org security predicate.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, and REQUEST_ID — Provide audit and concurrent request context.

Common Use Cases and Queries

The primary diagnostic use case is identifying accounting events that failed to create or transfer correctly. Because the user searched for accounting_error_code, the most relevant query filters on that column, for example:

SELECT ae_header_id, accounting_event_id, ae_category, period_name, accounting_error_code, gl_transfer_error_code FROM psb_ae_headers WHERE accounting_error_code IS NOT NULL AND org_id = :org_id;

This returns all failed accounting events for the current operating unit, allowing the consultant to compare ACCOUNTING_ERROR_CODE (creation failure) against GL_TRANSFER_ERROR_CODE (transfer failure). A second common query reviews pending transfer activity by examining GL_TRANSFER_FLAG and GL_TRANSFER_RUN_ID to determine which events remain untransferred to GL. A third use case joins the view to PSB_AE_LINES on AE_HEADER_ID to inspect line-level distributions behind a header that carries an error code. Because the view enforces operating unit security automatically, queries do not require an explicit ORG_ID predicate when run in the correct session context, though supplying ORG_ID is good practice in reporting SQL.