Payables Create Mass Additions (CMA) R12 SLA Swap

• In R12 Oracle adapted the CMA program in Payables to look to the XLA tables for Asset Clearing Account.  
• This means that if you have the wrong account in the 'Payables' tables (either from it being entered incorrectly on a PO or Invoice) and you have an Account Derivation rule (that includes an appropriate mapping set) to transform the account into the proper clearing account good things will happen i.e. the Asset lines will get over to FA into the Prepare Mass Additions arena.

How to Cancel/Retire an Asset Without Recognizing Gain or Loss on Net Book Value?

If the assets do not come from AP:
1.- Adjust the asset cost to zero
2.- Then retire the asset in the following period.

The cost adjustment will eliminate the cost and when depreciation is run, all 
previous depreciation expense will be recaptured.  This effectively eliminates 
the transactions from the system.  The asset clearing account will be charged 
with the cost of the asset and will need to be relieved by whatever transaction 
external to Fixed Assets prompted the need to delete the asset.

To adjust the cost to zero:
  Navigation: Asset Workbench / Books
  Select Book
  Change cost to zero and save

Asset's accumulated depreciation will be recaptured when depreciation is run at 
the end of the current depreciation period.  When subsequently retired, there 
will be no accounting effect as the cost and reserve are now both zero.

In case the assets come from AP:
1.- cancel in AP the invoice line transferred to FA 
2.- then enter another invoice line against an expense account
3.- Run Create Mass Additions from AP.
This way, the cancelled lines will be transferred to FA where they can be added 
to the asset setting cost to 0. Then asset can then be retired.

1250 vs 1245 vs 1231 Property Classifications for US Tax Code

Imagine drawing a house like you would have when you were 5 or 6 years old.

• The highest part is the roof - the building - highest number = 1250.
• Under that is the stuff in the building - FF&E next lowest number = 1245.
• The lowest part is the land it all sits on - lowest number = 1231.

Switch Responsibility Form is Showing Duplicate Responsibilities when Changing Responsibility

Switch Responsibility Form is Showing Duplicate Responsibilities when Changing Responsibility [ID 801393.1]

For R 12.1.1, download Patch 8678076.

Location for GSA Per Diem rates files

Here's were you can find the ; delimited file used in the Concurrent upload process in iExpense. 

http://www.defensetravel.dod.mil/site/perdiemFiles.cfm

Attribute Controls won't open. STILL???

This one has been around since R11.10.R2.  What gives?  On R12.1.3 and on install the following steps still need to be taken:

To implement the solution, please execute the following steps:
Recompile all the Inventory (INV) forms, (including the Attribute Controls form INVIDCTL.fmb and INVIVATT.fmb), even if they are valid, using Adadmin tool along with the libraries.

How to configure Oracle Approval Management (AME) for developer

Follow the steps below to have access to AME.

Steps to AME configuration for any user

1) Select the User Management responsibility.
2) Select the Users page.
3) Search for the user to whom you wish to grant AME roles.
4) In the results table, click Update. In the Update User page, you can view user details along with a list of roles available to the user.
5) Click Assign Roles.
6) Select following roles and click Apply.

1) Approvals Management Administrator
2) Approvals Management Analyst
3) Approvals Management System Viewer
4) Approvals Management System Administrator
5) Approvals Management Process Owner

7) Grant data access to users

1) Login as Administrator.
2) Select the Functional Administrator responsibility.
3) Select the Grants tab.
4) Click Create Grant.
5) Select Specific User as grantee type.
6) Select the user as grantee key.
7) Select AME Transaction Types as Object
8) Select AME Calling Applications as Set
9) Follow the screen and click on Finish

8) Run “Workflow Directory Services User/Role Validation”
9) Select Approval Management Business Analyst responsibility and check functionality

Mass Allocations

To Allocate down do:
A     =Source or SUM or Summary Acct
B/C =CC-SQFT(LOOP)/TOTAL-SQFT(SUM-unless Summary Acct)
T     =Target(LOOP)
O      = Same as source

To Clear accounts to one account (T becomes the offset and O becomes the Target)
A      =Loop the CC's
B/C  =-1/1 (to create the opposite of the balance on account)
T    =Loop the CC's
O   =Destination of all the balances

Note: Don't use a SUM on a summary value.

Global Consolidation System

11.5.10.2 to 12.1.3 Upgrade Steps

Done by Narayana Reddy

