AP Technical Reference Summary

T

High–Level Design 2 – 1

Oracle Proprietary, Confidential Information––Use Restricted by Contract

High–Level Design

his chapter presents a high–level design for Oracle Payables and

Oracle Public Sector Payables that satisfies the business needs we

specify during Strategy and Analysis. It contains database diagrams

for Oracle Payables and Oracle Public Sector Payables application

building blocks, lists of database tables and views, and a list of

modules.

2 – 2 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Overview of High–Level Design

During High–Level Design, we define the application components

(tables, views, and modules) we need to build our application. We

specify what application components should do without specifying the

details of how they should do it.

You can refer to this High–Level Design chapter to quickly acquaint

yourself with the tables, views, and modules that comprise Payables

applications. And, you can prepare yourself to understand the detailed

design and implementation of Oracle Payables and Oracle Public Sector

Payables.

Database Diagrams

The Database Diagrams section graphically represents all Payables

applications tables and the relationships between them, organized by

building block.

Use this section to quickly learn what tables each Payables application

building block uses, and how those tables interrelate. Then, you can

refer to the Table and View Definitions sections of Chapter 3 for more

detailed information about each of those tables.

Table Lists

The Table List sections list the Payables applications tables. Because a

product might not include at least one table for each type, this

Technical Reference Manual might not include each of the following

sections.

Public Tables

Use the Public Table List section to quickly identify the tables you are

most interested in. Then, you can refer to the Table and View

Definitions sections of Chapter 3 for more detailed information about

those tables.

In addition, this manual may contain full documentation for one or

more of the following Application Object Library tables: FND_DUAL,

FND_CURRENCIES, and FND_COMMON_LOOKUPS.

High–Level Design 2 – 3

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Internal Tables

This section includes a list of private, internal tables used by Payables;

we do not provide additional documentation for these tables.

View Lists

The View List sections list the Payables views, with one section for each

type of view. Because a product might not include at least one view for

each type, this Technical Reference Manual might not include each of

the following sections.

Use this section to quickly identify the views you are most interested

in. Then, you can refer to the Table and View Definitions sections of

Chapter 3 for more detailed information about those views.

Public Views

This section lists views that may be useful for your custom reporting or

other data requirements. The list includes a description of the view,

and the page in Chapter 3 that gives detailed information about the

public view.

Web Views

This section lists views that you may need to configure your

Self–Service Web applications. The list includes a description of the

view, and the page in Chapter 3 that gives detailed information about

the web view.

Forms and Table Views

This section lists supplementary views that are not essential to the

Release 11i data model, but simplify coding or improve performance

for Oracle Developer.

Internal Views

This section includes each private, internal view that Payables uses.

2 – 4 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Single–Organization Views

This section lists the Payables views that we added to take the place of

various tables that are now partitioned by operating unit, to support

multiple sets of books within a single installation of Payables.

Multiple Reporting Currency Views

This list includes views that were created to support the Multiple

Reporting Currencies feature.

Module List

The Module List section briefly describes each of the Payables

applications modules. This section lists forms, reports, and concurrent

programs.

A form is a module comprised of closely related windows that are used

together to perform a task. For example, the Enter Journals form in

Oracle General Ledger includes the Enter Journals window, the Batch

window, and the More Actions window. The Enter Journals window is

the main window, and from it, you can use buttons to navigate to other

windows in the form. The form name usually corresponds to the main

window in the form, and is frequently a window you can open directly

from the Navigator.

The Reports and Concurrent Programs lists include processes you can

submit from the Submit Requests window or other windows, as well as

processes that are submitted automatically by Payables. Use your

user’s guide to learn more about reports and concurrent processes.

High–Level Design 2 – 5

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Database Diagramming Conventions

We use the following notational conventions in our database diagrams:

Figure 2 – 1

Database Diagram

Conventions

Mandatory and Optional Foreign Keys

A value entered in the column in the foreign key

must match a value in the primary key column.

___

_______

________

_

____

________

_______

_

__&___           _$

"_' !__&&$__'&_

____&_"!________

___'$%_(___"$___!___)

_$_

_____%___$_

__&___%_%__&_"!

____&__$'____!____&"$

"$___!___)

_"!%&$__!&

___'_%__!_&____"$___!___)

 '%&_ _&___&___#$_ _$)___)

_$_ _$)___)__"_' !_____

__!__&"$)__"_' !____

Server Model Diagram Elements and Notation

A value entered in the column in the foreign key

must match either a value in the primary key column,

or else it must be null.

2 – 6 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Tables – are the basic unit of storage in the database. A hand symbol

preceding the title in the table’s title bar indicates that the table is not

owned by this application but shared with another.

Foreign key constraint – is a type of referential integrity constraint for

checking the integrity of data entered in a specific column or set of

columns. This specified column or set of columns is known as the

foreign key.

Delete rule indicator – determines the action to be taken when an

attempt is made to delete a related row in a join table. A line through

the foreign key constraint, as shown on the above diagram, indicates

that this action is restricted.

Arcs – specify that, for any given row in a table, a value must be

entered in one of the arc columns. The remaining columns within the

arc must be null.

High–Level Design 2 – 7

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Database Diagrams

This section graphically represents most of the significant Oracle

Payables applications tables and the relationships between them. Use

this section to quickly learn what tables your Payables application uses,

and how these tables interrelate. Then, you can refer to the Table and

View Definitions sections of Chapter 3 for more detailed information

about each of those tables.

This section contains a database diagram for each of the following areas

of your Payables application:

• Diagram 1: Invoices and Payments

• Diagram 2: Suppliers

• Diagram 3: Payment Batches

• Diagram 4: Expense Reports

• Diagram 5: Recurring Invoices

• Diagram 6: Credit Cards

• Diagram 7: Purchasing Integration

• Diagram 8: General Ledger Integration

• Diagram 9: Projects Integration

• Diagram 10: Fixed Assets Integration

Invoices and Payments

Diagram 1 shows the tables and relationships associated with Invoices

and Payments a well as Payables accounting entries. This diagram

shows all of the most important Payables tables that store the core

transaction data.

Suppliers

Diagram 2 shows the tables and relationships associated with suppliers

and supplier sites in your Oracle Payables application. The diagrams

also show some of the setup data that defaults to new suppliers.

Payment Batches

Diagram 3 shows the tables and relationships utilized when you create

payment batches. In particular, this diagram highlights the temporary

2 – 8 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

tables that Oracle Payables uses when a payment batch has not yet

completed.

Expense Reports

Diagram 4 shows the tables and relationships related to the entry of

employee expense reports using the Payables Expense Reports window

or Oracle Self–Service Expenses. You create invoices from expense

reports using the Payables Invoice Import program.

Recurring Invoices

Diagram 5 shows the tables and relationships utilized when you create

