You are browsing the archive for AP.

Oracle Accounts Payables Tables

  • AP_1096_DATA_ALL
  • AP_1099_TAPE_DATA_ALL
  • AP_ACCOUNTING_EVENTS_ALL
  • AP_AE_HEADERS_ALL
  • AP_AE_LINES_ALL
  • AP_AGING_PERIODS
  • AP_AGING_PERIOD_LINES
  • AP_ALLOCATION_RULES
  • AP_ALLOCATION_RULE_LINES
  • AP_APINV_APPROVERS
  • AP_AUD_AUDITORS
  • AP_AUD_AUDIT_REASONS
  • AP_AUD_AUTO_AUDITS
  • AP_AUD_QUEUES
  • AP_AUD_RULE_ASSIGNMENTS_ALL
  • AP_AUD_RULE_SETS
  • AP_AUD_WORKLOADS
  • AP_AWT_BUCKETS_ALL
  • AP_AWT_GROUPS
  • AP_AWT_GROUP_TAXES_ALL
  • AP_AWT_TAX_RATES_ALL
  • AP_AWT_TEMP_DISTRIBUTIONS_ALL
  • AP_BANK_ACCOUNTS_ALL
  • AP_BANK_ACCOUNT_USES_ALL
  • AP_BANK_BRANCHES
  • AP_BANK_CHARGES
  • AP_BANK_CHARGE_LINES
  • AP_BANK_TRANSMISSIONS
  • AP_BATCHES_ALL
  • AP_CARDS_ALL
  • AP_CARD_CODES_ALL
  • AP_CARD_CODE_SETS_ALL
  • AP_CARD_CURRENCIES
  • AP_CARD_DETAILS
  • AP_CARD_EMP_CANDIDATES
  • AP_CARD_GL_ACCTS_ALL
  • AP_CARD_GL_SETS_ALL
  • AP_CARD_PARAMETERS
  • AP_CARD_PROFILES_ALL
  • AP_CARD_PROFILE_LIMITS_ALL
  • AP_CARD_PROGRAMS_ALL
  • AP_CARD_REQUESTS_ALL
  • AP_CARD_SUPPLIERS_ALL
  • AP_CC_ACCEPTORS
  • AP_CC_TRX_DETAILS
  • AP_CHECKRUN_CONC_PROCESSES_ALL
  • AP_CHECKRUN_CONFIRMATIONS_ALL
  • AP_CHECKS_ALL
  • AP_CHECK_FORMATS
  • AP_CHECK_INTEGERS
  • AP_CHECK_STOCKS_ALL
  • AP_CHECK_TRANSMISSIONS
  • AP_CHRG_ALLOCATIONS_ALL
  • AP_CHRG_ALLOCATIONS_ALL_EFC
  • AP_CREDIT_CARD_TRXNS_ALL
  • AP_CURRENCY_GROUP
  • AP_DBI_LOG
  • AP_DISTRIBUTION_SETS_ALL
  • AP_DISTRIBUTION_SET_LINES_ALL
  • AP_DOC_SEQUENCE_AUDIT
  • AP_DUPLICATE_VENDORS_ALL
  • AP_ENCUMBRANCE_LINES_ALL
  • AP_ENCUMBRANCE_LINES_ALL_EFC
  • AP_EXPENSE_FEED_DISTS_ALL
  • AP_EXPENSE_FEED_LINES_ALL
  • AP_EXPENSE_PARAMS_ALL
  • AP_EXPENSE_REPORTS_ALL
  • AP_EXPENSE_REPORT_HEADERS_ALL
  • AP_EXPENSE_REPORT_LINES_ALL
  • AP_EXPENSE_REPORT_PARAMS_ALL
  • AP_EXP_LOCATIONS
  • AP_EXP_REPORT_DISTS_ALL
  • AP_FLEX_SEGMENT_MAPPINGS_ALL
  • AP_HISTORY_CHECKS_ALL
  • AP_HISTORY_INVOICES_ALL
  • AP_HISTORY_INV_PAYMENTS_ALL
  • AP_HOLDS_ALL
  • AP_HOLD_CODES
  • AP_IDENT_PARTY_SITE_GT
  • AP_INCOME_TAX_REGIONS
  • AP_INCOME_TAX_TYPES
  • AP_INTEREST_PERIODS
  • AP_INTERFACE_CONTROLS
  • AP_INTERFACE_REJECTIONS
  • AP_INVOICES_ALL
  • AP_INVOICES_INTERFACE
  • AP_INVOICES_UPG_CONTROL
  • AP_INVOICE_DISTRIBUTIONS_ALL
  • AP_INVOICE_DISTRIBUTIONS_GT
  • AP_INVOICE_KEY_IND_ALL
  • AP_INVOICE_LINES_ALL
  • AP_INVOICE_LINES_INTERFACE
  • AP_INVOICE_PAYMENTS_ALL
  • AP_INVOICE_PREPAYS_ALL
  • AP_INVOICE_RELATIONSHIPS
  • AP_INVOICE_TRANSMISSIONS
  • AP_INV_APRVL_HIST_ALL
  • AP_INV_DISTS_UPDATE
  • AP_INV_SELECTION_CRITERIA_ALL
  • AP_LE_GROUP
  • AP_LIABILITY_BALANCE
  • AP_LINES_UPG_SYNC_DATA
  • AP_LINE_APRVL_HIST_ALL
  • AP_MAP_CODES
  • AP_MAP_TYPES_B
  • AP_MAP_TYPES_TL
  • AP_MATCHED_RECT_ADJ_ALL
  • AP_MC_CHECKS
  • AP_MC_INVOICES
  • AP_MC_INVOICE_DISTS
  • AP_MC_INVOICE_PAYMENTS
  • AP_MC_PAYMENT_HISTORY
  • AP_NEGOTIATION_HIST
  • AP_NOTES
  • AP_NO_MATCH_TRXNS
  • AP_ORG_ATTRIBUTES_GT
  • AP_ORG_COUNTRY_GT
  • AP_OTHER_PERIODS
  • AP_OTHER_PERIOD_TYPES
  • AP_OU_GROUP
  • AP_PARTY_CONTACT_SITES_GT
  • AP_PAYCARD_TRX_FEE_HEADER_ALL
  • AP_PAYCARD_TRX_FEE_LINES
  • AP_PAYMENT_DISTRIBUTIONS_ALL
  • AP_PAYMENT_HISTORY_ALL
  • AP_PAYMENT_HIST_DISTS
  • AP_PAYMENT_KEY_IND_ALL
  • AP_PAYMENT_PROGRAMS
  • AP_PAYMENT_REP_ITF
  • AP_PAYMENT_SCHEDULES_ALL
  • AP_PAYMENT_TEMPLATES
  • AP_PAY_GROUP
  • AP_PBATCH_SETS_ALL
  • AP_PBATCH_SET_LINES_ALL
  • AP_PERIOD_CLOSE_EXCPS_GT
  • AP_POL_CAT_OPTIONS_ALL
  • AP_POL_CONTEXT
  • AP_POL_EXRATE_OPTIONS_ALL
  • AP_POL_EXRATE_TOLERANCES
  • AP_POL_HEADERS
  • AP_POL_ITEMIZATIONS
  • AP_POL_LINES
  • AP_POL_LINES_HISTORY
  • AP_POL_LOCATIONS_B
  • AP_POL_LOCATIONS_TL
  • AP_POL_SCHEDULE_OPTIONS
  • AP_POL_SCHEDULE_PERIODS
  • AP_POL_VIOLATIONS_ALL
  • AP_PPA_INVOICES_GT
  • AP_PPA_INVOICE_DISTS_GT
  • AP_PPA_INVOICE_LINES_GT
  • AP_PREPAY_APP_DISTS
  • AP_PREPAY_HISTORY_ALL
  • AP_PRODUCT_REGISTRATIONS
  • AP_PRODUCT_SETUP
  • AP_PURGE_INVOICE_LIST
  • AP_R115_UPGRADE
  • AP_RECON_CHECK_RESULTS
  • AP_RECON_DETAILS
  • AP_RECON_DISTRIBUTIONS_ALL
  • AP_RECON_ERROR_CHK_GROUPS
  • AP_RECON_ERROR_CHK_GROUP_LINES
  • AP_RECON_LOCKS
  • AP_RECON_RECORD_CODES
  • AP_RECON_RECORD_SPECS
  • AP_RECON_SUMMARIES
  • AP_RECON_TRANSACTION_CODES
  • AP_RECURRING_PAYMENTS_ALL
  • AP_REPORTING_ENTITIES_ALL
  • AP_REPORTING_ENTITY_LINES_ALL
  • AP_SELECTED_INVOICES_ALL
  • AP_SELECTED_INVOICE_CHECKS_ALL
  • AP_SELF_ASSESSED_TAX_DIST_ALL
  • AP_SUPPLIERS
  • AP_SUPPLIERS_INT
  • AP_SUPPLIER_BALANCE_ITF
  • AP_SUPPLIER_CONTACTS
  • AP_SUPPLIER_INT_REJECTIONS
  • AP_SUPPLIER_SITES_ALL
  • AP_SUPPLIER_SITES_INT
  • AP_SUP_SITE_CONTACT_INT
  • AP_SYSTEM_PARAMETERS_ALL
  • AP_TAX_CODES_ALL
  • AP_TAX_DERIVATIONS
  • AP_TAX_RECVRY_RATES_ALL
  • AP_TAX_RECVRY_RULES_ALL
  • AP_TB_BALANCES_TMP
  • AP_TEMP_APPROVAL_ALL
  • AP_TERMS_LINES
  • AP_TERMS_TL
  • AP_TOLERANCES_ALL
  • AP_TOLERANCE_TEMPLATES
  • AP_TRANSMISSIONS_SETUP
  • AP_TRIAL_BAL
  • AP_TRIAL_BALANCE
  • AP_TRIAL_BALANCE_LEDGERS
  • AP_UNSELECTED_INVOICES_ALL
  • AP_USER_EXCHANGE_RATES
  • AP_VENDOR_AUDIT_TMP
  • AP_VENDOR_KEY_IND_ALL
  • AP_WEB_ACCFLEX_SEGMENTS
  • AP_WEB_AMEX_PARAMS
  • AP_WEB_DISC_LINES_GT
  • AP_WEB_EMPLOYEE_INFO_ALL
  • AP_WEB_PREFERENCES
  • AP_WEB_PROXY_ASSIGNMENTS
  • AP_WEB_SIGNING_LIMITS_ALL
  • AP_WEB_VAT_SETUP_ALL
  • AP_WHT_ITF
  • FINANCIALS_PURGES
  • FINANCIALS_PURGES_ALL
  • FINANCIALS_SYSTEM_PARAMS_ALL
  • OIE_ADDON_MILEAGE_RATES
  • OIE_ALLOCATION_PREFS
  • OIE_ATTENDEES_ALL
  • OIE_CURRENT_PAGE_SETTING
  • OIE_DATA_CAPTURE_FIELDS
  • OIE_DATA_CAPTURE_OPTIONS
  • OIE_DATA_CAPTURE_RULES
  • OIE_DISTRIBUTION_SETS_ALL
  • OIE_PDM_DAILY_BREAKUPS
  • OIE_PDM_DESTINATIONS
  • OIE_POL_RATES_INTERFACE
  • OIE_SET_DISTRIBUTIONS

