PeopleSoft Receivables Integration Points
To use PeopleSoft Receivables to full advantage, it is important to understand the points of integration between PeopleSoft Receivables and the other PeopleSoft applications that you have purchased, such as:
PeopleSoft General Ledger.
PeopleSoft Billing.
PeopleSoft Order Management.
PeopleSoft Purchasing.
PeopleSoft Project Costing.
PeopleSoft Contracts.
PeopleSoft Lease Administration.
PeopleSoft Grants.
PeopleSoft Payables.
PeopleSoft Cash Management.
PeopleSoft Customer Relationship Management (CRM).
PeopleSoft Pension Administration.
Because applications share information, you must plan to work closely with the implementation teams that install other PeopleSoft applications to ensure that Oracle provides the full functionality and efficiency that your company requires.
This documentation covers integration considerations in the implementation topics of Receivables. Supplemental information about third-party application integrations is on Oracle's My Oracle Support website: https://support.oracle.com.
The following diagram shows the integration of PeopleSoft Receivables with other PeopleSoft applications.
This diagram illustrates the integration of PeopleSoft Receivables with other PeopleSoft applications: Grants integrates down to Contracts, which integrates down to Billing. Order Management integrates down to Billing, and then down to Receivables. Order Management also integrates directly down to Receivables. Project Costing also integrates down to Billing and then down to Receivables. Billing also integrates horizontally with eBill Payment, and Receivables integrates up to eBill Payment. Purchasing also integrates up to Receivables. Payables, Cash Management, General Ledger, and CRM applications integrate up to Receivables. Payables integrates horizontally with Cash Management, which integrates up to and away from Receivables. Pension Administration also integrates up to and away from Receivables.
PeopleSoft General Ledger
PeopleSoft Receivables sends accounting entries to PeopleSoft General Ledger through the Journal Generator Application Engine process (FS_JGEN).
PeopleSoft Billing
If you have PeopleSoft Billing, you enter invoices and credit memos in PeopleSoft Billing and interface them to PeopleSoft Receivables. You can choose to have PeopleSoft Billing create the accounting entries or to have PeopleSoft Receivables create them. You can drill down to see invoice details for an item in PeopleSoft Billing.
PeopleSoft Order Management
PeopleSoft Receivables receives information that is entered in sales orders and interfaced to PeopleSoft Billing. PeopleSoft Receivables enables you to drill down to see sales order details from an item. PeopleSoft Receivables also receives claimback items directly from PeopleSoft Order Management, and sends PeopleSoft Order Management notification when the open balance for a claimback changes due to payment or maintenance activity. In PeopleSoft Order Management, you use the claim management workbench to send the claimbacks to PeopleSoft Receivables and reconcile payment activity for the claimbacks.
The Load Cash Drawer Receipts Application Engine process (CDR_LOADPMT) updates the payment staging tables in PeopleSoft Receivables when you enter payments and deposits for orders using the Cash Drawer feature. The Payment Loader Application Engine process (AR_PAYLOAD) updates the payment application tables with the payment data.
PeopleSoft Purchasing
PeopleSoft Receivables receives vendor rebate claims and vendor rebate reversals directly from PeopleSoft Purchasing, and sends PeopleSoft Purchasing notification when the open balance for a vendor rebate item changes due to payment or maintenance activity. In PeopleSoft Purchasing, you use the claim management workbench to send the vendor rebate claims to PeopleSoft Receivables and reconcile payment activity for the claims.
PeopleSoft Project Costing
When you enter pending item information in PeopleSoft Receivables, you can also enter information that is picked up by PeopleSoft Project Costing ChartField values. A project manager using PeopleSoft Project Costing can review outstanding revenue to keep complete financial control of a project. Resources rows that you enter in PeopleSoft Project Costing can be interfaced to PeopleSoft Billing to create invoices, which become items in PeopleSoft Receivables by using the billing interface.
PeopleSoft Contracts
PeopleSoft Billing plan lines that you enter in PeopleSoft Contracts are interfaced to PeopleSoft Billing to create invoices. These invoices become items in PeopleSoft Receivable by using the Billing interface. You can drill down to see contract details for an item in PeopleSoft Receivables.
PeopleSoft Lease Administration
PeopleSoft Lease Administration bills are sent through PeopleSoft Contracts and enter PeopleSoft Receivables through the Billing interface.
However, if PeopleSoft Contracts is not installed, PeopleSoft Lease Administration bills are sent to PeopleSoft Billing through the PeopleSoft Transaction Billing Processor. These bills enter PeopleSoft Receivables through the Billing Interface. You do not have to install PeopleSoft Contracts to use the PeopleSoft Transaction Billing Processor.
PeopleSoft Grants
Invoices can originate in PeopleSoft Grants and then be interfaced through PeopleSoft Contracts and PeopleSoft Billing into PeopleSoft Receivables.
PeopleSoft Payables
The refund process in PeopleSoft Receivables adds rows to tables that are used by PeopleSoft Payables to build a voucher.
PeopleSoft Cash Management
PeopleSoft Cash Management integrates with PeopleSoft Receivables through the Treasury Netting Center. You must use PeopleSoft Cash Management with PeopleSoft Payables to use the bilateral netting functionality that offsets open items with open vouchers in PeopleSoft Payables. This functionality is useful when you have customers that are also suppliers.
PeopleSoft Cash Management also provides the Financial Gateway feature, which enables you to communicate directly with the bank for direct debit payments. Financial Gateway creates the electronic funds transfer file (EFT) after receiving the direct debit information from PeopleSoft Receivables, and sends the transmission to the bank. It also provides acknowledgement statuses to PeopleSoft Receivables from the bank.
PeopleSoft CRM
PeopleSoft CRM integrates with PeopleSoft Receivables to obtain financial information for a customer. The CRM 360-Degree View displays the information under nodes in the 360-Degree View tree. PeopleSoft CRM provides the GET ACCOUNT RECEIVABLES FOR 360 DEGREE VIEW enterprise integration point (EIP) to request the information. PeopleSoft CRM sends a request application message (AR_CRM_REQUEST) to PeopleSoft Receivables requesting information for a specific SetID, customer, and date range. Within the request application message, PeopleSoft CRM may request up to nine different data sets:
Customer status and balances (AR_STATUS_REQ)
Payments (AR_PAYMENT_REQ)
Dunning notices (AR_DUNNLTR_REQ)
Statements (AR_STATEMNT_REQ)
Follow-up notices (AR_FOLLWLTR_REQ)
Disputes (AR_DISPUTES_REQ)
Deductions (AR_DEDUCTNS_REQ)
Conversations (AR_CONVERS_REQ)
Overdue charges (AR_OVERDUE_REQ)
PeopleSoft Receivables sends a response application message (AR_CRM_RESPONSE) back to PeopleSoft CRM, returning as many data sets as are requested. The CRM 360-Degree View displays summary information for those requested data sets. The user can click on the links to drill down and view more detailed financial information in PeopleSoft Receivables.
See the section on managing enterprise integration for PeopleSoft CRM in the PeopleSoft CRM Application Fundamentals documentation.
PeopleSoft Pension Administration
PeopleSoft Pension Administration integrates with PeopleSoft Receivables to support companies that offer service purchase options to their employees. Pension plans and their associated Service Purchase options are set up and administered by PeopleSoft Pension Administration in PeopleSoft Human Capital Management (HCM). Eligibility to participate in the Service Purchase option is defined by the plan. Once a service purchase is initiated, it is assigned a Service Purchase ID in Pension Administration. A pension administrator initiates service purchase transactions in Pension Administration, and Integration Broker messages are sent to Receivables to do the following:
Create open invoices.
Request a refund.
Cancel a service purchase transaction.