PREPARING THE UPGRADE
***********************************
Review Upgrade Tasks and Apply 11i.AD.I.6
1. Apply 11i.AD.I.6 (conditional)
Both these patches are applied
Patch 6502079 – ‘AD.I.6 Delta’
Patch 6502082 – ‘AD.I.6′
2. Run TUMS utility (recommended) — The Upgrade Manual Script
/orastage/software/12i/12i_upg_patches/7705743
Apply 7705743 in hotpatch mode
cd $AD_TOP/patch/115/sql
sqlplus apps/apps @adtums.sql /u02/oracle/XXATD/11.5.0/comn/tmp
This will generate a report “tumsr12.html”
review the output “tumsr12.html”
Database and System Administration Tasks
_____________________________________________
1. Back up database, Applications, and customizations (recommended)
Will plan for backup
2. Prepare an upgrade plan for customizations (conditional)
Customizations will be tested before the upgrade.
Save customizations and modify them if necessary
3. Convert to Multiple Organizations architecture (required)
Already on multi-org
4. Drop event alert triggers in custom schemas (conditional)
No Custom Triggers
select * from all_triggers
where trigger_name like ‘ALR%’
$ALR_TOP/admin/sql/alrdtrig.sql
5. Review sizes of old and new tablespaces (required) ( 399362.1 )
From Metalink Note 399362.1
Database Size:
Years of Data Migrated    Before Upgrade DB Size(GB)    After Upgrade DB Size(GB)    Delta(GB)    %Growth
3 Years                    6609.97                          6808.44                        198.47            3%
12 Years                6609.97                          7161.61                    551.64          8.3%
6. Run AD preparation scripts (required)
Download patch 7197489 and unzip the patch
Patch unzip under /orastage/software/12i/12i_upg_patches/7197489
CREATE USER XXATDFND
IDENTIFIED BY xxatd
DEFAULT TABLESPACE XXATDD
TEMPORARY TABLESPACE TEMP2
PROFILE DEFAULT
ACCOUNT UNLOCK;
– 2 Roles for XXATDFND
GRANT CONNECT TO XXATDFND;
GRANT RESOURCE TO XXATDFND;
ALTER USER XXATDFND DEFAULT ROLE ALL;
– 1 System Privilege for XXATDFND
GRANT UNLIMITED TABLESPACE TO XXATDFND;
– 4 Object Privileges for XXATDFND
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON XXATDSCM.SCM_SCHEMA_CHANGE_LOG TO XXATDFND;
GRANT ALTER, SELECT ON XXATDSCM.SCM_SCHEMA_CHANGE_LOG_S TO XXATDFND;
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON XXATDSCM.SCM_SCHEMA_STATE TO XXATDFND;
GRANT ALTER, SELECT ON XXATDSCM.SCM_SCHEMA_STATE_S TO XXATDFND;
CREATE TABLESPACE INTERIM
DATAFILE ‘+DATA’
SIZE 10G REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
SEGMENT SPACE MANAGEMENT AUTO ;
cd /orastage/software/12i/12i_upg_patches/7197489
sqlplus <APPS username>/<APPS password> @adgncons.sql apps apps
creates adcrtbsp.sql
Modify adcrtbsp.sql generated from above to reflect the ASM data group
sqlplus system/manager @adcrtbsp.sql
>> Extend tablespace APPS_TS_CUSTOM_INV_DATA
extend the current datafiles which are 2g in size to 30 g, probably 2 of them
select file_name,sum(bytes)/(1024*1024) from dba_datA_files
where tablespace_name = ‘APPS_TS_CUSTOM_INV_DATA’
group by file_name;
FILE_NAME                                     SUM(BYTES)/(1024*1024)
——————————————— ———————-
+DATA/r12d/apps_cust_inv_data01.dbf                             4096
+DATA/r12d/apps_cust_inv_data02.dbf                             2048
+DATA/r12d/apps_cust_inv_data03.dbf                             2048
+DATA/r12d/apps_cust_inv_data04.dbf                             4096
+DATA/r12d/apps_cust_inv_data05.dbf                             2048
+DATA/r12d/apps_cust_inv_data06.dbf                             2048
+DATA/r12d/apps_cust_inv_data07.dbf                             5120
alter database datafile ‘+DATA/r12d/apps_cust_inv_data01.dbf’ resize 30g;
alter database datafile ‘+DATA/r12d/apps_cust_inv_data02.dbf’ resize 30g;
Run adgrants.sql
Create $ORACLE_HOME/appsutil/admin on the database server
Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPLSYS schema name>
Applications Technology Tasks
______________________________
1. Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
5903765 – Patch already applied in PRD
Currently using workflow notification mailer for Alert
Customer Relationship Management Tasks
_______________________________________
Marketing, Sales, or Trade Management
_______________________________________
1. Create new product catalog (conditional)
TUMS step key: AMS_OSO_PLM_CHK
From the TUMS report this can be ignored
Incentive Compensation
__________________________
1. Verify completion of Sales Compensation processes
TUMS step key: CN_PAYRN_REP_CHK
From the TUMS report this can be ignored
TeleService
______________________
1. Set up profile option for TeleService (required)
Not Required, Not using TeleService
Mobile Field Service
________________________
1. Synchronize data for Mobile Field Service (conditional)
Not Required, Not using Mobile Field Service
Financials and Procurement Tasks
____________________________________
Financials for India
______________________
1. Set minimum patch levels (conditional)
Not Required. Not using Financials for India
General Ledger
____________________________
1. Run Accounting Setup Manager Diagnosis for MRC (optional)
Apply patch 5259121
cd /orastage/software/12i/12i_upg_patches/5259121
Apply u5259121.drv using hotpatch mode
Run the report
Accounting Setup Manager Pre-Update Diagnosis report
from  General Ledger responsibility
output in “Accounting Setup Manager Pre-Update Diagnosis Report.html”
report came out with “No issues found” for all the steps
iPayments
___________
1. Prepare data for credit card encryption upgrade (conditional)
Not Required
( TUMS step key: IBY_SEC_UPGRADE )
Internet Expenses
___________________
1. Import expense reports into Accounts Payable (conditional)
Not Required
( TUMS step key: OIE_IMPORT_INTERCOMPANY_CHECK )
Payables
____________________
1. Import all invoices from Payables Open Interface (required)
TUMS step key: AP_IMPORT_INVOICES_CHECK
In this release, global descriptive flex fields (GDFs) are obsolete and are moved into tax
and payment columns. Several validations are performed based on the country the
invoice is imported from on these GDFs. They are not upgraded in the open interface
tables.
Import all invoices that have not yet been imported by running the Open Interface
Import program on the 11i APPL_TOP. Resolve any rejections and resubmit the
program until all invoices are imported.
select count(*) from ap_invoices_interface
1560
select count(*) from AP_INVOICE_LINES_INTERFACE
983
for this test upgrade
delete from ap_invoices_interface;
delete from AP_INVOICE_LINES_INTERFACE;
commit;
2. Confirm or cancel all Un-confirmed Payment Batches (required)
TUMS step key: AP__CNFM_PAY_BATCH_CHECK
Payables Manager -> Payments -> Inquiry
Search for status != Confirmed
No batches found
Subledger Accounting
___________________________
1. Set range of periods (optional)
Patch 5233248 can be applied to select the number of periods to be upgraded
cd /orastage/software/12i/12i_upg_patches/5233248
apply u5233248.drv in hotpatch mode
Run “SLA Pre-Upgrade program” to select the number of periods of data to be upgraded
Leasing and Finance Management Tasks
________________________________________
Not Required ( TUMS Step Key: OKL_LIC_CHK )
Projects Tasks
_________________
1. Complete distribution, transfer, and tieback of expense reports (conditional)
Not Required ( ATD does not use Projects — TUMS step key: PA_COMPLETE_DIST_TIEBACK_EXP )
2. Complete transfer and tieback of cost, cross charge, and revenue (conditional)
Not Required ( ATD does not use Projects — TUMS step key: PA_COMPLETE_DIST_TIEBACK_EXP )
Public Sector/University Tasks
_________________________________
Student Systems
_______________________
Not Required ( ATD does not use Oracle Student Systems )
Supply Chain Management Tasks
__________________________________________
Depot Repair
_________________
1. Identify and resolve problem data (conditional)
Not Required ( ATD does not use Depot Repair )
Process Manufacturing
_______________________
1. Prepare to migrate OPM data (conditional)
Not Required ( ATD does not use Process Manufacturing — TUMS step key: GMA_PREP_MIGRATE )
2. Finish migration preparations for OPM (conditional)
Not Required ( ATD does not use Process Manufacturing — TUMS step key: GMA_PREP_MIGRATE_FINISH )
Service Contracts
___________________________
1. Update Currency Code setup in Global Contracts defaults (conditional)
Not Required ( ATD does not use Service contracts — TUMS step key: OKS_VALIDATE_GCD )
2. Validate data for Rules and Time values migration (recommended)
Not Required ( ATD does not use Service contracts — TUMS step key: OKS_VALIDATE_GCD )
Prepare for the Upgrade
**************************************
ATD Specific Steps
ATD.1 Compile flexfield PRODUCT_CATEGORIES
Error: invctcat.ldt erroring out during upgrade
Solution
To implement the solution, please execute the following steps:
a. Go into the responsibility: Inventory
b. Navigate to Setup / Flexfields / Key / Segments / query Inventory, Item Categories.
c. Find PRODUCT_CATEGORIES flexfield structure, make sure that it is defined, enabled, and compiled.
Check other common category structures to ensure that they are defined, enabled and compiled.
ATD.2 Truncate ENI tables as we are not using business intelligence
MLOG$_ENI_OLTP_ITEM_STAR is Growing too Large, can it be Truncated? [ID 367693.1]
TRUNCATE TABLE ENI.MLOG$_ENI_OLTP_ITEM_STAR;
TRUNCATE TABLE ENI.ENI_OLTP_ITEM_STAR;
ATD.3 permission on olapsys objects
run the following connected as system
grant execute on OLAPSYS.CWM2_OLAP_METADATA_REFRESH to apps;
grant execute on OLAPSYS.CWM2_OLAP_CATALOG to apps;
grant execute on OLAPSYS.CWM2_OLAP_DIMENSION to apps;
grant execute on OLAPSYS.CWM2_OLAP_CUBE to apps;
ATD.4 db link SOLIX ( Only required for Test upgrades )
Make sure the db link SOLIX is valid
SQL> select name from v$database@solix;
NAME
—————————
SARCD
ATD.5   Unlock stats on mlog tables
on orar12.dev.icd
cd /orastage/software/12i/scripts
sqlplus ‘/ as sysdba’
@unlock_stats_gen.sql
@un_lock_stats.txt
1. Gather schema statistics for CBO (required)
This step should be done prior to the upgrade to reduce downtime. we gather stats weekly on a rotational basis, we can discuss the option of skipping this if required.
2. Back up the database (recommended)
Evaluate cold backup options or Take a backup of the system using netbackup
3. Run Rapid Install (required)
This step can be done ahead of time
a. Follow instructions in Chapter 1 of Oracle Applications Installation Guide: Using
Rapid Install to prepare your environment for the new system
Then, start Rapid
Install by typing rapidwiz on the command line.
b. On the Wizard Operation screen, select Upgrade to Oracle Applications Release 12.1.1. Click Next.
cd /orastage/software/12i/12.1.1/startCD/Disk1/rapidwiz
./rapidwiz
c. On the Select Upgrade Action screen, select Create Upgrade File System.
d. In the associated screen flow, enter the parameters required to set up your new
environment. Then, run Rapid Install.
select port pool : 0
Enter Database configuration info
Database Host : orar12
Database Port : 1521
Database SID  : R12D
Domain Name   : dev.icd
Database OS User  : oracle
Database OS group : dba
Base Directory    : /u01/oracle
Application User Information
Apps Username  : apps
Apps Password  : apps
GWYUID Username : APPLSYSPUB
GWYUID Password : PUB
Guest Username  : GUEST
Guest Password  : ORACLE
Primary Applications Node Configuration
Host Name     : appr12
Domain Name   : dev.icd
Apps OS User  : oracle
Apps OS Group : dba
Base Dir      : /u02/oracle/R12D
Instance Dir  : /u02/oracle/R12D/inst
Config File Location
/u02/oracle/R12D/inst/apps/R12D_appr12/conf_R12D.txt
rapidwiz will do the following checks
Port Uniqueness
File Space
File Systems
Host / Domain
/u02/oracle/R12D/inst/apps/R12D_appr12/logs/06131106.log
Following error can be safely ignored as the DB is not configured for R12
Attempting upload of Context file and templates to database…ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; The element reports_port is missing from the context file /u02/oracle/R12D/inst/apps/R12D_appr12/appl/admin/R12D_appr12.xml.  The context file upload will not continue.
Note: Rapid Install (as it runs AutoConfig) records errors in the
AutoConfig log file. These errors occur because the database has
not yet been upgraded. They can be safely ignored. The errors will
be resolved when you run Rapid Install (and AutoConfig) in Step 2
of the Finish the Upgrade, page 3-8 section of Chapter 3, page 3-
1.
Run Rapid Install again after the upgrade to configure and start the servers and
services. Rapid Install also delivers the unified upgrade driver that you will use later to
perform the upgrade.
4. Migrate or upgrade your database to at least Oracle 10g Release 2 (conditional)
Our database is at version 11GR1, this step can be ignored.
*****************************************
Upgrading to Release 12.1.1
*****************************************
Perform the Upgrade
____________________
1. Disable AOL Audit Trail (conditional)
Navigation  : System Administrator
Security > Audit Trail > Groups
There are five groups set to “Disable – Purge Table” –> set this to “Disable – Prepare for Archive”
Run program “AuditTrail Update Tables”
2. Shut down application tier listeners and concurrent managers (required)
adstpall.sh apps/apps
3. Migrate database to at least Oracle10g Release 2 (conditional)
We are on 11.1.0.7.4 – Skipping this step
4. Update init.ora with upgrade parameters (required)
396009.1 – Database Initialization Parameters for Oracle Applications Release 12
Page 1-11
https://support.oracle.com/CSP/main/article?cmd=show&id=396009.1&type=NOT
alter system set “_sqlexec_progression_cost”=2147483647 scope=both;
alter system set “_optimizer_autostats_job”=false scope=both;
alter system set “_disable_fast_validate”=TRUE scope=both;
5. Disable custom triggers, constraints, and indexes (conditional)
Follow instructions in suspend_jaros.txt to disable Noetix triggers
cd /orastage/software/12i/scripts
sqlplus jarosconnect/jarosconnect
@disable_jaros_trig_run.sql
@truncate_jcd_run.sql
@truncate_jel_run.sql
@truncate_jelh_run.sql
6. Drop MRC schema (conditional)
Not Applicable — MRC_APPS does not exist
7. Back up the database (recommended)
Applies to 11i release level: All
TUMS step key: N/A
Make a cold backup of the Oracle Applications database. If you encounter problems
during the upgrade process, you can use this backup to restore your system to the
same state as before you began the upgrade.
Note: Shut down with the NORMAL option. You may not be able
to restore the database from the backup if you use the IMMEDIATE
or ABORT option.
8. Ensure that Maintenance Mode is enabled (required)
run adadmin and enable maintenance mode
*****
CUSTOM/PRE-UPGRADE STEPS BEFORE RUNNING THE UPGRADE DRIVER
*****
Source 11i Environment file
Apply patch 8845395
ATD.6  Source R12 Environment file
. ./R12.env
cat R12.env
. /u02/oracle/R12D/apps/apps_st/appl/APPSR12D_appr12.env
Apply patch 7461070 in normal mode
on the DB server
cd $ORACLE_HOME/appsutil/admin
scp oracle@appr12.dev.icd:/orastage/software/12i/12i_upg_patches/pre_upg/7461070/admin/adgrants.sql .
sqlplus /nolog
@adgrants.sql APPS
run adadmin to recreate grants and synonyms
ATD.7  Apply Following patches in pre-install mode
/orastage/software/12i/12i_upg_patches/pre_upg
adpatch preinstall=y
# Following not required
# cd $AD_TOP/patch/115/sql
# sqlplus apps/apps
# @adpamiss.pls
# @adpamisb.pls
********** Following will be merged into one patch driver ( 1211_preinstall.drv )*********
adpatch preinstall=y
8601033
>> 8218945 — Failed ( Skipped in creating a merge patch )
This patch is compatible with: entity ‘per’ – codeline ‘R12.PER.A’.
Your current on-site codeline for the entity ‘per’ is: ‘R12.PER.B’.
10096115 — ( apilnupg.sql runs for a long time )
7303029 — CUP 1
7648869 — AP patch
8615142 — AP Patch
8712047 — AP Patch
8865466 — AP Patch
9257954 — AP Patch
9586498 — AP Patch
9799876 — AP Patch
9918101 — AP Patch
10096191 — AP Patch
10144929 — AP Patch
10170555 — AP Patch
10358280 — AP Patch
11071399 — AP Patch
12344218 — AP Patch
8517880  — AR Patch
8509517  — GL Patch
10235226 — GL Patch ( only if upgrading to 12.1.3 )
8752951  — EB Tax Patch
9504903  — EB Tax Patch
9947835  — EB Tax Patch
10029457 — EB Tax Patch
10221534 — EB Tax Patch
8942413  — iPayments
10393730 — Cash Management, consolidated preupgrade fixes
12347791 — Project Costing
admrgpch -s /orastage/software/12i/12i_upg_patches/pre_upg/pre_upg_src -d /orastage/software/12i/12i_upg_patches/pre_upg/pre_upg_merge -merge_name 1211_preinstall
adpatch preinstall=y u_1211_preinstall.drv
ATD.8 adsstats.sql failing with duplicate value error
delete from FND_HISTOGRAM_COLS
where table_name = ‘FII_FIN_ITEM_HIERARCHIES’
and column_name = ‘PARENT_FLEX_VALUE’
ATD.9 Upgrade to GMF failing
drop synonym APPS.GMF_BATCH_REQUIREMENTS_GTMP;
drop table GMF.GMF_BATCH_REQUIREMENTS_GTMP;
DROP INDEX INV.XXATD_MTL_TRANS_INTERF_N6;
drop table APPS.FII_CURR_CONV_RATES_GT; — this is a table in APPS
drop view APPS.CST_ACCRUAL_ACCOUNTS; — This is a view
drop index PO.PO_VENDORS_F1; — Upgrade creates PO_VENDORS_OBS_F1 on the same set of columns
drop index APPS.MTL_MATERIAL_TRANSACTIONS_N26; — for 12.1.3 upgrade
– Clear OPP Queue table ( will save around 1 hour 45 mins )
exec dbms_aqadm.purge_queue_table(‘FND_CP_GSM_OPP_AQTBL’, null, null);
ATD.10 : Apply database patches
Shutdown database
Apply database patches
/u01/oracle/product/11.1.0/DB/patches/12i_upg_patches/
/orastage/software/12i/12i_upg_patches/db_patches
6460304
7111245
7211965
7684818
$ORACLE_HOME/OPatch/opatch napply /u01/oracle/product/11.1.0/DB/patches/12i_upg_patches/7684818 -id 4247037,6263237,6815733,7243270,7277741,7319922,7327166,7684818 -skip_duplicate
8639653
Startup database
cd /orastage/software/12i/12i_upg_patches/db_patches/7684818
sqlplus ‘/ as sysdba’
SQL> @?/md/admin/catmgdidcode
ATD.11 Recompile all objects to prevent timestamp issues
Running utlirp.sql ( total around 15 mins )
Login to sqlplus as sys as sysdba.
SQL>shutdown
SQL>startup upgrade
SQL>@?/rdbms/admin/utlirp.sql  ( 15 mins )
SQL>shutdown
SQL>startup
SQL>@?/rdbms/admin/utlrp.sql ( 45 mins )
ATD.12 — delete MSC_APPS_INSTANCES
create table MSC_APPS_INSTANCES_1 as select * from MSC_APPS_INSTANCES;
delete from MSC_APPS_INSTANCES;
commit;
ATD.13 Extend Tablespace
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_IDX
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_IDX
add datafile ‘+DATA’ size 30g;
**************** Tablespace Info after AP index creation ****************
select df.tablespace_name “Tablespace”,
totalusedspace “Used MB”,
(df.totalspace – tu.totalusedspace) “Free MB”,
df.totalspace “Total MB”,
round(100 * ( (tu.totalusedspace)/ df.totalspace))
“Pct. Used”
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
and tu.tablespace_name not in (‘UNDO1′,’UNDO2′,’UNDO3′,’UNDO4′)
order by 2 desc
TABLESPACE              USED_MB         FREE_MB TOTAL_MB PCT_USED
APPS_TS_TX_DATA              818616    229689    1048305    78
APPS_TS_TX_IDX              576909    189037    765946    75
SABRIX_DATA              299696    34126    333822    90
XXATDD                      215383    265895    481278    45
XXATDX                      53865            13719    67584    80
APPS_TS_SUMMARY              52774     24018    76792    69
APPS_TS_MEDIA              41340     7812    49152    84
UNDO5                      26352     14608    40960    64
APPS_TS_INTERFACE         26076     4644    30720    85
APPS_TS_CUSTOM_INV_DATA      16585     60215    76800    22
APPS_TS_NOLOGGING      14068     27972    42040    33
SYSTEM                      13801     6679    20480    67
TOOLS                      13677     2707    16384    83
APPS_TS_ARCHIVE              11907     3189    15096    79
APPS_TS_CUSTOM_INV_IDX      10212     3100    13312    77
SYSAUX                      9813      5547    15360    64
APPS_TS_SEED              7758      3534    11292    69
APPS_TS_QUEUES              3369       18191    21560    16
JAROSCHTRKDAT              1888      120992    122880    2
XXATD_STD_EUL              1099      949    2048    54
JAROSCHTRKIDX              1009      50191    51200    2
DISCOVERER              168       856    1024    16
PORTAL                      34        266    300    11
9. Apply AD 12.1.1 upgrade driver (required)
cd $AU_TOP/patch/115/driver
adpatch options=nocopyportion,nogenerateportion
u6678700.drv
Following SQL running for more than 2 hours now, Might have to open a SR for performance
SQL.1
, following SQL is running. Might have to raise a SR
/* Formatted on 7/8/2011 4:07:49 PM (QP5 v5.163.1008.3004) */
SELECT COUNT (1)
FROM MTL_SYSTEM_ITEMS_B
WHERE STYLE_ITEM_FLAG = ‘Y’
AND ITEM_CATALOG_GROUP_ID IN
(    SELECT ITEM_CATALOG_GROUP_ID
FROM MTL_ITEM_CATALOG_GROUPS_B
CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID =
PARENT_CATALOG_GROUP_ID
START WITH ITEM_CATALOG_GROUP_ID = :B1)
******* Upgrade Observations *****************
07/11/2011 21:17
czhist.sql failed with “APPLSYS.FND_STATTAB is too old.”
Worker 8 was still running
Ran the script below and restarted worker 2
exec dbms_stats.upgrade_stat_table(‘APPLSYS’,'FND_STATTAB’);
adsstats.sql took 4 hours to complete
Continue with the next set of tasks
11. Run the NLS upgrade patch driver (conditional)
Skipped as English is the only language installed.
12. Apply latest product patches (required)
will apply 12.1.3 patchset later
13. Synchronize NLS and American English product patches (conditional)
N/A English is the only language
14. Disable Maintenance Mode (required)
run adadmin to disable maintenance mode
15. Reset init.ora parameters (required)
follow note 396009.1
alter system set “_disable_fast_validate”=FALSE scope=both;
16. Back up Oracle Applications (recommended)
FINISH THE UPGRADE
**********************************
1. Reset ORACLE schema passwords (recommended)
Might not be required if we are using the same passwords
2. Configure and start server processes (required)
a. Update the RDBMS ORACLE_HOME file system with AutoConfig files.
on apptier
cd $INST_TOP
perl $AD_TOP/bin/admkappsutil.pl
will generate /u02/oracle/R12D/inst/apps/R12D_appr12/admin/out/appsutil.zip
copy appsutil.zip to database ORACLE_HOME
cd $ORACLE_HOME
unzip -o appsutil.zip
b. Install/Upgrade JRE on apptier
cd /orastage/software/patches/jre
cp j2se16022.exe $COMMON_TOP/webapps/oacore/util/jinitiator
Apply the Interoperability Patch
Stop app tier services
enable maintenance mode using adadmin
apply patch 4377566 using adpatch
Patch Location
/orastage/software/patches/jre/4377566
Run the txkSetPlugin.sh Script on all webtiers
cd $FND_TOP/bin
./txkSetPlugin.sh 16022
copy jre to $ORACLE_HOME/appsutil on db tier
scp -r oracle@appr12.dev.icd:/u02/oracle/R12D/apps/tech_st/10.1.3/appsutil/jdk/jre $ORACLE_HOME/appsutil
Generate a new Database context file as follows:
cd $ORACLE_HOME/appsutil/bin
perl adbldxml.pl
will generate /u01/oracle/product/11.1.0/DB/appsutil/R12D_orar12.xml
Run AutoConfig on the database tier nodes
cd $ORACLE_HOME/appsutil/bin
adconfig.sh contextfile=/u01/oracle/product/11.1.0/DB/appsutil/R12D_orar12.xml
3. Configure Applications client software for forms applet (required)
Above steps will enable this ( Client side java is installed already )
4. Reapply customizations (conditional)
*** CUSTOM_DEV Will analyze later
5. Integrate custom objects and schemas (conditional)
*** CUSTOM_DEV Will analyze later
6. Re-enable custom triggers, constraints, and indexes (conditional)
sqlplus jarosconnect/jarosconnect
run enable_jaros_trig_run.sql
Finish System Administration Tasks
_____________________________________
System Administration
________________________
1. Configure SSL for Web Services (conditional)
Not required here
2. Complete Workflow Notification Mailer configuration (required)
Probably not required — but need to check in PRD
3. Complete Transport Agent setup (conditional)
Not required
4. Complete setup for Oracle XML Gateway (required)
Not required
Oracle XML Publisher
______________________
1. Enable PDF printing (required)
Copy pasta configuration file
Not required if PDF printing does not work
then cp $11i_FND_TOP/resource to 12i_FND_TOP/resource
2. Specify a temporary directory for XML Publisher (required)
Use XML publisher administrator to setup the temp directory
POST-UPGRADE TASKS
********************************
Review Post-upgrade Tasks
_____________________________
Will perform these steps after 12.1.3 Upgrade
12.1.3 UPGRADE
***************************************
12.1.3 pre upgrade steps
drop index APPS.MTL_MATERIAL_TRANSACTIONS_N26
/
12.1.3 Upgrade
cd /orastage/software/12i/1213_patchset
*** Apply RUP 3 ****
Steps
Apply prereq – R12.AD.B.DELTA.3 ( 9239089 ) — ( 15 mins )
copy adgrants.sql and run on database node
cd /u01/oracle/product/11.1.0/DB/appsutil/admin
scp oracle@appr12.dev.icd:/orastage/software/12i/1213_patchset/9239089/admin/adgrants.sql .
sqlplus /nolog @adgrants.sql APPS
on APPTIER
apply the patch driver u9239089.drv
Apply 12.1.3 ( 9239090 )
cd /orastage/software/12i/1213_patchset/9239090
Apply u9239090.drv
The following Oracle Forms objects did not generate successfully:
au      resource        OKSAUDET.pll
au      resource        CSCUTILS.pll
au      resource        OKCEXPOR.pll
au      resource        OKCKSRCH.pll
We will continue as if it were successful
APPLY ONLINE HELP
****************************
Apply 12.1.1 Help already applied as part of 12.1.1
Apply 12.1.3 Help
9239095
cd /orastage/software/12i/1213_patchset/9239095
apply u9239095.drv
Apply Post 12.1.3 Patches
cd /orastage/software/12i/1213_patchset
Patch 9817770 — POST-R12.ATG_PF.B.DELTA.3
Patch 9966055 — 1OFF:12.1.3:TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED
Apply HRMS Legislative data patch ( Metalink note : 145837.1 )
We have HR installed — but only used with purchasing.
HRMS RUP 4 can be applied  ( 10281212 )
cd /orastage/software/12i/12i_upg_patches/post_upg
a. Apply u10281212.drv — 30 mins
b. run data install :
java oracle.apps.per.DataInstall apps apps thin orar12.dev.icd:1521:R12D
c. apply hrglobal.drv ( 15 mins )
cd $PER_TOP/patch/115/driver
apply hrglobal.drv
skip the worker if it fails
******** PUT JOBS ON HOLD ********
Create table  apps.atd_upgrade_jobs_on_hold as select * from fnd_Concurrent_requests where PHASE_CODE=’P’ and  hold_flag=’N';
select count(*) from apps.atd_upgrade_jobs_on_hold ;
update fnd_Concurrent_requests set hold_flag=’Y’ where PHASE_CODE=’P’ and hold_flag=’N’ and request_id in
(select request_id from apps.atd_upgrade_jobs_on_hold) ;
Commit;
********* BEFORE Starting Services ************
cd $ADMIN_SCRIPTS_HOME
run autoconfig
./adautocfg.sh
cp /home/oracle/work/config_files_r12/adovars_R12D_appr12.env /u02/oracle/R12D/inst/apps/R12D_appr12/appl/admin/adovars_R12D_appr12.env
Before you start the applications — put the jobs on hold
./adstrtal.sh apps/apps
URL
http://appr12.dev.icd:8000/
POST-UPGRADE TASKS
******************************
Application Technology Tasks
___________________________________
System Administration
__________________________
1. Verify Completion of concurrent Programs
Will run programs after starting services
2. Install online help (recommended)
Already installed
3. Update/verify custom responsibilities (conditional)
Custom Step to be done later
4. Migrate custom development to new technologies (recommended)
Custom Step to be done later
5. Migrate the CUSTOM library (conditional)
Custom step to be done later
6. Copy and re-customize modified scripts or reports (conditional)
Modify .prog files
7. Copy existing custom start scripts (conditional)
Modify custom startup and shutdown scripts including MWA
8. Review user responsibility assignments (recommended)
Review user and responsibility assignments
Alerts
_________________
1. Associate organization names with custom Alert definitions (conditional)
N/A single org
Multiple Organizations
_____________________________
1. Set operating unit mode for customizations (conditional)
Analyze custom programs and set the following
UPDATE FIND_CONCURRENT PROGRAMS
SET MULTI_ORG_CATEGORY=’S’
WHERE CONCURRENT_PROGRAM_NAME = ‘<your program name>’\
Report Manager
__________________
1. Assign the Report Manager Data Migration Program to a request group (required)
Add the concurrent program “Data Migration Program” to ATDI Custom Reports request group
2. Run the Data Migration Program
This program moves to new schema
Program failed with an error — will check as part of testing
Web ADI
________________________
1. Recreate existing spreadsheets (conditional)
existing spreadsheets do not work with the new tech stack, recreate the spreadsheets
Will be done as part of testing
Workflow
__________________________________
1. Update Status Monitor URLs (required)
run the program “Workflow Plsql Cartridge Dependency Removal From Data” to update urls, there is also a data fix script in the clone documents
2. Synchronize Product License and Workflow BES license status (conditional)
Run program “Synchronize Product License and Workflow BES License”
Assign the program to request group “System Administrator Reports”
Oracle E-Business Suite Integrated SOA Gateway
_________________________________________________
Will apply SOA patches later
Customer Relationship Management Tasks
_________________________________________________
Email Center
__________________
1. Migrate Email Center data (recommended)
N/A do not use Email Center
Sales and Telesales
_____________________________
1. Run concurrent programs (required)
Do not use Sales and Telesales – Skipping
2. Migrate Sales methodologies for opportunities (required – application specialist)
Do not use Sales and Telesales – Skipping
3. Migrate Sales credits (required – application specialist)
Do not use Sales and Telesales – Skipping
Sales Upgrade From ASN.B to Release 12
_________________________________________
1. Run ASN Migrate Duplicate Salesrep Main Program.
Do not use Sales — Skipping
2. Run ASN Post Upgrade Log and Customer Update.
Do not use Sales — Skipping
Mobile Field Service
_______________________________
1. Migrate to the New Mobile Field Service Application (conditional)
Not using Mobile Field Service — Skipping
Financials and Procurement Tasks
___________________________________
Financials for India
_______________________
1. Apply custom logic for Projects functionality (conditional)
N/A for ATD — Skipping
Internet Expenses
___________________________
1. Ensure that document categories have valid sequences (conditional)
N/A for ATD — Skipping
Payments
______________________
1. Enter encryption key for Payments (conditional)
N/A for ATD — Skipping
2. Complete payment profile options for Netherlands (conditional)
N/A for ATD — Skipping
3. Complete Danish payment means and channels (conditional)
N/A for ATD — Skipping
4. Complete remittance advice controls for Italy (conditional)
N/A for ATD — Skipping
Human Resources Tasks
______________________
Human Resources
_________________
1. Apply latest HRMS Legislative Updates (required)
Complete as part of post patch application
2. Verify Labor Distribution tables (conditional)
N/A for ATD — Skipping
3. Re-seed custom salary components (conditional)
N/A for ATD — Skipping
4. Migrate Training Administration to Learning Management (conditional)
N/A for ATD — Skipping
5. Complete HRMS Configuration Workbench Setup (conditional)
N/A for ATD — Skipping
6. Verify Time Zone conversion for Learning Management (required)
N/A for ATD — Skipping
7. Check downtime reduction report (recommended)
N/A for ATD — Skipping
8. Migrate stored names to new and revised formats (required)
N/A for ATD — Skipping
Approvals Management
_______________________
1. Attach new responsibilities to existing users for AME (conditional)
N/A for ATD — Skipping
Payroll
___________________
1. Install or update Vertex for Payroll (conditional)
N/A for ATD — Skipping
2. Run the QuickPay Exclusions Data Upgrade process (recommended)
N/A for ATD — Skipping
3. Create translated Database Item names for Japanese Localizations (conditional)
N/A for ATD — Skipping
4. Compile Japanese flexfields after generating messages (required)
N/A for ATD — Skipping
5. Enable Subledger Accounting (SLA) (conditional)
N/A for ATD — Skipping
Intelligence Tasks
____________________
Intelligence
______________
1. Perform additional steps for Embedded Data Warehouse (required)
N/A for ATD — Skipping
2. Perform additional steps for End User Layer (conditional)
N/A — Already on latest release
3. Perform additional Daily Business Intelligence steps (required)
N/A for ATD — Skipping
4. Perform additional Balanced Scorecard steps (required)
N/A for ATD — Skipping
Daily Business Intelligence – Marketing
____________________________________________
1. Verify Initial Load, Incremental, and Dashboard reports (recommended)
N/A for ATD — Skipping
Daily Business Intelligence – Sales
______________________________________
1. Run Initial Request Set (required)
N/A for ATD — Skipping
2. Verify Initial Load, Incremental, and Dashboard reports (recommended)
N/A for ATD — Skipping
Projects Tasks
______________________
Property Manager
______________________
1. Create accounts distribution for leases (conditional)
N/A for ATD — Skipping
Supply Chain Management Tasks
___________________________________
Mobile Applications
______________________
1. Review MWA Server Administration Task Changes (required)
Edit scripts to use new location of config files
See 394495.1
Process Manufacturing
_________________________
1. Complete Inventory Convergence for OPM (conditional)
N/A for ATD — Skipping
Service Contracts
___________________________
1. Monitor Deferred Upgrade Tasks (conditional)
N/A for ATD — Skipping
Oracle Profitability Manager
______________________________
N/A for ATD — Skipping
Oracle Enterprise Performance Foundation
__________________________________________
System Maintenance Tasks
__________________________________
System Maintenance
______________________
1. Delete obsolete product files (recommended)
Skipping this and retaining 11i appl_top for reference
2. Drop obsolete columns (recommended)
Skipping this — Will check later
Check : Oracle Database Administrator’s Guide 11g Release 1 (11.1) for details.
3. Register new products (conditional)
N/A for ATD — Skipping
4. Update Java Color Scheme profile option for selected users (conditional)
Check the user profile settings before the upgrade and set the same
ATD Specific tasks
__________________________
ATD.1    Copy custom tops to R12 APPL_TOP
ATD.2    Edit adovars.env for PRD
ATD.3    Create common top
ATD.4    Recreate links  — run recreate_links_all.sh
ATD.5    Reset utl_file_dir    change the first value to point to the new tmp directory
alter system set utl_file_dir = ‘/u02/oracle/R12D/XXATD/12.0.0/comn/tmp’,'/usr/tmp’,'/u02/oracle/R12D/XXATD/12.0.0/comn/edi/outbound’,'/u02/oracle/R12D/XXATD/12.0.0/comn/edi/inbound’ scope=spfile;
ATD.6    Relink libraries
ATD.7    Apply Post Upgrade Patches    See list post_upgrade_patches.txt
ATD.8    Define new managers for Post upgrade jobs    See post_upgrade_jobs.txt
ATD.9    Tune database    Tune Database using “11g-upgrade-best-practices-ebusiness_suite.pdf”
ATD.10    SQL Plan baselines    Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE
Release jobs from hold
update fnd_Concurrent_requests
set hold_flag=’N’ where hold_flag = ‘Y’
and requesT_id in (select request_id from apps.atd_upgrade_jobs_on_hold)
********** Tablespace After Upgrade ******************
select df.tablespace_name “Tablespace”,
totalusedspace “Used MB”,
(df.totalspace – tu.totalusedspace) “Free MB”,
df.totalspace “Total MB”,
round(100 * ( (tu.totalusedspace)/ df.totalspace))
“Pct. Used”
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
and tu.tablespace_name not in (‘UNDO1′,’UNDO2′,’UNDO3′,’UNDO4′)
order by 2 desc
TABLESPACE                          USED_MB FREE_MB TOTAL_MB PCT_USED
APPS_TS_TX_DATA            928373    119932    1048305    89
APPS_TS_TX_IDX            688250    77696    765946    90
SABRIX_DATA            302276    31546    333822    91
XXATDD                    217218    264060    481278    45
XXATDX                    53982    13602    67584    80
APPS_TS_SUMMARY            51623    25169    76792    67
APPS_TS_MEDIA            42126    7026    49152    86
UNDO5                    31582    9378    40960    77
APPS_TS_INTERFACE    26399    4321    30720    86
APPS_TS_CUSTOM_INV_DATA    22101    54699    76800    29
SYSTEM                    17739    2741    20480    87
APPS_TS_NOLOGGING    14159    27881    42040    34
TOOLS                    13801    2583    16384    84
APPS_TS_ARCHIVE            11860    3236    15096    79
SYSAUX                    9394    5966    15360    61
APPS_TS_CUSTOM_INV_IDX    9071    4241    13312    68
APPS_TS_SEED            8226    3066    11292    73
APPS_TS_QUEUES            3349    18211    21560    16
JAROSCHTRKDAT            2182    120698    122880    2
XXATD_STD_EUL            1103    945    2048    54
JAROSCHTRKIDX            1009    50191    51200    2
DISCOVERER            168    856    1024    16
PORTAL                    34    266    300    11

Consolidations Equity method

Purchase price - (RE + equity) Equals the differential.

Differential gets adjust to zero by one of the following:

 FV differences (increase or decrease underlying assets) 

Goodwill (goes to BS and gets amortized over years) 

Bargain (goes to RE) 

Cost or Market Method Investor acquires < 20% of investee's voting stock (insignificant influence) Investment account (Trading or Available for Sale) Any income (dividends is placed in "Other income")

Equity Method Investor acquires 20% – 50% of investee's voting stock (significant influence) Investment account stays Income share increases Investment acct balance Dividends decrease Investment acct balance  Interco profit eliminated proportiionally Equity method applied

Consolidation Method Investor acquires > 50% of investee's voting stock (legal control). Investment account gets zero'd out. Common Stock eliminated RE eliminated Interco's elimininated Noncontrolling balance exists in Equity section of Parent Noncontrolling share of income shown below Total Income Books are consolidated

How to add a context dependent descriptive flexfield on OAF Control Item page (type dependent)

Author: Cyriel van Schaik

We all know (I think :-)) the way in Oracle Forms to create context dependent descriptive flexfields. That is displaying additional segments within the form based on some other value in the form or maybe a value on a profile option.

