Download - AP Overview
![Page 1: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/1.jpg)
Technical Overview of the Accounts
Payable Module
Technical Overview of the Accounts
Payable Module
![Page 2: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/2.jpg)
ContentsContentsContentsContents
• Objectives
• Technical Overview - Database Diagrams
• Integration with Other Modules
• Common Customizations
• Interfaces - Architecture and A Case Study
• Conclusion.
![Page 3: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/3.jpg)
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
![Page 4: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/4.jpg)
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
![Page 5: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/5.jpg)
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
![Page 6: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/6.jpg)
Integration with Other ModulesIntegration with Other Modules
•Purchasing Integration
•Fixed Assets Integration
•GL Integration
![Page 7: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/7.jpg)
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
![Page 8: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/8.jpg)
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
![Page 9: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/9.jpg)
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
![Page 10: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/10.jpg)
Common CustomizationsCommon Customizations
• Cheque Printing
• Separate Remittance Advise
• Interfaces with Internal systems and Other Accounting Systems
![Page 11: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/11.jpg)
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
![Page 12: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/12.jpg)
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
![Page 13: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/13.jpg)
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
![Page 14: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/14.jpg)
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.
![Page 15: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/15.jpg)
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
![Page 16: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/16.jpg)
• 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
![Page 17: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/17.jpg)
Interface Demo
![Page 18: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/18.jpg)
Any Questions ??Any Questions ??
![Page 19: AP Overview](https://reader036.vdocuments.us/reader036/viewer/2022082915/546f4dd5b4af9f64198b45b3/html5/thumbnails/19.jpg)
THANK YOU