Thursday, August 30, 2018

GROUP_ID in GL (Oracle APPS)

The GROUP_ID distinguishes import data within a particular source, i.e. Oracle Receivables, Payables and other Sub Ledgers. This allows you to choose a Selection Criteria:

1. No Group ID: Will select lines with the group id not populated (null)
2. All Group IDs: Will select all lines from the specified source with the group id populated (not null)
3. Specific Group ID: Will select lines with that specific group id

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...