ap overview

Technical Overview of the Accounts

Payable Module

Technical Overview of the Accounts

Payable Module

ContentsContentsContentsContents

• Objectives

• Technical Overview - Database Diagrams

• Integration with Other Modules

• Common Customizations

• Interfaces - Architecture and A Case Study

• Conclusion.

Objectives Objectives

At the end of this course, you should be able to :

•Identify the tables used in Oracle Payable module and how do they interrelate.

•Generate reports

•Do the Interface with Internal and external systems

Technical Overview - Database DiagramsTechnical Overview - Database Diagrams

Suppliers

PO_VENDOR_SITES_ALL

VENDOR_SITE_ID

PO_VENDORS

VENDOR_ID

PO_VENDOR_CONTACTS_ALL

VENDOR_CONTACT_ID

Banks

AP_BANK_BRANCHES_ALL

BANK_BRANCH_ID

AP_BANK_ACCOUNTS_ALL

BANK_ACCOUNT_ID

AP_CHECK_STOCKS_ALL

CHECK_STOCK_ID

AP_BANK_ACCOUNT_USES_ALL

BANK_ACCOUNT_USES_ID

Technical Overview - Database DiagramsTechnical Overview - Database Diagrams

Invoices and PaymentsAP_BACTHES_ALL

BATCH_ID

AP_INVOICES_ALL

INVOICE_ID

AP_INVOICE_DISTRIBUTIONS_ALL

INVOICE_ID

DISTRIBUTION_LINE_NUMBER

AP_PAYMENT_SCHEDULES_ALL

INVOICE_ID

PAYMENT_NUMAP_HOLDS_ALL

AP_ACCOUNTING_EVENTS_ALL

AP_AE_HEADERS_ALL

AP_AE_LINES_ALL

AP_INVOICE_PAYMENTS_ALL AP_CHECKS_ALL

Integration with Other ModulesIntegration with Other Modules

•Purchasing Integration

•Fixed Assets Integration

•GL Integration

Purchasing IntegrationPurchasing Integration

PO_VENDOR_SITES_ALL

VENDOR_SITE_ID

PO_VENDORS

VENDOR_ID

PO_HEADERS_ALL

PO_HEADER_ID

PO_LINES_ALL

PO_LINE_ID

PO_LINE_LOCATIONS_ALL

PO_LINE_LOCATION_ID

PO_DISTRIBUTIONS_ALL

PO_DISTRIBUTION_ID

PO_RELEASES_ALL

PO_RELEASE_ID

AP_INVOICES_ALL

INVOICE_ID

AP_INVOICE_DISTRIBUTIONS_ALL

INVOICE_ID

DISTRIBUTION_LINE_NUMBER

RCV_TRANSACTIONS

TRANSACTION_ID

Fixed Assets IntegrationFixed Assets Integration

PO_VENDOR_SITES_ALL

VENDOR_SITE_ID

PO_VENDORS

VENDOR_ID

AP_INVOICES_ALL

INVOICE_ID

AP_INVOICE_DISTRIBUTIONS_ALL

INVOICE_ID

DISTRIBUTION_LINE_NUMBER

FA_ASSET_INVOICES

FA_MASS_ADDITIONS

MASS_ADDITION_ID

GL IntegrationGL Integration

AP_ACCOUNTING_EVENTS_ALL

ACCOUNTING_EVENT_ID

AP_AE_HEADERS_ALL

AE_HEADER_ID

AP_AE_LINES_ALL

AE_LINE_ID

GL_SETS_OF_BOOKS

SET_OF_BOOKS_ID

GL_JE_BATCHES

JE_BATCH_ID

GL_JE_HEADERS

JE_HEADER_ID

GL_JE_LINES

JE_HEADER_ID

JE_LINE_NUM

GL_IMPORT_REFERENCES

JE_HEADER_ID

JE_LINE_NUM

Common CustomizationsCommon Customizations

• Cheque Printing

• Separate Remittance Advise

• Interfaces with Internal systems and Other Accounting Systems

Cheque PrintingCheque Printing

Steps for customizing the standard Cheque printing Program (Technical):

• Copy the APXPBFOR.rdf from $AP_TOP/reports directory

• Rename the file as per the required naming conventions

• Change the code as per the additional requirement (Ex: Payee Name, Check Date and amount in words).

• Change the layout as per the requirement (With and without Remittance advice or Remittance

before or after cheque)

• Copy the file to $AP_TOP/reports directory

Cheque PrintingCheque Printing

Steps for customizing the standard Cheque printing Program (Applications):

I. System Administrator / Application Developer

Sysadmin --> concurrent Program --> Executable

• Define the concurrent program executable

Sysadmin --> concurrent Program --> Define

• Query for the Standard Oracle Check Printing program

• Use the Copy button for copying the concurrent program definition to the customized program

Cheque PrintingCheque Printing

…..Contd.

For Various dimensions of cheques and to print on specific printers, we also need to do the following setups:

• Install Printers

• Install Printer drivers

• Define Style

• Attach the style to the existing concurrent program definition

Cheque PrintingCheque Printing

Steps for customizing the standard Cheque printing Program (Applications):

II. Accounts Payable Setup.

Setup --> Payment --> Programs

• Attach the concurrent program defined as a Format Payment

Setup --> Payment --> Formats

• Define the Format Payment

Setup --> Payment --> Banks

• Query the Bank to which you would like to attach this format.

Interface ArchitectureInterface Architecture

Data from Oracle HRMS/

Other Accounting Systems

Custom Program to validate and populate into Interface

tables

Payable Open Interface Tables(AP_INVOICE_INTERFACE, AP_INVOICE_LINES_INTERFACE)Invoice records with header and line invoice information

Payable Open Interface Import Process

Invoice Tables(AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTION_ALL, AP_PAYMENT_SCHEDULES_ALL)

Processed

Perform corrections in

the Payable open interface tables

Rejected

Standard Program for Payable Approval Process

• Define the source from which we need to import the data

• Define the Document categories, sequences and their assignments, if we are using any document sequencing.

Interface Pre-requisites

Interface Demo

Any Questions ??Any Questions ??

THANK YOU