EPM Planning - PBCS - How to create source application to FCC from Planning

 Creating source application is small part only, bit tricky I found, may be it is easy for others. It may be useful at least for beginners. Sometimes we forget things with on going activities, so you can found steps here..

Go to Data Exchange >> Actions >> Applications

Click on Add

Enter FCC URL, with out HyperionPlanning in the URL, enter username, password then click Refresh button which highlighted in the below screen shot.

Select your application in the next popup screen as shown below, then select Plan Types and Prefix if required.

Click OK, it will be popup in right side as Application Registered successfully.

Thanks,

Mady

OIC - How to schedule an Integration

 Scheduling an Integration in OIC also bit tricky, if you are working as a beginner. There are few limitations, as per Oracle mentioned, we cannot schedule integration within 10 minutes if you are using 

Click on 3 lines once you activated the Integration.

In the actions list, you can schedule, click on schedule.

Click on Edit button on the Top-right corner

You can select Simple or iCal option to schedule as per you requirement.

In Simple selection, you can schedule the integration to execute in frequency of below mentioned and showed in screen shot.

• Hours and Minutes
• Days
• Weeks
• Months

In Case of, you want to schedule other than the default options in Simple, you can select iCal option, where you can update Expression to schedule the integration. 

For Example: To schedule integration to execute in weekdays, 2 times a day. you can use below code.

FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR;BYHOUR=2,14;BYMINUTE=30;

Usage commands:

INTERVAL

BYSECOND

BYMINUTE

BYHOUR

BYDAY

BYMONTHDAY

BYYEARDAY

BYWEEKNO

BYMONTH

BYSETPOS

WKST

enddate = date

enddate =/ date-time ;An UTC value

byseclist = seconds / ( seconds *(“,” seconds) )

seconds = 1DIGIT / 2DIGIT ;0 to 59

byminlist = minutes / ( minutes *(“,” minutes) )

minutes = 1DIGIT / 2DIGIT ;0 to 59

byhrlist = hour / ( hour *(“,” hour) )

hour = 1DIGIT / 2DIGIT ;0 to 23

bywdaylist = weekdaynum / ( weekdaynum *(“,” weekdaynum) )

weekdaynum = [([plus] ordwk / minus ordwk)] weekday

plus = “+”

minus = “-”

ordwk = 1DIGIT / 2DIGIT ;1 to 53

weekday = “SU” / “MO” / “TU” / “WE” / “TH” / “FR” / “SA”

Reference: https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/define-integration-schedule.html

Thanks,

Mady

Oracle EPM Planning/PBCS - Data not showing up in Data Management Workbench

 In Data Management, workbench if it shows, Gold fish, we will be happy as much as we earn Real GOLD or Gold Fish. Why because, Data Management will show this gold fish after lot of steps only, if you do correctly. Otherwise, even you can't find out the issue at which step it is failing, not every time, but some times. 

This post is about simple step only but, we must know that we need to enable these option to see data, otherwise even though Gold fish is showing up, you can't see data in workbench, you don't even know about what happening, whether it is working or not.

If you are extracting data from Planning, and data not showing up in workbench, then check below steps to enable or see the data.

Navigate >> Click on Data Exchange in Application section >> Actions >> Applications >> Click ... 3 dots(last column, under actions) in particular application then Select Application Details >> Select options >> Select Workflow Mode as full, then only you can see data in Data Management Workbench.

Thanks

Mady

Oracle EPM Planning/PBCS - Error Resolutions in Data Management

 While we work on Data Management, more often we will face these issues:

As these Message Number and Contents are self-explainer, as I found some information, I am posting here, 2 issues solution.

Error 3303: This issue is about member not found, which means member itself is missing in the database. 

Solution: So, We can add member in dimension, and try to load again.

Error 3335: Mapped target dimension member does not exists (or) the same member name exists in more than one dimension. 

Solution: Check whether the mapping is defined properly, target value mentioned in Mapping should exist in Target Application. Also, check that the same member name does not exists in more than one dimension. 

We will add more....

Thanks,

Mady