BI Publisher
Discussion List
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '… -
please suggest a query to get all revenue categories ?please suggest a query to get all revenue categories ?
-
Query to get PPR pending approver nameI need to extract data for Payment Process Request ( PPR ) with pending approver name.
-
oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: ErrorSummary: Hi, am getting below error in BIP level. oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: Error invoking round:java…Ranjith1166 25 views 4 comments 0 points Most recent by Abhinay Singh-Oracle Reporting and Analytics for HCM
-
ESS Job for BIP Report – Error During Scheduled Process ExecutionSummary: Hi Team, We have created an ESS job for the BIP report and assigned the appropriate ESS privilege to the custom role. However, when a user with this role attemp…
-
BIP Report Interactive LayoutSummary: We have developed an interactive layout in our report. We are looking to see if we can do below, How to add scroll bars to table data in the layout How to align…Nagarjuna Nudurupati 1 view 0 comments 0 points Started by Nagarjuna Nudurupati Reporting and Analytics for ERP
-
How to fetch AP invoice status same as it show from invoice summary screenWe have a requirement to print invoice status similar to Invoice Summary Status screen. We need to retrieve validation, account coding, approval, accounting, payments st… -
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f…
-
Subject area for FND Flex valuesWe have a flex set defiend with values for categories. This flex field is used as source on invoice as DFF. Payable Subject area is used to design a report and we are us… -
Can you explain the purpose of the BIPUBLISHER_V view and how the IAU_AUDITUSER column fits into itSummary: Can you explain the purpose of the BIPUBLISHER_V table and how the IAU_AUDITUSER column fits into it SELECT iau_resource , IAU_TSTZORIGINATING, IAU_INITIATOR , …KHALED IHADDADENE 115 views 3 comments 0 points Most recent by Debby P Reporting and Analytics for ERP -
How to unhide the hidden Infolets or where we can view the hidden InfoletsHi Team, Can you please help us with the below information in oracle fusion. 1.How to unhide the hidden Infolets or where we can view the hidden Infolets. 2.We couldn't …Nirosha Yelicherla 34 views 1 comment 1 point Most recent by Francis Grégoire Payables, Payments & Cash Management
-
Blank page appears end of report in RTF template even though conditional split page is used.We are encountering an issue in a BI Publisher RTF template where an extra blank page is generated at the end of the PDF output. The template uses a conditional page bre…Sai Teja Madishetty 45 views 1 comment 0 points Most recent by Yemi Onigbode Reporting and Analytics for ERP
-
which table holds Offering task progress information for learnersSummary: Hi Team, Please let us know which table holds the information of leaner tasks progress under offering. We will attach snapshot from UI for the column details. C…Baswanth Kumar Reddy-Oracle 32 views 6 comments 0 points Most recent by Sarin - Support-Oracle Learning -
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 326 views 4 comments 1 point Most recent by SR_1234 Reporting and Analytics for ERP
-
Custom Disbursement Payment File Format Not Appearing in 'Manage Format' SetupDear All, I have successfully customized the Disbursement Payment File Format report: I also added two custom templates: However, nothing appears in the 'Manage Format' …George Mattar 174 views 7 comments 0 points Most recent by SuniChacko Payables, Payments & Cash Management
-
Need attachment url from AP invoicesSummary: Need invoice attachment url for approval notification Content (please ensure you mask any confidential information): Trying to add the invoice attachment url to…M. Coburn 134 views 3 comments 0 points Most recent by M. Coburn Payables, Payments & Cash Management
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Table to extract taxpayer id details for suppliers of individual typeSummary: Table to extract taxpayer id details for suppliers of individual type Content (required): Table to extract taxpayer id details for suppliers of individual type.…Vinothini 906 views 2 comments 0 points Most recent by User_FXECS Payables, Payments & Cash Management
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Query to fetch the CARRIER_NAME, DELETE_SOURCES and DELETE_EXCLUSION for Sourcing RulesHi Everyone, Can you please help me with the SQL Query or the Fusion tables/columns required to fetch the following fields for Sourcing Rules( Supply Chain Planning → Ma…Sravanthi0310 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
XDO_TEMPLATES_BSummary: I am not able to query XDO_TEMPLATES_B. Getting ORA-00942: table or view does not existhttps://docs.oracle.com/error-help/db/ora-0 Content (please ensure you ma…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 2K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM
-
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know…
-
Expense Setup TablesCan anyone please help in identifying the backend tables where the configurations related to Manage Expense Report Audit Rules and Manage Expense Report Audit and Receip…
-
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j…Sayali Pawar-Oracle 871 views 7 comments 1 point Most recent by Subhojit31 Reporting and Analytics for HCM
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
How to monitor the following reporting and analytics field : "Enable Monitor and Audit" fieldSummary: Under reporting and analytics, under Administration, Manage Publisher, Server configuration, under Monitor and Audit section How can monitor "Enable Monitor and…