Voucher Build Created Voucher In Recycle Status When SPro Invoice For Progress Logs

(Doc ID 2347267.1)

Last updated on JANUARY 10, 2018

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Progress Log - Create

Voucher Build Created Voucher in Recycle Status When sPro Invoice Has Distribution Lines Where the Percentage Does Not Sum to 100. Voucher build

error:Invoice line Merchandise Amount nnn.nn <> sum of Distrib Line amounts nnn.n.

This is occurring only for Progress Logs


 
REPLICATION STEPS
=================
 
1) Create a wO with time reporting option:Percent allocation and multiple
distribution lines expense lines and labour lines
2)Submit,approve WO
3)Create and dispatch PO
5)Create PLOG for the work order (this PLOG should be distributed based on percentage allocation in the work order LBR distribution)
6)Create invoice, approve invoice
8)Run export to payables process
9)Run Voucher build process.

The invoice/ voucher created for the PLOG goes to Recycle status as the distribution amount and the line amounts in the vouchers dont match.

This is because of incorrect coding in SPF_TO_AP.DISTLINEGBLdefault 1900-01-01.CALCAMT.OnExecute

In this code, only the first expense line's distribution is taken into consideration when calculating the LBR percentage.


The issue can be reproduced at will with the following steps:
1) Create a wO with time reporting option:Percent allocation and multiple distribution lines expense lines and labor lines
2)Submit,approve WO
3)Create and dispatch PO
5)Create PLOG for the work order (this PLOG should be distributed based on percentage allocation in the work order LBR distribution)
6)Create invoice, approve invoice
8)Run export to payable process
9)Run Voucher build process.
10)Voucher will be created with errors.


Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms