Oracle Apps: Query to Fetch Users using Responsibilities having a specific function

  select distinct fus.user_name, fr.responsibility_name
   from  FND_USER_RESP_GROUPS_DIRECT fur,
         FND_user fus,
         fnd_responsibility_vl fr
   where fur.RESPONSIBILITY_ID in  (SELECT fr.RESPONSIBILITY_ID
                                      FROM fnd_responsibility_vl fr,
                                           fnd_menus fm,
                                           fnd_compiled_menu_functions fmf,
                                           fnd_form_functions_vl ff
                                     WHERE fr.menu_id = fm.menu_id
                                       AND ff.function_id = fmf.function_id
                                       AND fmf.menu_id = fm.menu_id
                                       AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
                                       AND ff.user_function_name = :function_name)
    AND nvl(fur.end_date,trunc(sysdate)) >= trunc(sysdate)
    AND fus.USER_ID = fur.USER_ID
    AND fr.responsibility_id = fur.responsibility_id
    order by fus.user_name, fr.responsibility_name

Tags:

oracleapps

Oracle Apps: Query to fetch Responsibility associated with Function

SELECT fr.RESPONSIBILITY_NAME
  FROM fnd_responsibility_vl fr,
       fnd_menus fm,
       fnd_compiled_menu_functions fmf,
       fnd_form_functions_vl ff
 WHERE fr.menu_id = fm.menu_id
   AND ff.function_id = fmf.function_id
   AND fmf.menu_id = fm.menu_id
   AND ff.user_function_name = :function_name
   AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
   order by responsibility_name

oracleapps

Enable Personalization on OAF Page

Enable following profile options to see Personalization Link for a OAF Page
                                                                                          Value
FND: Personalization Region Link Enabled                   Yes
     
Personalize Self-Service Defn                                          Yes
     
Disable Self-Service Personal                                           No



Tags:
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer

Oracle P2P Accounting entries

In Oracle purchasing 3 different events occur
1. Enter Purchase Order: 
    No accounting takes place

2. Enter a Receipt:
    For Inventory, Asset and Expense Items:
        Dr: Inventory Receiving A/c
        Cr: Accrual A/c

3.Receiving Transaction: 
   Based on type of item here accounting entry differs
   Inventory Item:
        Dr: Inventory Valuation A/c
        Cr: Inventory Receiving A/c
   Expense Item:
        Dr: Expense A/c
        Cr: Inventory Receiving A/c
  Asset Item:
        Dr: Asset Clearing A/c
        Cr: Inventory Receiving A/c

 Oracle Payable:
 In payable 3 events occur
1. Enter Invoice:
        Dr: Accrual A/c
        Cr: Liability A/c

2.Payment against Invoice:
        Dr: Liability A/c
        Cr: Bank clearing A/c

3.Clearing (Cash Management):
        Dr: Bank clearing A/c
        Cr: Bank A/c

Oracle P2P Accounting entries

Incase below type of items one more accouting entry happens in Oracle
Inventory Item: Item issued to Dept.
       Dr: Expense A/c
       Cr: Inventory valuation

Asset Item: Asset is capitalized
       Dr: Asset A/c
       Cr: Asset clearing A/c


Tags:
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle
      

   

Learn Oracle ADF Online from Oracle

Below link contains recorded sessions that will help you get up to speed with Oracle ADF. The Oracle ADF Insider Basics series gives you introduction to the core functionality of Oracle ADF and the various layers of the framework. ADF Insider Essentials demonstrates essential skills, tips and techniques required for building ADF applications. The Oracle ADF Insider series covers advanced topics and techniques with Oracle Application Development Framework. Check back regularly for updates by experts, for experts.

http://www.oracle.com/technetwork/developer-tools/adf/learnmore/adfinsider-093342.html#a2




at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle 

PLSQL: Identify special characters in the string

Execute the below SQL statement  if returns value the string contains special character(characters apart from
those one listed in Translate statement).

SELECT *
FROM   dual
WHERE
LENGTH(REPLACE(TRANSLATE(lower('STRING'),'asdfghjklqwertyuiopzxcvbnm1234567890','                                   '),' ',''))>0




at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle

Oracle and Oracle Database

What is Oracle?
Oracle is a US based organization known for its Oracle database and ERP products. Oracle with more than 380,000 customers—including 100 of the Fortune 100—and with deployments across a wide variety of industries in more than 145 countries around the globe, Oracle offers an optimized and fully integrated stack of business hardware and software systems.
Oracle is associated with famous personality Larry Ellison. Larry" Ellison (born August 17, 1944) is an American business magnate, co-founder and chief executive of Oracle Corporation.

Oracle Customers:
Oracle has Customers in various Domains such as Banking, Automotive, Chemicals, Communications, Consumer Goods, etc.

Oracle Acquisitions:
Oracle has aggressive strategy in Acquisitions and is known for acquisitions of big and small companies around the world.Some of the famous acquistions are Sun, Peoplesoft, JDEdwards, iFlex, Logical Apps, Hyperion, etc.

Visit http://www.oracle.com/us/corporate/acquisitions/index.html for complete list

Oracle website:
www.oracle.com

What is Oracle Database?
Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files ("datafiles").[6] Tablespaces can contain various types of memory segments, such as Data Segments, Index Segments, etc. Segments in turn comprise one or more extents. Extents comprise groups of contiguous data blocks. Data blocks form the basic units of data storage.The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

Oracle database versions:
Its latest versions are Oracle Database 10g and 11gR2, 11g R1



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Oracle Apps Receivables Accounting entries

Transactions Accounting:
Accounting setups:
1. Define Receivable and Revenue Account for Transaction Type like Invoice,Credit Memo,etc.
    Navigation
    Setup>Transactions>Transaction Types

2. Define AutoAccounting which determines defaulting rules for each segment of different Accounts like
    Receivable, Revenue, Tax, etc
    Setup>Transactions>AutoAccounting

