My Oracle Support Banner

R12: AP: How to Get Card_Id for a Card Number in Pcard? (Doc ID 1377485.1)

Last updated on APRIL 04, 2025

Applies to:

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

Goal

Uploaded data into the AP_EXPENSE_FEED_LINES_ALL and ran Procurement Card Transactions Validation Program.

When processing the Procurement Card Transaction Validation Report getting:

Exception Reason: Invalid Card ID is raised.

Seems that the error is caused by the missing CARD_ID, but don't know where to get it from, based on a CARD_NUMBER.

The CARD_NUMBER FIELD in the AP_CARDS_ALL is NULL for all records.

How to get the card_id for a card number?


Solution

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
Goal
Solution


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