How to find SubLedger accounting package being used for custom or standard subledger accounting engine

Use following query to find the accounting package is being used

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
SELECT
    *
FROM
    all_objects
WHERE
    object_name IN (SELECT 'XLA_'|| lpad(application_id,5,0)
             || '_AAD_'
             || product_rule_type_code
             || '_'
             || lpad(product_rule_hash_id,6,0)
             || '_PKG'
        FROM
            xla.xla_product_rules_b
        WHERE
            ( application_id,product_rule_type_code,product_rule_code,amb_context_code ) IN (
                SELECT
                    application_id,
                    product_rule_type_code,
                    product_rule_code,
                    amb_context_code
                FROM
                    xla.xla_acctg_method_rules
--where acctg_method_rule_id = :l_acctg_method_rule_id
            )
    );

acctg_method_rule_id can be obtain from XLA_ACCTG_METHOD_RULES table where you can find STANDARD_ACCRUAL and STANDARD_CASH and all custom sub ledger methods.

Thanks Yogesh

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s