Change Default APPS password

on Sunday, March 8, 2009

1. Shutdown concurrent manager

2. Logon as sysadmin

3. Goto sysadmin-->security-->Oracle-->Register

4. Query for APP%

5. Change the APPLSY & APPS Password (Both the Password should be same)

6. Logon to TOAD as system/manager and run the command
1. Alter user APPS identified by >
1. Alter user APPLSYS identified by >
1. Commit


7. Edit startup and shutdown scripts in the following lines:
1. sh adstrtal.sh apps/<> -- Startup script
1. sh adstpall.sh apps/<>-- Shutdown script

8. Edit the following files (change the path according to your instance)
8. /applvis/testappl/admin/TEST_cctcal/out/templbac/wdbsvr.app -- Optional
8. /applvis/testappl/admin/TEST_cctcal/out/02111859/wdbsvr.app -- Optional
8. /applvis/testora/iAS/Apache/modplsql/cfg/wdbsvr.app

Find the word password and type the new password against the password field where the original value is APPS. There might be many password fields in these files. Do not change other password fields where the default password is not APPS.

9. Use vi command to open the aforementioned files
:set ic
/password – This will take the cursor to the first password fieldIf this password field has default value as APPS, change it. If this is not the field then press “n” to go to the next password field. Do this till you get the correct field. Save the file once the change is made.

There will be only one password field with default value as APPS in each of the files. So you need to make only one change per file. Restart all the services (bounce the DB & restart all services) Login to application and test whether you can enter into the forms.

Overview of Oracle Payables

on

Payables Workbenches
Oracle Payables includes two fully integrated workbenches, the Invoice Workbench and the Payment Workbench. You can perform most of your transactions in Payables using the Invoice Workbench or the Payment Workbench. You enter, adjust, and review invoices and invoice batches in the Invoice Workbench. You create, adjust, and review payments and payment batches in the Payments Workbench.

Payables workbenches let you find critical information in a flexible way. For example, in the Invoice Workbench, you can find an invoice based on supplier, purchase order number, status, or other criteria. Then, for that invoice, you can review distributions, scheduled payments, payments, holds, and other detailed invoice information. You can also perform matching, submit invoice validation, apply and release holds, or initiate payment. You can query an invoice then perform several transactions without having to find the invoice again. You can also keep multiple windows open at one time.

Invoice Workbench
The Invoice Workbench is a group of windows that you use to enter, adjust, and review your invoices and invoice batches. The following is the window hierarchy in the Invoice Workbench:
  • Invoice Batches
  • Find Invoice Batches
  • Invoices
  • Find Invoices
  • Calculate Balance Owed
  • Distributions
  • Find Invoice Distributions
  • Invoice Actions
  • Apply/Unapply Prepayments
  • Invoice Overview

The following diagram shows how you can navigate between the windows in the Invoice Workbench. You navigate into the Invoices window or Invoice Batches window through the Navigator, and navigate to most regions by choosing tabs. You can access the Find windows from the View menu, and the Apply/Unapply Prepayment window by selecting the appropriate check box in the Invoice Actions window. You access the matching windows from the Invoices window by selecting Invoice, Purchase Order, or Receipt from the match poplist and then choosing the Match button.