My Oracle Support Banner

Why Does PATTAR Invert the Quantity and Unit Selling Price in Receivables? (Doc ID 2010968.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Project Billing - Version and later
Information in this document applies to any platform.
Flow of data:
Issue manual deliverables from OKE / DELIVERABLES BASED BILLING with a certain quantity and unit price.
Interface the invoice to Receivables.
The Receivables tables have inverted quantity and unit price.

The code of "PRC: Interface Invoices to Receivables" is inserting the values of unit selling price & Quantity from below queries.

SELECT DECODE(SIGN(ITEM.Inv_Amount),(-1),(-ITEM.Inv_Amount),ITEM.Inv_Amount) "Unit Selling Price",
DECODE(SIGN(ITEM.Inv_Amount),(-1),(-1),1) "Quantity"
FROM PA_Draft_Invoice_Items ITEM WHERE PROJECT_ID = 1122162;

(This code is found in the file patopt.lpc.)


 The Quantity and Unit Price should be same.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.