These context dependent flexfields were at first not possible in framework because the references like BLOCK etc (which you can use in Forms) are not applicable to framework pages. Starting from release 12.0.6 of E-Business Suite there is a way to implement context descriptive flexfields on framework pages.

As an example I'll use some example we encountered during an implementation. There was a requirement that additional details should be given to a control item in Project Management. Control Items in Project Management can be used to record your issues and risk on your running projects. In this case we have 2 Control Item Types being Issue and Risk. Based on the type we need to display additional segments in a DFF for the end user to use. This DFF must change with every type of issue.

To implement this behaviour we need to do a number of things:

1. Implement the DFF and add segments on it for 2 context values (Issue and Risk)
2. Implement a reference value used by the DFF which is the Control Item Type
3. Enable the Descriptive Flexfield on the Control Item page of a project
4. Add a so called Flex Map to the Descriptive Flexfield on the OAF page to hold the control item type (and used by the DFF definition
5. Bounce Apache

Key thing in the above is step number 4. Starting from release 12.0.6 E-Business Suite introduces the functionality of Flex Maps. Follow the below steps to implement the behaviour. Of course the same method can be used in other parts of E-Business Suite if the page has a seeded DFF. If that's not the case than also a self made descriptive flexfield can be added but I'll write a post about that in near future.

Step 1: Implement the DFF for Control Items
a) Go to Application Developer - Flexfield - Decriptive - Segments and query the Control Item flexfield with the name Control Items Desc Flex.

