Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Integration Fields from Subledger (XLA_AE_LINES) to General Ledger (GL_JE_LINES) — Cloud Customer Connect
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

Integration Fields from Subledger (XLA_AE_LINES) to General Ledger (GL_JE_LINES)

Question
12
Views
0
Comments

Description (Required):

Need to send about 10 fields listed below from Subledgers (AP/Project Costing/AR/FA/Receiving) to General Ledgers through delivered integration and we need to use the same columns mapping (10 individual columns) for Accruals and Manual Journals (Allocations & Intercompany) while loaded through FBDI/ADFDi or Manual entry in GL. So we can report the total amounts based on these columns in various reports in GL. Ex: if we are sending the "Location" in Attribute1 in XLA_AE_LINES then we need the same column in GL_JE_LINES Attribute1.


We have checked the Header/Line Description rule in SLA however, they get send to GL in Line description however the values are concatenated which we do not want, it will end up substring/in-string function to decode the values also, we have validate the Recon Reference even this will not work since it can store only one value/column, We have checked DFFs on one of the oracle note it was said the DFFs from Subledgers does not get transferred to General Ledger.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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