Oracle Alerts

SELECT a.* FROM ALR_ALERTS a WHERE ALert_Name LIKE 'XXX%Eco%';
SELECT * FROM ALR_ACTIONS WHERE UPPER(to_recipients) LIKE '%CHUA%';

Oracle E-Business Suite (EBS) Upgrades

Custom code can be expensive to develop but even more expensive to maintain.

Minimize EBS custom code

Try to eliminate as much custom code as possible. Research the more recent releases to see if new functionality replaces the homegrown code.

Set up queries or monitor the concurrent requests to see if reports and even interfaces are being used.

Global companies may see that the improved localization functionality in R12 can allow them to eliminate some custom code as well.

If you have taken copies of standard Oracle reports and modified them, the best practice is to take a new copy of that object from the new release and reintroduce the modifications. Don't spend inordinate amounts of time trying to get an old 11i report to work in an R12 environment.

The same recommendation holds true for workflow items.

While many standard open interfaces and APIs are typically not heavily changed during the migration to EBS R12, you may rename interfaces, and add new or additional parameters. 

Event alerts are typically disabled during the upgrade, so you may need to re-enable them prior to testing.

Customizations to Oracle Forms can be tricky, as they are probably one of the most invasive customizations besides database triggers. If your business processes require modifications to the forms, replace them with personalizations as much as possible. If you do have customized forms, look to see if those forms will exist in the new, plain-vanilla version. Some EBS modules have quite a few brand-new forms.

You should be able to replace some old forms with new OA Framework-based forms. 

Finally, consider the third-party products that you may have previously licensed. You may be spending extra money for functionality that has now been introduced into the applications. Examples include third-party form and label software, check printing software, invoice printing and delivery solutions, and more.

Oracle Payables (AP) - Elementary

• Payables Accounting Process - to create accounting entries in Payables.

1. The Payables Accounting Process APACCENG writes to the following tables:
   
   ap_accounting_events_all
   ap_ae_headers_all
   ap_ae_lines_all
   
   For invoices it updates the accounting_event_id in ap_invoice_distributions_all
   For payments it updates the accounting_event_id in ap_invoice_payments_all
   For Clearing events it updates the accounting_event_id in ap_payment_history_all

2. Parameter Submit Transfer to GL. If you want to initiate the Payables Transfer to General Ledger program immediately after the accounting entries are created, then enter Yes.
3. The Payables Accounting Process is obsoleted in R12 and replaced by the Create Accounting Program.

• P

OM - Elementary

• Drop Shipment --> http://www.oracleappshub.com/om/understand-drop-shipment-in-order-management-part-ii/

Oracle CRM Service - Elementary

In Oracle CRM modules, apart from creating username it's important you create them as Resource and assign a role.

Step1. Create a new employee

(R) HRMS Manager
(N) People --> Enter and Maintain

Step 2. Create applications username

(R) System Administrator
(N) Security --> User --> Define

Step 3. Import Resource into CRM

(R) Manager
(N) Setup --> CRM Foundation --> Resource Manager --> Maintain Resources --> Import Resources

Step 4. Assign required role(s) to the resource

Navigation same as Step 3 and go to tab 'Roles'.

--------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------
The CRM 'Service Suite' components:

• TeleService module
• Depot Repair module
• iSupport module
• eMail Center module
• Preventive Maintenance module - uses CMRO (Complex Maintenance, Repair and Overhaul) to create SR and tasks. 
• Service Contracts module
• Install Base module
• Knowledge Management
• Common Application Components like Territory Manager, Task Manger, Resource Manager.

--------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------

Process Flows:

Service Request to Resolution

There are three components to this flow:

1. Service Call Intake (SR created via TeleService, iSupport, eMail Center)
2. Execution Channel
3. Service Execution

The Execution Channel has three alternatives:

• Technical Support
• Field Service
• Depot Repair

--------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------

Issue: User Maintenance link under CRM HTML Administration throws message, "You don't have sufficient privileges to view this page."
Sol: Login with SYSADMIN account and assign JTF_SYSTEM_ADMIN_ROLE to your id.

Issue: When creating a new Service Request (SR), it throws error message, "The user-to-resource link has not be setup correctly."
Sol: Either the user is not yet defined as resource or User Name is not defined (or re-define) in the Resource Details screen (under Maintain Resources)

AOL - Elementary

1. Use the 'Organization Access' [R -> System Administrator] form to map responsibility with access to one or more org. Backend --> org_access_v
2. a
3. Flexfields:

Key Flexfields (KFF) --> Owned by one application, used by many. Required to setup, usage is optional. Support intelligent keys. 

Descriptive Flexfields (DFF) --> Associated with tables in specific application. Setup optional. No intelligence, stores additional info. 

Construction-In-Process (CIP) Assets

A construction-in-process (CIP) asset is an asset you construct over a period of time. Create and maintain your CIP assets as you spend money for raw materials and labor to construct them. Since a CIP asset is not yet in use, it does not depreciate and is only in the corporate book. When you finish building the CIP asset, you can place it in service and begin depreciating it.

You can track CIP assets in Oracle Assets, or you can track detailed information about your CIP assets in Oracle Projects. If you use Oracle Projects to track CIP assets, you do not need to track them in Oracle Assets.

Use the Asset Key to Track CIP Projects
The asset key is a set of key identifying information, such as project name and project number, that you define for each CIP asset. Use the asset key to group and track your CIP assets with common key words so you can find them easily for inquiry or transactions.


CIP Capitalization Report
This report shows the CIP assets that you capitalized during a range of accounting periods. The report is sorted by balancing segment, CIP cost account, cost center, and asset cost account. It prints totals for asset cost account, cost center, CIP cost account, and balancing segment.
The Cost column on this report matches the Capitalizations column on the CIP Detail Report.
You must enter a Book and From/To Period range when you request this report.
Selected Headings
Date Placed in Service: The date you capitalized the CIP asset. Oracle Assets calculates depreciation using this date and the prorate convention.
Reverse Capitalization: An asterisk (*) denotes a reverse capitalized asset.