b) Unfreeze the Flexfield Definition if needed. Tick the checkbox Synchronize with Reference Field to make sure the context is updated when you move along control items. Also untick the Displayed checkbox as we don't want to show the Context field to the end user. Set the Reference Field. Add the syntax :$PROFILES$.<Name>. As a name anything can be used. Remember that name because we need it in a later step. In my example I'll set it to :$PROFILES$.TypeCICyriel

c) Add Context Field values. I'll add 2 values named Issue and Risk. It's very important that these names represent the exact naming of your control item types. Add as many as you like representing each option you have for the types. Add your segments to the contexts and assign them to one of the attribute fields.

By default the segments are set to be a required segment. If applicable turn this off by opening the segment (click on Open) and untick the required checkbox.

d) When done adding your context field values and the related segments save the work and freeze the Flexfield definition. Your DFF should compile without problems.

Step 2: Handle the DFF on the framework page (Control Items)

Go to your Control Item page. If you don't have the Personalize options enable the profile options and set it to the username who's going to do the change. Change the below profile options and set it for the specific username on value Y (for Yes).

• Create Seeded Personalizations
• FND: Personalization Region Link Enabled
• FND: Personalization Seeding Mode
• HR: Enable User Personalization
• Personalize Self-Service Defn

Make sure the DFF is enabled (Shown) for the page. If that's not the case than click the Personalize pencil on the row Flex: (PaDescFlex) and change the rendered setting to Yes.

