Best Of
Re: I want to un-remit receipts; user wrongly remitted in wrong bank account... there are total of 5200
Hello,
If the funds were collected for those receipts then a data fix to change status back to Confirm will not work.
You need to reverse the receipts and create them again.
Regards,
Nanzy
Re: I want to un-remit receipts; user wrongly remitted in wrong bank account... there are total of 5200
Hi
We can move them to Confirmed via datafix.
There is a script available : AR_DFS_RCT_RMT_TO_CONF.sql
You can refer to Note 2873187.1
Run the sql provided in the Note and see if same rows are returning.
Best Regards,
Bharat
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
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.




