Oracle EBS – Purchasing / Inventory – Receiving Reports and Processes


The following are the reports and processes within the Receiving application. An explanation of each report or process follows.

REPORTS

POXDLPDT – Receipt Traveler
POXRVRUR – Unordered Receipts Report
POXRVRSR – Substitute Receipts Report
RCVIERR – Receiving Interface Errors Report
POXRVRTN – Receipt Adjustments Report
RCVTXRTR – Receiving Transactions Register
POXRVXRV – Expected Receipts Report
POXRVRER – Receiving Exceptions Report
POXRVOVS – Overshipments Report
POXPORRA – Uninvoiced Receipt report
POXRRVDR – Receiving Account Distribution report
POXACREC – Accrual Reconciliation report
POXACWRO – Accrual Write-off form and report
POXRRCVV – Receiving Value Report
POXRVRVD – Receiving Value Report by Destination Account

PROCESSES

PORCPTWF – Confirm Receipts Workflow Select Orders Process
POXPOIV – Payment on Receipt
RCVDLPDT – Receipt Traveler
RVCTP or RTP – Receiving Transaction Processor
RVCACR – Receipt Accruals – Period-End Process

 

POXDLPDT – Receipt Traveler
The Receipt Traveler facilitates receiving inspection and delivery of goods you receive within your organization. After you receive the goods, you can print receipt travelers and attach these tickets to the goods. You can enter selection criteria to specify the receipt travelers you want to print. One receipt traveler prints per distribution, and each traveler has space for you to record delivery comments.

If the RCV: Print Receipt Traveler profile option is set to Yes, the receipt traveler automatically prints when you perform a receipt or a receiving transaction and using Online or Immediate processing mode, and when you match unordered receipts

POXRVRUR – Unordered Receipts Report
The Unordered Receipts Report lists all or selected unordered receipts. Unordered receipts refer to received items that receivers could not match to purchase orders or return material authorizations (RMAs). You can enter unordered receipt transactions only if you set up your system options accordingly. Purchasing lets you specify which unordered receipts you want to review.

POXRVRSR – Substitute Receipts Report
The Substitute Receipts Report lists all or specific substitute receipts. To prevent disruption in your receiving process, Purchasing lets you receive items which a supplier has delivered as a substitute for the ordered item. You need to predefine the items you accept as substitute for other items.

The report includes sourcing information appropriate for the source type. For the Inventory source type, this is the organization and subinventory. For the Supplier source type, this is the supplier and supplier site.

RCVIERR – Receiving Interface Errors Report
This report shows you what warnings or errors occurred while the Receiving Transaction Processor was processing rows in the Receiving Open Interface tables. Rows processed in the Receiving Open Interface include Advance Shipment Notices (ASNs), receipts, and deliveries. Any errors that occur during this process are displayed in the Receiving Interface Errors report when you run the report. At the same time, the errors are also sent to the Oracle e–Commerce Gateway process responsible for generating Application Advices. (For example, Application Advices are sent back to suppliers detailing errors that occurred when the suppliers sent ASNs.)

POXRVRTN – Receipt Adjustments Report
The Receipt Adjustments Report lists purchase order shipments, internal requisition lines, or return material authorization (RMA) lines with corrections or returns to supplier (or customer).

RCVTXRTR – Receiving Transactions Register
The Receiving Transactions Register lists detail information about your receiving transactions. The register is sorted by item, category, receipt number, document number, and transaction date. The three–part document number represents purchase order number, purchase order line number, and purchase order shipment number. For receiving transactions created against customer returns, the two–part document number represents the return material authorization (RMA) number and RMA line number.

POXRVXRV – Expected Receipts Report
The Expected Receipts Report can be used to review all or specific supplier sourced expected receipts or expected customer returns that have not yet been received for a particular date or a range of dates. The report excludes purchase orders that are cancelled, closed, or closed for receiving at the header, release, line, or shipment level. You can specify the expected receipts you want to review.

POXRVRER – Receiving Exceptions Report
Use the Receiving Exceptions Report to review receipts for which there is a receipt exception. These receipts cannot be automatically closed for receiving or invoicing. You can enter a receipt exception when you receive the item.

POXRVOVS – Overshipments Report
The Overshipments Report lists purchase order receipts with a quantity received greater than the quantity ordered. You can also use the Overshipments Report to identify service overcharges or suppliers who deliver more than the requested quantity.

POXPORRA – Uninvoiced Receipt report
The Uninvoiced Receipts Report should be run before the Receipt Accrual – Period–End process. With this report, you can review all or specific uninvoiced receipts for both period end and online accruals. Uninvoiced receipts are goods and services you have received that your supplier did not invoice yet. This report indicates exactly what you have to accrue and for what amount, and helps you analyze your receipt accrual entries. The accrual amount is the difference between the quantity received and the quantity billed multiplied by the unit price of the item

POXRRVDR – Receiving Account Distribution report
The Receiving Account Distribution Report lists the accounting distributions for your receiving transactions. This report supports the distributions created for the following transactions:
– Purchase Order Receipts
– Purchase Order Receipt Adjustments
– Purchase Order Returns to Supplier
– Deliver to Expense Destinations
– Return to Receiving from Expense Destinations
– Match Unordered Receipts
This feature helps you reconcile your receiving accounting to your general ledger.

POXACREC – Accrual Reconciliation report
The Accrual Reconciliation Report can be used to analyze the balance of the Accounts Payable (A/P) accrual accounts. You can accrue both expense and inventory purchases as you receive them. When this happens, you temporarily record an accounts payable liability to your Expense or Inventory A/P accrual accounts. When Payables creates the accounting for the matched and approved invoice, Payables clears the A/P accrual accounts and records the liability from the supplier site.

