Problem During The Validation Between The GL Account (Debit and Credit) And Chart Of Account (Doc ID 832610.1)

Last updated on DECEMBER 04, 2019

Applies to:

Goal

 In order to validate the GLIDs against COA_Id , users specify the parameter COA_Id in gl_id file.

Once users provide the value in the glid file and load the pin_glchartaccts and pin_glid its failing by giving the below error
        "Error validating gl accounts"
    
Scenario: Specify the Chart of Accounts (COA) Id in pin_glid file with the value that is be used
               to validate the gl accounts specified under a GL Id. Load the pin_glchartaccts file and load the
               pin_glid file
    
Input :
        pin_glchartaccts file
        gl_chartaccts (
                coa_id          1001
                coa_name        Primary COA
                gl_coa_acct     60000   monthly.A/R     asset           active
                gl_coa_acct     70000   cash            revenue         active
                gl_coa_acct     80000   Discount        expense         active
                gl_coa_acct     90000   Revenue_account revenue         active
        )
   
        pin_glid file
        COA_Id 1001
        glid (
                id              1000001
                descr           Purchase Fees
                gl_acct billed_earned           gross   60000   70000
                gl_acct billed_earned           disc    70000   60000
                gl_acct unbilled_earned         gross   60000   70000
                gl_acct unbilled_earned         disc    80000   60000
        )
    
Output:
        load_pin_glid: pcm_connection open
        load_pin_glid: transaction open
        Error validating gl accounts
        load_pin_glid: pcm_connection closed

Solution

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