recurring invoices, for example, lease payments. Oracle Payables will

create invoices based on your definitions of recurring invoices.

Credit Cards

Diagram 6 shows the tables and relationships associated with the

Procurement Card Integration feature. You can import transactions

from your card issuers, validate and build accounting distributions for

transactions, notify employees and managers of transactions to be

verified and approved, and you can automatically create an invoice to

pay the credit card issuer. The diagram shows all the tables related to

setting up and using the Credit Card Integration features in your

Oracle Payables application. The tables store information about how

you define your credit card program, cards assigned to employees, and

information about transactions from your card issuer.

Purchasing Integration

Diagram 7 shows the tables and relationships utilized when you match

an invoice to one or more purchase orders or receipts.

General Ledger Integration

Diagram 8 shows the tables and relationships that Oracle Payables

applications use to integrate with Oracle General Ledger to create

journal entries and to drill down from these journal entries to the

accounting entries in your Payables application.

Projects Integration

Diagram 9 shows the tables and relationships utilized when you store

projects–related information for an invoice, whether the invoice was

High–Level Design 2 – 9

Oracle Proprietary, Confidential Information––Use Restricted by Contract

created in Payables or the invoice was created from an expense report

imported from Projects.

Fixed Assets Integration

Diagram 10 shows the tables and relationships utilized when you

record assets information for invoices. You use the Mass Additions

Create program to import assets information from Payables into Oracle

Assets.

2 – 10 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Invoices and Payments

High–Level Design 2 – 11

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Suppliers

2 – 12 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Payment Batches

High–Level Design 2 – 13

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Expense Reports

2 – 14 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Recurring Invoices

High–Level Design 2 – 15

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Credit Cards

2 – 16 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Purchasing Integration

High–Level Design 2 – 17

Oracle Proprietary, Confidential Information––Use Restricted by Contract

General Ledger Integration

2 – 18 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Projects Integration

High–Level Design 2 – 19

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Fixed Assets Integration

2 – 20 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Public Table List

This section lists each public database table that Oracle Payables uses

and provides a brief description of each of those tables. The page

reference is to the table description in Chapter 3.

Note that ”public” tables are not necessarily intended for write access by

custom code; Oracle Corporation supports write access using only

standard Oracle Applications forms, reports, and programs, or any SQL

write access to tables explicitly documented as API tables. For more

information, see the How Not To Use This Manual section of this book’s

Introduction.

Oracle Payables uses the following Public tables:

Table Name Description

AP_1096_DATA_ALL Summary payment information for 1099 type suppliers (See

page 3 – 8)

AP_1099_TAPE_DATA_ALL Supplier payment amounts by MISC type for 1099 reports

on magnetic media (See page 3 – 9)

AP_ACCOUNTING_EVENTS_ALL Accounting events table (See page 3 – 11)

AP_AE_HEADERS_ALL Accounting entry headers table (See page 3 – 12)

AP_AE_LINES_ALL Accounting entry lines table (See page 3 – 14)

AP_AGING_PERIODS Aging period definitions (See page 3 – 17)

AP_AGING_PERIOD_LINES Individual aging period information (See page 3 – 19)

AP_AWT_BUCKETS_ALL Summary amount of tax withheld to date for a particular

supplier site (See page 3 – 21)

AP_AWT_GROUPS Withholding tax groups (See page 3 – 22)

AP_AWT_GROUP_TAXES_ALL Withholding group taxes (See page 3 – 23)

AP_AWT_TAX_RATES_ALL Withholding tax rates (See page 3 – 24)

AP_AWT_TEMP_DISTRIBUTIONS_ALL Withholding tax temporary distributions (See page 3 – 27)

AP_BANK_ACCOUNTS_ALL Detailed bank account information (See page 3 – 29)

AP_BANK_ACCOUNT_USES_ALL Information about bank account use by Oracle Payables and

Oracle Receivables applications (See page 3 – 34)

AP_BANK_BRANCHES Detailed bank branch information (See page 3 – 36)

High–Level Design 2 – 21

Oracle Proprietary, Confidential Information––Use Restricted by Contract

AP_BANK_CHARGES Bank charges definition information (See page 3 – 40)

AP_BANK_CHARGE_LINES Ranges for bank charges and tolerance limits (See page

3 – 41)

AP_BATCHES_ALL Summary invoice batch information (See page 3 – 42)

AP_CARDS_ALL Information about credit cards issued to employees (See

page 3 – 46)

AP_CARD_CODES_ALL Information for credit card codes that you define (See page

3 – 48)

AP_CARD_CODE_SETS_ALL Descriptive information about credit card code sets assigned

to and used by card programs (See page 3 – 50)

AP_CARD_GL_ACCTS_ALL Information about the GL accounts and descriptions for

credit card GL account sets (See page 3 – 51)

AP_CARD_GL_SETS_ALL Descriptive information about credit card GL account sets

(See page 3 – 53)

AP_CARD_PROFILES_ALL Information about the profiles assigned to credit cards

distributed to your employees (See page 3 – 54)

AP_CARD_PROFILE_LIMITS_ALL Reserved for a future feature (See page 3 – 56)

AP_CARD_PROGRAMS_ALL Information about credit card programs you have defined

(See page 3 – 58)

AP_CARD_REQUESTS_ALL Reserved for a future feature (See page 3 – 60)

AP_CHECKRUN_CONC_PROCESSES_ALL Temporary table for tracking payment batch concurrent

programs (See page 3 – 62)

AP_CHECKRUN_CONFIRMATIONS_ALL Temporary table for payment batch confirmations (See page

3 – 63)

AP_CHECKS_ALL Supplier payment data (See page 3 – 64)

AP_CHECK_FORMATS Payment document format records (See page 3 – 72)

AP_CHECK_INTEGERS Temporary table for list of document numbers used by the

Missing Documents Report to find gaps in document

numbers (See page 3 – 75)

AP_CHECK_STOCKS_ALL Payment document types (See page 3 – 76)

AP_CHRG_ALLOCATIONS_ALL Charge allocations table (See page 3 – 79)

2 – 22 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

AP_CREDIT_CARD_TRXNS_ALL Detailed information about the credit card transactions of

your employees (See page 3 – 80)

AP_DISTRIBUTION_SETS_ALL Invoice Distribution Set definitions (See page 3 – 85)

AP_DISTRIBUTION_SET_LINES_ALL Individual Distribution Set line definitions (See page 3 – 87)

AP_DOC_SEQUENCE_AUDIT Voucher numbers assigned to invoices and payments (See

page 3 – 89)

AP_DUPLICATE_VENDORS_ALL Supplier information used by Supplier Merge (See page

3 – 90)

AP_ENCUMBRANCE_LINES_ALL Encumbrance lines table (See page 3 – 92)