Accounting entries:
Below are Transaction Accounts that are hit for Transaction like Invoices and Credit Memos
Invoices
When you enter a regular invoice through the Transactions window,
Receivables creates the following journal entry:
DR Receivables
CR Revenue
CR Tax (if you charge tax)
CR Freight (if you charge freight

Credit Memos
When you credit an invoice, debit memo, or charge back through the
Credit Transactions window, Receivables creates the following journal
entry:
DR Revenue
DR Tax (if you credit tax)
DR Freight (if you credit freight)
CR Receivables (Credit Memo)
DR Receivables (Credit Memo)
CR Receivables (Invoice)

Receipts Accounting:
Depending upon the status of the Receipt whether its Applied, Unapplied, Applied On-Account the
Transaction entries will hit different accounts. The Accounts are defaulted based on Payment method
(Receipt Class) and Remittance Bank selected when you enter the receipt.

Accounting setups:
Navigation:
Setup>Receipts>Receipt Classes
1.Define your Receipt Class along with  Remittance Bank. Receivables uses the default Cash, Unapplied,
   Unidentified, On account, Unearned, and Earned accounts that you specified in the Remittance Banks
    window for this receipt class.

2. Remittance Method: determines status of receipt, remittance required or not Standard, No Remittance

3. Clearance Method: Determines whether clearance is required or not.
        By Automatic Clearing
        By Matching
       Directly
4. At Receipt Class the values of Remittance method and Clearance method determines whether accounting
     entries hit Remittance and Cash Clearing accounts. If these are No Remittance and Clearing is Directly
     the accounting entries don't hit Remittance and Cash Clearing accounts.

Accounting entries:
These examples assume that the receipt has a Remittance Method of No Remittance and a Clearance Method of Directly.
When you enter a receipt and its Unapplied, Receivables creates the following journal entries:
DR Cash
CR Unapplied Cash

When you fully apply a receipt to an invoice, Receivables creates the following journal entry:
DR Cash
DR Unapplied Cash
CR Unapplied Cash
CR Receivables

When you enter an unidentified receipt, Receivables creates the following journal entry:
DR Cash
CR Unidentified

When you enter an on– account receipt, Receivables creates the following journal entry:
DR Cash
CR Unapplied
DR Unapplied
CR On–Account

When your receipt includes a discount, Receivables creates the following journal entry:
DR Receivables
CR Revenue
DR Cash
CR Receivables
DR Earned/Unearned Discount
CR Receivables

At Receipt Class the Remittance and Clearance method is set as Standard and By Matching
Enter the Receipt the entry hits Receipt Confirmation with status of receipt as Confirmed
DR Receipt Confirmation
CR Receivables

Once the receipt is remitted and status becomes "Remitted"
DR Remittance
CR Receipt Confirmation

Once receipt is Cleared
Dr Cash
CR Remittance


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle

  
  

Oracle Apps: Forms Personalization Tables

Below is the list of tables that are populated when any Forms Personalization is done
FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST


Use FNDLOAD utility to move one instance to another.
Download:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPERSON.ldt FND_FORM_CUSTOM_RULES function_name="PERHRTTT"

Upload:
FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPERSON.ldt


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle

Oracle Apps: Payables Period Closing process( Payables month end closing)

To complete the close process in Oracle Apps Payables:
1. Validate all invoices.
    Run Invoice Validation Concurrent program.

2. Confirm or cancel all incomplete payment batches.

3. If you use future dated payments, submit the Update Matured Future Dated Payment Status Program.
   This will update the status of matured future dated payments to Negotiable so you can account for them.

4. Resolve all unaccounted transactions. Submit the Payables Accounting Process to account for all
    unaccounted transactions. Review the Unaccounted Transactions Report. Review any unaccounted
    transactions and correct data as necessary. Then resubmit the Payables Accounting Process to account
    for transactions you corrected. Or move any unresolved accounting transaction exceptions to another
    period (optional).

• Payables Accounting Process.
• Submit the Unaccounted Transactions Sweep Program.

5. Transfer invoices and payments to the General Ledger and resolve any problems you see on the output report: Payables Transfer to General Ledger Program.

6. In the Control Payables Periods window, close the period in Payables.Controlling the Status of Payables Periods.

7. Reconcile Payables activity for the period. You will need the following reports

• Accounts Payable Trial Balance Report (this period and last period).
• Posted Invoice Register.
• Posted Payment Register.

8. If you use Oracle Purchasing, accrue uninvoiced receipts.

9. If you use Oracle Assets, run the Mass Additions Create Program transfer capital invoice line distributions from Oracle Payables to Oracle Assets.

10. Post journal entries to the general ledger and reconcile the trial balance to the General Ledger.

You cannot close a period in Payables if any of the following conditions exist:
o Outstanding payment batches. Confirm or cancel all incomplete payment batches.
o Future dated payments for which the Maturity Date is within the period but that still have a status of Issued.
o Unaccounted transactions. Submit the Payables Accounting Process to account for transactions, or submit the Unaccounted Transaction Sweep to move any remaining unaccounted transactions from one period to another.
o Accounted transactions that have not been transferred to general ledger. Submit the Payables Transfer to General Ledger process to transfer accounting entries.


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database 

Oracle iExpense Report Tables with Policy Violation Details

Below are queries for Oracle iExpense to find out the Policy violation detail for iExpense reports.

--Expense Report Details
SELECT attribute_category,org_id
FROM   apps.ap_expense_report_headers_all a
WHERE  a.invoice_num = <Expense report number>

SELECT *
FROM   apps.ap_expense_report_lines_all
WHERE  report_header_id =<Report Header id>

SELECT *
FROM   apps.ap_exp_report_dists_all
WHERE  report_header_id =<Report Header id>

--Fetch Invoice corresponding for Expense report
SELECT *
FROM   apps.ap_invoices_all aia
WHERE  aia.invoice_num =  <Expense Report Number>


--Parameters for a Specific Expense Template used to fetch the Policy line id for Expense Line
SELECT expense_report_id
FROM   apps.ap_expense_reports_all
WHERE  report_type = <attribute_category from Expense header table>
AND    org_id = <org_id from Expense Header table>

SELECT *
FROM   apps.ap_expense_report_params_all aerp
WHERE  expense_report_id = <id from above query>
AND    prompt = <item_description of expense line>

--Policy Header and details
SELECT *
FROM   apps.AP_POL_HEADERS a
WHERE  policy_id = <POLICY ID>

SELECT *
FROM   apps.AP_POL_LINES
WHERE  policy_id = <POLICY ID>

--Policy Violations for Expense Report header and Line
SELECT *
FROM   apps.ap_pol_violations_all apv
WHERE  apv.report_header_id =< report header id>
AND    apv.distribution_line_number = <dist line id>

--Table of Policy violations without duplicate violation enteries used for accurate counts
(SELECT report_header_id, distribution_line_number, violation_type, MAX(VIOLATION_NUMBER)
 FROM   apps.ap_pol_violations_all
 GROUP BY report_header_id, distribution_line_number, violation_type)

--Find the Employee/Non Employee attendees for a Expense report line
--Employee
SELECT *
FROM   oie_attendees_all oie
WHERE  report_line_id = <Report line id>
AND    oie.employee_flag = 'N'

--Non Employee
SELECT *
FROM   oie_attendees_all oie
WHERE  report_line_id = <Report line id>
AND    oie.employee_flag = 'Y'


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database, oracle iexpense

Oracle Apps: Kill a Locked session through Toad

Query All the Locked sessions using below SQL and based on your OBJECT find the session locking it

SELECT  l.inst_id, 
    SUBSTR(L.ORACLE_USERNAME,1,8) ORA_USER,  
    SUBSTR(L.SESSION_ID,1,3) SID, 
    S.serial#, 
    SUBSTR(O.OWNER||'.'||O.OBJECT_NAME,1,40) OBJECT, P.SPID  
    OS_PID, 
    DECODE(L.LOCKED_MODE,   0,'NONE', 
    1,'NULL', 
    2,'ROW SHARE', 
    3,'ROW EXCLUSIVE', 
    4,'SHARE', 
    5,'SHARE ROW EXCLUSIVE', 
    6,'EXCLUSIVE', 
    NULL) LOCK_MODE 
    FROM    sys.GV_$LOCKED_OBJECT L 
          , DBA_OBJECTS O 
          , sys.GV_$SESSION S 
          , sys.GV_$PROCESS P 
    WHERE     L.OBJECT_ID = O.OBJECT_ID 
      and     l.inst_id = s.inst_id 
      AND     L.SESSION_ID = S.SID 
      and     s.inst_id = p.inst_id 
      AND     S.PADDR = P.ADDR(+) 
    order by l.inst_id 

Kill the session by below ALTER statement. To perform this operations you need to have full db access, if you face issue, check with your DBA.

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;  




at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database 

Oracle Apps: Install Jdeveloper 10g on Linux

Oracle Jdeveloper 10g installation steps on Linux Platform

Software: Oracle Linux 5 installed on Oracle VM on windows 7

Installing Sun SDK 1.4.2_03 for Linux:
For JDeveloper to run successfully, you must install Java SDK release 1.4.2_03 (or later releases). Perform the following steps:
1. Download the self-extracting binary file of version 1.4.2_03 (or later release) of the Sun J2SE for Linux  to your Linux machine.

oracle website for downloading JAVA SDK:
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase14-419411.html#j2sdk-1.4.2_30-sol-JPR

2. Follow the instructions provided on the JavaSoft Web site to install the Java SDK. Note the install location when it is complete.Execute below command using root user in the directory where you downloaded the file
       ./j2sdk-1_4_2_19-linux-i586.bin

Note:
preferably install it in  /usr/java, I got it installed it in /media/sf_ebusiness/j2sdk1.4.2_19


Installing JDeveloper
To install JDeveloper, perform the following steps:
1. Download Oracle10g JDeveloper 9.0.5.1 from http://otn.oracle.com/software/products/jdev/index.html.

2. Open a terminal window and execute the following:
               cd /home/oracle
               mkdir -p jdevoaf
               cd jdevoaf
               unzip <path to zip file>/jdev9051.zip
                  
The JDeveloper software installation is complete. The software now must be configured.


Configuring JDeveloper and SDK
1. Using the text editor gedit or your editor of choice, open the file /home/oracle/jdevoaf/jdev/bin/jdev.conf .

2. Find the SetJavaHome parameter. Change
      # SetJavaHome c:\jdk1.4.2_03
                          to the location where the Java SDK was installed.
      Example:
        SetJavaHome /media/sf_ebusiness/j2sdk1.4.2_19

3. Save the jdev.conf file and exit gedit .


Modifying Your .bash_profile
Now that you have installed JDeveloper, you need to update the /home/oracle/.bash_profile and change your path accordingly. Perform the following steps:

1. Applications>System tools>File Browser
    Because the .bash_profile is hidden you need to enable show hidden files in the browser
    For this tick View>Show hidden files
    Now the file will be visible double click to edit it.

2. Make sure the PATH includes the location for JDeveloper and the Java SDK. Modify the file as below

           JDEV_HOME=/home/oracle/jdevoaf        
           PATH=$PATH:$JDEV_HOME/jdev/bin:/media/sf_ebusiness/j2sdk1.4.2_19;
           export PATH
           export JDEV_HOME

3. Save the .bash_profile file

4. You now need to source the file. Open a terminal window and execute the following commands:
          cd
          . ./.bash_profile


Configuring OC4J
To deploy applications in JDeveloper, you must configure OC4J. Perform the following steps:
1. From a terminal window, execute:                        
        cd /home/oracle/jdevoaf/j2ee/home
        java -jar oc4j.jar -install
                             
    At the prompt, enter the password oracle .

Modifying Permissions of Files in Linux
You must carry out a few tasks before running JDeveloper. Perform the following steps:1.  To set the proper permissions, execute the following commands from your terminal window:
chmod -R g+r /home/oracle/jdevoaf/
chmod +x /home/oracle/jdevoaf/jdev/bin/jdev
chmod +x /home/oracle/jdevoaf/jdev/bin/ojc
chmod +x /home/oracle/jdevoaf/jdev/bin/start_oc4j
chmod +x /home/oracle/jdevoaf/jdev/bin/stop_oc4j
chmod -R g+w /home/oracle/jdevoaf/j2ee/home/application-deployments
chmod -R g+w /home/oracle/jdevoaf/j2ee/home/applications
chmod -R g+w /home/oracle/jdevoaf/j2ee/home/config


Adding an Icon to Your Panel
To create an icon on your panel in JDeveloper, perform the following steps:1. Right-click on the desktop (not in the toolbar, an icon, or a window). Select New Launcher from the drop-down menu.

2.  In the Create Launcher Applet window, enter the following and then click No Icon.

           Name: JDeveloper 10g 9.0.5.1
           Comment: JDeveloper 10g 9.0.5.1
           Command: /home/oracle/jdevoaf/jdev/bin/jdev

3.  Enter /home/oracle/jdevoaf/jdev/bin/ in the directory field and select coffee.png .
     Then click OK.

4.  Click OK again to create the icon on the panel.


Running JDeveloper
To run JDeveloper, perform the following steps:
1. Click the icon that you just created in the panel.

2. The first time you run JDeveloper, you may get a message stating that your jdevhome directory does not exist and asking if you want to create it. Click Yes.


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database 

Oracle XML Publisher Report: An Invalid character was found in text content

The following Error can be observed when Oracle XML Report data can contain foreign characters like Norwegian æøå, or french êèé. The  Output processor fails to process the data and the report logs shows follwoing error

"An Invalid character was found in text content"

Solution:
1. Find out the encoding that has been setup at the SITE leve using this query

SELECT po.user_profile_option_name, po.profile_option_name "NAME"
, DECODE (TO_CHAR (pov.level_id), '10001', 'SITE'
, '10002', 'APP', '10003', 'RESP', '10004', 'USER', '???') "LEV"
, DECODE (TO_CHAR (pov.level_id)
, '10001', '', '10002', app.application_short_name
, '10003', rsp.responsibility_key, '10004', usr.user_name, '???')
"CONTEXT"
, pov.profile_option_value "VALUE"
FROM apps.fnd_profile_options_vl po, apps.fnd_profile_option_values pov
, apps.fnd_user usr, apps.fnd_application app, apps.fnd_responsibility rsp
WHERE (po.profile_option_name = 'FND_NATIVE_CLIENT_ENCODING')
AND pov.application_id = po.application_id AND pov.profile_option_id =
po.profile_option_id
AND usr.user_id(+) = pov.level_value AND rsp.application_id(+) =
pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value AND app.application_id(+)
= pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE"

2. Based on the above value setup in the PROFILE, set the XML TAG LINE as the first line of the Program output.

<?xml version="1.0" encoding="UTF-8"?>

<?xml version="1.0" encoding="UTF-16"?>
<?xml version="1.0" encoding="ISO-8859-1"?>

 <?xml version="1.0" encoding="windows-1252"?>

Also if none of the above options works try to use REPLACE function and remove the Special characters from the XML Output.

So your output should look like this

<?xml version="1.0" encoding="UTF-8"?><REPORT>
<REC><GL_PERIOD>01-12</GL_PERIOD><FISCAL>2012</FISCAL><QT>Q4-12</QT></REC>
</REPORT>



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database 

Oracle XML Publisher Report: Number/Date format in Excel

Leading zero issues/ Number Formatting while opening in Excel
In case of Oracle XML Publisher report which needs to be opened in Excel, Excel tends to manipulate with the formats of Number and Date. This is really annoying as all the formatting that has been achieved through the Program or Formatting tags in Template don't seem to work.

A simple solution for this problem is to override the Excel formatting, by enclosing your XML tag in the template with below XML code

Before:
<?STAT?>

After:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?STAT?></fo:bidi-override>








at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Oracle Apps: R12 Payment Document Setup

Following steps are needed to Create a New Payment Format in Oracle Payables R12 and associate it with Payment Document.

Step 1: Create XML Template

Payables Manager > Setup > Payment > Payment Administrator > Formats > XML Publisher Format Templates

    Click 'Create Template'
        Enter valid name, Code, Application (= Payments)
        Type = RTF
        Data Definition = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
        Default File Language = English
        Default File Territory = UNITED STATES
       
    Upload your RTF File

Step 2: Create Payment Format

Payables Manager > Setup > Payment > Payment Administrator > Formats > Formats
    Select Type = Disbursement Payment Instruction

    Click on Create
        Enter Code, NameType = Same as above
        Data Extract = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
        XML Publisher Extract = XML Template name created in Step 1

Step 3: Create Payment Document

Payables Manager > Setup > Payment > Bank Accounts

    Query up your Bank Name. It is assumed that your Bank has already been setup in AP.
    Select the Bank Account and click on Manage Payment Documents.
    Click on Create

    Enter:
    Name: XXXX Check Payment Document
    Paper Stock Type: Blank Stock or Prenumbered Stock
    Format: Enter Format defined in step 2
    First Available Document Number:
    Last Available Document Number
    Enter any other information that you may need.
    Click Apply

Step 4: Create Payment Process Profile

Payables Manager > Setup > Payment > Payment Administrator > Payment Process Profiles

    Click on Create
    Enter:
    Code
    Name
    Payment Instruction Format: As defined in Step 2
    Processing Type: Printed
    Payment Completion Point: When the Payment Instruction is Formatted
    Default Payment Document: Document created in Step 3
    Payment File: Send to Printer
    Check the box ‘Automatically Print After Formatting’ (Note: You mau choose not to check this box initially – it will help in testing)
    Default Printer: Valid oracle printer name

    Click Apply



For making Payments use the above created Payment Process profile


at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application, 
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database
.

Oracle Apps: Install Jdeveloper on Oracle Linux on VM

Below set of instructions are to Install Jdeveloper on Oracle Linux on Oracle VM. 

1. Download Oracle Jdeveloper ISO File  from
    http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html

2. Mount the ISO File and Navigate to Shared Folder(/media/<mount folder>) on  Linux VM
    and execute below command
    ./jdk-6u30-linux-x64.bin

3. Once installation is successful to start the Jdevloper execute below command
    cd /home/oracle/Oracle/Middleware/jdeveloper/jdev/bin
     ./jdev



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Oracle Apps: frm-15004 error while parsing

Oracle Apps error: frm-15004 error while parsing

Cause:
While creating a link between Master and Detail Block when the join details are provided
this error pop's up.

eg:
Master Block:  MASBLK

Detail Block:  DTLBLK

common column: MAP_ID

all the below join conditions I got the frm-15004 error

    MASBLK.MAP_ID = DTLBLK.MAP_ID

    MAP_ID = MAP_ID

    :MASBLK.MAP_ID = :DTLBLK.MAP_ID



Solution:

1. Go to Master and Detail Block Property Palette and check if the below properties have
   correct values
  
   Query Data Source Type:
  
   Query Data Source Name:
  
   This may not be required if your Blocks are based on views
  
2. Change the name of the Item in Detail block from MAP_ID to DTL_MAP_ID and now provide
   the below join condition
  
   MAP_ID = DTL_MAP_ID



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Display Distinct Values in Oracle Apps Value Set

How to display distinct values in Oracle Apps valueset, below are possible options

1) Create a view to fetch distinct values from the TABLE and use the VIEW in the value-set