Oracle Payables Forms

Oracle Accounts Payables module forms:

FORM SHORT CODE ORACLE FORM NAME
APXALLOC Charge Allocations
APXAMDOP Define Periods
APXAMDPT Define Period Types
APXCUMSP Define System Options and Defaults
APXIIFIX Fix Open Interface Invoices
APXIISIM Quick Invoices
APXIMTCH Correct Unmatched Invoice
APXINAWT Projected Withholding Tax
APXINWKB Invoice Workbench
APXIWALL Invoice Overview
APXPAWKB Payment Workbench
APXPBSET Payment Batch Set
APXPGSUB Submit Purge
APXPMTCH Match to Purchase Order
APXPWALL Payment Overview
APXRICAD Recurring Invoices
APXRMTCH Match to Receipts
APXSPDPF Define Payment Formats
APXSSFSO Define Financials Options
APXSSSOB Set of Books
APXSUAPL Set Up Aging Periods
APXSUDAP Define Automatic Payment Programs
APXSUDBC Define Bank Charges
APXSUDCC Maintain Countries and Territories
APXSUDIP Define Payment Interest Rates
APXSUIAC Define Invoice Approvals
APXSUMBA Set Up Bank Information
APXSUMDS Maintain Distribution Sets
APXSUMMT Define Tolerances
APXSUMPS Control Period Statuses
APXSUMVT Define Payment Terms
APXTADRR Define Tax Recovery Rules
APXTADTC Define Tax Names
APXTADTR Define Income Tax Regions
APXTBCKT View Period-to-Date Withheld Amounts
APXTCERT Tax Certificates and Exceptions
APXTGRPS Withholding Tax Groups
APXTRDRE Define Reporting Entities
APXUPDAE Update Accounting Entries
APXVDDUP Vendor Merge
APXVDMVD Enter Vendor
APXVWENC View Encumbrances
APXWCARD Credit Cards
APXWCODE Credit Card Code Sets
APXWCTRX Credit Card Transactions
APXWGSET Credit Card GL Sets
APXWPROF Credit Card Profiles
APXWPROG Credit Card Programs
APXWSLMT Employee Signing Limits
APXXXDER Define Expense Reports
APXXXEER XpenseXpress
APXSYSOP Define Payables System Setup
APXPRCOR Correct Matched Invoice
APXIAWHS Invoice Approval History
APXTVBNK View Transmissions Form
APXTSBNK Define Bank Transmission Setup Information
APXWTRXF Transaction Fees

