BI Publisher
Discussion List
-
what events and actions populate GL_FRC_REPORTS_BSummary: Our auditors flagged an audit due to update of the "critical table" GL_FRC_REPORTS_B. From looking at documentation it says that this is populated with BIP/OTBI…Richard Halford 13 views 2 comments 0 points Most recent by Richard Halford General Ledger & Intercompany -
Missing GL account in Oracle TBSummary: A GL account is missing in Oracle TB but I can find it in Power BI. I have looked for the accounting combination in Oracle and it does not exist. The GL account…Hreddy 10 views 1 comment 0 points Most recent by Julien_Dubouis Subledger Accounting & Accounting Hub -
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o… -
BIP query to get OTL project and task detailsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Boby Joylin 27 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Notification to Manager for learner triggered using alert composer not with name but by the email idSummary: Notification to Manager for learner triggered using alert composer not with name instead of email id in security console their username is xxworkemialid.com Con… -
Comparison between two fields in rtf templateSummary: Comparison between two fields in rtf template Content (please ensure you mask any confidential information): In the RTF template, we need to conditionally displ… -
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…Shruthi Arun Krithika 23 views 2 comments 0 points Most recent by Dhruvi Reporting and Analytics for ERP -
Issue with Additional Columns in Disbursement Payment Process Request Status Report FormatsSummary: Hi All, We are facing an issue while customizing the “Disbursement Payment Process Request Status Report Formats” report. We have added some additional columns …Karthikeyan s-Oracle 60 views 6 comments 0 points Most recent by Devesh Tyagi Payables, Payments & Cash Management -
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu… -
Cannot generate sample data for DM when customizing Invoice Print TemplateSummary: I am trying to add custom RTF invoice templates to Oracle BI Publisher to be used in Fusion. I used the "Generate Receivables Transactions: Invoices" scheduled …Shane Riley 42 views 2 comments 0 points Most recent by Narendra Prasad Golla Receivables & Collections -
eText Payment Format in BIP output appending question marksSummary: I have created a custom Disbursement Payment File format using eText, and placed in the Custom folder in BI Publisher to be used in a payment process profile. T…Shane Riley 32 views 1 comment 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP -
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 52 views 6 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP -
Include project details AP Payment CheckSummary: In 'Disbursement Payment File Formats' oracle Seeded XML file I did not see AP invoice project details, if invoice is mapped to any project details. How to map …Narendra Prasad Golla 22 views 2 comments 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management -
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 201 views 6 comments 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management -
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep_Chavda 291 views 2 comments 0 points Most recent by User_E19UQ Reporting and Analytics for HCM -
Program "Print Receivables Transactions" is completing with errorWe have a requirement to deliver the consolidated output to customer if he has multiple invoices which are eligible to print. We have changed the bursting key to achieve…ramesh.daniyala.mcd 206 views 3 comments 0 points Most recent by User_JK2QN Receivables & Collections -
CE_GL_AVAILABLE_TRX_VSummary: Historical changes in CE_GL_AVAILABLE_TRX_V definition across Oracle Fusion releases Content (please ensure you mask any confidential information): We are inves…Guilherme L Rocha 21 views 2 comments 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …Maddipati Ajay Kumar 62 views 3 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM -
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 432 views 5 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
How can we print different Logo based on LE name in EXCEL BIP TemplateSummary: For the Excel template, we have a requirement to print the logo based on the Legal Employer selected in the parameter while running the report. This requirement… -
How to report on job subfamily?Hi, Is there a way to run a report with the job code, job name, associated job family and associated job subfamily in BI publisher?Jacqueline Mellonas 32 views 3 comments 0 points Most recent by Melissa Robinson Reporting and Analytics for HCM -
Reliable way to identify negative gross / net pay employees without error message text?Hi all, We maintain a custom BI Publisher report that flags employees with negative gross or negative net payments during payroll processing. The report is provided to o…Chandrika Yatham 31 views 0 comments 0 points Started by Chandrika Yatham Reporting and Analytics for HCM -
Which table stores Receivables Specialist Assignment Rules?Summary: Which table stores Receivables Specialist Assignment Rules? Is there any Subject area to create OTBI report? Content (please ensure you mask any confidential in…Bhanu Prakash Sharma 11 views 3 comments 0 points Most recent by Bhanu Prakash Sharma Receivables & Collections -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 117 views 20 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
DeletedThis post has been deleted. Regards, -
Need a query that identifies run results or balances where taxes are not being withheldNeed a query that identifies run results or balances where taxes are not being withheld, even though tax withholding is configured on the Calculation Card. There are sev… -
External bank transactions cannot be voided in Oracle Fusion. However, the Bank Transfer canceled.Summary: External bank transactions cannot be voided in Oracle Fusion. However, the Bank Transfer canceled. Could you please clarify what is the recommended process for …Esraa Yousef 10 views 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Bank account is not being populated in Payment file register and payment fileSummary: I am trying to create a Payment file using PPR however all bank details are populated in Payment register and payment file except Bank account number. I can see…BhargavV 31 views 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management