3) Write your query in such a way that it gives you a distinct value. You can make use of ROWID to meet the requirement.

  Example.      SELECT date_col
                      FROM   xx_custom_table xpr
                      WHERE  rowid = (select max(rowid) from  xx_custom_table xpr1
                                                    where xpr.date_col =xpr1.date_col)





at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

SQL LOADER

SQLLOADER is a great utility for loading data into Oracle Tables. But working with SQLLOADER can have its own set of challenges, some of the common requirements and there solutions are listed below.

1. Populating record number in SQL LOADER:
    This can be really helpful if you need to populate the sequence of records as they appear in the data file.
    SQL Loader doesn't neccessarly insert data the way it comes in datafile, using RECNUM can help.
    Record_ID RECNUM

2. Populating who columns in SQL LOADER
    ,CREATION_DATE        "TRUNC(SYSDATE)"     
    ,CREATED_BY           "UID"     
    ,LAST_UPDATE_DATE     "TRUNC(SYSDATE)"     
    ,LAST_UPDATED_BY      "UID"     

3. Populating request id and Filename (Input Parameters) in SQL LOADER
    SQLloader doesn't populate the request id, File name or other input parameters directly through
    control file. Even using the below statement doesn't work

    REQUEST_ID               "fnd_global.conc_request_id"

    So write a Wrapper Program and trigger SQLOADER through the wrapper and then excute a Update
    statement to update the required fields. Below is sample code
   
    -- Call SQL*Loader program that load the data from csv file
    l_conc_request_id := fnd_request.submit_request
                                               ('XXX',
                            'XXSQLLDR',
                            '',
                            '',
                            FALSE,
                            l_chr_dir_path||'/IN/'||in_file_name);

    fnd_file.put_line( fnd_file.log,'Request id: '||l_conc_request_id );

    IF l_conc_request_id != 0
    THEN

        COMMIT;

        l_call_status :=  fnd_concurrent.wait_for_request
                                ( l_conc_request_id,
                                  3,        -- interval
                                  0,        -- max_wait
                                  l_phase,
                                  l_status,
                                  l_dev_phase,
                                  l_dev_status,
                                  l_message
                                 );

    END IF;

    --Check Program completion status
    IF  (l_dev_phase = 'COMPLETE'
        AND l_dev_status = 'NORMAL')
    THEN
        fnd_file.put_line( fnd_file. 'Program Completed Successfully');

        --Update the Staging table
        UPDATE xx_stg_table
           SET filename = in_file_name,
               request_id= l_conc_request_id
        WHERE  status = 'NEW'
        AND    request_id IS NULL;

        COMMIT;

    ELSE
        fnd_file.put_line( fnd_file.log, 'Program did not Completed Successfully: '||l_dev_status);       

    END IF;


