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
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.
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
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
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.
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.
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.
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.....
Apps2Fusion are passionate about Fusion Cloud E-Learning and classroom trainings. Training is our core business and we have been doing this for many many years. We work hard to advise trainees with right career paths. We have published various five star rated Oracle Press Books each was best sellers in its category. We have helped many and could help you as well.
Comments
Can u provide sql scripts Related to All Financial Modules in OA
I am in need of Functional test Scripts (black box) in OM, AR and PO,INV,AP for to understand the basic script writing.
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
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
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
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
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
ambabu2006gmail.com
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
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?
Th e 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....
Thank s & Regards,
Raju M
RSS feed for comments to this post