Payables Profile Options

Oracle Accounts Payables Module Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
AP_WEB_OVERRIDE_APPR_REQ OIE:Approver Required
AP_WEB_PURPOSE_REQUIRED OIE:Purpose Required
AP_WEB_REPNUM_PREFIX OIE:Report Number Prefix
AP_WEB_TAX_ENABLE OIE:Enable Tax
SSE_WORKFLOW_USE_AME OIE:Enable Approval Management
SSE_CC_PAYMENT_DUE_FROM OIE:CC Payment Due From
SSE_CC_PAYMENT_NOTIFY OIE:CC Payment Notify
SSE_ENABLE_CREDIT_CARD OIE:Enable Credit Card
AP_WEB_ENABLE_PROJECT_ACCOUNTING OIE:Enable Project Allocations
AP_WEB_DESC_FLEX_NAME OIE:Enable DescFlex
AP_WEB_APPROVER_REQ_CC OIE:CC Approver Req
AP_WEB_ALLOW_OVERRIDE_APPROVER OIE:Enable Approver
AP_WEB_ALLOW_NON_BASE_REIMB OIE:Allow Non-Base Pay
AP_WEB_ALLOW_CREDIT_LINES OIE:Allow Credit Lines
AP_EXPENSE_ENABLE_WORKFLOW Expenses: Enable Workflow
OIE_ENABLE_BAR_CODE OIE:Enable Bar Code
OIE_ENABLE_PROJECT_EXPEND_ORG OIE:Enable Project Expenditure Organization
OIE_ENABLE_ALLOCATION_SPLITTING OIE:Enable Expense Allocation Splitting
AP_IAW_USER AP: Invoice Approval Workflow User
OIE_ENABLE_ADVANCES OIE:Enable Advances
OIE_CARRY_ADVANCES_FORWARD OIE:Carry Advances Forward
AP_WEB_CREDIT_CARD_EXPIRATION_DAYS WebExpenses:Maximum Days to Show Credit Card Transactions
AP_SUPPLIER_CONSIGNED_ENABLED AP: Supplier Consigned Enabled
OIE_ENABLE_LINE_LEVEL_ACCOUNTING OIE:Enable Expense Allocations
AP_BANK_FILE_CHARACTER_SET AP: Bank File Character Set
AP_SORT_BY_ALTERNATE AP: Sort By Alternate Fields
AP_ENTER_ALTERNATE AP: Enter Alternate Fields
AP_SHOW_FINAL_CLOSED_PO AP: Show Finally Closed POs
AP_USE_INV_BATCH_CONTROLS AP: Use Invoice Batch Controls
AP_WEB_POLICY_GRACE_PERIOD OIE:Grace Period
SSE_CREDIT_CARD_EXPIRATION_DAYS OIE:Maximum Days to Show Credit Card Transactions
AP_NOTIFICATION_EMAIL AP: Notification Recipient E-mail
AP_GATHER_PPR_TABLE_STATS AP: Gather PPR Table Stats
AP_COPY_INV_LINE_DFF AP: Copy Invoice Lines Flex field to Distributions during Import
OIE_ENABLE_COST_CENTER OIE:Enable Cost Center
AP_WEB_POLICY_VIOLATION_SUBMIT OIE:Enable Policy