8 to15 BIP Data Model RTF ESS Job Schedule and Bursting

 

Tools -> Report and Analytics -> Browse Catalog

Fusion URL/analytics 

Custom Folder Significance in Shared Folders

Getting Table Information

Official Docs

Record Issue and Raise SR with Oracle [If not able to find]

In Create New Data Model

In Fusion Audti tables with _ at the end of table not like _A in EBS

Drag n Drop Link between two groups like above

Parameter type menu for  LOV to use and Refresh Check box

Save as sample data and create Reprot

Generate RTF automatically

ESS Job

LOV  for ESS Job Parameters

In ESS Job we cannot pass first parameter value to the second parameter like in EBS and BI publisher - Limiation SR with Oracle

UCM or Content Server or WebCentre Content - FusionURL/cs

We won't this BI Publisher Schedule as we cannpt chnage dynamically mails or subject or msg body. We will mostly use bursting concept

Schedule from ESS

Bursting

SQL For UCM Delivery Channel

SQL for Email Delivery Channel

SQL for FTP Delivery Channel

In order for FTP to work we have rasie SR with oracle to whitelist ports

Migration 

BI Publisher- Archive and Unarchive

ESS Jobs - No option manual only

Security - Permissions

For BI

For ESS

Below job will create privilige which we have to assign to existing custom job role or new job role 

Standard Report Customization

FusionURL/xmlpserver

This will create same folder structure with files in Custom folder 

ESS job Run will check in Custom folder first if not run standard files

For Data Model Customize option won't be there we have to manually archive and unachive to copy & point data model of report to custom folder where we copied.

There is no option to edit all the data models only few standard reports we can which were made available

Disbursement Payment File Format Customization