Receivables - EBS (MOSC)

MOSC Banner

Query to identify the Product Rule for Receivables in XLA tables


Im trying to figure out the SLAM for Receivable application is configured as MF or not ?

Will the product_rule_code column in below query help me identity if the system is configured as MF or NOT ?

Thanks,

SELECT DISTINCT gl.ledger_id, slam.accounting_method_code, slam.product_rule_code, slam.start_date_active, slam.end_date_active

FROM gl_ledgers gl, 

xla_acctg_method_rules slam 

WHERE gl.sla_accounting_method_code = slam.accounting_method_code AND slam.application_id = 222;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center