Oracle e-Business Suite
How can we reduce time for shipping in Oracle Order Management?
In one of my client they are facing problem that oracle shipping process is very hectic and lengthy for making one gate pass / delivery note they need 10 to 15 minutes
They are following these Steps to Ship / dispatch an order
Release order
Navigate to Transact Move order
Allocate quantity
Transact ...
Categories: APPS Blogs
Accounting Entries of Accrue on receipt (APO) in Oracle Application?
Accounting entries for purchase orders with destinations type expense, item type expense and with accrue on receipt option is true.
Sequence of actions and accounting entries
Action
Create, Approve, Reserve PO
Accounting entries
Budget a/c DR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO ...
Categories: APPS Blogs
How can I unreserved quantity, Reserved against a closed / canceled sale order
Problem
In one of my operating unit sale officer enter order and released to ware house, after that sale officer cancel that sale order. Now it showing me quantity reserved for that sale order in system but actually order is canceled how can I unreserved this quantity
Solution
For 11i - 11.5.7 / ...
Categories: APPS Blogs
Period Close Checklist In Oracle Account Receivables
Complete manual payments and adjustments for the period (including cleanup of ‘Out of Balance’ batches)
Check and Complete final Receivables Interface from Order Management
Complete manual invoices, DEBIT Memos and credit memos
Run your final Auto Invoice process
Correct ALL Auto Invoice rejects and re-run
Clear all receipts from Cash Management
Apply receipts against Invoices and ...
Categories: APPS Blogs
Price List Bulk Loader Example Scripts
Please apply Patch#4900462 and find the following example scripts under QP_TOP/patch/11.5/sql directory.
QPBLKEX1.sql - Script populates interface tables to insert price list header and price list line.
QPBLKEX2.sql - Script populates interface tables to insert price list header and price list line and pricing attributes.
QPBLKEX3.sql - Script populates interface tables to ...
Categories: APPS Blogs
Serial number is not available when doing a inventory transaction but shows in on hand quantity
serial-number-is-not-available-when-doing-a-inventory-transaction-but-shows-in-on-hand-quantity
Categories: APPS Blogs
Oracle Purchasing Hierarchies used for Approval routing.
There are two types of Hierarchies used for approval routing.
a. Position Hierarchies
b. Supervisor Hierarchies
Position Hierarchies
========================
Position Hierarchies are hierarchies that have a JOB/POSITION relationship.
For example, you could have a JOB called BUYER and within BUYER you could have various grades or POSITIONS of BUYER - Junior, Senior and Chief
Each POSITION ...
Categories: APPS Blogs
Formula to Calculate Available to Reserve at Different levels
The formula is
Actual Available to Reserve = Minimum (Available to Reserve at Particular node/Sub Inventory level, Available to Reserve at higher nodes/ Inventory Organization Level)Explanation
--------------------------------
1. Organization level (highest level):
On Hand Quantity for item A = 345 - 30 = 315
(Here Consider 30 is stuck quantity in MMTT, Mean ...
Categories: APPS Blogs
How to Find Applied and Unapplied Credit memos in Oracle Application 11.5.10.2
how-to-find-applied-and-unapplied-credit-memos-in-oracle-application-115102
Categories: APPS Blogs
A year in the life of my blog.
I would like to thank all the visitors of this blog for there support and co-operation which gave me confidence to walk through the blog life with firm steps!!! Bundle of THANKS!!!
I can’t believe it’s been a year since I started this blog. It’s really quite amazing when I look ...
Categories: APPS Blogs
Script to Clear Orders Stuck in Workflow @ Releasing
If you have some order lines in booked status and the ship line activity is in error instead of 'Notified' then use the following script (But check on Test Environment first). Pass the line_id for one of the line from problematic order and check if this will progress the line ...
Categories: APPS Blogs
What Notification Types are available in Oracle Service
The following Notifications are available:”You can set up the application to automatically notify the service request owner and customer contacts associated with the service request whenever a certain event occurs, for example, whenever a service request is created, closed, or reassigned. Notifications can be sent via Oracle Workflow notifications or ...
Categories: APPS Blogs
How to start the Workflow Mailer Service Using Oracle Application Manager (OAM)
1. Login to OAM
2. Navigate to Workflow
3. Click on Service Components you will find a new page with item name “Workflow Notification Mailer” and Container “Workflow Mailer Service”
4. Under column container click on Workflow Agent Listener Service
5. From drop down list at the end of the line , choose start ...
Categories: APPS Blogs
How to Delete Stock Locators by Using API
How to Delete Stock Locators by Using API
Categories: APPS Blogs
Account Receivable to General Ledger Transfer
Source Oracle Account Receivable User Guide
Categories: APPS Blogs
Key ERP Leadership Positions and Pre-Requisite
Key ERP Leadership Positions and Pre-Requisite
Categories: APPS Blogs
How to enable multiple logins per Single user
Perform the following steps to enable the multiple logins per user id:
Login as Workflow Web Administrator Responsibility --> Click Administration.
Please note the user name in the "Workflow System Administrator" field.
Logout from Oracle Applications.
Now Login with ...
Categories: APPS Blogs
How to restrict single session per user in Oracle EBS
How to restrict single session per user in Oracle EBS
Categories: APPS Blogs
How to Apply Security on Form By Using Customized Profile Option and Forms Personalization.
how-to-apply-security-on-form-by-using-customized-profile-option-and-forms-personalization
By using This Document you can create your own profile options and apply security or fulfill other requirements as well
Categories: APPS Blogs
How to Create Stock Locators By using API
How to Create Stock Locator by using API
Categories: APPS Blogs



