R12:OIE:Credit Card Transactions loaded to incorrect Org when using the American Express Global Feed Transaction and Loader Validation Program (Doc ID 2159706.1)

Last updated on MARCH 07, 2023

Applies to:

Symptoms

On : 12.1.3 version,

ACTUAL BEHAVIOR
---------------

(i) Below is the setup done in the place 
- At Site level, the profile option 'mo:operating unit' is set to Jade CORPORATE
- At Site level, the profile 'mo:security profile' is set to 'RM Security SS'

(ii) 4 Card Programs are setup with the same 'Card Program Name = Corporate Card Program' in these 4 Operating Units
Operating Unit = Replacement Parts Division (RPD), org_id=83
Operating Unit = Jade Corporate (Corporate), org_id=87
Operating Unit = Air Conditioning Division (ACD), org_id=82
Operating Unit = Water Heater Division (WHD), org_id=84

There are two other Oper Units that will not be using Amex
Canada (org_id = 88)
Mexican (org_id = 89)


Operating Unit = Replacement Parts Division
Card Program Name = Corporate Card Program
Global Program Name = Corporate Card Program
Market Code = 001
Company Account Number = 77777

Operating Unit = Jade Corporate
Card Program Name = Corporate Card Program
Global Program Name = Corporate Card Program
Market Code = 001
Company Account Number = 77777

Operating Unit = Air Conditioning Division
Card Program Name = Corporate Card Program
Global Program Name = Corporate Card Program
Market Code = 001
Company Account Number = 77777

Operating Unit = Water Heater Division
Card Program Name = Corporate Card Program
Global Program Name = Corporate Card Program
Market Code = 001
Company Account Number = 77777


(iii) Run the American Express Global Feed Transaction and Loader Validation Program with
'Operating Unit = Canadian Operations'
'Card Program Name = Corporate Card Program'

** recall, Operating Unit = Canadian Operations (org_id=88) is not using Amex and has no Card Program setup...
'Card Program Name = Corporate Card Program' is setup in org_id=87 **

Problem: the credit card trxns got loaded with ap_credit_card_trxns_all.org_id = 83


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the American Express Global Feed Transaction and Loader Validation Program with 'Operating Unit = Canadian Operations' 'Card Program Name = Corporate Card Program'

BUSINESS IMPACT
-----------------------
Credit card trxns are loaded to incorrect org_id - therefore users can not properly expensed

Cause

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