AP_EXPENSE_FEED_DISTS_ALL Accounting information for credit card transactions (See

page 3 – 94)

AP_EXPENSE_FEED_LINES_ALL Detailed information about credit card transactions

imported from the credit card issuer (See page 3 – 108)

AP_EXPENSE_REPORTS_ALL Descriptive information about expense report templates

(See page 3 – 111)

AP_EXPENSE_REPORT_HEADERS_ALL Header information about employee expense reports (See

page 3 – 112)

AP_EXPENSE_REPORT_LINES_ALL Expense item information for employee expense reports

(See page 3 – 119)

AP_EXPENSE_REPORT_PARAMS_ALL Expense type information for expense report templates (See

page 3 – 124)

AP_HISTORY_CHECKS_ALL Summary information about purged invoice payments (See

page 3 – 126)

AP_HISTORY_INVOICES_ALL Summary information about purged invoices (See page

3 – 127)

AP_HISTORY_INV_PAYMENTS_ALL Relationships between purged invoices and invoice

payments (See page 3 – 128)

AP_HOLDS_ALL Invoice hold information (See page 3 – 129)

AP_HOLD_CODES Invoice hold and release codes (See page 3 – 135)

AP_INCOME_TAX_REGIONS Income tax region information for supplier tax reporting

purposes (See page 3 – 139)

High–Level Design 2 – 23

Oracle Proprietary, Confidential Information––Use Restricted by Contract

AP_INCOME_TAX_TYPES 1099 supplier types (See page 3 – 141)

AP_INTEREST_PERIODS Interest rates and period information used to create Interest

invoices (See page 3 – 142)

AP_INTERFACE_CONTROLS Temporary table for importing invoices from the open

interface tables (See page 3 – 143)

AP_INTERFACE_REJECTIONS Information about data that could not be loaded by

Payables Open Interface Import (See page 3 – 144)

AP_INVOICES_ALL Detailed invoice records (See page 3 – 149)

AP_INVOICES_INTERFACE Information used to create an invoice using Payables Open

Interface Import (See page 3 – 157)

AP_INVOICE_DISTRIBUTIONS_ALL Invoice distribution line information (See page 3 – 162)

AP_INVOICE_KEY_IND_ALL Compiled invoice information for Key Indicators Report

(See page 3 – 175)

AP_INVOICE_LINES_INTERFACE Information used to create one or more invoice distributions

(See page 3 – 177)

AP_INVOICE_PAYMENTS_ALL Invoice payment records (See page 3 – 184)

AP_INVOICE_RELATIONSHIPS Relationships between invoices and interest invoices

automatically created for overdue invoices (See page

3 – 189)

AP_INV_SELECTION_CRITERIA_ALL Payment batch invoice selection criteria (See page 3 – 190)

AP_MATCHED_RECT_ADJ_ALL Tracks receipts that have been modified after invoices have

been matched to them (See page 3 – 195)

AP_MC_CHECKS Supplier payment data in MRC defined reporting currency

(See page 3 – 196)

AP_MC_INVOICES Detailed invoice records in MRC defined reporting currency

(See page 3 – 198)

AP_MC_INVOICE_DISTS Invoice distribution line information in MRC defined

reporting currency (See page 3 – 199)

AP_MC_INVOICE_PAYMENTS Invoice payment records in MRC defined reporting

currency (See page 3 – 201)

AP_OTHER_PERIODS Recurring invoice, key indicator, payment terms, and

withholding tax time period definitions (See page 3 – 202)

2 – 24 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

AP_OTHER_PERIOD_TYPES Recurring invoice, key indicator, and withholding tax

period type definitions (See page 3 – 204)

AP_PAYMENT_HISTORY_ALL Maturity and reconciliation history for payments (See page

3 – 206)

AP_PAYMENT_KEY_IND_ALL Compiled payment information for Key Indicators Report

(See page 3 – 209)

AP_PAYMENT_PROGRAMS Payment programs used for defining payment formats (See

page 3 – 211)

AP_PAYMENT_REP_ITF Payables Interface table for RX payment reports (See page

3 – 212)

AP_PAYMENT_SCHEDULES_ALL Scheduled payment information on invoices (See page

3 – 214)

AP_PBATCH_SETS_ALL Payment batch sets (See page 3 – 217)

AP_PBATCH_SET_LINES_ALL Payment batch set lines (See page 3 – 218)

AP_PURGE_INVOICE_LIST Temporary storage of invoice IDs for invoice purge

candidates (See page 3 – 221)

AP_R115_UPGRADE Release 11i upgrade values for FUTURE DATED and

MANUAL FUTURE DATED payment methods (See page

3 – 222)

AP_RECURRING_PAYMENTS_ALL Recurring invoice parameters (See page 3 – 223)

AP_REPORTING_ENTITIES_ALL Tax identification information for a tax reporting entity (See

page 3 – 229)

AP_REPORTING_ENTITY_LINES_ALL Balancing segment information associated with a tax

reporting entity (See page 3 – 231)

AP_SELECTED_INVOICES_ALL Temporary storage of invoices selected for payment in a

payment batch (See page 3 – 232)

AP_SELECTED_INVOICE_CHECKS_ALL Temporary storage of payment information for invoices in a

payment batch (See page 3 – 237)

AP_SUPPLIER_BALANCE_ITF Stores records for the AP Supplier Open Balance Letter

report (See page 3 – 240)

AP_SYSTEM_PARAMETERS_ALL Payables system defaults and parameters (See page 3 – 241)

AP_TAX_CODES_ALL Tax code information (See page 3 – 251)

High–Level Design 2 – 25

Oracle Proprietary, Confidential Information––Use Restricted by Contract

AP_TAX_RECVRY_RATES_ALL Used to define recovery rates for tax recovery rules (See

page 3 – 254)

AP_TAX_RECVRY_RULES_ALL Contains information about tax recovery rules (See page

3 – 257)

AP_TEMP_APPROVAL_ALL Temporary storage of holds placed and released during

Approval (See page 3 – 259)

AP_TERMS_LINES Detail information about payment terms (See page 3 – 261)

AP_TERMS_TL Payment term definitions (See page 3 – 263)

AP_TOLERANCES_ALL Matching and invoice variance testing tolerance levels (See

page 3 – 265)

AP_TRIAL_BAL Temporary table that holds outstanding invoice balances for

the Trial Balance Report (See page 3 – 266)

AP_TRIAL_BALANCE Denormalized information about posted invoices for your

accrual set of books (See page 3 – 267)

AP_VENDOR_AUDIT_TMP Temporary table for duplicate supplier candidates during

Supplier Merge (See page 3 – 268)

AP_VENDOR_KEY_IND_ALL Compiled supplier information for the Key Indicators

Report (See page 3 – 269)

AP_WEB_SIGNING_LIMITS_ALL Tracks signing limit authority for Self–Service

