The APPLIED_TO_DISTRIBUTION_TYPE And APPLIED_TO_DIST_ID_NUM_1 are Null - Not Having Values - On XLA_DISTRIBUTION_LINKS
Last updated on APRIL 11, 2018
Applies to:Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.
Accrual Posting to General Ledger post upgrade to 12.2.6
The fields APPLIED_TO_DISTRIBUTION_TYPE and APPLIED_TO_DIST_ID_NUM_1 from table XLA_DISTRIBUTION_LINKS used to populate for the period end accruals.
They are no longer being populated.
Fields APPLIED_TO_DISTRIBUTION_TYPE and APPLIED_TO_DIST_ID_NUM_1 from table xla_distribution_links to be populated for all period end accruals.
The issue can be reproduced at will with the following steps:
1. Period End Process
2. Journal import
3. Journal posting
Run the "Receipt accruals period end" concurrent request, imported the resulting journals to GL and then posted them.
Data is missing - APPLIED_TO_DISTRIBUTION_TYPE and APPLIED_TO_DIST_ID_NUM_1 from table xla_distribution_links have no values.
Upgraded to 12.2.6
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms