BI Publisher
Discussion List
-
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi… -
Seeded Asset Additions Report: YTD Depreciation showing zero for legacy assetsSummary: On the seeded Asset Additions Report, why is the YTD Depreciation column showing 0.00 while initial depreciation field has value. Content (please ensure you mas… -
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 12 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…Rohit Soni-259808 225 views 5 comments 1 point Most recent by Dpalmborg-Amica Reporting and Analytics for ERP
-
TransactionDocumentExtractDm data model used for Disbursement Payment File FormatsHi Guys Does anyone know of the existence of comprehensive documentation around the set of fields that are available to be used in a new "Disbursement Payment File Forma…
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 34 views 2 comments 0 points Most recent by Deputy Birara-Oracle Reporting and Analytics for ERP
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…Rama Mohan ReddyB 24 views 1 comment 0 points Most recent by Rama Mohan ReddyB General Ledger & Intercompany
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
Where is the justification for a budget override request stored?Whenever a user creates a budget override request, he/she needs to enter a justification or reason for the override. The name of the field depends on the transaction for…
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
LACLS It is possible that DDF used in localization can be defined at the global attributes level?We are configuring the localization for Peru and have found that many of the descriptive fields are already in use by other companies operating in the system, so we have…Cristian Gonzalez S 3 views 0 comments 0 points Most recent by Cristian Gonzalez S Reporting and Analytics for ERP
-
BI Security using Secured View in Fusion HCM Release 9.2Summary BI Security using Secured ViewsContent Regarding BI Security the MOS ID (Doc ID 1533659.1) talks about : PER_POSITION_SECURED_LIST_V PER_PUB_PERS_SECURED_LIST_V …AshishERPCloud 318 views 6 comments 2 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b…Consultant Ian 72 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
YTD Depreciation is not showing correct value in Fixed AssetsHi I am using below tables in my query and i am pulling YTD Depreciation from Fa_Deprn_detail table. it is not pulling the record which has deprn_source_code='B' from th…
-
Ship-To Customer Information in Invoice LinesHello. Does anyone have any idea on what table to use to find this information? Is the SHIP_TO_PARTY_SITE_USE_ID the correct table to use for this and how to connect thi… -
Securing a digitized signature for check printing in Oracle fusionSummary: Securing a digitized signature for check printing in Oracle fusion Hello Experts, We have developed Check template with RTF (Microsoft Word) and hard coded samp…Narendra Prasad Golla 179 views 2 comments 0 points Most recent by Chaunae Walton Payables, Payments & Cash Management
-
Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though whenSummary: Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though when our Payment process automatically transmits from Oracle Clo…Danny P Smith 33 views 3 comments 0 points Most recent by Stephanie Turner Payables, Payments & Cash Management
-
BIP report job status - difference between 'failed' and 'skipped'Summary: BIP job status - skipped and failed - what do these mean Content (required): We have a number of BIP report jobs running to send out letters / notifications to …Tasha 321 views 5 comments 1 point Most recent by Ram Murthy Buddhiraju Reporting and Analytics for HCM
-
Missing > Intercompany 'Enter Receiver Distribution' notification TemplateSummary: Hi there, We are trying to personalize the Intercompany Enter Receiver Distribution Notification template; however this is no where to be found on the environme…marc.joed.de.guzman 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Learning Certificates of Completion are not available when setting catalog defaultsHello, I've configured the Completion Certificates in BI Publisher, and they're in their respective folders in OTBI. When I go to add the completion certificates to the …
-
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical…
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 744 views 5 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
How do I know which employees run a custom report?Summary: Content (please ensure you mask any confidential information): I'd like to know if Oracle logs BIP report executions that are not scheduled Version (include the…Stefano_Mazzocca 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 703 views 7 comments 0 points Most recent by Youssef_Antoury Reporting and Analytics for ERP -
User inadvertently unreconciled old transactions from 2021 to 2024.Summary: User inadvertently unreconcile the old transactions from 2021 to 2024. Now user want to reconcile back the transactions all at once. In SR agent suggested to us…Shaik Fayaz 1 view 0 comments 0 points Most recent by Shaik Fayaz Payables, Payments & Cash Management
-
Invoice Hold Custom BI template created but when user receives a notification Hold reason is missingSummary: Invoice Hold Custom BI template created but when user receives a notification, Hold reason is missing on template? Content (please ensure you mask any confident…User_M03HO 6 views 0 comments 0 points Most recent by User_M03HO Payables, Payments & Cash Management
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…