My Oracle Support Banner

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.

Symptoms

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
  (SELECT *
  FROM ozf_funds_utilized_all_b
  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;


Steps:
--------
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

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.