Step 3: Add a Flex Map (bean) to the DFF in OAF through personalization
a) Click on Create Item on the row Flex: (PaDescFlex). You get a new screen where you define the Flex Map settings.

b) Enter the ID which can be anything you want. Leave the Attribute Set and Comments blank. For Name you have to use the exact name as defined in the reference field setting in the DFF definition without the :$PROFILES$. I used the reference field name settting :$PROFILES$.TypeCICyriel so the name of the Reference Value of the Flex Map must be TypeCICyriel.

The Reference Value is very important and will be the placeholder for in this case the Control Item Type name. This setting can use the so called SPEL language with which you reference an attribute of the page or view object of the OAF page. In this case the Control Item Type name is a seeded attribute of the ControlItemVO object of the page. We enter ${oa.ControlItemVO.CiTypeName} as the reference value. The Refers Context option needs to be set to true as we use this Flex Map as a context item.

c) Save all your work and bounce apache if the changes are not reflexted immediately.

The end result will be that when you create a new control item being, in our example, a risk or an issue the applicable additional segments are shown for the type. We've unticked the Displayed checkbox within the DFF definition so it's also not visible in the OAF page. See below the shots for the end results. Good luck with using this feature :-)

Risk showing the 2 defined risk segments of the DFF (Context hidden)

