Oracle Apps Forum Guide [message #654638] |
Mon, 08 August 2016 05:28 |
|
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
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/
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
12.2 -> http://docs.oracle.com/cd/E26401_01/index.htm 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
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
|
|
|