4. Populate a sequence value in SQL LOADER
     LOAD DATA
       INFILE *
       INTO TABLE load_db_seq_positional
       (seq_number "db_seq.nextval"
        data1 POSITION(1:5),
        data2 POSITION(6:15),
       )

5. Using functions in SQL LOADER

    LOAD DATA
    INFILE 'xyz.dat'
    BADFILE 'xyz.bad'
    LOG xyz.log
    INSERT INTO TABLE empmast
    (emp_no POSITION(1:6) INTEGER,
    emp_name POSITION(7:31) CHAR "initcap(:emp_name)")

6. Assigning constants in SQL LOADER

    LOAD DATA
    INFILE 'xyz.dat'
    BADFILE 'xyz.bad'
    LOG xyz.log
    INSERT INTO TABLE empmast
    (emp_no POSITION(1:6) INTEGER,
    emp_name POSITION(7:31) CHAR,
    alive CONSTANT "Y")
   
7. Fixed position file in SQL LOADER

    LOAD DATA
    INFILE filename
    REPLACE
    INTO TABLE temp_data
    (
     field1    POSITION (1:4)     INTEGER EXTERNAL,
     field2    POSITION (5:6)     INTEGER EXTERNAL,
     field3    POSITION (7:12)    INTEGER EXTERNAL,
     field4    POSITION (13:42)   CHAR,
     field5    POSITION (43:72)   CHAR,
     field6    POSITION (73:73)   INTEGER EXTERNAL,
     field7    POSITION (74:74)   INTEGER EXTERNAL,
     field8    POSITION (75:75)   INTEGER EXTERNAL,
     field9    POSITION (76:86)   INTEGER EXTERNAL
    )

