Search Results ic_adjs_jnl_vw




Overview
Explore in AI Chat

Overview

IC_ADJS_JNL_VW is an Oracle EBS database view owned by the APPS schema, defined within the GMI (Process Manufacturing Inventory) product family. It presents inventory adjustment journal data by joining journal header, journal detail, item master, lot, warehouse, location, reason code, grade, and accounting information into a single denormalized result set. The view carries a VALID status and is documented in ETRM for both EBS 12.1.1 and 12.2.2.

This view is commonly used in reporting and integration scenarios where adjustment transactions must be extracted together with their descriptive context. Rather than resolving foreign keys manually across the numerous Process Manufacturing tables, developers and report authors query IC_ADJS_JNL_VW to retrieve adjustment lines already enriched with item numbers, descriptions, warehouse names, lot attributes, reason descriptions, and accounting unit details.

Underlying Base Objects

The view is defined over a set of Process Manufacturing synonyms and supporting reference objects. The key documented base objects are:

Key Columns

The view exposes a wide set of adjustment attributes. Frequently referenced columns include:

Common Use Cases and Queries

Typical usage includes adjustment audit reports, reason code analysis, inventory reconciliation extracts, and integrations that feed downstream costing or accounting systems. A common query filters on reason description and posted status:

  • SELECT JOURNAL_NO, DOC_DATE, ITEM_NO, ITEM_DESC1, WHSE_CODE, QTY, REASON_CODE, REASON_DESC1 FROM APPS.IC_ADJS_JNL_VW WHERE REASON_DESC1 = 'Cycle Count Adjustment' AND POSTED_IND = 'Y';
  • SELECT REASON_CODE, REASON_DESC1, COUNT(*) FROM APPS.IC_ADJS_JNL_VW GROUP BY REASON_CODE, REASON_DESC1;
  • SELECT JOURNAL_NO, ITEM_NO, LOT_NO, QTY, ACCT_NO FROM APPS.IC_ADJS_JNL_VW WHERE ACCTG_UNIT_NO = :p_acct_unit;

Because the view joins numerous master tables, queries should be filtered by organization, date range, or journal identifiers to maintain acceptable performance on larger installations.