Can we directly insert expense account rules data to this table : PO_RULE_EXPENSE_ACCOUNTS. We are in R12 (12.1.1).
In R12 Purchasing, the *"Expense Account Rules"* is now a web based form. From front-end it is indeed a cumbersome task as for each Item_category rule you need to key in information in 2 windows and through Dataload s/w we are unable to populate these values as syetm open 2 differnt windows for entering 1 category. We have 400 categories (approx) and 13 operating units in which we want to include this expense a/c rules.
In 11i there is no such issues.
Could you please let us know what is the best way to define expense account rules in R12.
Hello S.P. Dash,
I have not done a direct insert into the po_rule_expense_accounts table. However, there are only 4 main fields (RULE_TYPE
I think it should be safe to do a direct table insert. You can double check by doing a trace and tkprof and then checking the inserts performed by Oracle when you save one rule.
Hope this helps,
Please let me know if there is any API through which we can handle this Purchasing expense a/c rule. We discussed the approach you suggested with our business community but they are bit reluctant to insert data through backend.
We have already created a SR with Oracle on this and the answer is still awaited.
Thanks again for your help.