I am working to create a transaction model that identifies the first time a natural (GL) account is used by a supplier in the last two years. I have the model logic down but I have an issue locating the business object that houses the GL account. I was able to find the “Payables Invoice Details.Line: Overlay Distribution” that houses the entire GL account string made up of the CompanyCode.LOBCode.LoactionCode.DepartmentCode.AccountCode.ProductCode (###.###.#####.####.#####.####) - the GL account is represented in the AccountCode of the GL account string.
I went to enable the following business objects for audit that resemble the unique part of the account string (Configure Business Object Attributes → Payables (Product) → Invoice → Invoice Lines):
- Overlay Account Segment
- Overlay Primary Balancing Segment
- Overlay Cost Center
After enabling the business objects for audit, I ran a Transaction Data Source Synchronization job that completed without errors. I created a model that shows the Overlay values enabled and established the values are blank in the “Payables Invoice Details” Model Object.
I ran my issue by AI and here is what it responded related to the overlay business objects:
- These are not parsed outputs of the final distribution account. They are input fields used only during the Payables Open Interface Import (e.g., FBDI) to override specific segments of an invoice's account coding. From Oracle's documentation: “You can use the Account Overlay feature to overwrite one or more account segments of a line expense or asset account... BALANCING_SEGMENT, COST_CENTER_SEGMENT, and ACCOUNT_SEGMENT will overlay any values in DIST_CODE_CONCATENATED.”
Is there any other way to build this model? I have tried looking at all of the Payables Model Objects to see if there is a unique field I can use to relate to any Journal Entry objects but did not find a unique ID that can be used across Payables and Journal Entry Model Objects.