Discounted Invoices Errors In Exception Reports As Not Transferring To PA (Doc ID 1589441.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Purchase to Pay Flow

When attempting to interface Discounted Supplier invoices via PRC: Interface Supplier Costs process, no errors and no transactions picked up.

However, the the Transaction Exception Report, the following error occurs:

ERROR
-----------------------
Exception Reason : The new invoice line is not interfaced to Oracle Projects.

Corrective Action : Please run the PRC: Interface Supplier Costs concurrent program


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Navigate via Payables Manager, navigate to Payments- query payment, select Actions and 'Void' payment.

These are upgraded invoices, with upgraded payments.  When user voided the payments on these invoices, in AP they are able to successfully account for the void no issue - so in AP, these invoices are whole - validated and accounted perfectly.  The issue is on the Projects side after they try to invoice to PA...see exception details that are uploaded.  It seems this is a 'data corruption' type issue because user cannot replicate this for NEWLY created transactions in R12.

In summary:

The AP functional group was voiding these upgraded payments and they were unable to fully account for them (i.e. payment workbench shows the accounting status as "partial"). They are reported as exceptions when they run EXC: Transaction Exception Details by GL Period” and “EXC: Transaction Exception Details by PA Period” .  Running “PRC: Interface Supplier Costs” (per the Corrective Action) does not fix these exceptions, and the output report for the “AUD: Supplier Costs Interface Audit” does not show these as exceptions.
 

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