1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Financials GL Trial Balance Report Unbalanced

Discussion in 'Oracle Financials' started by lakshmiswetha, Nov 14, 2011.

  1. lakshmiswetha

    lakshmiswetha Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    In GL for the trail balance report i am getting imbalance amounts. Some amount is carry forwarding from 3 months onward as a opening balance how can i find the transactions related to the imbalanced amount in gl? IN clear the trail balance opening and closing balance should be zero but some amount is carry forwarded from some periods what are the transactions related to that balance and how can i find that transactions. pls help
     
  2. tejach.apps

    tejach.apps Active Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Hyderabad
    Re: oracle

    Hi Lakshmi,

    From the explanition given by you we could able to understand that there is a need to do some Accounting adjustment for the account which being carry forward. If possiable send us the detaild Mail of ur explination and the Trail Balance and any other document which u feel will help us in investigating in to this issue. Mails us at Krishnateja.apps@gmail.com.

    Regards,
    Sri Krishna Teja.
     
  3. lesalazar

    lesalazar Guest

    Re: oracle

    Hi
    Please chech if you have security rules, remember that the standar report does not show the combinations in the trial balance report. try to inactivate the rules a nd run the trial balance again.

    If that doesn't work i have a script that do a datafix but is for release 11

    Code (SQL):
    DECLARE
    CURSOR C_DATA IS
    SELECT B.CODE_COMBINATION_ID,
           B.SET_OF_BOOKS_ID,
           B.CURRENCY_CODE,
           NVL(B.BEGIN_BALANCE_DR,0) BEGIN_BALANCE_DR,
           NVL(B.BEGIN_BALANCE_CR,0) BEGIN_BALANCE_CR,
           NVL(B.PERIOD_NET_DR,0)    PERIOD_NET_DR,
           NVL(B.PERIOD_NET_CR,0)    PERIOD_NET_CR,
           ((B.BEGIN_BALANCE_DR - B.BEGIN_BALANCE_CR) + (B.PERIOD_NET_DR - B.PERIOD_NET_CR)) SALDO
      FROM APPS.GL_BALANCES B,
           APPS.GL_CODE_COMBINATIONS K
     WHERE B.SET_OF_BOOKS_ID = 216  --+ YOUR BOOK
       AND B.PERIOD_NAME = 'SEP-10' --+ YOUR PRIOR PERIOD
       AND B.ACTUAL_FLAG = 'A'
       AND B.CODE_COMBINATION_ID = K.CODE_COMBINATION_ID
       AND K.SEGMENT1 != 'T'
       AND K.SEGMENT2 != 'T'
       AND K.SEGMENT3 != 'T'
       AND K.SEGMENT4 != 'T'
       AND K.SEGMENT5 != 'T'
       AND K.SEGMENT6 != 'T'
       AND K.SEGMENT7 != 'T'
       AND K.SEGMENT8 != 'T'
       AND K.SEGMENT9 != 'T';
    --+
    CURSOR C_FIX(COMB_ID NUMBER, MONEDA VARCHAR2) IS
    SELECT B.CODE_COMBINATION_ID,
           B.PERIOD_NAME,
           NVL(B.BEGIN_BALANCE_DR,0) BEGIN_BALANCE_DR,
           NVL(B.BEGIN_BALANCE_CR,0) BEGIN_BALANCE_CR,
           NVL(B.PERIOD_NET_DR,0)    PERIOD_NET_DR,
           NVL(B.PERIOD_NET_CR,0)    PERIOD_NET_CR,
           ((B.BEGIN_BALANCE_DR - B.BEGIN_BALANCE_CR) + (B.PERIOD_NET_DR - B.PERIOD_NET_CR)) SALDO
      FROM APPS.GL_BALANCES B
     WHERE B.SET_OF_BOOKS_ID = 216 --+ YOUR BOOK
       AND B.PERIOD_NAME = 'OCT-10'--+ YOUR NEXT PERIOD
       AND B.CODE_COMBINATION_ID = COMB_ID
       AND B.ACTUAL_FLAG = 'A'
       AND B.CURRENCY_CODE = MONEDA;
    --+
    BEGIN
       FOR V IN C_DATA
       LOOP
           FOR K IN C_FIX(V.CODE_COMBINATION_ID, V.CURRENCY_CODE)
           LOOP
               --+ VALIDA LOS SALDOS
               IF (V.BEGIN_BALANCE_DR + V.PERIOD_NET_DR) != K.BEGIN_BALANCE_DR OR
                  (V.BEGIN_BALANCE_CR + V.PERIOD_NET_CR) != K.BEGIN_BALANCE_CR THEN
                   --+
                   UPDATE GL_BALANCES
                      SET BEGIN_BALANCE_DR = (V.BEGIN_BALANCE_DR + V.PERIOD_NET_DR),
                          BEGIN_BALANCE_CR = (V.BEGIN_BALANCE_CR + V.PERIOD_NET_CR)
                    WHERE SET_OF_BOOKS_ID = V.SET_OF_BOOKS_ID
                      AND CODE_COMBINATION_ID = V.CODE_COMBINATION_ID
                      AND ACTUAL_FLAG = 'A'
                      AND PERIOD_NAME = K.PERIOD_NAME
                      AND CURRENCY_CODE = V.CURRENCY_CODE;
               END IF;
           END LOOP;
       END LOOP;
       --+
       COMMIT;
    END;
    /
     
    Sadik likes this.