Skip to Main Content

Intelligent Advisor

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trunc() function does not work as expected in 20A for very large numbers

Ambrose ChengJul 2 2020 — edited Jul 2 2020

Hi all

Has anyone encountered a similar issue? We are using the trunc() function in our project currently (12.2.8) for very large numbers (>= 10^15) and it is working as intended today. We're using the function to truncate any trailing decimals from this large number i.e. trunc(x,0). However, when we upgraded our project and tested the function again, trunc(x,0) instead exhibited a rounding behaviour to the nearest hundred. After some testing, we found this behaviour to be consistent for any value >= 10^13.

If anyone has encountered, is it a known bug, and is there any workaround or fix?

Comments

66787
Yes mainly DAC client is windows only and so it the BI Admin tool.

You can connect BI admin tool to the BI server on the Linux by setting an ODBC connection of type BI server on your desktop.

Likewise, when you follow the DAC installation instructions, you need some Informatica components on the DAC client PC.
So generally you should install DAC and Informatica clients on same box while DAC and Informatica server can be on Linux.
674896
Actually DAC client works perfectly on Linux, but it is not supported.
716953
Shyam & User8...

Thanks for your answers. We will install client in windows and try connectign and installing, thanks
716953
Shyam

We are installing these to test Financial Analytics. There are some steps ( listed ) in the installation.

Section 4.15, "Configuring Relational Connections in Informatica Workflow
Manager"
Section 4.16, "Configuring the SiebelUnicodeDB Custom Property"
Section 4.17, "Setting Up DAC to Receive Email Notification"
Section 4.18, "Additional Configuration Tasks"

Are these mandatory for our case. OR can we skip some of them.

Thanks in Advance
66787
4.16 is mandatory for unicode db setting
Section 4.17, "Setting Up DAC to Receive Email Notification is not required

i would follow the rest and do it
716953
Shyam

Thanks for your quick reply. I would go ahead and perform all the steps except 4.17 and update if it works or not.

Thanks again.
716953
Shyam

I am creating connection from PowerCenter client to the OLTP and OLAP. For OLTP ( Oracle EBS Applicaitons ) , do I use APPS user for connecting.

Thanks
66787
yes apps for OLTP side
716953
Shyam

Now we are configuring the BI Applications before running full load of ETL. We are trying to do the steps 3.1.1 (How to Configure Initial Extract Date) through 3.2.2.5 (How to Configure Country Codes). But none of them is editable. IS it okay to skip these steps and just do step 5 (Configuring Oracle Financial Analytics)

Thanks
66787
you can skip them for the first pass, you will extract the whole historical data. If your country is USA, then you will be fine,

you can make changes to the copy of the original containers for ETL.
716953
Thanks Shyam

IF we are running the ETL for Oracle EBS Vision database, do we have to create our own container , or can we use the prebuilt container ORACLE_R12

Thanks again
66787
Pre built R12 if Vision instance is R12.
Thanks
716953
Yes, our Vision is R12.

Few more questions.

1. We are about to run full load of ETL. In case it fails for any reason, can we re run a full load. If some of the data is not loaded, can we run it just for that data or do we have to do a full run.

2. Initilly we are planning to run full load for Project Analytics and then run Financial Analytics. Is it possible to run them seperate at different time.

3. Our dashboad currently shows sample data ( 1.Overview,2.Rankers&Toppers,3.History&Benching,4.Tiering&Distribution). Once we load Project Analytics, would this change or do we have to do any post load steps.

Thanks in Advance
66787
1. We are about to run full load of ETL. In case it fails for any reason, can we re run a full load. If some of the data is not loaded, can we run it just for that data or do we have to do a full run.

[you can run it from that point or use do a master reset and reload the full run, depends on how long it takes for full run in your case]

2. Initilly we are planning to run full load for Project Analytics and then run Financial Analytics. Is it possible to run them seperate at different time.

[you can create two ETL executions plans, though I suggest doing it in one Execution plan, you can run Projects subject area first, then ready for Fin, create a new execution plan with both, and then run it, full for first time and daily incrementals]

3. Our dashboad currently shows sample data ( 1.Overview,2.Rankers&Toppers,3.History&Benching,4.Tiering&Distribution). Once we load Project Analytics, would this change or do we have to do any post load steps.

[not sure where is the sample data coming from, is it from Vision instance, where will you point for Project analytics load?]
716953
Shayam, thanks for all your replies


The sample data came when we installed it. It was just the menu, dont know if there was any data in it. We just executed the full load of Project Analytics and it is pointing to the R12 Vision database. Its been running to half an hour. MY question was - after this ETL load is complete, how do we access Proj Analytics. Would the menu appear by itself, or do we have to do any steps.

Also another question. While the ETL was running , I accidentaly closed the PowerCenter Workflow Manager client that was running in hte windows. This should not affect the ETC load right ? Also I am not able to change tabs in DAC admin console. Looks like the system is real busy. Hope it did not kill the server.

Thanks
66787
The menu items are from the Presentation catalog that are installed while installing OBIA. Once you successfully load the data via ETL, and rpd is configured properly to point to the DW, then you will be able to look at dashboards/reports.

If you informatica server is on same box as DAC server/DAC client then you cannot kill it in the middle of ETL run. ETL can easily take 1hr+ depending upon data and DB performance.

You can close the workflow client, with no issues.
716953
Shyam , thanks


Our Informatica , DAC server are in the same box ( Linux). Only the things that cannot be installed in Linux ( DAC console, POwerCenter Workflow Manager) are in windows.

We just ran into another problem. Since all the servers were in one box and there was ver less swap space, the server was almost hanging. And our DBA restarted teh server whithout knowing we were running the processes.

No i dont know where to strat from. Can i do the whole things again. You said I can do the master reset. How do i do that.

Thanks alot
716953
When i try to reset using ETL Management > Reset Data Sources , it said "There are incomplete ETLs, can't reset Data Sources!". I guess i have to start from where it left. Is that correct.

Thanks
716953
I just reran it since I could not reset. Out of 302 tasks , 214 failed and only 82 were succesful. How do i find details for the 214 failed ones and fix them.

Thanks
66787
you need to right click and mark the job complete (even though) it did not complete,
then reset etl data sources and re-run full load
716953
Shyam

Thanks for the information. Im just startign the rerun. If I find any of the tasks as failed, where do I debug. It says look at the log file for each failed task. Where do i look for log file. Do i have to look at different file for each failed task.

Thanks
66787
Here is the sample path for the log files:
C:\Informatica\PowerCenter8.6.0\server\infa_shared\SessLogs

Yes each task has a similar named log file.
66787
Also I suggest you mark this thread answered as it was related to install issues. If you encounter task failures open new threads.
Thanks
716953
Shyam, thanks for all your help. I will close this thread and open another for the ETL load issue
1 - 24

Post Details

Added on Jul 2 2020
0 comments
219 views