8. Comma delimited file in SQL LOADER

    LOAD DATA
    INFILE *
    INTO TABLE stg_table
    REPLACE
    FIELDS TERMINATED BY ','
    (
     image_id   INTEGER(5),
     file_name  CHAR(30),
     field1,
     field2
        )
9. Command SQL LOADER
  sqlldr userid=ora_id/ora_passwd control=control_file_name.ctl data= data.csv

10. Populating master and detail record using SQL LOADER:
      Let say you have a data file with mutliple groups of data for Master and details record as below
    
     CONTACT REC1
     FIRST NAME LAST NAME1
     FIRST NAME LAST NAME2
     CONTACT REC2
     FIRST NAME LAST NAME21
     FIRSTNAME  LAST NAME22

    SQL Loader never process the data the sequence it comes in data file, but there is a workaround
    all you need to do is use SQL Loader command line parameter ROWS =1, this will make SQLLoader commit for each record and process records in the data file in the same sequence.

10.  Skip Loading of Columns SQLLOADER
FILLER columns are used to skip columns/fields in the load file, ignoring fields that one does not want. Look at this example:

LOAD DATA
TRUNCATE INTO TABLE T1
FIELDS TERMINATED BY ','
( field1,
  field2 FILLER,
  field3
)

BOUNDFILLER