Expenses–entered expense reports (See page 3 – 273)

AP_WHT_ITF Information for the submission of the AP Withholding Tax

extract program (See page 3 – 274)

ECE_TP_HEADERS Contains information for trading partner address entity.

(See page 3 – 276)

FA_ASSET_INVOICES Accounts payable and purchasing information for each

asset (See page 3 – 279)

FA_BOOK_CONTROLS Control information that affects all assets in a depreciation

book (See page 3 – 283)

FA_MASS_ADDITIONS Information about assets that you want to automatically

add to Oracle Assets from another system (See page 3 – 291)

FA_SYSTEM_CONTROLS System–wide controls that affect all assets (See page 3 – 300)

2 – 26 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

FINANCIALS_PURGES Invoice purge selection criteria and purged invoice

statistical data (See page 3 – 302)

FINANCIALS_SYSTEM_PARAMS_ALL Oracle Financials system parameters and defaults (See page

3 – 305)

FND_APPLICATION Applications registered with Oracle Application Object

Library (No table description)

FND_CONCURRENT_PROGRAMS Concurrent programs (No table description)

FND_CONCURRENT_REQUESTS Concurrent requests information (No table description)

FND_CURRENCIES Currencies enabled for use at your site (See page 3 – 309)

FND_DOCUMENT_SEQUENCES Document sequences registered with Oracle Application

Object Library (No table description)

FND_DOC_SEQUENCE_ASSIGNMENTS Assigns a sequence to a document (No table description)

FND_DOC_SEQUENCE_CATEGORIES Document category definitions (No table description)

FND_DUAL Dummy base table used by a form block that does not have

a real base table (for commit purposes) (See page 3 – 312)

FND_FLEX_VALUES Valid values for flexfield segments (No table description)

FND_FLEX_VALUE_SETS Value sets used by both key and descriptive flexfields (No

table description)

FND_ID_FLEX_SEGMENTS Key flexfield segments setup information and

correspondences between table columns and key flexfield

segments (No table description)

FND_ID_FLEX_STRUCTURES Key flexfield structure information (No table description)

FND_LANGUAGES National dialects (No table description)

FND_LOGINS Sign–On Audit information about who signs on to an

application and when (No table description)

FND_PRINTER Printers registered with Oracle Application Object Library

(No table description)

FND_PRODUCT_DEPENDENCIES Dependencies of Oracle Applications products installed at

your site (No table description)

FND_PRODUCT_INSTALLATIONS Oracle Applications products installed at your site (No table

description)

High–Level Design 2 – 27

Oracle Proprietary, Confidential Information––Use Restricted by Contract

FND_RESPONSIBILITY Responsibilities (No table description)

FND_SEGMENT_ATTRIBUTE_VALUES Values of flexfield qualifiers for different segments of key

flexfield structures (No table description)

FND_TERRITORIES Territories, also known as countries (No table description)

FND_USER Application users (No table description)

GL_BALANCES Account balances for both detail and summary accounts

(See page 3 – 313)

GL_BC_PACKETS Budgetary control queue table (See page 3 – 315)

GL_BUDGETS Budget definitions (See page 3 – 320)

GL_BUDGET_PERIOD_RANGES Status of budget period ranges (open/not open) (See page

3 – 322)

GL_BUDGET_VERSIONS Budget version definitions (See page 3 – 323)

GL_CODE_COMBINATIONS Account combinations (See page 3 – 325)

GL_DAILY_CONVERSION_TYPES Foreign currency daily conversion rate types (See page

3 – 330)

GL_DAILY_RATES Daily conversion rates for foreign currency transactions (See

page 3 – 331)

GL_ENCUMBRANCE_TYPES Encumbrance type definitions (See page 3 – 333)

GL_IMPORT_REFERENCES Cross–references between subledgers and Oracle General

Ledgers Journal Entries (See page 3 – 334)

GL_INTERCOMPANY_ACCOUNTS Assignments of intercompany due to and due from

accounts to a source, category, and balancing segment value.

(See page 3 – 336)

GL_INTERFACE Import journal entry batches (See page 3 – 338)

GL_INTERFACE_CONTROL Journal import execution control (See page 3 – 342)

GL_JE_BATCHES Journal entry batches (See page 3 – 343)

GL_JE_CATEGORIES_TL Journal entry categories (See page 3 – 347)

GL_JE_HEADERS Journal entry headers (See page 3 – 348)

GL_JE_LINES Journal entry lines (See page 3 – 353)

GL_JE_SOURCES_TL Journal entry sources (See page 3 – 357)

2 – 28 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

GL_PERIODS Calendar period definitions (See page 3 – 359)

GL_PERIOD_SETS Calendar definitions (See page 3 – 361)

GL_PERIOD_STATUSES Calendar period statuses (See page 3 – 362)

GL_PERIOD_TYPES Calendar period types (See page 3 – 364)

GL_SETS_OF_BOOKS Set of books definitions (See page 3 – 365)

GL_STAT_ACCOUNT_UOM Statistical units of measure (See page 3 – 369)

GL_SUSPENSE_ACCOUNTS Additional suspense accounts for source/category

combinations (See page 3 – 370)

GL_TRANSACTION_RATE_EXCEPTIONS Feeder system journal transaction rate exceptions (See page

3 – 371)

GL_TRANSLATION_RATES Foreign currency translation rates (See page 3 – 373)

GL_USSGL_TRANSACTION_CODES USSGL transaction codes (See page 3 – 375)

GL_WEIGHTED_AVG_DETAILS Feeder system journal details calculated using weighted

average rates (See page 3 – 376)

HR_LOCATIONS_ALL Work location definitions. (See page 3 – 378)

MRP_ITEM_PURCHASE_ORDERS Purchase orders and purchase requisitions (See page

3 – 381)

MTL_CATEGORY_SETS_B Category Sets (See page 3 – 384)

MTL_DEFAULT_CATEGORY_SETS Default category set for a particular functional area (See

page 3 – 386)

MTL_MATERIAL_TRANSACTIONS Material transaction table (See page 3 – 388)

MTL_SUPPLY Stores incoming supply information (See page 3 – 395)

MTL_SYSTEM_ITEMS_B Inventory item definitions (See page 3 – 400)

ORG_FREIGHT_TL Freight codes (See page 3 – 420)

PAY_EXTERNAL_ACCOUNTS Bank account details that enable payments to be made. (See

page 3 – 422)

PA_EXPENDITURE_TYPES Implementation–defined classifications of expenditures

charged to projects and tasks (See page 3 – 424)

PA_EXP_ORGS_IT Information about expenditure organizations for Oracle

Project Analysis Collection Pack (See page 3 – 426)

High–Level Design 2 – 29

Oracle Proprietary, Confidential Information––Use Restricted by Contract

