Apps To Fusion

...
written by shravan , June 13, 2007

Hi Anil,
Can u provide sql scripts Related to All Financial Modules in OA

...
written by Parth , June 29, 2007

Hi Anil,
I am in need of Functional test Scripts (black box) in OM, AR and PO,INV,AP for to understand the basic script writing.

...
written by Anil , July 01, 2007

Hi Parth

FUT - Functional Unit Testing Scripts depend upon your business flow, as they are specific to your implementation.

Email me on passi dot anil @ gmail dot com

My friend is working on ON FUT scripts. I will try to get a sample copy from him and mail to you

Thanks,
Anil

...
written by BabuAM , July 08, 2007

Hi Anil,
I want some info reg the following, if possible, at earliest.
a) How to reduce/shorten the time taken from shipping of a order to autoinvoice. Actually there are walkin customers who cannot wait for 15-20 min. Is there anyway we can reduce the time so that the customer can justified. Is it a performance issue. Plz provide any scripts to find the system status.
b) Some of the invoices are splitting when coming from OM.
c) sometimes, in an order there are two lines, one is closing say on 3/7 and another gets closed on 31/7. how to change that.

Looking for ur mail, if any.

Thanks & regards,
Babu

...
written by Siva Ganesan , July 08, 2007

Hi Babu,

How to reduce/shorten the time taken from shipping of a order to autoinvoice. Actually there are walkin customers who cannot wait for 15-20 min. Is there anyway we can reduce the time so that the customer can justified. Is it a performance issue. Plz provide any scripts to find the system status.

Ans:While Doing the Shipping transactions, they might have enabled the Defer interface checkbox.
Uncheck this check box and schedule the WF Background Process to run every minute immediately after ship confirmed,
then the invoice will get generated in Receivables immediately.

If the Customer feels they have a performance issue, they can run a DB Trace with log level set to 12 and analyze the
performance

b) Some of the invoices are splitting when coming from OM.

Ans: This you have to check how the transactions are grouped using Autoinvoice Grouping rules set up in Receivables
Check meatlink for how Grouping rule works

c) sometimes, in an order there are two lines, one is closing say on 3/7 and another gets closed on 31/7. how to change that.

Ans: The Delivery of two lines might be different. The First line in the SO might have been
delivered on 3/7 and interfaced to Receivables Immediately whereas the next line might
have been either delivered are interface to Receivables only on 31/7

Thanks
Siva

...
written by venkadesh , July 11, 2007

I scheduled one SQL script in Oracle Apps .From that I am calling one Unix script. In that I am ftp one file to some other system.If there is no file means the SQL script should error out, but it's just exiting from unix script. Can you provide solution for it

...
written by AMBabu , August 12, 2007

Hi Siva,
I made 3 SubInv and each SI has 2 Rawmaterial SI and Finished Goods SI. The Raw SI consists of items Starting with name like RM1234 & PM1234(packing material) whereas all finished item goods start with FP----.
When I make transactions, there I change Org(101, 102,103) and do necessary.Here I have to select the necessary SI (either FG or RM).

What I want is that as & when I type FP, the necessary FG Sub Inv is to be defaulted and When I give RM/PM item number the necessary SubInv is to be defaulted.

How to do this.

Looking for ur guidance/mail on this issue.

Thanks & Regards,
A.M.Babu
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

...
written by AMBabu , August 12, 2007

Hi Siva,
Booked an order, the did necessary and ran the auto invoice. I am facing some issues.
1. I want the sales order number and invoice number & invoice number to be the same. This is very easy for customer.
2. I want all salesorders to be in serial (gapless, I have made). The sales order number is to come as the transcation number (invoice number). Is it possible. Kindly let me know the necessary steps for that.

Looking very eagerly for ur mail.

Thanks & Regards,
AM babu
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Custom Message not displaying when validated from Valueset Special
written by Ram Babu , October 05, 2007

Hi Anil,
Steps followed:
)From Message Form created message with language US, type ERROR, Message Text and submitted concurrent program Generate Messages.

2)Bounced Apache Server

3)Called this message through a valueset-type Special and event:validate with conditions.

4)Assigned this valueset to a concurrent program parameters to validate.

Issue is the Message Name is not calling the actual message text from message form, instead displaying Message Name at runtime.

eg: fnd_message.set_name('ONT','TEST_MSG');
fnd_message.raise_error;

Showing message TEST_MSG at runtime instead of actual message text.

please suggest how to overcome from the issue.

thanks,
Ram

Running Diagnostic Problem
written by RajuM , May 30, 2008

Hi Siva,

I am not able to see all the application in the application LOV when i go to Oracle Applications Manager -> Diagnostics -> Click on Launch Diagnostics Test Button. Do we need to have any privileges?

The document is very good Siva. I want to see Sales Order flow tables but when i see in the Application LOV i did not find Order Management application in that even po, ap, inv.....

Can you please guide me on this....

Thanks & Regards,
Raju M

...
written by Nomula , July 10, 2008

Explain or share about Shipping API's related to Order Management