<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Contributors arrow Siva's Knowledge Village arrow Usage of Diagnostic Scripts and Tools in Oracle Applications
This website has now moved to http://apps2fusion.com





Usage of Diagnostic Scripts and Tools in Oracle Applications | Print |  E-mail
Written by Sivakumar Ganesan   
Monday, 04 June 2007
Sivakumar Ganesan needs no introduction, when in Oracle, he was driving the effort of using this HTML based diagnostic scripts rather than the text scripts likeinv _info_115.sql, Rec_info_115.sql etc., and he helped increase the usage of these diagnostics scripts internally within Oracle from 15% to 68% in six months time in oracle and was involved in providing inputs to Script development team the changes required in the Diagnostic Scripts and new scripts development efforts. Please find a document written by him on Diagnostic Scripts.

These techniques provide you with easy and effective way to understand the Data flow model in Oracle applications in any module, including the set up & diagnostics


Click Here for link to Document for Usage of Diagnostic Scripts and Tools in Oracle Applications

Comments (9)add
...
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
ambabu2006@gmail.com
...
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
ambabu2006@gmail.com

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
You must be logged in to a comment. Please register if you do not have an account yet.

busy