My Oracle Support Banner

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

Last updated on NOVEMBER 18, 2022

Applies to:

Oracle Project Billing - Version 11.5.10.2 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.)

Goal

 The Quantity and Unit Price should be same.

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.