Search Results ap_expense_feed_lines




Overview
Explore in AI Chat

Overview

AP_CARD_VALIDATE_PKG is a PL/SQL package in the Oracle E-Business Suite Payables application (APPS schema) that supports credit card transaction processing in the expense feed workflow. Its primary responsibility is to validate expense feed lines generated from corporate credit card transactions and to prepare validated records for downstream accounting and interface processing. The package validates foreign key relationships, determines exception conditions, and populates the REJECT_CODE column in AP_EXPENSE_FEED_LINES with assigned exception codes drawn from the CARD EXCEPTION lookup type. It also handles the creation of distributions and the construction of interface records. The package is documented in ETRM with an API classification of OTHER and is referenced by one other package within the APPS schema.

Key Procedures and Functions

  • VALIDATE — Populates foreign keys and validates user-provided foreign keys. It matches CARD_ID against AP_CARDS on CARD_NUMBER, resolves CODE_ID against AP_CARD_CODES using CODE_VALUE for the card code set defined for the card program, and denormalizes EMPLOYEE_ID from AP_CARDS. It validates currency codes and CARD_PROGRAM_ID, checks for duplicate reference numbers within a card program, and raises exceptions when the card profile requires account construction from code (BAFCF=Y) with distributions created from lines (CDF=Y) but CODE_ID cannot be determined. It also raises an exception when verification is required (EVM=Y) but distributions are not specified as created from lines (CDF=N or null). Assigned exceptions — such as INVALID CARD NUM, DUPLICATE REFERENCE, and INVALID POST CURR — are stored in AP_EXPENSE_FEED_LINES.REJECT_CODE.
  • CREATE_DISTRIBUTIONS — Creates expense feed distribution records (AP_EXPENSE_FEED_DISTS and related _ALL and _S objects) from validated expense feed lines.
  • CREATE_INTERFACE_RECORDS — Builds the interface records required to transfer validated credit card expense feed data into the Payables interface tables for subsequent invoice and payment processing.

Tables Accessed

  • AP_EXPENSE_FEED_LINES — The central staging table for credit card transaction lines; validated here and updated with REJECT_CODE and resolved foreign keys.
  • AP_EXPENSE_FEED_DISTS, AP_EXPENSE_FEED_DISTS_ALL, AP_EXPENSE_FEED_DISTS_S — Distribution records created from validated lines by CREATE_DISTRIBUTIONS.
  • AP_CARDS, AP_CARDS_ALL — Source of card definitions; CARD_ID and EMPLOYEE_ID are matched and denormalized from here.
  • AP_CARD_CODES — Resolves CODE_ID from CODE_VALUE based on the card code set of the card program.
  • AP_CARD_PROFILES — Supplies profile flags (EVM, MAM, CDF, BAFCF) that drive validation rules. AP_CARD_PROFILES is the parent of AP_CARDS.
  • AP_CARD_PROGRAMS — Source of CARD_PROGRAM_ID and its associated code set, and the scope for duplicate reference number checks.
  • AP_SYSTEM_PARAMETERS — Provides system-level Payables configuration values used during validation.

Usage Notes

AP_CARD_VALIDATE_PKG is invoked during credit card expense feed processing, typically from the concurrent programs that import and validate card transactions before creating distributions and interface records. The VALIDATE procedure is called first to populate and validate foreign keys and identify exceptions; CREATE_DISTRIBUTIONS and CREATE_INTERFACE_RECORDS are then invoked to advance validated records through to the Payables interface. Because the package is classified as OTHER rather than a public API, direct custom invocation is uncommon; customizations should instead call the standard concurrent programs that wrap this logic. The package header references version identifier $Header: apwcvalb.pls 120.15.12020000.3 2012/07/14, and it is documented as referenced by one other package, confirming it sits within a dependent call chain rather than at the top of the processing hierarchy.