Results for “ra_interface_distributions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_INVOICE_XFER is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite, classified under the generic API category OTHER. Its purpose is to support the transfer of Oracle Projects draft invoice data into Oracle Receivables. The package provides the validation, conversion, and reference-data lookup logic required to move project billing information into the Receivables transaction tables, where it becomes an autoinvoice-eligible customer transaction. This transfer is the technical underpinning of the Project Billing "Interface to Receivables" or invoice generation process. The package is documented as VALID and is referenced by two other packages, with PA_OUTPUT_TAX explicitly listed as a dependent, indicating it also participates in tax line handling during the invoice submission cycle. It relies on a broad base of human resources, Projects, and Receivables tables to validate organizations, currencies, accounting flexfields, transaction types, and cost distributions before records are written to the interface or transaction tables.

Key Procedures and Functions

The documented package exposes eight procedures and functions covering validation, conversion, and reference data retrieval:

• CONVERT_AMT — Performs currency amount conversion, applying the appropriate conversion type and rate to translate draft invoice amounts into the functional or Receivables currency.
• CHECK_INVOICE_ACCT_SETUP — Validates that the invoice accounting setup, including the relevant accounting rules and Receivables configuration, is complete before transfer proceeds.
• CHECK_CCID — Validates a code combination identifier against GL_CODE_COMBINATIONS to confirm the accounting flexfield assignment is valid for the transaction.
• GET_REJECT_REASON — Retrieves the rejection reason text associated with a validation failure, supporting error reporting when a row cannot be transferred.
• GET_TRX_CRMEMO_TYPES — Returns the appropriate Receivables transaction types used for credit memos, used when negative or credit project billing lines are interfaced.
• CHECK_TRXTYPE_INTERNAL — Determines whether a given transaction type is internally defined, allowing the transfer logic to distinguish seeded Receivables types from user-defined ones.
• GET_GL_DATE_PERIOD — Derives the GL date and accounting period to be applied to the generated Receivables transaction.

No parameter signatures are published in the source metadata; the descriptions above reflect each program unit's documented business purpose only.

Tables Accessed

The package references APPS synonyms across HR, Projects, and Receivables:

• FND_CURRENCIES — Currency validation and conversion metadata used by CONVERT_AMT.
• GL_CODE_COMBINATIONS — Accounting flexfield validation for CHECK_CCID.
• HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_INFORMATION, PER_ORG_STRUCTURE_ELEMENTS — Organizational hierarchy and classification data, used to resolve the owning operating unit and business group for the transferred invoice.
• PA_COST_DISTRIBUTION_LINES_ALL, PA_FUNCTION_TRANSACTIONS — Project cost and billing transaction data that supplies detail lines for the transfer.
• PA_DRAFT_INVOICES, PA_DRAFT_INVOICE_ITEMS — The source draft invoice header and line records being submitted to Receivables.
• PA_PROJECT_CUSTOMERS — Customer assignment on the project, used to populate the Receivables customer.
• RA_BATCH_SOURCES, RA_CUST_TRX_TYPES, RA_CUSTOMER_TRX, RA_INTERFACE_DISTRIBUTIONS — Receivables batch source, transaction type, generated transaction, and interface distribution records written or validated during transfer.

Usage Notes

PA_INVOICE_XFER is invoked internally by the Oracle Projects invoice generation and transfer workflow rather than being called directly by end users. It executes when draft invoices are submitted to Receivables, typically through the Invoice Review and Invoice Generation windows or their associated concurrent programs. Because PA_OUTPUT_TAX references it, the package also participates in tax calculation and tax line generation during submission. Custom extensions or corrections to project invoice transfers should be developed against the published PL/SQL APIs rather than by modifying this package, which remains under Oracle support. Any diagnostic querying should account for the fact that the package reads from both Projects draft invoice tables and Receivables interface tables within the same transaction scope.