BI Publisher
Discussion List
-
Fetch Payment File Reference into Disbursement Payment FileSummary: Fetch Payment File Reference into Disbursement Payment File Content (please ensure you mask any confidential information): We have a custom Disbursement payment…KDR 313 views 4 comments 0 points Most recent by ChaitratestUser Payables, Payments & Cash Management -
NullPointerException in send dunning lettersHi Team, We have customized bursting query in seeded dunning report and getting 'exception in vectorjava.lang.NullPointerException' in Send Dunning Letters process. We a…Santhosh Kumar J 1 view 1 comment 0 points Most recent by Gopal Reddy-Oracle Receivables & Collections
-
BI Report Time card details - Calculated details by earned dateSummary: Team we have a requirement to fetch all the details available in the timecard. (Calculated details by earned date) - Screenshot attached. I am using the below q…
-
Editing PersonHeader subtemplateHello. I'm trying to customize the PersonHeader subtemplate and is already in the Shared Folders/Custom/Human Capital Management/ Workflow Notifications. But when I chan…Maria Cristina L. San Jose 62 views 2 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM
-
PER_PERSON_SECURED_LIST_V View Does not Retrirve all RecordsSummary: PER_PERSON_SECURED_LIST_V View Does not Retrieve all Records. It fetches the data of only the Current logged in user. Please advise Content (please ensure you m…Milan_Mohanty 868 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
DFF for Corporate Card Transaction onlySummary: DFF should be visible only for corporate card transaction. Content (please ensure you mask any confidential information): Hi . We are defining DFF at expense le…Yashwanth Kumar Meesala-Oracle 11 views 2 comments 0 points Most recent by Yashwanth Kumar Meesala-Oracle Expenses
-
Does anyone know why running a BIP report from OIC produces different result vs. ESS?Summary: We created a BIP report to generate data in XML for a data integration, but some elements are getting dropped when it's run from OIC. Content (please ensure you…
-
Is there a way to get the latest data from the GL_FRC_REPORTS_B tableHi, I need to retrieve the latest data from the GL_FRC_REPORTS_B table. When I queried the table, the results did not match the expected original data. Could anyone assi…Keerthana Sekar 4 views 1 comment 0 points Most recent by Keerthana Sekar General Ledger & Intercompany
-
Can we burst XPT templateSummary: We have an Report created with XPT template (Normal report creation). Can we use this template and burst the report in excel format? Content (please ensure you …
-
Supplier number not displaying in AP Invoice Coding workflow notificationSummary: How to display Supplier number in AP Invoice Coding workflow notification? Content (please ensure you mask any confidential information): Upon receiving the inv…manojsharma2407.wa 17 views 2 comments 0 points Most recent by manojsharma2407.wa Payables, Payments & Cash Management
-
BIP Query Job Roles and the roles assigned to themSummary: I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them. I tried to create the report, but I can only get it to this point: sele…JaimeOrtega 132 views 4 comments 0 points Most recent by JaimeOrtega Reporting and Analytics for HCM
-
Need to capture individual feedback responses of multiple instructors in one offeringSummary Need to capture individual feedback responses of multiple instructors in one offering for the instructors dashboardContent Need a solution for a below usecase in…
-
Empty fields are not displayed on the report output when exporting csvSummary: Empty fields are not displayed on the report output if it was Scheduled through Report and Analytics Content (please ensure you mask any confidential informatio…
-
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats.Ronel M 5 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch the payment date field under the payment tab (query required)Summary: Hi, I need to verify some information using Oracle BIP tools. Could you please provide the table or the query that will allow me to display the payables invoice…Emilie06 190 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific…Matheus Roberto 36 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 153 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 20 views 0 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.6K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sayeed_ahmed 12 views 1 comment 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Encryption format supported by OracleSummary: The public key algorithm for this private key is not supported error while connecting to a FTP server Content (please ensure you mask any confidential informati…LeelaV 308 views 1 comment 0 points Most recent by GowriTatikonda Fusion Applications Administration
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…Subash Ravichandran 463 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
Query for recepit method in AR transactionI want to display trx_number and the receipt method used in this transaction. Someone knows the query?ACNROMA2023 21 views 3 comments 0 points Most recent by Raghuram Saradka-Oracle Receivables & Collections
-
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?