This report is available in two versions: Accrual Reconciliation Report and Accrual Rebuild Reconciliation Report. When you specify Accrual Rebuild Reconciliation Report, the report selects the accounting entries from the appropriate source (sub ledgers). This accounting information resides in a temporary table and remains until you rebuild this information again. When you specify Accrual Reconciliation Report, the report does not reselect this information. Instead, it merely reports using the pre–existing information. This feature saves you time, because you do not have to recreate the accrual information every time you submit a report. Typically, you specify the Accrual Rebuild Reconciliation Report at month end and use the Accrual Reconciliation Report for interim reports. Note that the title of the report remains the Accrual Reconciliation Report even if you specify the rebuild option.

After you have entered your receipt transactions and matched your invoices, you can run the report for any transaction date range and identify any differences between your PO Receipts and A/P Invoices. This report also displays any miscellaneous transactions recorded in error to your accrual accounts. These miscellaneous transactions or transactions unrelated to purchase order receipts may be from Payables, Inventory, or Work in Process (depending on your installation). After you have researched the reported accrual balances, you can use the Accrual Write–Offs window to indicate which entries you wish to remove and write off from this report. And, after you have written off these entries, you can use the Accrual Write–Off Report as supporting detail for your manual journal entry.

The Accrual Reconciliation Report helps you monitor potential problems with purchasing and receiving activities that can affect the accuracy of your A/P accrual accounts. You can review this report to identify the following problems in receiving, purchasing, inventory, work in process, or accounts payable transactions:
• Quantities differ between receipts and invoices
• Discrepancies in supplier billing
• Accounts payable matched invoice to wrong purchase order or purchase order line, or the wrong receipt or receipt line
• Receiving clerk received against the wrong purchase order or wrong purchase order line
• Miscellaneous inventory or work in process transactions that do not belong to the accrual accounts
• Payables entries for sales tax and freight that do not belong to the accrual accounts.

If you use Inventory, this report automatically reconciles your activity for all inventory organizations. If you use Work in Process for outside processing receipts, this report also reconciles all work in process activity for all organizations.

In addition, the Accrual Reconciliation Report supports multiple A/P accrual accounts. In this case, the report groups information by each account. When you define your purchase order requisitions or orders, the Account Generator processes create your A/P accrual accounts. Typically, you use only one A/P accrual account for all of your inventory organizations. However, for certain situations you may want to use more.

POXACWRO – Accrual Write-off form and report
The Accrual Write–Off Report to provide supporting detail for your write–off journal entries. The process is as follows. First, you analyze the Accrual Reconciliation Report for transactions that you should expense out of the accrual accounts. After you have researched the reported accrual balances, you then use the Accrual Write–Off window to indicate which entries you wish to remove and write off from this report. And, after you have written off these entries, you use the Accrual Write–Off Report as supporting detail for your manual journal entry.

POXRRCVV – Receiving Value Report
The Receiving Value Report shows item quantity, valuation, and detailed receipt information for your receiving inspection location.

POXRVRVD – Receiving Value Report by Destination Account
The Receiving Value Report by Destination Account lists received items by purchase order destination and distribution account. If you accrue both inventory and expense at the time of receipt, you may have both inventory and expense as part of your receiving valuation account. The Receiving Value Report by Destination Account allocates your receiving balances by the purchase order line inventory, expense accounts, and quantities. You can then use this report to manually re class the receiving valuation account to the appropriate expense accounts.

 

PROCESS DEFINITIONS

PORCPTWF – Confirm Receipts Workflow Select Orders Process
The Self–Service Purchasing Confirm Receipts Workflow Select Orders process in Purchasing must be running in order to use the Confirm Receipts workflow. The Confirm Receipts workflow sends notifications through the Web, e–mail, or Notification Details Web page (accessible through the Notifications Summary menu in Purchasing) to requester or buyers who create requisitions in Purchasing or iProcurement. It lets people know they should have received an item.

The Confirm Receipts workflow sends notifications for items with a Destination or Deliver–To Type of Expense, a Routing of Direct Delivery, and a Need–By date that is equal to or later than today’s date.

POXPOIV – Payment on Receipt
Payment on Receipt enables you to automatically create standard, unapproved invoices for payment of goods based on receipt transactions. Invoices are created using a combination of receipt and
purchase order information, eliminating duplicate manual data entry and ensuring accurate and timely data processing. Payment on Receipt is also known as Evaluated Receipt Settlement (ERS) and Self Billing. You can automatically create invoices with multiple items and distribution lines, and include tax. You define which supplier sites participate in Payment on Receipt and enforce matching rules to ensure the proper payments are made to the suppliers.

The Pay on Receipt Auto Invoice program automatically creates an invoice batch depending on the options in the Payables Options window. Invoice count and invoice total are calculated automatically.

RVCTP or RTP – Receiving Transaction Processor
Use the Receiving Transaction Processor to process your pending or unprocessed receiving transactions. How the Receiving Transaction Processor handles these transactions depends on the processing mode, which is a profile option that you can set at the site, application, responsibility, and user levels.

You can set Standard Report Submission parameters to run the Receiving Transaction Processor at specified intervals so that your pending transactions are processed as often as required.

RVCACR – Receipt Accruals – Period-End Process
Use the Receipt Accruals – Period–End process to create period–end accruals for your uninvoiced receipts for Expense distributions. Purchasing creates an accrual journal entry in your general ledger for each uninvoiced receipt you choose using this form

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s