PA_PROJECTS_ALL Information about projects (See page 3 – 427)

PA_TASKS User–defined subdivisions of project work (See page

3 – 435)

PO_ACCEPTANCES Purchase order acceptances (See page 3 – 442)

PO_ACTION_HISTORY Document approval and control action history table (See

page 3 – 444)

PO_DISTRIBUTIONS_ALL Purchase order distributions (See page 3 – 446)

PO_HEADERS_ALL Document headers (for purchase orders, purchase

agreements, quotations, RFQs) (See page 3 – 452)

PO_HEADERS_ARCHIVE_ALL Archived purchase orders (See page 3 – 459)

PO_HISTORY_POS_ALL Purged purchase orders (See page 3 – 465)

PO_HISTORY_RECEIPTS Purged receipts (See page 3 – 467)

PO_HISTORY_REQUISITIONS_ALL Purged requisitions (See page 3 – 468)

PO_HISTORY_VENDORS Purged suppliers (See page 3 – 469)

PO_LINES_ALL Purchase document lines (for purchase orders, purchase

agreements, quotations, RFQs) (See page 3 – 470)

PO_LINES_ARCHIVE_ALL Archived purchase order lines (See page 3 – 476)

PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders,

purchase agreements, quotations, RFQs) (See page 3 – 482)

PO_LINE_LOCATIONS_ARCHIVE_ALL Archived purchase order shipments (See page 3 – 490)

PO_LINE_TYPES_B Line types (See page 3 – 497)

PO_NOTES No longer used (See page 3 – 499)

PO_NOTE_REFERENCES Document/notes references (See page 3 – 501)

PO_NOTIFICATIONS_ALL Notifications (See page 3 – 503)

PO_ONLINE_REPORT_TEXT Online report errors (See page 3 – 504)

PO_PURGE_PO_LIST Purchase order candidates for purging (See page 3 – 506)

PO_PURGE_REQ_LIST Requisition candidates for purging (See page 3 – 507)

PO_PURGE_VENDOR_LIST Supplier candidates for purging (See page 3 – 508)

2 – 30 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

PO_RELEASES_ALL Purchase order releases (See page 3 – 509)

PO_REQEXPRESS_LINES_ALL Template lines for express requisitions (See page 3 – 514)

PO_REQUISITION_HEADERS_ALL Requisition headers (See page 3 – 517)

PO_REQUISITION_LINES_ALL Requisition lines (See page 3 – 521)

PO_REQ_DISTRIBUTIONS_ALL Requisition distributions (See page 3 – 528)

PO_RFQ_VENDORS Suppliers on an RFQ (See page 3 – 531)

PO_SYSTEM_PARAMETERS_ALL Purchasing options (See page 3 – 533)

PO_UNIQUE_IDENTIFIER_CONT_ALL Purchase order document number control (See page 3 – 538)

PO_USAGES Note usages (See page 3 – 539)

PO_VENDORS Suppliers (See page 3 – 540)

PO_VENDOR_CONTACTS Supplier contacts (See page 3 – 547)

PO_VENDOR_LIST_ENTRIES RFQ supplier list entries (See page 3 – 549)

PO_VENDOR_LIST_HEADERS RFQ supplier list headers (See page 3 – 551)

PO_VENDOR_SITES_ALL Supplier sites (See page 3 – 553)

RA_CUSTOMERS Customer information (See page 3 – 558)

RA_SITE_USES_ALL Business purpose of a customer address (See page 3 – 563)

RCV_LOTS_SUPPLY Receiving lots supply (See page 3 – 568)

RCV_LOT_TRANSACTIONS Receiving lots transactions (See page 3 – 570)

RCV_PARAMETERS Organization–level receiving controls (See page 3 – 571)

RCV_ROUTING_HEADERS Receiving routing headers (See page 3 – 574)

RCV_SERIALS_SUPPLY Receiving serial supply (See page 3 – 575)

RCV_SERIAL_TRANSACTIONS Receiving serial transactions (See page 3 – 576)

RCV_SHIPMENT_HEADERS Shipment and receipt header information (See page 3 – 577)

RCV_SHIPMENT_LINES Receiving shipment line information (See page 3 – 581)

RCV_TRANSACTIONS Receiving transactions (See page 3 – 585)

RCV_TRANSACTIONS_INTERFACE Receiving transactions interface table (See page 3 – 591)

High–Level Design 2 – 31

Oracle Proprietary, Confidential Information––Use Restricted by Contract

WIP_OPERATIONS Operations necessary for jobs and schedules (See page

3 – 599)

2 – 32 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Web View List

This section lists each view we created to simplify access from Oracle

Self–Service Web Applications, and it provides a brief description of

each of those views. The page reference is to the view description in

Chapter 3.

Payables uses the following Web views:

View Name Description

AP_EXPENSE_FEED_DISTS_OPEN_V Verify Open Transactions in Self–Service Expenses is based

on this view (See page 3 – 96)

AP_EXPENSE_FEED_DISTS_V View Transaction History in Self–Service Expenses is based

on this view (See page 3 – 102)

AP_WEB_PA_PROJECTS_TASKS_V The View Projects and Tasks function and the Task Number

list of values in Oracle Self–Service Expenses are based on

this view (See page 3 – 270)

AP_WEB_PA_PROJECTS_V The Project Number list of values in Oracle Self–Service

Expenses is based on this view (See page 3 – 272)

High–Level Design 2 – 33

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Forms and Table View List

This section lists supplementary views that are not essential to the

Release 11 data model, but simplify coding or improve performance of

Developer/2000. For example, many of these views are used as base

tables in Payables forms.

Warning: We do not recommend you query or alter data using

these views. Furthermore, these views may change

dramatically in subsequent minor or major releases of Payables.

Payables uses the following Forms and Table views:

• AP_APPLY_PREPAYS_FR_PREPAY_V

• AP_APPLY_PREPAYS_V

• AP_AWT_BUCKETS_V

• AP_AWT_TEMP_DISTRIBUTIONS_V

• AP_BANK_ACCOUNT_USES_V

• AP_BATCHES_V

• AP_CARDS_V

• AP_CHARGE_ALLOCATIONS_V

• AP_CHECKS_V

• AP_CHECKS_WWW_V

• AP_CHECK_STOCKS_ACTIVE_V

• AP_CHECK_STOCKS_V

• AP_DISTRIBUTION_SETS_DSN_V

• AP_DISTRIBUTION_SET_LINES_V

• AP_DUPLICATE_VENDORS_V

• AP_ENCUMBRANCE_LINES_V

• AP_EXPENSE_FEED_LINES_V

• AP_EXPENSE_REPORT_HEADERS_V

• AP_HOLDS_HOLD_NAME_V

• AP_HOLDS_OVERVIEW_V

• AP_HOLDS_RELEASE_NAME_V

