R12: OIE: The Create Credit Card Issuer Invoice Program is not Selecting a Credit Card Transaction that has No Billed Date (Doc ID 2083671.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

An adjustment credit card transaction is received in the Mastercard credit card file. Note, in the Mastercard file, there is no value for billed date (or billing date) for the adjustment credit card transaction. Submit the Mastercard CDF3 Load and Validate program to load the Mastercard credit card file.  The adjustment credit card transaction is successfully loaded and validated. In the table ap_credit_card_trxns_all, the field billed_date is populated with the adjustment transaction's transaction date. 

Submit the Create Credit Card Issuer Invoice program to create invoice payable to Credit Card Supplier. The Create Credit Card Issuer Invoice program uses 'billed from' / 'billed to' as a parameter. So, the adjustment credit card transaction may not be selected. If the true billing date of the adjustment credit card transaction does not fall within the date range specified (because the transaction date is being used), then the adjustment would not be included  on the invoice payable to the Credit Card Supplier.


EXPECTED BEHAVIOR:  Expect that the adjustment credit card transaction should get populated with their billed date and not their transaction date. Then, the adjustment credit card transaction would get included on invoice payable to the Credit Card Supplier.



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