When you try to access forms personalization menu option, you are getting error
"Function not available to this responsibility...."
Cause:
Profile set to Utilities:Diagnostics to No.
Solution:
Set the above profile to Yes
The above profile controls access to following Diagnostics submenu items
- Examine, Trace, Debug, Properties, and Custom Code.
For more details, refer to Oracle E-Business Suite System Administrator's Guide - Configuration and Controlling Access to the Oracle Forms-based Applications Diagnostics Menu
Issue: Unable to see custom personalizations in any form, though they are present in the table, and seeded personalizations are viewable. The issue could be because of profile "FND: Enable Industry Editing" set to Yes. This is the setting that the Oracle Localizations development uses to create Oracle delivered personalizations. Oracle delivered personalizations must have a RULE_KEY. Solution: Set the profile "FND: Enable Industry Editing" to No and re-test.
1. Please check "GL Set of Books Name" profile for the responsibility in which you are receiving, from System Administrator responsibility. It should be set to the correct Set of Books name 2. Ensure the GL period is open for the accounting period in question using: Purchasing -> Setup -> Financials -> Accounting -> Open and Close Periods 3. Ensure the Purchasing period is open for the accounting period in question using: Purchasing -> Setup-> Financials -> Accounting -> Control PO Periods 4. Ensure the Inventory period is open for the accounting period in question using: Inventory -> Accounting Close Cycle -> Inventory Accounting Periods 5. Ensure the Accounts Payable period is open for the accounting period in question using: Payables -> Accounting -> Control Payables Period
Creating JAR files on desktop for OAF project files
Steps: 1) Go to the <code path>/myprojects/oracle/apps 2) Copy xxcst folder and paste to <jdev install dir>/jdevbin\jdk\bin 3) Remove any unnecessary files from xxcst folder. 4) Go to Cmd and cd to <jdev install dir>/jdevbin\jdk\bin 5) Execute the below cmd jar -cf <jar file name>.jar xxcst 6) Deploy the JAR appropriately
Oracle Application Framework Developer's Guide Release 12.1.3 [ID 1107973.1] Oracle Application Framework Developer's Guide Release 12.1.2 [ID 972774.1] Oracle Application Framework Developer's Guide Release 12.1.1 [ID 744832.1] Configuring JDeveloper For Use With Oracle Applications 11i and R12 [ID 330236.1]) Oracle Application Framework: Allowing an Extended VO to See Subsequent Parent VO Changes (Doc ID 353443.1) How To Make DFF Segments Read Only Using OAF Personalise (Doc ID 438215.1)
Oracle Application Framework: Allowing an Extended VO to See Subsequent Parent VO Changes (Doc ID 353443.1)
MOAC related notes:
Oracle Applications Multiple Organizations Access Control for Custom Code [ID 420787.1] --> Very Good document for developers. SQL Queries and Multi-Org Architecture in Release 12 [ID 462383.1] Multi Org Access Control (MOAC) in Oracle Purchasing [ID 397362.1] FAQ - Multiple Organizations Architechure (Multi-Org) [ID 165042.1]
Localizations related notes:
Globalization Guide for Oracle Applications Release 12 (Doc ID 393861.1)
Country-Specific Features (Globalizations/Localizations) Guide (Doc ID 403211.1)
Oracle Applications 11i Internationalization Guide (Doc ID 333785.1) --> char set
Oracle E-Business Suite Release 12.1+ Information Center - Localizations [ID 885960.1]
Introduction to Add-On Localizations for R12 [ID 429042.1]
XML Publisher related notes:
XML Publisher Report Issues, Recommendations and Errors (Doc ID 862644.1)
R12: Troubleshooting Known XML Publisher and E-Business Suite (EBS) Integration Issues (Doc ID 1410160.1)
Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite [ID 364547.1]
Concurrent Processing and Post Processor related notes:
Unable to Find the Concurrent Request Output Post Processor (OPP) Service [ID 465036.1]
The Output Post Processor does not process all requests. [ID 1399463.1]
BI Publisher Requests in Pending Status End in Warning When Starting Concurrent Managers [ID 375208.1]
APIs and Integration repository:
Note: 462586.1 - Where are the Oracle® Release 12 (R12) API Reference Guide?
Information Center: Using Oracle Payables (Doc ID 1417577.2)
AP: How To Determine Ap Invoice Approval Status Via The Backend? (Doc ID 220653.1)
11i & R12: AP: Where Is The Invoice Validation Status Stored? How Is The Invoice Validation Status Determined? (Doc ID 301806.1)
PO(Oracle Purchasing):
Attachments:
Note 338651.1: trouble shouting attachmetns and export How to Query Attachments with SQL - Querying an Item Attachment? (Doc ID 370176.1) Enable Attachments in a Form (Doc ID 369215.1) How to enter images in the HRMS Application (Doc ID 103263.1) How To Use Attachments In Oracle Applications? (Doc ID 197549.1) Is There A File Size Limit For EBS Attachments (Doc ID 739643.1)
Misc Notes:
ICX related notes:
How To Handle Numeric Fields When Profile Icx: Numeric Character = 10.000,00 [ID 452839.1]
What is the setting and functionality of Profile Option ICX: Numeric characters? [ID 167513.1]
Report is missing data ICX Numeric Characters Profile option set to 10.000,00 [ID 858245.1]
Other Notes:
How to Determine Data Populated in the Reference Columns in GL,AR,AP Interface tables for AGIS Invoices [ID 853296.1] Reports Exchange (RXi) Basics (Doc ID 119736.1) AME: How To Copy / Migrate AME Setup Like Rules/Attributes/Transactions etc From One Instance To Another Instance ? (Doc ID 371605.1) How To Migrate AME Setups From One Instance To Another (Doc ID 1168883.1)
R12.1 Where can I find the latest eTRM information for 12.1.3 or 12.1.2? (Doc ID 1190603.1)
Oracle E-Business Suite Electronic Technical Reference Manual (eTRM), Release 12.1 and 12.2 (Doc ID 2736939.1)
Format number in BI report according to the ICX: Numeric Char profile option: Its common in Oracle Apps UIs that the number and date formats are displayed according to the user preferences. Often we need the number format preference be honoured in BI Publisher (XML Publisher) reports. With the following we can achieve the same: 1) Set the profile 'ICX: Numeric characters' according to your need. 2) Set the profile XDO: Numeric characters to 'Read from ICX: Numeric characters' When the above is set, the system passes the separators to xslt._XDONFSEPARATORS XDO parameter during runtime. In your RTF for the number field - write the following code: <?format-number:NUM_COLUMN;'999G999D99'?> Where 'G' denotes thousands separtor and D denotes decimal separator. During runtime, the BIP engine uses XSL-FO style sheet instead of RTF that was uploaded. As soon as you upload the RTF document and save you can see one more extra record in XDO_LOBS for the XSL: We can see the XSL from the BIP add-in as well. Open your RTF --> From Add-ins --> Tools --> export --> XSL-FO Style sheet. You will something like this: <xsl:value-of select="xdoxslt:xdo_format_number($_XDOXSLTCTX, .//NUM_COLUMN, '999G999D99')"/> $_XDOXSLTCTX is made up of locale, timezone, calendar, numeric separtors etc.. You can refer metalink notes 760434.1,1355022.1
ORA-00947: not enough values even when number of VALUES matches the insert I faced the issue "ORA-00947: not enough values even when number of VALUES matches the insert" - I checked the couple of sites but did not get any clue finally found that the issue is because of 'VALUES' clause with 'SELECT' statement.. Wrong: insert into tabA(a,b,c) Values (Select 'a', 'b', 'c' from dual); Correct: - No Values clause insert into tabA(a,b,c) (Select 'a', 'b', 'c' from dual);
