It also depends on what kind of debugging messages are coded in those packages where the control enters and processes the code and then passes to the next level. S: Almost all the packages in Oracle Applications, has debugging messages enabled, however, there are exceptions, where packages may not have debugging enabled, hence, will not be shown in the debug file. This will be showing the package name where the error occurs. Check for the values which are being passed to this SQL and see the exception block of the script.
On analyzing further, you will mostly be able to find the value which is not getting passed or the wrong value being passed to this SQL and the reason for the error. Once this is identified, you have to check the Application Settings and modify it accordingly to have the correct value to be passed to the SQL to prevent it from erroring out. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. Post a Comment. Now Oracle Dollars is mobile friendly.
Double click any word to know its meaning from Answers. Subscribe to the blog to get the latest updates and the newer posts in your email. How to Debug Oracle Applications:. Download PDF. Now, this is a very interesting perspective. I hope, now you understood why renaming the media extracted folder to a very meaningful name is important. As usual Oracle suggests you the defaults, however I recommend you to follow a pattern that you can feel comfortable with.
As you could see, the default installation sets up one pdb. You may rename the default PDB at this level. Here I left everything to defaults as my intentions were pretty limited to installation. Unless you have a reason to set up Automatic Memory management, go ahead with the well trusted manual management, that gives you granular level control on how the memory is utilized by the database.
You may choose a different location for the database data files. Script for Creating user in oracle Apps R12 You can create user in oracle from front end directly, but user can be created only if you are having Sysadmin responsibility. What if you don't have Sysadmin responsibility. Newer Post Older Post Home. Search This Blog. Reasons for a sales order to get backordered. Reasons for a sales order to get Backordered Back Orders: The Oracle "term" backorder is a "status" on the order
0コメント