For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
We are getting error in Release 13 because of wrong number or types of arguments in call to GET_DURATION'.
'ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_DURATION'
Note: This function was working fine in Releases 9 to 12.
Any help in this regards ?
Thanks - Mahesh
Hi All
I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segregated to themselves/their own cost centre.
The reports I am looking to do is a procurement requester report I have build, and I want users to be able to see all POs that they have raised and are requester for. What custom role/seeded role is their so they can have a view of this report (I also want to pin this report onto there oracle homepage - is this possible?)
Another role I want to create is so that cost centre managers can see all POs raised to their cost centre only. How can I do this?
Finally I want to create a role for expenses where a manager can see a report of all expenses that their team (Line manager hierarchy) have raised. Is this easy to do?
Thnx
Can we create NACHA format files using BI Publisher template builder in Cloud? Any documentation for creating the same will be helpful.
Regards,
Swathi
Hello,
I have stumbled across a 'Custom Print and Export Layouts' feature in our OBIEE 12C dashboards. I got as far as importing into BI Publisher data model and report (which I am familiar with as well) but that's about as far as I got. This looks different than other BI report layouts I'm used to, etc. Is there any good documentation or examples out there that could help? I've read through the generic Oracle doc that tells me the limited information that I already know. Any more advanced info out there?
Thanks,
Stephanie
We have a requirement from a client where from the prompts, if we select any attributes you report layout has to show case those field attributes in the report layout.
Any help is highly appreciated
we are trying to divide two columns but its not working.we are using the below code.
<?CURR_TOT_GAURENTEED_COMP?>DIV <?NEW_TOT_GAURENTEED_COMP?>
Hi,
We need to developed few custom reports as per the requirements. In this implementation we have around 30 companies each of them has its own logo.
so in the report template we need to make the displaying logo dynamic
means if user from COMP1 run the report then LOGO1 will appear .
and if COMP2 runs the report then LOGO2 will appear.
Is there any flexibility where we keep the logo in one particular location and pull the logo dynamically in the report template in FUSION CLOUD?
or there is another way to do it fusion cloud ..
For example if we can upload the logos to a path in fusion server and from the template we call them .
I am not sure how to do this in fusion
Please advise
Hi,
We need to fetch the pending transaction Transfer details like New Location,New Position,New Grade,New Job etc. We are aware that We can capture these details in data_cache column in hrc_txn_data table. As these column captures many entries, how can we fetch only one value(say New location, New Position,New Grade,New job etc.)? Is there any syntax to fetch that alone? Please suggest.
Thanks,
Nirmal kumar
This white paper provides the best practices for working with BI catalog folders, and suggestions on actions for accidental move or deletion of a folder.
Cloud Integration process where data is extracted and sent via FTP to other partner applications.
If this process is performed on a scheduled basis (or manual run) then it becomes difficult to find out which records were extracted earlier and where are NOT? Other mechanisms are used to remove already extracted records from being sent twice.
Could we perform the following steps:
#01: BIP Report is given the capability (similar to EBS) to update some DFF fields (not other fields) from the source tables (data being pulled) to update and store them so that next run could validate and exclude these records. This should be kept as datatime field so that it can keep track of when the data was pulled. In addition, if the record was updated then the record should be pulled second time in BIP. This could be performed on Datatime and "Last_Update_date" comparison.
#02: ATOM configuration could accommodate custom BI Publisher reports so that one can create reports and send via ATOM audit structure to FTP / emial