My Oracle Support Banner

Mass Additions table has "Invoice Distribution id" Missing in the Interface Invoice Price Variance to FA Process for OAT Invoices (Doc ID 1573140.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Asset Tracking - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version

Requirement to populate the "Invoice Distribution Id" in the Mass Additions table for IPV transfer to FA.
This will greatly help in reconciliation of AP to FA for all of OAT.  Users do not have a way to plug it in through STUB or other means.

 "Invoice Distribution id" to be included in the interface invoice price variance to FA process for OAT invoices.

The issue can be reproduced at will with the following steps:
1. Create an invoice for OAT PO and interface the tax/freight to FA.
2. Requesting that the invoice distribution id be populated in fa mass additions as part of this transfer.
3. The invoice distribution id can be self assessed tax or regular distributions. Since user will have invoice number and invoice dist id, it can linked back to AP.

The issue has the following business impact:
Due to this issue, users are unable to reconcile differences between AP and FA.

It becomes very difficult to reconcile AP and FA since there is no clean link between the invoice distribution that is transferred from AP to FA for OAT.


To view full details, 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 a vibrant support community of peers and Oracle experts.