LOAD DATA
INFILE *
TRUNCATE INTO TABLE sometable
FIELDS TERMINATED BY ","  trailing nullcols
(
 c1,
 field2 BOUNDFILLER,
 field3 BOUNDFILLER,
 field4 BOUNDFILLER,
 field5 BOUNDFILLER,
 c2     ":field2 || :field3",
 c3     ":field4 + :field5"
)

Oracle Apps: Working with Oracle Forms

Below are common points we need to incorporate while working on Oracle Forms

LOV for Date and Date time Fields

1. Make the field as "Text Item" and set the LOV to "ENABLE_LIST_LAMP"

2. Set validate from the List property for the Item to "No"

2. Create a Trigger "KEY-LISTVAL" for the Item with following code
    
      calendar.show;
     
      By default, the Calendar shows the month of the value in the date field
      (if a value exists) upon first opening. If no specific date is supplied, the
      Calendar shows the current month.
     
      calendar.show([first_date]);
     

Set value of item/primary key using Sequence

:SEQUENCE. XXGL_ADP_SECURITY_HDR_SEQ.NEXTVAL in Intial value of the Item


Populate non database fields during Query in form

1. Create post query trigger on the Datablock

2. Set the fields by writing the code, in below example Employee number and name are non database
   fields which are populate based on the value of field person id(Database field)
  
    PROCEDURE post_query is
    begin

        --Get the Person details
        SELECT ppf.EMPLOYEE_NUMBER ,
               ppf.FULL_NAME
               into    
               :MAIN.EMP_NUM,
               :MAIN.EMP_NAME
        FROM   per_all_people_f ppf
        WHERE  person_id =:MAIN.person_id
        AND    rownum =1;
       
        --To prevent status change of the block
        SET_RECORD_PROPERTY( :SYSTEM.TRIGGER_RECORD,'BLOCKNAME', STATUS,
QUERY_STATUS);

    end post_query;     
     
 
Display Messages in Oracle Forms:

--String Message
fnd_message.set_string ('SERial Num has been repaired more than 3 times ');
fnd_message.show ();

--Dictonary Message
FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
FND_MESSAGE.Error;

--Debug Messsage
FND_MESSAGE.DEBUG('ERROR');


Validate if the Record entered is a Duplicate Record

1. Create a ON-COMMIT trigger at form level and write below logic based on your requirement
   PROCEDURE on_commit is
    CURSOR c_person
    is
    SELECT rowid row_id,
           hdr_id
    FROM   STAGGING_TBL
    WHERE user_name =:BLOCK.user_name
    AND   nvl(person_id,'-999') = nvl(:BLOCK.person_id,'-999');
  
  BEGIN
         --Validate if there is existing record for Oracle user
         FOR c_preson_rec IN c_person
         LOOP
        IF c_preson_rec.row_id <> :BLOCK.row_id
        THEN
            FND_MESSAGE.Set_STRING('Record exist for this Oracle User');
            FND_MESSAGE.show;
            Raise FORM_TRIGGER_FAILURE;                 
        END IF;
            
         END LOOP;
  
  END;
        

Looping logic to perform validations
curr_record  := :SYSTEM.CURSOR_RECORD;
curr_item    := :SYSTEM.TRIGGER_ITEM;   
BEGIN
    go_block('BLOCK');
    First_Record;
    LOOP

        IF :BLOCK.PERSON_ID = person_id
        AND curr_record <> :SYSTEM.CURSOR_RECORD
        AND ( :BLOCK.START_DATE >= start_date OR :BLOCK.end_DATE <= end_date
              OR :BLOCK.END_DATE >= start_date OR :BLOCK.end_DATE <= end_date)
        THEN
            FND_MESSAGE.Set_STRING('Employee has mutliple records with Overlapping Dates');
            FND_MESSAGE.show;
               Raise FORM_TRIGGER_FAILURE;

        END IF;

        IF :System.Last_Record = 'TRUE'
        THEN
            EXIT;

        END IF;

    END LOOP;   



    Execute_Query;
    Go_Record( curr_record);
    go_item(curr_item);

