|
|
|
|
| Re: API to create/update data in ra_territories table [message #212460 is a reply to message #211763] |
Fri, 05 January 2007 07:03   |
sokmen
Messages: 6
Registered: October 2006
Location: Turkey
|
Junior Member |
|
|
|
I did not try but I think you can try inserting the data you want by a simple sql. I don't think that table has a data relation with other tables. Probably the relation is created by TERRITORY_ID. You can get new TERRITORY_ID by RA_TERRITORIES_S sequence. Fill SYSDATE into default date columns, and -1 into CREATED_BY and LAST_UPDATED_BY columns.
|
|
|
|
|
|
| Re: API to create/update data in ra_territories table [message #212505 is a reply to message #212499] |
Fri, 05 January 2007 10:41 |
sokmen
Messages: 6
Registered: October 2006
Location: Turkey
|
Junior Member |
|
|
I know that updating or inserting is not recommended in base tables but if you review some of the APIs, you can just see inserting statement. Most of the APIs are handling many exceptions, but most of them are very simple too.
There is another way. If there is a standard form that creates territory data, you can download and examine the fmb file. Probably you can find the way (insert code, API call, etc..) inserting territory data on Save button for example. If there is a simple inserting code, you can use sql query to create your data. I am sure, you can insert your data with a sql query.
The other way is to search "RA_TERRITORIES" word in ALL_SOURCES and try to find an API that calls inserts to RA_TERRITORIES table.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
