ap overview
TRANSCRIPT
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