Let’s say that your Oracle apps password got locked and you need the help of your system administrator to reset the password for you, but unfortunately he is not reachable.
Luckily if you have toad access for that particular instance, you can use the below query to change the password.
declare
l_flag boolean;
begin
l_flag := fnd_user_pkg.CHANGEPASSWORD('username','password');
end;
Click commit button.
Ex:
declare
l_flag boolean;
begin
l_flag := fnd_user_pkg.CHANGEPASSWORD('orasupport','oracle1234');
end;
Click commit button.
---X---
Below is a list of various Oracle application modules with their abbreviations.
ABM - Activity Based Management
AD - Applications DBA
AHL - Oracle Advanced Service Online
AK - Oracle Common Modules-AK
ALR - Oracle Alert
AMF - Oracle Fulfillment Services
AMS - Oracle Marketing
AP - Oracle Payables
AR - Oracle Receivables
AS - Oracle Sales
ASG - Oracle CRM Gateway for Mobile Services
ASL - Oracle Mobile Field Sales Laptop
ASO - Oracle Order Capture
AST - Telesales
AX - Global Accounting Engine
AZ - Application Implementation
BEN - Oracle Advanced Benefits
BIC - Customer Intelligence
BIL - Sales Intelligence
BIM - Marketing Intelligence
BIS - Oracle Applications BIS
BIX - Call Center Intelligence
BNE - Oracle Web ADI
BOM - Oracle Bills of Material
BSC - Balanced Scorecard
CCT - Oracle Call Center and Telephony
CE - Oracle Cash Management
CHV - Oracle Supplier Scheduling
CLN - Supply Chain Trading Connector for Rosetta Net
CN - Oracle Sales Compensation
CS - Oracle Service
CSC - Customer Care
CSD - Depot Repair
CSE - Oracle Enterprise Install Base
CSF - Field Service
CSI - Install Base
CSM - Oracle Field Service Palm
CSP - Oracle Spares Management
CSR - Oracle Scheduler
CSS - Support
CUG - Oracle Citizen Interaction Center
CUN - Oracle Network Logistics NATS
CZ - Oracle Configurator
EAM - Oracle Enterprise Asset Management
EC - Oracle E-Commerce Gateway
ECX - Oracle XML Gateway
EDR - Oracle E-Records
ENG - Oracle Engineering
FII - Financials Intelligence
FLM - Oracle Flow Manufacturing
FND - Application Object Library
FTE - Oracle Transportation Hub
FV - Oracle Federal Financials
GHR - Oracle Federal HR
GL - Oracle General Ledger
GMA - Oracle Process Manufacturing Systems
GMD - Oracle Process Manufacturing Product Development
GME - Oracle Process Manufacturing Process Execution
GMF - Oracle Process Manufacturing Financials
GMI - Oracle Process Manufacturing Inventory
GML - Oracle Process Manufacturing Logistics
GMP - Oracle Process Manufacturing Process Planning
GMS - Oracle Grants Accounting
GR - Oracle Process Regulatory Mgmt
HRI - Human Resources Intelligence
HXC - Oracle Time and Labor
HXT - Oracle Time and Labor Rules
IBA - i-Marketing
IBC - i-Content
IBE - i-Store
IBU - i-Support
IBY - i-Payment
ICX - Oracle Self-Service Web Applications
IEB - Oracle Interaction Blending
IEC - Oracle Campaign Plus
IEM - Oracle e-Mail Center
IEO - Call Center Technology
IES - Scripting
IEU - Oracle Universal Work Queue
IEX - Oracle Collections
IGC - Commitment Administration
IGF - Student Systems Fin Aid
IGI - Oracle International Public Sector Financials
IGS - Oracle Student Systems
IGW - Oracle Grants Proposal
INV - Oracle Inventory
IPD - Oracle Product Development Exchange
ISC - Supply Chain Intelligence
JTF - CRM Foundation
JTM - Oracle CRM Mobile Foundation
JTS - Oracle CRM Self Service Administration
MRP - Oracle Master Scheduling/MRP
MSC - Oracle Advanced Supply Chain Planning
MSD - Oracle Demand Planning
OFA - Oracle Assets
OKC - Oracle Contracts Core
OKI - Oracle Contracts Intelligence
OKL - Oracle Lease Management
OKR - Oracle Contracts for Rights
OKS - Oracle Contracts Service Module
ONT - Oracle Order Management
OPI - Operations Intelligence
OTA - Oracle Training Administration
OZF - Funds & Budgets
PA - Oracle Projects
PAY - Oracle Payroll
PER - Oracle Human Resources
PJM - Oracle Project Manufacturing
PN - Oracle Property Manager
PO - Oracle Purchasing
POA - Purchasing Intelligence
POM - Oracle Exchange
PON - Oracle Sourcing
POS - Internet Supplier Portal
PQH - Oracle Public Sector HR
PSA - Public Sector Applications
PSB - Oracle Public Sector Budgeting
PSP - Oracle Labor Distribution
PV - Partner Relationship Management
QA - Oracle Quality
QP - Oracle Pricing
QRM - Oracle Risk Management
RG - Application Report Generator
RLM - Oracle Release Management
VEA - Oracle Automotive
WIP - Oracle Work in Process
WMS - Oracle Warehouse Management System
WSH - Oracle Shipping
WSM - Shop Floor Management
XDP - Oracle Provisioning
XNC - Oracle Sales for Communications
XNI - Oracle Install Base Intelligence
XNP - Oracle Number Portability
XNS - Oracle Service for Communications
XTR - Oracle Treasury
---X---
Before finding out how to check the status & enable or disable a trigger it is best to know what a trigger is & what it does.
A trigger is a named program unit that is stored in the database and executed in response to a specified event. When a trigger is initiated it does its intended function such as copying a data from one table to another (or) automatically executing a concurrent request, etc.,
With the following query we can find the status of a trigger,
select status from user_triggers where trigger_name = 'Name of the trigger'
Ex: select status from user_triggers where trigger_name = 'JA_IN_GEM_PM_MATL_DTL_T1'
Enabling Triggers:
If the status of the trigger is in disabled status, then with the following query we can enable it.
alter trigger trigger_name enable;
Ex: alter trigger JA_IN_GEM_PM_MATL_DTL_T1 enable;
Click Commit button.
Disabling Triggers:
If the status of the trigger is in enabled status, then with the following query we can disable it.
alter trigger trigger_name disable;
Ex: alter trigger JA_IN_GEM_PM_MATL_DTL_T1 disable;
Click Commit button.
---X---
Note:
- You can use these scripts when rest of the Process like Final Cost Update, Final Sub-ledger Update, Transfer and Post to GL is not done.
- It is always a best practice to first test in your test instance.
The following script will reverse the final closed OPM Inventory period to Preliminary close status.
update ic_cldr_dtl
set closed_period_ind = 2
where orgn_code = upper('&&orgn_code')
and fiscal_year = &&fiscal_year
and period = &&period
Provide the following parameters,
Orgn_code -- provide the Operating Unit (Ex: abs)
Fiscal_year -- give the fiscal year (Ex: 2012)
Period -- the period for which the status is to be changed (Ex: 8)
Confirm that only 1 row gets updated.
update ic_whse_sts
set close_whse_ind = 2
where fiscal_year = &&fiscal_year
and period = &&period
and whse_code in ('XXX','YYY','ZZZ')
Parameters:
Fiscal_year -- give the same fiscal year
Period -- give the same period
Whse_code -- give all the warehouses of the Operating unit
“N” number of rows will get updated – depending upon the No. of warehouses in the corresponding Operating Unit.
Click Commit button.
If we change the value of “set closed_period_ind = 2” in the 1st query & “set close_whse_ind = 2” in the 2nd query to “1” and execute the queries in the same order, the final closed OPM Inventory period will be reversed to Open status.
Copyright © 2015 an ORACLE APPS blog. All Rights Reserved.
