BI Publisher
Discussion List
-
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… -
Suggestion Needed: Removal of special characters at the XSL template level for Payment OutboundsHi Oracle Cloud Community, I hope this message finds you well. We are working on a project where our client requires payment outbound files generated in oracle cloud whi…Subhranil Maitra 41 views 2 comments 1 point Most recent by Vaikunth Talaulikar Payables, Payments & Cash Management
-
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…Rakesh Viswam-Oracle 32 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 31 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 21 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, …Shubhojit Purkait 1.8K views 12 comments 0 points Most recent by J_007 Reporting and Analytics for ERP
-
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… -
How to customize Disbursement Payment File FormatSummary: How to customize Disbursement Payment File Format Content (please ensure you mask any confidential information): We are looking to implement a new electronic pa…
-
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 1 view 0 comments 0 points Started 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 315 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 7 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 142 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 32 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 311 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 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to bind effective date parameter of HCM Extract to BIP Report's parameter and load HDL ?Summary: How to bind effective date parameter of HCM Extract to BIP Report's parameter and load the HDL file generated by BIP Report ? Content (please ensure you mask an…
-
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 15 views 0 comments 0 points Started by VijayRajalbandi Reporting and Analytics for HCM
-
How to schedule BIP report in application composer ?Summary: I would like to use the application composer to schedule a BIP report I have defined the (https://****/xmlpserver/services/ScheduleReportWSSService?WSDL ) webse…
-
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 606 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 21 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 284 views 7 comments 0 points Most recent by Youssef_Antoury Reporting and Analytics for ERP