Members   Search   Help    Register    Login   Home
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: 1597
Registered: October 2003
Location: Hyderabad, India
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, 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/
4. Check the Oracle Technical Manuals for the Product User Guides
Quote:
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
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
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
   Views (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
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';
12. How to enable the FND Debug Log to analyze the issue yourselves?
Check the Note 787724.1
If AX(Global Accounting Engine - 11i) is enabled (Note 121721.1), then the Note 231649.1 can be used to enable the AX Trace.

By
Vamsi

[Updated on: Sun, 07 June 2009 05:57]

Report message to a moderator
Previous Topic:I want to run a request set from pl/sql for create invoice
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 7 23:24:06 CST 2009

Total time taken to generate the page: 0.40221 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.