此内容已被标记为最终。 显示 6 条回复
SELECT account_rule_id,rule_value,RULE_VALUE_ID,SEGMENT_NUM,segment_name,RULE_TYPE,segment_value FROM PO_RULE_EXPENSE_ACCOUNTS_V
Hope this answers your question,
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.
No - there is no API.
What reply have you got from Oracle on this?