• AP_HOLDS_V

• AP_HOLD_CODES_HOLD_NAME_V

2 – 34 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

• AP_HOLD_CODES_V

• AP_INTERFACE_REJECTIONS_V

• AP_INVOICES_DERIVED_V

• AP_INVOICES_INTERFACE_V

• AP_INVOICES_READY_TO_PAY_V

• AP_INVOICES_UNION_PREPAYS_V

• AP_INVOICES_V

• AP_INVOICES_WWW_V

• AP_INVOICE_DISTRIBUTIONS_V

• AP_INVOICE_DISTS_INQUIRY_V

• AP_INVOICE_LINES_INTERFACE_V

• AP_INVOICE_PAYMENTS_V

• AP_INVOICE_PAYMENTS_WWW_V

• AP_INVOICE_PAYMENT_HISTORY_V

• AP_INVOICE_PREPAYS_V

• AP_INV_SELECTION_CRITERIA_V

• AP_LC_INVOICE_TYPES_DB_V

• AP_LC_INVOICE_TYPES_V

• AP_LC_PAYMENT_METHODS_V

• AP_LC_QUICK_RELEASES_V

• AP_OTHER_PERIODS_PN_V

• AP_OTHER_PERIODS_V

• AP_OTHER_PERIOD_TYPES_PT_V

• AP_PAYMENT_SCHEDULES_V

• AP_PBATCH_SETS_V

• AP_PBATCH_SET_LINES_V

• AP_PO_USRDEF_LOOKUP_CODES_V

• AP_RECURRING_PAYMENTS_V

• AP_TAX_CODES_ACTIVE_V

• AP_TAX_CODES_NAMES_V

High–Level Design 2 – 35

Oracle Proprietary, Confidential Information––Use Restricted by Contract

• AP_TAX_CODES_TN_V

• AP_TAX_CODES_V

• AP_TAX_CODES_VAL_V

• AP_TAX_LINES_SUMMARY_V

• AP_TERMS_BAT_PAY_TERMS_V

• AP_TERMS_V

• AP_TERMS_VAL_V

• AP_UNAPPLY_PREPAYS_FR_PREPAY_V

• AP_UNAPPLY_PREPAYS_V

• AP_VENDORS_V

• AP_VENDOR_DISP_V

• AP_VENDOR_SITES_V

• AP_WEB_SIGNING_LIMITS_V

• FINANCIALS_PURGES_V

• FND_DOCUMENT_SEQUENCES_AP_V

• FND_DOC_SEQ_CATEGORIES_AP_V

• FND_ID_SEGMENT_NAME_AP_V

• GL_JE_BATCHES_AP_V

• HR_EMPLOYEES

• HR_EMPLOYEES_CURRENT_V

• ORG_ORGANIZATION_DEFINITIONS

• PA_EXPENDITURE_TYPES_AP_V

• PA_PROJECTS_AP_V

• PA_PROJECT_TASKS_AP_V

• PA_TASKS_AP_V

• PO_VENDORS_ACTIVE_AP_V

• PO_VENDORS_ALL_V

• PO_VENDORS_AP_V

• PO_VENDOR_SITES_ALL_V

• PO_VENDOR_SITES_PAY_AP_V

2 – 36 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Internal View List

This section lists each private, internal view that Payables uses.

Warning: Oracle Corporation does not support access to Oracle

Applications data using these views, except from standard

Oracle Applications forms, reports, and programs.

Payables uses the following internal views:

• AP_AEL_GL_INV_V

• AP_AEL_GL_PAY_V

• AP_AEL_SL_INV_V

• AP_AEL_SL_PAY_V

• AP_AEL_SL_V

• AP_AE_HEADERS_V

• AP_AE_LINES_V

• AP_BANK_BRANCHES_V

• AP_CARD_NOTIFICATIONS_V

• AP_CHARGES_V

• AP_JE_CATEGORIES_V

• AP_LOOKUP_CODES

• AP_LOOKUP_TYPES

• AP_SOB_INFO_V

• AP_SRS_ACCTG_CURR_V

• AP_SRS_REGION_NAMES_V

• AP_SRS_SOB_NAME_V

• AP_TEMP_APPROVAL

• AP_TERMS_VL

• AP_WEB_APPROVER_LOV_V

• AP_WEB_DFLEX_LOV_V

• PO_DISTRIBUTIONS_AP_V

• PO_VENDOR_SITES_AP_V

High–Level Design 2 – 37

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Single Organization View List

Multi–Organization Support is a feature that allows you to implement

multiple sets of books within a single installation of Oracle Payables,

Oracle Receivables, Oracle Purchasing, and Oracle Order

Entry/Shipping. Instead of using multiple installations to provide data

security, data is secured by operating unit.

In Release 10.7, we added a column, ORG_ID, to each base table that

requires ”partitioning” by operating unit, including all transaction tables

and many reference tables, then renamed these tables to end with the

suffix _ALL. Then, to take the place of the renamed table, we create a

view (named like the Release 10.6 or earlier table) containing a WHERE

clause that automatically restricts data to a single operating unit. The

WHERE clause relies upon the value of an Oracle global variable to

indicate the current organization.

If you want to retrieve all information, regardless of operating unit,

query the _ALL table. For example, if you are running a

cross–organization report, you probably want to query the _ALL table.

However, if you want to report against only a single organization or

operating unit, query the corresponding cross–organizational view,

using the familiar 10.6–style table name. The view definition will

automatically retrieve only data for your current operating unit.

Additional Information: Multiple Organizations in Oracle

Applications

Payables uses the following Single Organization views:

• AP_1096_DATA

• AP_1099_TAPE_DATA

• AP_ACCOUNTING_EVENTS

• AP_AE_HEADERS

• AP_AE_LINES

• AP_AWT_BUCKETS

• AP_AWT_GROUP_TAXES

• AP_AWT_TAX_RATES

• AP_AWT_TEMP_DISTRIBUTIONS

• AP_BANK_ACCOUNTS

• AP_BANK_ACCOUNT_USES

2 – 38 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

• AP_BATCHES

• AP_CARDS

• AP_CARD_CODES

• AP_CARD_CODE_SETS

• AP_CARD_GL_ACCTS

• AP_CARD_GL_SETS

• AP_CARD_PROFILES

• AP_CARD_PROFILE_LIMITS

• AP_CARD_PROGRAMS

• AP_CARD_REQUESTS

• AP_CHECKRUN_CONC_PROCESSES

• AP_CHECKRUN_CONFIRMATIONS

• AP_CHECKS

• AP_CHECK_STOCKS

• AP_CHRG_ALLOCATIONS

• AP_CREDIT_CARD_TRXNS

• AP_DISTRIBUTION_SETS

• AP_DISTRIBUTION_SET_LINES

