My Oracle Support Banner

R11i/R12: AP: How to Manually Create Procurement Card Distributions when Create_Distribution_Flag=N (Doc ID 313688.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


This document is provided as a guide to assist customers who are looking for another method outside of the standard supported functionality to manually create distribution lines from procurement card transactions.  The application currently automatically creates the distribution lines from procurement card transactions via concurrent request : Procurement Card Validation Report (APXPCVAL).  This occurs because AP_EXPENSE_FEED_LINES_ALL is loaded with rows where create_distribution_flag=Y.  If create_distribution_flag=N, then the program APXPCVAL does not automatically create the associated distribution lines.

Having to manually create distribution lines maybe a business need at certain customer sites.  Currently, the applications does not fully support this method but with some manual manipulation the transactions and distributions can be loaded and viewable in the system using the following method.  Please note, until the Oracle Payables User's Guide is updated with supported steps, this is considered an optional method as opposed to standard method.  Optional meaning not supported as this is not expected behavior.

The standard method is to load transactions with create_distribution_flag=Y, run Pcard Validation Report to automatically create distributions into AP_EXPENSE_FEED_DISTS_ALL; then using the Transactions Distributions form to manipulate the distribution line.  Navigate Payables Manager > Credit Cards > Procurement Cards Trans > Click Distributions.


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.