Issue showing the 2 defined issue segments of the DFF (Context hidden)

Employees and users script

SELECT
    fuser.USER_NAME USER_NAME
    , per.FULL_NAME FULL_NAME
    , per.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
    , frt.RESPONSIBILITY_NAME RESPONSIBILITY
FROM
    FND_USER fuser
    , PER_PEOPLE_F per
    , FND_USER_RESP_GROUPS furg
    , FND_RESPONSIBILITY_TL frt
WHERE
    fuser.EMPLOYEE_ID = per.PERSON_ID
    AND fuser.USER_ID = furg.USER_ID
    AND (to_char(fuser.END_DATE) is null
        OR fuser.END_DATE > sysdate)
    AND frt.RESPONSIBILITY_ID = furg.RESPONSIBILITY_ID
    AND (to_char(furg.END_DATE) is null
        OR furg.END_DATE > sysdate)
    AND frt.LANGUAGE = 'US'
ORDER BY fuser.USER_NAME;

Extract Mapping Set values from Oracle Apps

SELECT
    MS.MAPPING_SET_CODE MAPPING_SET_CODE
    , DECODE(MS.FLEXFIELD_ASSIGN_MODE_CODE, 'S', 'SEGMENT', 'V', 'VALUE SET', 'A', 'FLEXFIELD', 'NA') MAPPING_SET_TYPE
    , MS.VALUE_SET_NAME MS_VALUE_SET_NAME
    , MS.FLEXFIELD_SEGMENT_NAME MS_FF_SEGMENT_NAME
    , MS.FLEX_VALUE_SET_NAME MS_FLEX_VALUE_SET_NAME
    , MSV.INPUT_VALUE_CONSTANT INPUT_VALUE
    , MSV.INPUT_VALUE_TYPE_CODE INPUT_VALUE_TYPE_CODE
    , MSV.VALUE_CONSTANT OUTPUT_VALUE
    , DECODE(GCC.SEGMENT1, NULL, NULL, GCC.SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6 || '.' || SEGMENT7) GL_CODE_COMBINATION
    , GCC.SEGMENT1
    , GCC.SEGMENT2
    , GCC.SEGMENT3
    , GCC.SEGMENT4
    , GCC.SEGMENT5
    , GCC.SEGMENT6
    , GCC.SEGMENT7
    , MSV.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
    , MSV.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
    , MSV.ENABLED_FLAG ENABLED_FLAG
    , MSV.CREATION_DATE CREATION_DATE
    , MSV.MAPPING_SET_VALUE_ID MAPPING_SET_VALUE_ID
    , CREATEUSER.USER_NAME CREATED_BY
    , MSV.LAST_UPDATE_DATE
    , UPDATEUSER.USER_NAME LAST_UPDATED_BY