• AP_DUPLICATE_VENDORS

• AP_ENCUMBRANCE_LINES

• AP_EXPENSE_FEED_DISTS

• AP_EXPENSE_FEED_LINES

• AP_EXPENSE_REPORTS

• AP_EXPENSE_REPORT_HEADERS

• AP_EXPENSE_REPORT_LINES

• AP_EXPENSE_REPORT_PARAMS

• AP_FLEX_SEGMENT_MAPPINGS

• AP_HISTORY_CHECKS

• AP_HISTORY_INVOICES

• AP_HISTORY_INVOICE_PAYMENTS

High–Level Design 2 – 39

Oracle Proprietary, Confidential Information––Use Restricted by Contract

• AP_HOLDS

• AP_INVOICES

• AP_INVOICE_DISTRIBUTIONS

• AP_INVOICE_KEY_IND

• AP_INVOICE_PAYMENTS

• AP_INVOICE_PREPAYS

• AP_INVOICE_SELECTION_CRITERIA

• AP_MATCHED_RECT_ADJ

• AP_PAYMENT_DISTRIBUTIONS

• AP_PAYMENT_HISTORY

• AP_PAYMENT_KEY_IND

• AP_PAYMENT_SCHEDULES

• AP_PBATCH_SETS

• AP_PBATCH_SET_LINES

• AP_RECON_DISTRIBUTIONS

• AP_RECURRING_PAYMENTS

• AP_REPORTING_ENTITIES

• AP_REPORTING_ENTITY_LINES

• AP_SELECTED_INVOICES

• AP_SELECTED_INVOICE_CHECKS

• AP_SYSTEM_PARAMETERS

• AP_TAX_CODES

• AP_TAX_RECVRY_RATES

• AP_TAX_RECVRY_RULES

• AP_TOLERANCES

• AP_VENDOR_KEY_IND

• AP_WEB_SIGNING_LIMITS

• FINANCIALS_SYSTEM_PARAMETERS

2 – 40 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Multiple Reporting Currencies View List

This section lists each view that Payables uses to support the Multiple

Reporting Currencies (MRC) feature. These views, under certain

circumstances, replace the corresponding transaction tables but retrieve

currency–sensitive information expressed in the reporting currency

rather than in the functional currency for the associated set of books.

That is, when you access a transaction table from the APPS_MRC

schema, an MRC synonym redirects your query to the corresponding

MRC view; this MRC view ensures you retrieve currency amounts

expressed in the currency associated with the reporting set of books, as

indicated by the userenv variable.

If you have not installed Multiple Reporting Currencies, you do not

need to use these views. If you do use MRC, standard product forms

and reports automatically access data using these views whenever you

sign on using a reporting currency responsibility.

Additional Information: Multiple Reporting Currencies,

Oracle Applications Installation Manual, Volume 1: Architecture and

Concepts; and Multiple Reporting Currencies in Oracle Applications

Payables uses the following Multiple Reporting Currencies views:

• AP_CHECKS_ALL_MRC_V

• AP_CHECKS_MRC_V

• AP_INVOICES_ALL_MRC_V

• AP_INVOICES_MRC_V

• AP_INVOICE_DISTS_ALL_MRC_V

• AP_INVOICE_DISTS_MRC_V

• AP_INVOICE_PAYMENTS_ALL_MRC_V

• AP_INVOICE_PAYMENTS_MRC_V

• AP_PAYMENT_HISTORY_MRC_V

• AP_PAYMENT_HIST_ALL_MRC_V

• AP_SYSTEM_PARAMETERS_MRC_V

• AP_SYSTEM_PARAMS_ALL_MRC_V

• AP_TRIAL_BALANCE_MRC_V

• FINANCIALS_SYSTEM_PARAMS_MRC_V

• FIN_SYSTEM_PARAMS_ALL_MRC_V

High–Level Design 2 – 41

Oracle Proprietary, Confidential Information––Use Restricted by Contract

Module List

This section lists each form, report and concurrent program comprising

Oracle Payables.

Forms

APXALLOC Charge Allocations

APXAMDOP Special Calendar

APXCUMSP Payables Options

APXEDSUF Account Segments for Expense Reporting

APXIIFIX Open Interface Invoices

APXIISIM Invoice Gateway

APXINAWT Projected Withholding Tax

APXINWKB Invoice Workbench

APXIWALL Invoice Overview

APXPAWKB Payment Workbench

APXPBSET Payment Batch Sets

APXPGSUB Submit Purge

APXPMTCH Match to Purchase Orders

APXPWALL Payment Overview

APXRICAD Recurring Invoices

APXRMTCH Match to Receipts

APXSPDPF Payment Formats

APXSSFSO Financials Options

APXSSSOB Choose Set of Books

APXSUAPL Aging Periods

APXSUDAP Automatic Payment Programs

APXSUDBC Bank Charges

APXSUDCC Countries and Territories

APXSUDIP Payment Interest Rates

APXSUIAC Invoice Approvals

APXSUMBA Banks

2 – 42 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

APXSUMDS Distribution Sets

APXSUMMT Invoice Tolerances

APXSUMPS Control Payables Periods

APXSUMVT Payment Terms

APXTADRR Tax Recovery Rules

APXTADTC Tax Codes

APXTADTR Income Tax Regions

APXTBCKT View Period–To–Date Withheld Amounts

APXTCERT Withholding Tax Certificates and Exceiptions

APXTGRPS Withholding Tax Groups

APXTRDRE Reporting Entity

APXUPDAE Update Accounting Entries

APXVDDUP Supplier Merge

APXVDMVD Supplier

APXVWENC View Encumbrances

APXWCARD Credit Cards

APXWCODE Credit Card Code Sets

APXWCTRX Credit Card Transactions

APXWGSET Credit Card GL Account Sets

APXWPROF Credit Card Profiles

APXWPROG Credit Card Programs

APXWSLMT Signing Limits

APXXXDER Expense Report Templates

APXXXEER Expense Report

FNDFFMCV Define Cross–Validation Rule

FNDFFMDC Define Descriptive Flexfield Segments

FNDFFMIS Define Key Flexfield Segments

FNDFFMSA Define Shorthand Aliases

FNDFFMSV Define Segment Values

FNDFFMVS Define Value Set

FNDFFSRA Assign Security Rules

FNDFFSRN Define Security Rule

High–Level Design 2 – 43

Oracle Proprietary, Confidential Information––Use Restricted by Contract

FNDNLDCX Define Currency

FNDPOMSV Update Personal Profile Values

FNDRSRUN Run Reports

FNDRSSET Administer Report Sets

GLXACCMB GL Accounts

GLXRTDLY Daily Rates

GLXRTTYP Conversion Rate Types

GLXSTBKS Set of Books

GLXSTCAL Accounting Calendar

GLXSTPTY Period Types

