Utilizations Are Missing In XLA_ACCRUALS And Not Accounted In General Ledger (GL)
(Doc ID 2797501.1)
Last updated on SEPTEMBER 22, 2021
Applies to:Oracle Trade Management - Version 12.2.5 and later
Information in this document applies to any platform.
Trade Management > Budget Adjustment on Offer,
After creating an offer decrease earned adjustment and in table OZF_FUNDS_UTILIZED_ALL_B the utilization record has GL_POSTED_FLAG as "Y". Ran SubLedger Accounting and not final accounted in General ledger . This effecting the reconciliation of accrual balance in General Ledger (GL).
Utilization with GL_Posted_flag is "Y" not found in the Sub ledger accruals (XLA_AACCRUALS) and not final accounted in General ledger. This effecting the reconciliation of accrual balance in GL.
SELECT * FROM
WHERE utilization_id NOT IN
(SELECT DISTINCT utilization_id FROM ozf_xla_accruals)
AND gl_posted_flag = 'Y'
ORDER BY creation_date DESC)
WHERE ROWNUM <= 10000;
1. Nav: Oracle Trade Management User > Budgets
2. Select the Budget for adjustment
3. From the Budget checkbook, create adjustment to decrease earned amount
4. Nav: Oracle Trade Management Administrator responsibility > concurrent program
5. Run Sub-LEdger Accounting program
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document