FROM
    APPS.XLA_MAPPING_SETS_FVL MS
    , XLA.XLA_MAPPING_SET_VALUES MSV
    , APPLSYS.FND_USER CREATEUSER
    , APPLSYS.FND_USER UPDATEUSER
    , GL.GL_CODE_COMBINATIONS GCC
WHERE
    MS.MAPPING_SET_CODE = MSV.MAPPING_SET_CODE
    AND MSV.CREATED_BY = CREATEUSER.USER_ID
    AND MSV.LAST_UPDATED_BY =  UPDATEUSER.USER_ID
    AND MSV.VALUE_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
    AND MSV.ENABLED_FLAG = 'Y'

FAH in Action: Presentation on how FAH can be leveraged.

Profile options for FNDLoad

Using "examine" with "PROFILE_OPTION_NAME" Get the criteria



GL:
GL_SET_OF_BKS_NAME
GL_ACCESS_SET_ID


Multi-org
ORG_ID
XLA_MO_SECURITY_PROFILE_LEVEL

HR:
PER_SECURITY_PROFILE_ID
PER_BUSINESS_GROUP_ID

FNDLOAD apps/biggie@PROD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Prof_MO_Sec.ldt PROFILE PROFILE_NAME=“XLA_MO_SECURITY_PROFILE_LEVEL"

FNDLOAD apps/biggie@PROD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Prof_HR_BG.ldt PROFILE PROFILE_NAME="PER_BUSINESS_GROUP_ID" APPLICATION_SHORT_NAME=‘PER'

FNDLOAD apps/biggie@PROD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Prof_HR_Sec.ldt PROFILE PROFILE_NAME="PER_SECURITY_PROFILE_ID" APPLICATION_SHORT_NAME='PER’ 

FNDLOAD apps/biggie@PROD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Prof_GL_ASID.ldt PROFILE PROFILE_NAME=“GL_ACCESS_SET_ID"

FNDLOAD apps/biggie@PROD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Prof_GL_SOBNM.ldt PROFILE PROFILE_NAME="GL_SET_OF_BKS_NAME” 

FNDLOAD apps/biggie@PROD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct Prof_MO_ORGID.ldt PROFILE PROFILE_NAME="ORG_ID" 

Foreign Currency Translation Under FAS 52

Foreign Currency Translation Under FAS 52

September 01, 2010
By Kevin Douglass, CPA
From New Jersey CPA, the monthly magazine of the NJ State CPA Society


Companies that consolidate the results of foreign operations denominated in local currencies must translate the foreign financial statements into U.S. Dollars (USD). Financial Accounting Statement No. 52, Foreign Currency Translation (FAS 52), sets forth the appropriate accounting treatment under U.S. GAAP. Companies reporting under International Financial Reporting Standards (IFRS) are subject to International Accounting Standard No. 21, The Effects of Changes in Foreign Exchange Rates (IAS 21), which is substantially similar to FAS 52. 
History
Prior to the adoption of FAS 8, U.S. companies generally translated current accounts at current exchange rates and noncurrent accounts at historical rates. This method was known as the current-noncurrent method and had a very short-term focus. FAS 8, adopted in 1975, required use of the temporal method, which uses the rate in effect at the time each item is recorded (different rates for different items). This method was widely criticized due to the wide variation in earnings that resulted. Six years later, FAS 52 was issued, which mandates the functional currency approach. A key feature of this approach is the current rate method, which translates all assets and liabilities at the current rate in effect at the time of translation, equity accounts at historical rates and income statement items at a weighted-average rate for the period.
Translation
The entire task of foreign currency translation can be understood as determining the correct exchange rate to be used in converting each financial statement line item from the foreign currency to USD. The translation adjustment is an inherent result of this process, in which balance sheet and income statement items are translated at different rates. FAS 52 establishes these steps:

1. Determine the functional currency. The functional currency is defined as the currency of the primary economic environment in which the entity operates. Normally, that is the currency in which the majority of the subsidiary’s business activities are transacted. This task can be more difficult than it seems and may require significant judgment. The functional currency is not necessarily the home currency or the currency in which the subsidiary keeps its books.
2. Determine whether the functional currency of the subsidiary is also its home currency.
3. If the functional currency is the home currency, the current method is used. The current method translates all assets and liabilities at the current spot rate at the date of translation. Equity items, other than retained earnings, are translated at the spot rates in effect on each related transaction date (specific identification). Retained earnings are translated at the weighted-average rate for the relevant year, with the exception of any components that are identifiable with specific dates, in which case the spot rates for those dates are used. Income statement items are translated at the average rate for the period, except where specific identification is practicable. The resulting adjustment is not recognized in current earnings, but rather as a component of other comprehensive income.
4. If the functional currency of the subsidiary is not its home currency, the temporal (historical) method is used. Under this method, nonmonetary balance sheet accounts and related income statement accounts are re-measured using historical exchange rates. The resulting translation adjustment is recognized in current earnings.
5. Under FAS 52, the temporal method is also used when the subsidiary operates in a highly inflationary environment. Again, the resulting adjustment is recognized in current earnings. Companies reporting under IFRS treat this differently by re-measuring the financial statements at the current balance sheet rate in order to present current purchasing power. GAAP, on the other hand, does not generally permit inflation-adjusted financial statements. Instead, it requires the use of a more stable currency as the functional currency.

Foreign currency translation is more than a simple mechanical exercise. A thorough understanding of FAS 52 or IAS 21 is required, and many aspects of this process require significant management judgment, especially as it relates to determining the functional currency of the subsidiary.

Kevin Douglass, CPA, M.B.A., is an audit manager with EisnerAmper, LLP. He is a member of the New Jersey Society of CPAs Professional Conduct Committee. Douglass can be reached at 732-287-1000.

Using FND Loader

What worked for me:
FNDLOAD apps/biggie O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct TEST2.ldt VALUE_SET FLEX_VALUE_SET_NAME='MAKRO ACCOUNT'

Change the name of the Value set inside the "File.ldt" file and if necessary change the values.  I think a Java program could write out these ldt files and then they could be used as the starting point instead of a go between.

From Oracle:

Some Tips About FNDLOAD

Data Synchronization?
Data Synchronization is a process in which some setup data would be synchronized, and this would be more important when you are working in Oracle application development/implementation project. The equally important that ATG data Migration takes place necessary to synchronize the data across databases instance during
· Installations (New descriptive flex field creations etc)
· Upgrades (Apps upgrade etc.)
· Maintenance (Value set changes etc.)
Generic Loader (FNDLOAD)
The Generic Loader (FNDLOAD) is a concurrent program that can move Oracle Applications data between database and text file representations. The loader reads a configuration file to determine what data to access. For information on specific configuration files consult the Open Interfaces Guide for your product group.
From an FNDLOAD perspective, there is absolute no limitation on parallel execution.  Parallel upload of concurrent programs and responsibilities should through fine unless upload logic in LCT file restrict the same.
There is no way to limit the download of the value hierarchy data with the existing flexfield loader logic. 
If this data is removed manually from the .ldt file generated when downloading data, the upload might error out as a result and this is NOT a supported method of using fndload and the corresponding generated data.
Overview
The Generic Loader can download data from an application entity into a portable, editable text file. This file can then be uploaded into any other database to copy the data. Conversion between database store and file format is specified by a configuration file that is read by the loader.

The Generic Loader downloads data from a database according to a configuration (.lct) file, and converts the data into a data file (.ldt file). The Generic Loader can then upload this data to another database using a configuration file.

The loader operates in one of two modes: download or upload. In the download mode, data is downloaded from the database to a text file; in the upload mode, data is uploaded from a text file to the database.

Data structures supported by the loader include master-detail relationships and foreign key reference relationships.

In both downloading and uploading, the structure of the data involved is described by a configuration file. The configuration file describes the structure of the data and also the access methods to use to copy the data into or out of the database. The same configuration file may be used for both uploading and downloading.

When downloading, the Generic Loader creates a second file, called the data file that contains the structured data selected for downloading. The data file has a standard syntax for representing the data that has been downloaded. When uploading, the Generic Loader reads a data file to get the data that it is to upload. In most cases, the data file was produced by a previous download, but may have come from another source. The data file cannot be interpreted without the corresponding configuration file available.

