Search Results rcv shipments




The PO.PO_RCV_CHARGES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Purchasing and Receiving modules, primarily used to store additional charges associated with received shipments. These charges may include freight, insurance, taxes, or other ancillary costs that are not part of the base item cost but are essential for accurate financial accounting and cost distribution. Below is a detailed technical and functional analysis of this table.

Table Structure and Key Columns

The PO_RCV_CHARGES table contains columns that link charges to specific receipts, shipments, or purchase orders. Key columns include:

  • CHARGE_ID: A unique identifier for each charge record.
  • SHIPMENT_HEADER_ID: Links the charge to a shipment in PO_RCV_SHIPMENT_HEADERS.
  • SHIPMENT_LINE_ID: Associates the charge with a specific shipment line in PO_RCV_SHIPMENT_LINES.
  • PO_HEADER_ID and PO_LINE_ID: References the purchase order and line to which the charge applies.
  • CHARGE_TYPE_CODE: Defines the type of charge (e.g., FREIGHT, TAX, HANDLING).
  • AMOUNT: The monetary value of the charge.
  • DISTRIBUTION_ACCOUNT_ID: Specifies the GL account for cost allocation.

Functional Role in Receiving Process

When goods are received in Oracle EBS, the system captures not only the item quantities but also any associated charges. These charges are stored in PO_RCV_CHARGES and are later used for:

  • Cost Accruals: Charges are accrued to ensure accurate liability reporting.
  • Cost Distribution: Charges may be allocated to inventory items or expensed directly, depending on the setup.
  • Invoice Matching: During AP invoice validation, charges are matched against receipts to ensure consistency.

Integration with Other Modules

The PO_RCV_CHARGES table integrates with multiple Oracle EBS modules:

  • Accounts Payable (AP): Charges are matched against supplier invoices for three-way matching.
  • General Ledger (GL): Charge amounts are posted to appropriate accounts during period-end processes.
  • Inventory (INV): If charges are absorbed into item costs, they affect inventory valuation.

Technical Considerations

For customizations or reporting, note the following:

  • Indexes: Key columns like SHIPMENT_HEADER_ID and CHARGE_ID are indexed for performance.
  • API Usage: Oracle provides PL/SQL APIs (PO_RCV_API_S) to manipulate data programmatically.
  • Audit Columns: CREATION_DATE, CREATED_BY, and LAST_UPDATE_DATE track changes for compliance.

Common Use Cases

Typical scenarios involving this table include:

  • Adding freight charges to a receipt after goods arrive.
  • Automating tax calculations via custom triggers.
  • Generating reports for chargeback or cost analysis.

In summary, PO.PO_RCV_CHARGES is a pivotal table in Oracle EBS for managing ancillary costs in the procure-to-pay lifecycle. Its data supports financial accuracy, compliance, and operational reporting, making it indispensable for organizations leveraging Oracle's Purchasing and Receiving functionalities.