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.
Read more…
Product Overview
Oracle Applications for Human Resources enable an organization to hire, train, and deploy, assess, motivate and reward its people more effectively than ever before, turning HR into a strategic-level function and key contributor to an organization’s success. By automating its administrative duties, providing self-service for non-HR professionals, and managing information more efficiently, HR professionals can devote their energy and creativity to delivering the maximum value for the organization’s investment in people.
Read more…
One can use UTL_FILE else OS editors/utilities. The best is using undocumented KSDWRT procedure of the DBMS_SYSTEM package.
Read more…
1. Configure “Notification Methods” to receive alerts.
Login at OMS Console and click on “Setup” at top right hand corner.
Click on “Notification Methods” at Left hand side.
Read more…
I wanted to remove one my client node from OMS. I used following GUI option but it returned errors as below
Read more…
(Release 12)
Login as database user
cd $ORACLE_HOME/appsutil/scripts/<SID_hostname>
Read more…
How to start Oracle Application Server?
Starting an application server instance
a) login to server with oracle Userid
b) set the environment
c) cd $ORACLE_HOME/opmn/bin
d) opmnctl startall (to start)
Read more…
Oracle Applications is installed on the servers of a company and every user from the CEO down to a factory staff is given a user name and password. They use their browsers to connect to the servers in their LAN and typically get a menu called responsibilities to choose from. Once they choose their responsibility, accordingly they get another menu of functions they can perform. For example if it is a Purchasing user, he may be able to create RFQs (Request for quotations), Purchase Requisitions, Purchase Orders, Receive material etc. Hence whatever that is happening at the factory ground needs to be entered in a particular form in APPS. If something is not right, APPS will not allow the process to flow further. Hence mistakes will be arrested at each step. Besides there are dozens of reports in a variety of formats for Business Intelligence and better understanding of what is actually happening for the decision makers.
So now, you understand how Oracle apps is used, but how is it structured?
The following image represents the directory structure of APPS.
Read more…
The following is a brief Guideline on steps to follow to clone you Oracle Applications from PROD to TEST
Read more…
If you carry Agent auto discovery, the display names cannot be configured.
To configure the display names of the targets in the GRID Control console, the targets must be manually discovered.
Read more…
rman> shutdown immediate;
rman> startup mount
1. Let’s validate if there is ample of space for backup at Target device type i.e DISK/TAPE
Read more…
The primary and standby database have the same filesystem layout, i.e. archive redo is at same place on both servers. Read more…
I was trying to execute following SQL through client side tools and found network delays were contributing to the SQl execution times. This SQL normally returns in less than 50 millisec and now taking more than 700 Msec. I am addicted to TOAD -TORA GUI created Execution plans and was looking for a an easy way to get execution times as well as plans on sqlplus. Here is how you do it .
Read more…
For last many years I worked for number of clients using all sort of latest technologies. One of my duties was tuning and monitoring system performance which formed part of Capacity planning. I have been using number of tools and when I saw 10G grid first time I could see a real way forward where a database technology could work towards client needs to deliver end result.
Read more…
Advantages of using grid control to schedule jobs
- Could be run against multiple targets at any given time
- Run a job immediately or repeatedly on a schedule
- Could be submitted against number of targets
- Could be shared using job library
Read more…
Click on Database Tab at grid Control
Read more…
Tweet
