Sla Rules Not Returning Expected Results (Doc ID 1438023.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Goal

Qn1:
The Product Line Accounting process is not reading from the Category Account assignment. We have created and assigned the Product Line Category set and setup the corresponding category accounts. We have also performed all the required SLA setups. The process works if I set the Account Derivation Rules to use a constant value. It does not work when the Account Derivation Rules are set as follows: ‘Value Type’ is ‘Source’; ‘ Value’ is set to ‘Product Line Accounting Category Material Account’ and ‘Segment’ is ‘Cost Center’. How can this be resolved?


Qn2:
I am not %100 sure that all transactions eligible to be passed to GL are being passed. I am looking at the 'mtl_material_transactions' table as this is the source of most of the transactions being passed to GL. I would expect each record to be populated with a 'request_id ' once create accounting has processed. Is this the most accurate way to determine if all eligible transactions are transferred from the sub-ledger to GL by the create accounting programs?

Solution

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