Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Map 2 Source Amounts to Target for ARCS AP subledger

in Account Reconciliation

Summary:

In Oracle ARCS, AR subledger Integration Setup/ Import Format maps source " FUNCTIONALAMOUNTREMAINING " to target "Amount". This works for existing account 12101. But new account 12106 uses "CCY2AMOUNT", instead. Since Integration setup/Import format only allows one source to map to the target, how can I account for the 2 sources? Since current Data Load Mapping for AR SL includes 5 fields (Account, Data, Ledger, Legal Entity, Profile and Source Type) but not Amount, is it even possible to use #SQL to map both?

Content (please ensure you mask any confidential information):

I attempted these #SQL code on the Account line:

Amount =
CASE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!