Search Results invoice_category




Overview
Explore in AI Chat

Overview

JA_CN_CUSTOM_SOURCES is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Financials for China localization (the JA_CN product prefix). Its documented purpose is to create customer source values, and more specifically to derive a source value from an invoice source input. The package belongs to the OTHER API classification, meaning it is not published as a formal public API with guaranteed interface stability; it is an internal utility used by the China localization code to satisfy country-specific reporting and derivation requirements.

The package is relevant to users searching on "invoice_category" because one of its documented functions, INVOICE_CATEGORY, returns a category value for an invoice based on the invoice source. This supports Chinese localization requirements where invoice information must be classified into specific categories for tax, statutory reporting, or subledger derivation purposes that are not met by the standard Oracle Payables data model.

Key Procedures and Functions

  • INVOICE_CATEGORY — Returns a source or category value derived from an invoice source input. According to the header comments, the function is used to return different source values according to the invoice source that is passed in. The documented parameter set includes the invoice source, an invoice identifier, and an invoice distribution identifier; the return type is VARCHAR2. This is the member most commonly associated with the "invoice_category" search term.
  • INVOICE_GAINLOSS_CATEGORY — Documented in the ETRM metadata as a member of this package, this function derives a gain/loss category value. It follows the same derivation pattern as INVOICE_CATEGORY and is intended to classify exchange gain or loss treatment for invoices within the Chinese localization context.
  • GET_PROJECT_NUM — Accepts a project identifier and returns a project number as a VARCHAR2 value. It resolves a PA project ID to its user-visible project number, typically to populate reporting or interface columns that expect the project number rather than the internal identifier.

The package also declares a module prefix constant used for debugging or message identification. No other public members are documented.

Tables Accessed

The recorded table access is broad and reflects the derivation and lookup logic performed by the three functions.

  • AP_INVOICES_ALL — the primary invoice header table, read to resolve invoice source, invoice type, and header-level attributes.
  • AP_INVOICE_DISTRIBUTIONS_ALL and AP_INVOICE_LINES_ALL — read to obtain line and distribution level detail when the category must be derived from a specific line or distribution rather than the invoice header.
  • AP_INVOICE_PAYMENTS_ALL — read to determine payment-related information, which can affect gain/loss categorization.
  • MTL_CATEGORY_SETS_TL and MTL_ITEM_CATEGORIES — read to resolve item category assignments and category set names when the invoice category is tied to inventory item classification.
  • PO_LINES_ALL — read to link invoice lines back to purchasing document lines, supporting matching-based derivation.
  • PA_PROJECTS_ALL — read by GET_PROJECT_NUM to translate a project ID into a project number.

Usage Notes

As an OTHER-classified package, JA_CN_CUSTOM_SOURCES is not intended for direct invocation by customer code without risk. It is most commonly called from the Oracle Payables invoice entry and validation flow within the China localization, and from concurrent or reporting programs that require a China-specific invoice category or source derivation. The package is referenced by one other package in the APPS schema, indicating a dependent internal caller.

Because the functions are deterministic lookups and derivations, they are safe to call repeatedly within a session. Any customization or extension of this package should be performed by copying the logic into a custom package rather than modifying the seeded object, so that Oracle-supplied updates in releases such as 12.1.1 and 12.2.2 are not overwritten.