END;

Querying on Non Database fields in Oracle Forms
1.  Sample Block :  EMPCCLOCOVD
               employee_name    -   Non database field.
               employee_number  -   Non database field.
               person_id        -   Database, hidden field


2. Add a Pre-Query trigger on the block , where it contains a non database fields for querying.

3. Sample code for the Pre - Query trigger :
  PROCEDURE pre_query IS
        l_where       VARCHAR2(250) := 'Where 1 = 1';
  BEGIN
      l_where :=  l_where || 'AND person_id IN (SELECT person_id FROM per_all_people_f ppf '
               ||' WHERE EMPLOYEE_NUMBER like '''||'%'||:EMPCCLOCOVD.EMP_NUM||'%'')'
               ||' AND   FULL_NAME like '''||'%'||:EMPCCLOCOVD.EMP_NAME||'%'')';

        SET_BLOCK_PROPERTY('EMPCCLOCOVD',DEFAULT_WHERE,l_where);
  END pre_query;


POPULATE WHO COLUMNS in Oracle Forms:

Write the below code in PRE-INSERT, PRE-UPDATE at DATABLOCK LEVEL

FND_STANDARD.SET_WHO;

Datablock Order by Non database Column
I need my header block order by NON DATABASE Column COUNTRY below is the value
that I need to have in ORDER BY Clause of the datablock

(SELECT ftt.territory_short_name from fnd_territories_tl ftt where   ftt.TERRITORY_CODE = country_code)

Oracle Forms - internal error 60604

Issue:  
Working on Forms you have created a Program unit and your trying to compile it and it
results in below error

    Error 801 at line 0,column 0
    internal error [[60604]]

Solution:
This error is caused when u make some changes in the form after either changing the table design at the back end (database block) or the connectivity to the server is disconnected for some time and u reconnect and compile.

1. Save the Form and Close the Form Builder session
2. Reopen the session, connect to Database and Open your Form
3. Navigate to Program>Compile>All and compile all objects.

Starting your Oracle Apps Instance

The directories used below are based on my environment settings on the Laptop.
Please modify accordingly

Start database
cd /home/oracle/u01/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_oraerp
./addbctl.sh start

Start Listener
./addlnctl.sh start VIS

Start Instance
cd /home/oracle/u01/VIS/inst/apps/VIS_oraerp/admin/scripts
./adstrtal.sh

All the commands should exit with status 0 otherwise check the corresponding log files for any errors



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Query to find Responsibility for the Concurrent Program

SELECT frt.responsibility_name,
               frg.request_group_name,
               frg.description
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   frg.application_id = frgu.application_id
 AND   fcpt.source_lang = USERENV('LANG')
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   frs.responsibility_id = frt.responsibility_id
 AND   frt.source_lang = USERENV('LANG')
 AND   frs.request_group_id = frg.request_group_id
 AND   frs.application_id = frg.application_id
 AND   fcp.concurrent_program_name = <shortname>
 AND   fcpt.user_concurrent_program_name LIKE <User concurrent program>



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Oracle Apps R12 MOAC and its impact

Oracle R12 MOAC and its impact


Setup the Security Profile:
1.Create a Security Profile in HRMS Responsibility
    HRMS Manager>Security>Profile
    In this setup specify different Operating Units that you want to Access.

2.Run the Security List Maintenance
    This is a required step when you create a new Profile or modify existing one.


3.Setup the MO: Security Profile value to above created security profile.
     This "MO: Security Profile" Profile option has to be setup at the responsibility level.This will ensure that
     Responsibility will have access to the data of all the Operating units under the Security Profile.


Important profile option

MO: Security Profile:

MO: Operating Unit:
This comes from 11i and is still valid only its evaluated, if there is no value setup at MO:Security
Profile.

MO: Default Operating Unit
If the security profile is setup to access multiple operating units, this requires users to select
the Operating Unit every time user access the Sub ledger pages. To avoid this the Default Operating Unit profile can be setup.

How MOAC impacts the way we work in TOAD

11i
To set the Org id in TOAD
1. Get the Org_id from HR_ORGANIZATION_UNITS

2. In toad execute the below code
        begin
        fnd_client_info.set_org_context(&org_id);
        end;


To set the responsibility context in TOAD
1. Get the User id, Responsibility Id and Application id from Front end
    Help>Diagnostic>Examine and select BLOCK as "$PROFILES$" and then get the respective IDS

2. Using the IDs execute the below code in TOAD

      begin
      FND_GLOBAL.APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in
      number);
      end;

R12:
To set the Org id in TOAD
1. Get the Org_id from HR_ORGANIZATION_UNITS

2. In toad execute the below code
    --Sets the 201 as single Org id
    exec MO_GLOBAL.SET_POLICY_CONTEXT('S',201);
    Pass a value "S" in case you want your current session to work against Single ORG_ID
    Pass a value of "M" in case you want your current session to work against multiple ORG_ID's

To set the responsibility context and initiate MOAC in TOAD
1. Get the User id, Responsibility Id and Application id from Front end
     Help>Diagnostic>Examine and select BLOCK as "$PROFILES$" and then get the respective IDS

2. Using the IDs execute the below code in TOAD

       a. exec  FND_GLOBAL.INITIALIZE
          This will set your responsibility id, user_id etc

       b. call MO_GLOBAL.INIT('AR')
           This will read the MO profile option values for your responsibility/user, and will initialize the
           Multi Org Access.
        
MOAC for table access
In 11i _ALL Tables where non Org specific and Org specific views were created on these tables.
But in R12 its different concept
  a. For the table AP_INVOICES_ALL a synonym  AP_INVOICES_ALL is created in APPS.

  b. Also another synonym AP_INVOICES is created which refers to AP_INOICES_ALL.

  c. A Row Level security is applied to AP_INVOICES, using package function
      MO_GLOBAL.ORG_SECURITY.
     This can be double-checked by running SQL select * from all_policies where
      object_name='AP_INVOICES'

