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
In 19B version, the invoice currency seems to be missing in Procurement - Procure To Pay Real Time Subject Area (Procurement - Procure To Pay Real Time -> Invoice Additional Attributes -> Invoice Currency). There is "Apps Document Currency Code" instead but the documentation does not have any information about this, logical sql provides source as "Procurement - Procure To Pay Real Time"."Invoice Additional Attributes"."Invoice Currency". Is there any specific significance for this column "Apps Document Currency Code"?
Hey Guys,
We were checking to see if there is a way for OTBI Admins to access the reports/data as a Super User without having the Specific Job roles (like Inventory Manager, Warehouse Manager etc) assigned.
We tried assigning all the %TRANSACTION_ANALYSIS_DUTY roles, but aren't able to access the data without Job Roles assigned. Any thoughts?
Thanks,
Hi Friends,
I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create parameter. Could you please let me know the process for adding account(GL_CODE_COMBINATIONS - SEGMENT1to7) parameter to custom BI Publisher report.
Appreciated your quick help..!
Thanks
Lak
Currently the system allow users to filter and view Infolet data based on the values you can select in 'View By' prompt (Source System) in Order Management landing page, we want to add additional filter criteria's like Buyer, Business Unit, Supplier, Sales Channel etc...
Navigation
Oracle Fusion --> Spring Board --> Order Management --> Order Management --> Filter data in Infolets by selecting 'View By' prompt.
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11. Please help us with solution if you are faced the same in R12 upgrade.
Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current day (e.g. if run on 03/22 will only show the AP Aging @ 03/22).
Thanks in advance.
Thanks.
Matt
I am completing an audit of our approval workflow setup for expenses, procurement and budget. Our naming convention is Dept ##### Fund Manager. Some rules are out of numerical order by department. For example, we have Dept 19900 followed by Dept 19799.
I am trying to see all the rules that we have setup but the rules under Task Configuration only shows 5 lines and we have over 346 rules setup.
Is there a report that can be run to view all the rules available?
Looking for a basic GL detail report with supplier name and no blank lines in between rows, does this exist anywhere or does it need to be built as a custom report? If so are these types of reports easy to create?
Attached is an example.
Thanks in advance.
Matt
I am needing to prepare either a report and/or analysis to show all purchase orders from a specific account code over a specific time period (ex: FY16). I have zero experience with Oracle's Business Intelligence reporting tool. Any suggestions for help and/or resources to help create such a report/analysis, please?
Thank you.
Hi,
I was trying to customize the BPA approval email notification seeded template(from Purchase Document E-Mail Report) available in application.
But when i opened that rtf template, it contains one line like "Review the purchasing document and any files that are attached to the message."
Am not sure whether its completely built rtf or its still under development.
Any comments on this?
Thanks,