Sivakumar Ganesan

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

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

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:Wh ile Doing the Shipping transactions, they might have enabled the Defer interface checkbox.
Unche ck 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.

I f 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
Che ck 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

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.Ba bu
ambabu2006gmail.com

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','TE ST_MSG');
fnd_message.ra ise_error;

Showing message TEST_MSG at runtime instead of actual message text.

please suggest how to overcome from the issue.

thanks,
Ram

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