What can be done?
These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules
The FNDLOAD: Concurrent Program – FNDLOAD can be executed as a concurrent program.
Some advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained
Some disadvantages when using FNDLOAD
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data
Syntax
The Generic Loader is a concurrent program named FNDLOAD. The concurrent executable takes the following parameters:

FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ...]
where

<apps/pwd>
The APPS schema and password in the form username/password[@connect_string]. If
connect_string is omitted, it is taken in a platform-specific manner from the environment
using the name TWO_TASK.

< 0 Y >
Concurrent program flags.

mode
UPLOAD or DOWNLOAD. UPLOAD causes the datafile to be uploaded to the database. DOWNLOAD causes the loader to fetch rows and write them to the datafile.

<congle>
The configuration file to use (usually with a suffix of .lct, but not enforced or supplied by the loader).

<datale>
The data file to write (usually with a suffix of .ldt, but not enforced or supplied by the loader). If the data file already exists, it will be overwritten.

<entity>
The entity(ies) to upload or download. When uploading, always upload all entities, so specify a "-" to upload all entities.

< [param] >
Zero or more additional parameters are used to provide bind values in the access SQL (both UPLOAD and DOWNLOAD). Each parameter is in the form NAME=VALUE. NAME should not conflict with an attribute name for the entities being loaded.
Modes of Operation
This is important because it would drive the whole flow, and it always be either Upload or Download.
Example of download
FNDLOAD apps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=<application_short_name>
Example of Upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt - CUSTOM_MODE=FORCE undocumented parameter

What are FNDLOAD Options?
· Application level OR single entity level download
o (Example) Download all the profile options of Inventory or just the INV: Default Primary UOM
· Entire OR Partial upload of a data file
o (Example) Upload the entire myfile.ldt or just a single entity indicated by - and mode UPLOAD or  UPLOAD_PARTIAL
o Entity name required for UPLOAD_PARTIAL mode
· Custom mode force update
o To override Oracle’s upload algorithm and update the custom AOL data regardless, use CUSTOM_MODE= FORCE
o UPLOAD_MODE= REPLACE (only for menus)
· Support for NLS uploads
o NLS data uploads for translated columns are supported, use UPLOAD_MODE= NLS

Where is Configuration File Located
By default Oracle delivers most of configuration files that can be used to download certain entities.
· Configuration files with extension .lct
o On Unix - all the configuration files are in $FND_TOP/patch/115/import directory
o On Unix Oracle also places the original configuration files in $FND_TOP/admin/import directory
· Data files with extension .ldt
FNDLOAD File Structure
· The configuration files (.lct) are delivered and maintained by Oracle.
· It has entity definitions, parent-child relationships and user input parameters identified by :NAME.
· Downloading a parent automatically downloads all children - (Example) Concurrent Program download.
· The data files (.ldt) have both entity definition and the data.
· It also shows the version and the location of the configuration file (.lct) that was used.
· Without the configuration file, a data file is useless.
· Without the data file, a configuration file is meaningless.
FNDLOAD Files
· Key files: .lct and .ldt
· FNDLOAD must be run as the apps user not as applsys or any other user, otherwise an Ora-6550 error will be received.
· Both are easily readable, editable and portable.
· Do not modify Oracle .lct files.
· Use a favorite editor to manipulate only the .ldt files but be cautious about data type, length, delimiter placements etc.
· Use the log file outputs or .ldt file contents creatively for quick file comparisons and answer questions as: (Why can this be accessed? What is that profile option name, value and level? What is the value set used for that DFF segment attribute10 etc.)
· Partial string searches (which value set has Priority something in its where clause, etc)

Some sample examples

1 - Printer Styles

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”

2 - Lookups

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”prod” LOOKUP_TYPE=”lookup name”

3 - Descriptive Flexfield with all of specific Contexts

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=:COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name”

4 - Multiple Flexfields

Use a combination of APPLICATION_SHORT_NAME and DESCRIPTIVE_FLEXFIELD_NAME names ie. APPLICATION_SHORT_NAME=PER >> will download all PER flexfields DESCRIPTIVE_FLEXFIELD_NAME=PER_% >> will download all flexfields that start with 'PER_'.

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME="PER_%"

5 - Key Flexfield Structures

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=:COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=”prod” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”structure name”

6 - Concurrent Programs

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name”

7 - Value Sets

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”

 8 - Value Sets with values

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”

9 - Profile Options

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod” 

10 - Request Group

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod”

11 - Request Sets

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set”

12 - Responsibilities 

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=”responsibility"

13 - Responsibilities with all Security Groups

FNDLOAD apps/<PASSWORD> 0 Y DOWNLOAD FND_TOP/patch/115/import/afscursp.lct <USER>.ldt
FND_USER USER_NAME="<USER>" SECURITY_GROUP=% DATA_GROUP_NAME=%

14 - Menus

FNDLOAD apps/ pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=”menu_name”

15 - Forms/Functions/Personalizations: Refer to the System Administrator's Guide on dependencies

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
<filename.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>

OR

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FUNCTION FUNCTION_NAME=<function_name>

OR

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FORM FORM_NAME=<form_name>

OR

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>

16 - User/Responsibilities 

FNDLOAD apps/ pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER

17 - Alert

FNDLOAD apps/pwd 0 Y DOWNLOAD
$ALR_TOP/patch/115/import/alr.lct my_file.ldt ALR_ALERTS
APPLICATION_SHORT_NAME=FND ALERT_NAME=Alert name to downloa

18 - Blob

With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.

FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]

 19 - Overwrite custom definitions

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/.lct $
XX_TOP/import/.ldt CUSTOM_MODE=FORCE

20 - Load an NLS Language

FNDLOAD <APPS USR>/<APPS PWD> 0 Y UPLOAD <controlfile.lct> <datafile.ldt> \
- UPLOAD_MODE=NLS CUSTOM_MODE=FORCE WARNINGS=TRUE

21 - Migrate the role registration process from one instance to another
a. Please navigate to the path: $FND_TOP /patch/115/import/US/umxrgsvc.ldt

b. The following command can be used to download:

FNDLOAD apps/<PASSWD>@(instance name) O Y DOWNLOAD $FND_TOP/patch/115/import/umxrgsvc.lct umxrgsvc.ldt UMX_REG_SERVICES REG_SERVICE_CODE UMX

c. The following command can be used to upload:

FNDLOAD apps/<PASSWD>@(instance name) O Y UPLOAD $FND_TOP/patch/115/import/umxrgsvc.lct umxrgsvc.ldt UMX_REG_SERVICES REG_SERVICE_CODE UMX

22 - Transfer Custom Messages to another Instance
a. Download the message from the source instance.

FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND MESSAGE_NAME=PASSWORD-INVALID-NO-SPEC-CHAR

b. Move the custom LDT file (password.ldt) over to the destination instance.

c. Upload the custom message to the destination instance.

FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND CUSTOM_MODE=FORCE

23 - Download UMX Roles and Role Assignment data from one instance and upload to another.
To download from one instance:

FNDLOAD <username/pwd@sid> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afrole.lct
umxroles.ldt WF_ROLE ORIG_SYSTEM=UMX%

To upload to another instance:

FNDLOAD <username/pwd@sid> 0 Y UPLOAD $FND_TOP/patch/115/import/afrole.lct
umxroles.ldt


References:
· Oracle Applications Systems Administrator Guide - Configuration
Notes:
1. Give special attention when downloading Menus or Responsibilities.  In the case for several developers modifying Responsibilities and Menus, then be very careful.  Not being careful will mean that untested Forms, Functions, and Menus will become available in the clients Production environment besides the tested Forms, Functions, and Menus.
2. Be very careful when downloading flexfields that reference value sets with independent values for GL Segment Codes.  By doing so, downloading and extracting all the test data in GL Codes that might not be applicable for production.
3. There are several variations possible for FNDLOAD.  For example, restricting the download and upload to specific segments within Descriptive Flexfields.
4. FNDLOAD is very reliable and stable, if used properly.
5. Please test the FNDLOAD properly, so as to ensure that no unexpected data occurs.
6. As the name suggests, FNDLOAD is usedful for FND related objects.  However, in any implementation, it's required to migrate the Setups in Financials and Oracle HRMS from one environment to another.  Oracle iSetup can be used for this.  Some of the things that can be migrated using Oracle iSetup are GL Set of Books, HR Organization Structures, HRMS Employees, Profile Options Setup, Suppliers, Customers, Tax Codes & Tax Rates, Financials Setup, Accounting Calendars, Chart of Accounts, GL Currencies.