My Oracle Support Banner

R12: PA: Need Script To Delete Old Exceptions From Transaction Exception Details Report (Doc ID 2455999.1)

Last updated on MARCH 13, 2020

Applies to:

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


The following invoices from 2016/2017 are appearing on the report output for EXC: Transaction Exception Details by PA Period

These need to be removed from appearing on the report.

Invoice Number       Inv Date           Number          Supplier Name       Inv Line         Dist Line    Payment Num        Check Num Posted         Project       Task
--------------           ---------            -------------    ---------------         ---------         ----------   -------------           ------------- ------           ----------     ----------
131902490            24-OCT-16        150009899     ABC USA INC          1                  1                                                          *                 1000540     4.D
131902490            24-OCT-16        150009899     ABC USA INC          1                  2                                                          *                 1000540     4.D
PR976.1                13-JUN-17         150009910     XYZ INC                 1                  2                                                          *                 1005039     1.H
PR976.1                13-JUN-17          150009910    XYZ INC                 1                  4                                                          *                 1005039    1.H

NOTE: In the sample above, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.




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

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