Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Applications Forum Guide (Please read this before posting)  () 2 Votes
Oracle Applications Forum Guide [message #295022] Mon, 21 January 2008 02:58
vamsi kasina
Messages: 2089
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Please read this till end before posting questions in Oracle Fusion Apps & E-Business Suite Forum.
********************************************************************************************************************
PLEASE DON'T PASTE THE CONTENT FROM METALINK IN THE FORUM POSTS. WHEREVER YOU CAN USE NOTE ID OR LINK, PLEASE DO SO.
********************************************************************************************************************
1. Post the version of 11 / 11i / R12.
2. Post the exact error message along with the clear reproduction steps, if you get any.
3. Have you searched Metalink(for the bugs), etrm(for the information on objects) and Wiki?
OraFAQ Articles
Some other helpful sites:
http://www.oracleappshub.com/
http://apps2fusion.com/apps/
http://oracleappstechnicalworld.blogspot.com/
http://oraclecs.com/financials-for-r12/
4. Check the Oracle Technical Manuals for the Product User GuidesQuote:
http://www.oracle.com/technology/documentation/applications.html
11 -> http://download.oracle.com/docs/cd/A60725_05/r11_doc.htm
11i -> 11.5.10 and 11.5.10.2
R12 -> http://download.oracle.com/docs/cd/B34956_01/current/html/docset.html
12.1.3 -> http://download.oracle.com/docs/cd/B53825_07/current/html/docset.html
In the above links
5. For the differences between versions, check "Oracle Applications Product Update Notes"
For R12, Release Content Documents (RCD) Note:404152.1
For 12.1.1, Release Content Documents (RCD) Note:561580.1
For 12.2, Release Content Documents (RCD) Note:1302189.1
6. For Application Object Library related topics like Concurrent Programs, Executables, Responsibilities, etc, check "Oracle Applications Developer's Guide" and "Oracle Applications Flexfields Guide".

7. For FNDLOAD, have a look at link1, link2 and link3.
8. Not able to see the profile option values from back end SQL tools? Have a look at link1 and link2?
9. Is count(*) giving 0 rows? (Or) Isn't SELECT giving desired output?
Are you using MO view like ap_invoices?
  For all org_ids' data      -> Use ap_invoices_all
  For specific org_id's data -> 11i -> dbms_application_info.set_client_info(&org_id);
                                R12 -> mo_global.set_policy_context('S',&org_id);
Are you using VPD enabled tables like xla_transaction_entities?
  For specific application's data -> xla_security_pkg.set_security_context(&appl_id);
  For all applications' data      -> xla_security_pkg.set_security_context(602);
                                    (Or) Use xla.xla_transaction_entities
                                    (Or) Use xla_transaction_entities_upg
10. Have access to the code? If so, go through the code yourself and find out the issue.
   SQL Files / Packages   -> $PROD_TOP/patch/115/sql
   SQL*Plus Reports       -> $PROD_TOP/sql
   Views/Tables (odf)     -> $PROD_TOP/patch/115/odf
   Tables/Indexes (xdf)   -> $PROD_TOP/patch/115/xdf
   Forms (fmb)            -> $PROD_TOP/forms/US
   Reports (rdf)          -> $PROD_TOP/reports/US
   Libraries (pll)        -> $PROD_TOP/resource
   Source Files           -> $PROD_TOP/src
   Java Files             -> $PROD_TOP/java
   OAF Pages              -> $PROD_TOP/mds
   lct Files (FNDLOAD)    -> $PROD_TOP/patch/115/import
   ldt Files (FNDLOAD)    -> $PROD_TOP/patch/115/import/US
   Data Templates (rtf)   -> $PROD_TOP/patch/115/publisher/templates/US
   Data Definitions (xml) -> $PROD_TOP/patch/115/publisher/defs
   Business Event Subscriptions (Workflow) -> $PROD_TOP/patch/115/xml/US
11. How to get the version of the files?
For Packages:
   SELECT text
   FROM   all_source
   WHERE  name = Upper('&package_name')
   AND line = 2;
For Other Files:
   SELECT af.subdir, 
          af.filename, 
          afv.version 
   FROM   ad_files af, 
          ad_file_versions afv 
   WHERE  af.file_id = afv.file_id 
   AND af.filename = '&file_name'
   ORDER BY afv.creation_date DESC;
12. How to get the FND Debug Log?
For R12, Refer the Note 787727.1
For 11i, if the Global Accounting Engine (AX) has implemented (Note 121721.1), then refer Note 231649.1 for AX Trace.

By
Vamsi

[Updated on: Fri, 23 August 2013 02:33]

Report message to a moderator

Previous Topic: Defaulting / Validating a value on the WEB ADI Template
Goto Forum:
  


Current Time: Sun Apr 20 11:16:08 CDT 2014

Total time taken to generate the page: 0.07896 seconds