This content has been marked as final. Show 8 replies
The screen is quite straightforward with just 4 fields to enter.1 person found this helpful
Try a key mapping software like Winparrot, Dataloader, Form loader etc.
Check http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/template-to-upload-data-through-dataloader-464744 for basic instructions.
Hope this helps,
With winparrot it is very easy you just have to record and insert :
-loop (with Goto(:XXX,1) function and XXX location)
-Read Excel data (with XlsReadData function)
-Chack (with IfImage() function, move/resize the red rectangle in order to check the status bar message after saving: "1 record...")
-Write your results in theExcel Spreadsheet (with XlsWriteData function)
See winparrot video on the official site (you have an example with sources for OEBS 11i and 12i)
Hope It helps
Dear Sandeep Gandhi:
Thank you for your reply.
You can check available api's atI have found the API, there is no standard API to insert into expense account rules directly, Can you tell me if I want to insert the record through TOAD or pl/sql Development, Which tables should I mention to , I mean which tables should I insert into?
Oracle Integration Repository Documentation Resources Release 12 (Doc ID 396116.1)
IREP - Oracle Integration Repository: The Tool To Find Which API Is Supported and How To Use It ... (Doc ID 554986.1)
You can insert into Oracle table, nevertheless it is not supported by Oracle.
Later if you face issues they will not be able to help you.
1 person found this helpful
if I want to insert the record through TOAD or pl/sql Development, Which tables should IThe main table for expense a/c rules is po_rule_expense_accounts. However, I don't know off the top of my head if you can do direct inserts into this table
Thank you for your reply, po_rule_expense_accounts_v can help me to know more about the rules. I will add the rule by patch,for example 1000 rows through the po_rule_expense_accounts_v view and try if it can be work.
As per ID 1075850.1:
There is no Standard API or an interface available to upload the Expense Account Rules in Purchasing. These have to be created manually.