fusion query to get file import and export details

SELECT DID,DDOCNAME,DDOCTYPE,DDOCTITLE,DDOCAUTHOR,ABSPARENTID processid FROM revisions r JOIN ESS_REQUEST_PROPERTY erp1 ON to_char(r.did)= erp1.value AND erp1.name = 'dID' JOIN ESS_REQUEST_HISTORY erp2 ON erp1.requestid = erp2.requestid WHERE r.ddocaccount='prj$/projectCosting$/import$'

Fusion workflow notification tables

Fusion Can we access tables in the XXX_FUSION_SOAINFRA schema in order to report on Workflow Notifications ? (Doc ID 2010398.1) Starting with Release 13 of Fusion Application the FUSION_RUNTIME has been granted with access on the following schemas: FA_FUSION_SOAINFRA A list of tables that can be queries through BI Publisher can be found below. FA_FUSION_SOAINFRA.WFTASK FA_FUSION_SOAINFRA.WFASSIGNEE FA_FUSION_SOAINFRA.WFCOMMENTS FA_FUSION_SOAINFRA.WFATTACHMENT FA_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC FA_FUSION_SOAINFRA.WFTASKHISTORY FA_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE FA_FUSION_SOAINFRA.WFAPPROVALGROUPS FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS FA_FUSION_SOAINFRA.WFCOLLECTIONTARGET For HCM_FUSION_SOAINFRA tables you can use also the Human Capital Management - Approval Notification Archive Real Time subject area.

Notepad++ background orange color

Problem: Notepad++ editor show orange background for every line

Resolution: Settings->Preferences --> Margins/Border/Edge --> uncheck "Display Change History"

xmlparserv2.jar SAAJ0535: Unable to internalize message

Try this: unjar the file using the following command:

"C:\Program Files\Java\jdk1.7.0_02\bin\jar" -xvf xmlparserv2.jar

Change the entries in the files in the META-INF/services as follows:

• for javax.xml.parsers.DocumentBuilderFactory replace oracle.xml.jaxp.JXDocumentBuilderFactory with com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl
• for javax.xml.parsers.SAXParserFactory replace oracle.xml.jaxp.JXSAXParserFactory with com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl
• for javax.xml.transform.TransformerFactory replace oracle.xml.jaxp.JXSAXTransformerFactory with com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl

Re jar the file using the following command:

"C:\Program Files\Java\jdk1.7.0_02\bin\jar" -cvfm xmlparserv2.jar META-INF\MANIFEST.MF -c ./ .

Oracle Fusion AP Check Printing -- MICR font not recoginzed

Problem:

  In general "Default Micr MT" font is used by default for most implementation, sometime the MICR doesn't not recognized in the check printing process.

Solution:

1. Check the rtf template has the font mapped correctly. (eg:Default Micr MT). Incase if you are using any other MICR font, first check with the default seeded font.

2.  BI Administration --> Font Mapping

3. Make sure font mapped correctly under Report Properties

Fusion R10: Infolets

Problem: Need to access the Infolet Repository (inside and outside of sandbox) and nothing happens. Infolet page is blank and 3 small white square boxes appear in a corner.

Resolution:

In a sandbox, go to Navigator, Structure

Select: Set Systems Options
Enable Infolets - Sales Infolets
Check yesAfter enabling the Sales Infolet ,  need to publish the sandbox in order to see the toggling white dots.
the second dot is the infolet UI.

Again, open another sandbox and need to add infolets per your requirement. Out-of-the-box, nothing will be enabled but there are some seeded infolets available which could be added.

Once inside sandbox, if  hover over that 3 white boxes, can see 'Create infolet' link.  Click on it and add content as needed.

Please refer the document the Oracle Sales Cloud Using Analytics and Reports  section "Editing Infolet Tiles and Views" which as the clear step-by-step details with screenshots

Reference Metalink Note: 2048703.1

Oracle Report Builder 10.1.2.3.0 crash (APPCRASH)

Problem: After upgrading the report builder to 10.1.2.3, it crashes while opening seeded rdf in R12.2+ version.

Solution: Connect to R12 instance and retry opening the rdf, the file opens up properly..