e. The effect of this policy is that,whenever you access AP_INVOICES, Oracle RLS will
    dynamically append WHERE CLAUSE similar to below

    SELECT * FROM AP_INVOICES
    WHERE EXISTS (SELECT 1 FROM mo_glob_org_access_tmp oa WHERE oa.organization_id =
     org_id)



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Oracle Apps: LDT Commands

LDT Commands for Upload and Download of Programs:

Download
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXMLBEX.ldt PROGRAM APPLICATION_SHORT_NAME="XXTTY" CONCURRENT_PROGRAM_NAME="XXMLBEXPGAL"


Upload:
FNDLOAD apps/<appspwd> O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXMLBEX.ldt

--------------------------------------------------------------------------------------------------
Request group download for Specific Program
Download:
FNDLOAD apps/<appspwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXMREQ.ldt REQUEST_GROUP REQUEST_GROUP_NAME="All Project Billing Programs" UNIT_NAME="XXMLBEGAL"

--------------------------------------------------------------------------------------
Request Group (NEW request group creation)

Download:
FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_XXX_DTC_Request_Gr.ldt REQUEST_GROUP REQUEST_GROUP_NAME="ALL Programs" APPLICATION_SHORT_NAME="XX"

Upload:
FNDLOAD apps/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_XXX_DTC_REQUEST_GR.ldt

---------------
Oracle Menu (New Menu)

Download:
FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXX_DTC_GLOBAL_MENU.ldt MENU MENU_NAME="XXX_DTC_GLOBAL"

Upload:
FND_TOP/bin/FNDLOAD apps/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXX_DTC_GLOBAL_MENU.ldt

--------------
Oracle Responsibility (New Responsibility)

Download:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XXX_DTC_GLOBAL_RESPO.ldt FND_RESPONSIBILITY RESP_KEY="XXX_DTC_GLOBAL"


Upload
FNDLOAD apps/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXX_DTC_GLOBAL_RESPO.ldt

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

Lookup Type:

DownLoad:
FNDLOAD apps/pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_OA_STATUTORY_ACCT_MAPPING.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XX" LOOKUP_TYPE="XX_OA_STATUTORY_ACCT_MAPPING"

Upload:
FNDLOAD apps/<Pwd> 0 Y UPLAOD $FND_TOP/patch/115/import/aflvmlu.lct XX_OA_STATUTORY_ACCT_MAPPING.ldt

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

Value set only:

Download:
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

Upload:
FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

Value set with values:

Download:
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

Upload:
FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

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

Descriptive flex field

Download:
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_OA_EXP_RPT_SEG_MAP_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="FND_COMMON_LOOKUPS" DESCRIPTIVE_FLEX_CONTEXT_CODE="XX_OA_EXP_RPT_SEG_MAP"

Upload:
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_OA_EXP_RPT_SEG_MAP_DFF.ldt


----------------------------------------------------
Concurrent Program

Download:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXOAGLTSIMP_CONC.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XXOAGLTSIMP"

Upload:
FNDLOAD <apps>/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXOAGLTSIMP_CONC.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XXOAGLTSIMP"

Conc program assignment to Request Group

Download:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXOAGLTSIMP_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME=" DTC Global" APPLICATION_SHORT_NAME="XX" REQUEST_GROUP_UNIT UNIT_NAME="XXOAGLTSIMP"

Upload:
FNDLOAD <apps>/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXOAGLTSIMP_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME=" DTC Global" APPLICATION_SHORT_NAME="XX" REQUEST_GROUP_UNIT UNIT_NAME="XXOAGLTSIMP"
FNDLOAD <apps>/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_CW_EVAL_NOTIFY_CONC_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME="PO All Reports" APPLICATION_SHORT_NAME="PO" REQUEST_GROUP_UNIT UNIT_NAME="XX_CW_EVAL_NOTIFY"


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

Forms:

Download
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFRMNAME.ldt FORM APPLICATION_SHORT_NAME="PN" FORM_NAME="XXFRMNAME"

Upload:
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct XXFRMNAME.ldt

Functions:

Download
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFUNNAME.ldt FUNCTION FUNC_APP_SHORT_NAME="PN" FUNCTION_NAME="XXFUNNAME"

Upload
FNDLOAD apps/apps O Y UPLOAD @FND:patch/115/import/afsload.lct XXFUNNAME.ldt

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

Form Personalization

Download:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"

Upload:
FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXGLJOURNALIMP.ldt

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

FND Load for DFF Context

FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXAPdff_CUST_DECL.ldt DESC_FLEX APPLICATION_SHORT_NAME="SQLAP" DESCRIPTIVE_FLEXFIELD_NAME="AP_INVOICES" DFF_CONTEXT DESCRIPTIVE_FLEX_CONTEXT_CODE="CUST_DECL"

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

FND Load for Messages

Donwload:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='ICX' MESSAGE_NAME=XX_ICX_POR_LIFECYCLE_PAY_TIP
or for all messages
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ALL_GMS_MESSAGES_00.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='XXGMS'

Upload:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt

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

FND Load for Alert

Download
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct Email_to_requestes_for_PO_Receipt.ldt ALR_ALERTS APPLICATION_SHORT_NAME='PO' ALERT_NAME=' Email to requestes for PO Receipt'

Upload
FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct Email_to_requestes_for_PO_Receipt.ldt

-----------------------------------------------------------------
XML Publisher Data Definition and Templates

a) To download all Templates defined for a particular Data Definition
FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFINITIONCODE]


b) To download for a particular Template and Data Definition
FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFSHORTCODE] TMPL_APP_SHORT_NAME=[APPSHORTNAME] TEMPLATE_CODE=[TEMPLATECODE]