Archives

Abhijit

I love sleeping, watching Hollywood blockbusters, my Wii, road trips and watching my 4 year old son grow up. In between I try to squeeze in some time to go to work.
Abhijit has written 288 posts for Oracle Maniacs' Notes

Batch payment process in Oracle R12 for Check payments

Previously we discussed how Electronic payments are made in Oracle Payments R12. In this article I shall demonstrate how Check payments are made. The main difference in the 2 process is that the payment has to be printed out as a check after the payment is formatted. Step 0: Create the invoice Responsibility: Payables responsibility … Continue reading

Rate this:

Batch payment process in R12 for Electronic payments

In a previous article we had talked about batch payment process in Oracle 11i. In Oracle R12 the batch payment process has changed considerably. A new module named Payments is created in R12 to make payment in batches (short name IBY). In this article I have demonstrated how an Electronic payment is made in Oracle R12. Step 0: … Continue reading

Rate this:

Order to Cash process using Warehouse Management

We have discussed the Order to Cash (O2C) process earlier. We shall now go through the O2C process with where WMS (Warehouse management) is installed. When WMS is installed in Oracle the shipping process is handled outside of Oracle forms. The warehouse employees use handheld devices to carry out shipping. The handheld devices are used … Continue reading

Rate this:

Dunning letter setup and usage in Oracle r12

The dunning letter setup has improved substantially in Oracle r12. I have illustrated the steps to set up a dummy Dunning Letter and how to set up a custom Dunning letter report. Custom Dunning Letter Create a new query We have the option to use a seeded query but we would like to create our … Continue reading

Rate this:

Handheld device usage and emulators for Warehouse transactions on Oracle

Handheld devices are used in warehouses for completing shipping transactions as workers in a huge warehouse will not have immediate access to a computer to complete the transactions. Also it is easy for the workers to scan bar codes and send the details directly to Oracle using the Wi Fi network set up within the … Continue reading

Rate this:

AME rule setup using database function

I have given a live example of setting up an approval process. This example shows how AME can be used with database objects and work as per requirements. The requirement for generating an expense approval hierarchy Check Signing Limit form Responsibility: Payables Administrator/Super User Navigation: Employees > Signing Limits Query the form. All the expense report … Continue reading

Rate this:

Raising business events via concurrent requests/programs

In previous examples I have shown how to execute a DB package/workflow from an event and how to send notifications from an event. Now I have given an example of how an event is kicked off from a concurrent program. It also shows how we can trigger off a workflow or a program when 1 … Continue reading

Rate this:

Single/Quick payment process in Oracle R12

In Oracle R12 the payables process has deviated from the 11i process quite a bit. The Invoice entry form and the Payment forms have remained very similar to 11i but the Payment batch form has now been replaced with “Payments Manager”. You can check the Oracle 11i single payment process and batch payment process in … Continue reading

Rate this:

How to get the file versions from the Oracle database

There are many reasons why we might need to get the file version of a particular code within Oracle. The main reason being that Oracle requires the file version of certain files within the Oracle instance when we a service request (SR) is opened in Oracle Support/Metalink. Normally we tend to go directly to the file … Continue reading

Rate this:

Concurrent program output delivery options in Oracle R12

Oracle R12 has given the users a new set of delivery options. Users no longer need to run a concurrent program, save the output of the program on their local computer and then email, FTP, fax or print the output file. This task can be automatically handled directly from the SRS form. Suppose if you had … Continue reading

Rate this:

Transaction setup for Sales Orders in OM

I have shown example of transaction setup for Sales Orders below. Responsibility: Order management super user Navigation: Setup > Transaction Types > Define Query for Transaction Type, STANDARD-UK. Assigning workflow to the order type: You can assign the header level workflow by clicking on the LOV for Fulfillment Flow. You can select the workflow for … Continue reading

Rate this:

How to check whether a patch has been applied in Oracle

We can check whether a particular patch has been applied in Oracle in 2 ways, from the front end form or from the backend. Both methods are given below. Apps form Responsibility: System Administrator Navigation: System Administration > Oracle Applications Manager > License Manager Click on Licensed Products under Reports The list of licensed applications/modules … Continue reading

Rate this:

Custom concurrent program in Shipping Document Set

You can create custom concurrent programs that can be configured to be submitted after, Pick Release Ship Confirm The programs are added in the Shipping Document Sets form. Navigation: Setup > Shipping > Documents > Document Sets Query for Document Set as All Pick Release Documents There is only 1 concurrent program added for this … Continue reading

Rate this:

Bursting control file examples and delivery configuration

In the original article on XML bursting I had discussed how a concurrent program output can be split and mailed to multiple recipients. Here I have given examples of other delivery mode via bursting, FTP, Print, fax etc. Here are some sample bursting control files for different delivery options. Fax FTP Execute the program followed by … Continue reading

Rate this:

Provide Shipping Grants to selected users

All Oracle users do not have privileges to all functionalities of Order Management even though they might have Order Management responsibility. The super user allows which functionality individual users get. Here is how the users get access. Create/View a Role Responsibility: Order Management Super User Navigation: Setup > Shipping > Grants and Role Definitions > … Continue reading

Rate this:

Traffic

Site Stats

  • 636,243 views since Feb 2012

Archives

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 194 other followers

Flags

Free counters!
Follow

Get every new post delivered to your Inbox.

Join 194 other followers