XLAIQACL View Accounting Lines

Reports

APGVEDPR SF 1166–EDP Voucher and Schedule of Payments

APGVOCRR SF 1166–OCR Voucher and Schedule of Payments

APGVQPRO Sales Tax and Freight Proration Report

APPAYDIS Payment Distribution Report

APXACPAY Japanese Actual Payment Report

APXAECTR Payables Accounting Entries Report

APXBABAL Bank Account Listing

APXBCACN Bank Charge Accounting Upon Notification Report

APXBCACP Bank Charge Accounting Upon Payment Report

APXBCOBN Batch Control Report by Batch Name

APXBCOEB Batch Control Report by Entered By

APXBCRPT Bank Charges Report

APXCHCCG Missing Document Numbers Report

APXCHCCR Payment Batch Control Report

APXCHECC Payment Exceptions Report

APXCMINV Credit Memo Matching Report

APXCRRCR Cash Requirement Report

APXCRUGL Unrealized Gain/Loss Report

2 – 44 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

APXEDSRS Expense Distribution Detail Report

APXEMELR Employee Listing

APXFPMDR Future Payment Maturity Date Report

APXGDGDL Distribution Set Listing

APXINAGE Invoice Aging Report

APXINDIA Discounts Available Report

APXINDTL Discounts Taken and Lost Report

APXINDUP Invoice Audit Report

APXINHAP Quick Release Report

APXINHIS Invoice History Report

APXINLST Invoice Audit Listing

APXINMHD Matching Hold Detail Report

APXINPIR Posted Invoice Register

APXINPRT Print Invoice Report

APXINPSR Prepayments Status Report

APXINREV Open Items Revaluation Report

APXINRIR Invoice Register

APXINROH Invoice on Hold Report

APXINSWP Unposted Invoice Sweep Program

APXINUTR Use Tax Liability Report

APXINVAD Invoice Audit Listing by Voucher Number

APXINVPH Supplier Paid Invoice History

APXINVTC Japanese Invoice Transaction Check Report

APXJEHIS Journal with GL Details Report

APXKIRKI Key Indicators Report

APXMHLET Matching Hold Agent Notice

APXMTDCR Payment Register

APXPAYAD Payment Audit by Voucher Number

APXPAYGL Payment Gain/Loss Report

APXPAYSC Japanese Scheduled Payment Report

APXPBFPR Final Payment Register

APXPBPPR Preliminary Payment Register

High–Level Design 2 – 45

Oracle Proprietary, Confidential Information––Use Restricted by Contract

APXPBSRA Separate Remittance Advice

APXPCEMP Distribute Employee Card Transaction Verifications

APXPCMAN Distribute Manager Card Transactions Approvals

APXPGDEL AP/PO Purge Deletion Routine

APXPGLIS Purge Report Listings

APXPPHIS Supplier Payment History

APXPPREM Prepayments Remittance Report

APXPPSPR Stopped Payments Report

APXPTDCR Posted Payment Register

APXPTPTR Payment Terms Listing

APXQCQCL Lookups Listing

APXRPRPR Recurring Invoices Report

APXRTB Accounts Payable Trial Balance

APXTARRL Tax Recovery Rules Listing

APXTATAT Tax Audit Trail

APXTATCL Tax Codes Listing

APXTAVAR Intra–EU VAT Audit Trail

APXTRINE 1099 Invoice Exceptions Report

APXTRRVT 1099 Payments Report

APXTRSWP Unaccounted Transactions Report

APXTRUTT Update Income Tax Details Utility

APXTRVEE 1099 Supplier Exceptions Report

APXTRXRN Transaction Reconciliation Report

APXVCHCR Void Payment Register

APXVDDUP.RDF Supplier Audit Report

APXVDLBL Supplier Mailing Labels

APXVDLET Invalid PO Supplier Notice

APXVDRAL Receiving Hold Requestor Notice

APXVDREV Supplier Balance Revaluation Report

APXVDTIN Tax Information Verification Letter

APXVDVSR Suppliers Report

APXVSRPT New Supplier/New Supplier Site Listing

2 – 46 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract

APXWTCER Withholding Tax Certificate Listing

APXWTINV Withholding Tax by Invoice Report

APXWTPAY Withholding Tax by Payment Report

APXWTSRA Withholding Tax Authority Remittance Advice

APXWTTXA Withholding Tax by Tax Authority Report

APXWTVND Withholding Tax by Supplier Report

APXXPXPL Expense Report Templates Listing

APYRLLVR Tax Declaration Report

FAS822 Mass Additions Create Report

POXNOTES Standard Notes Listing

Concurrent Programs

APECEPYO Create payment data to pass to Oracle e–commerce

Gateway

APGLTRANS Payables Transfer to General Ledger

APMACR Create mass addition lines for Oracle Assets

application

APPBCF Confirm payment documents created for a payment

batch

APPRVL Approve invoices for payment and posting

APTCMT Create 1099 payments report on electronic media

APTZGF Format payments in Zengin format

APXAEREP Payables Accounting Process.

APXATR Update exchange rates for foreign currency invoices

and payments

APXIIADV Create data for outbound advice from Oracle

e–commerce Gateway

APXIIMPT Load invoices from open interface tables

APXIIPRG Purge open interface tables

APXIIWKF Validate data in open interface tables prior to import

APXINUPD Initiate supplier merge and report on all updated

information

High–Level Design 2 – 47

Oracle Proprietary, Confidential Information––Use Restricted by Contract

APXPBASL Select invoices for payment in a payment batch

APXPBBLD Build payments in a payment batch

APXPBFBC Format and create output file for BACS 1/2” Tape

electronic media

APXPBFEF Format and create output file for form feed checks

APXPBFEG Format and create output file for standard checks

APXPBFEL Format and create output file for laser checks

APXPBFOF Format and create output file for standard form feed

checks

APXPBFOR Format and create output file for standard checks

APXPBFTR Support for Japanese bank charges feature

APXPBFUS Format and create output file for standard U.S.

Treasury checks

APXPBFZG Generate Zengin file

APXPCINV Credit card invoice interface summary report

APXPCVAL Credit card transaction validation and exception

report

APXPGABT Abort purge of selected records

APXPGCFM Confirm records selected for purge

APXPGSEL Select eligible records for purge

APXPGSUM Create historical data for records to be deleted during

purge

APXPOPAY Create file of paid checks for bank to verify payments

APXR11PP Unapply Preupgrade Prepayments

APXTRF96 Produce a summary of 1099 payments

APXTRF99 Produce 1099 payment form for a specified supplier or

all suppliers

APXUMFPS Update Matured Future Payment Status

APXXTR Create invoices for expense reports

2 – 48 Oracle Payables Applications Technical Reference Manual

Oracle Proprietary, Confidential Information––Use Restricted by Contract