Best Of
Re: How to select multiple rows in form request without any filter with range e.g. first 100 records etc
Have you tried using the Maximum Records setting in the form request? It's under "Form Request Options."
Re: Possible business scenarios in Order Management
Oracle has supported most of the business flows when it comes to order fulfillment
Case 1: Ur warehouse needs material and ur other location warehouse has sufficient material to ship it to you. Use IR/ISO process.
Case2: Ur warehouse needs material against demand like a Customer SO. Ur warehouse at other location has material. U can request other warehouse to fulfill the customer order. - Direct Ship Process. No receiving into warehouse which has the customer demand. Other warehouse ships product directly to Customer.
Case 3: None of ur warehouses has material. Ur supplier or Third Party Vendor has material. Create a Drop order order if u want to ship directly from supplier to customer.
Case 4: None of ur warehouses has material. Ur supplier or Third Party Vendor has material. U do not want ur supplier to know the customer details. Create a Back to Back Order. A PO gets created against ur SO to supplier. Receive the PO and ship the parts to customer.
Hope I covered most of the scenarios. If u have any other scenario, which is not covered, let me know.
Note: All these processes have certain limitations.
Regards,
N
655919
Address Book Record Search Type WARNING
Our users are getting this error message. Can someone please advise what to check.
Issues (click each label for more information):
| Address Book Record Search Type WARNING
 |
|
||||||||||
|
An error has occurred on a hidden field (that is, a field that you cannot view). Please contact your system administrator.
WARNING . . . The address number currently being inquired upon is not a 1. supplier, if the inquiry is being made through "Supplier Master Information". or 2. customer, if the inquiry is being made through "Customer Master Information". This is only a Warning, press Enter to continue. | ||||||||||||
|
||||||||||||
Re: SBC sending INVITE directly to endpoint instead of ECB
Hi Yyl,
This happens because you have "route-to-registrar=disabled" on that sip-interface where SBC receives the problematic INVITE. This is old good known problem. Can you enable it?
Regards,
Daureen
Re: Reading a text file using PL/SQL and storing data in table.
You can use UTL_TCP. Here are links to UTL_TCP based FTP package from Tim Hall:
Alternatilvely, you can create procedure/function with extproc or Java under the hood. You can also use external table with a preprocessor. Security risks should be carefully evaluated regardless of method used.
SY.
Re: Reading a text file using PL/SQL and storing data in table.
Hello Krishna,
«the text file is present in Oracle application tier and not in DB tier» Too bad!
You have to develope something on the client side to read the file. The server side can open and read files with UTL_FILE, but they must be in a DIRECTORY defined in the database and those directories point to server side…
Best regards,
Bruno Vroman.
Re: database resource utilization for a user
That won't be easy but in OEM for example you can just query the top queries and get a lot of details in the session context in which this query is running. That would include the database user running the query. It depends what you're really looking for.
Do you really want to show some figure showing this or that user has just somewhat more than the other,
or, are you looking for excessive usage, and you want to pinpoint which user (or users) that is ? In the latter case, you may be looking for what is stated above: top usage database sessions.
Other tools will very likely have this info as well, and it will be in some tables, but that won't be an easy query, I guess. Then again, there's many views in the database …
Mr. C
Re: database resource utilization for a user
Hi
Tracking per-user resource consumption (CPU, memory, I/O, etc.) is feasible and can be achieved using a combination of Oracle’s dynamic performance
views like gv$sesstat,gv$statname,gv$session etc .
You can also Generate AWR reports (awrrpti.sql for RAC) to get cluster-wide historical breakdowns by user, SQL, service, and more.
The section "Top Users by DB Time" summarizes per-user resource usage.
Thanks
Swati A
Re: eSupplier / Supplier Portal Setup Guide 9.2
This what I was thinking I believe….it was implementing Strategic Sourcing and not the overall Supplier Portal.