BI Publisher
Discussion List
-
how to invoke ESS Job Set from webservicesSummary: Trying to use SOAP WSDL and submitESSJobRequest Service. I am able to submit ESS Job but While submitting Job Set I am not able to.Please throw some lights arou…Aditi Agrawal2650 163 views 2 comments 0 points Most recent by AnanyaR-Oracle General Ledger & Intercompany -
What is the link between batch name and ESS job Import Journals ?Hello, We need to query the details of a journal batch (Batch name) with the schedule process (ESS Job 'Import Journals') that created that journal batch. We obtain the …
-
Cannot generate "Open Purchase Order Analysis Report"When I tried to run the standard "Open Purchase Order Analysis Report," I noticed that it doesn’t have a layout and the data model appears to be empty. I’d like to under…
-
SQL for ENABLED code combinations that have a disabled segment included.Summary: SQL for ENABLED code combinations that have a disabled segment included. Content (please ensure you mask any confidential information): SQL for ENABLED code com…
-
Difference between Date_created column and creation_date column in GL_INTERFACE TableSummary: Difference between Date_created column and creation_date column in GL_INTERFACE Table. Name Datatype Comments CREATION_DATE TIMESTAMP Who column: date and time …
-
Unable to fetch GL Budget Balances from GL_BALANCES table even though the documentation states itNeed to develop an Oracle BIP report to include the three types of GL Balances (Actual, Budget, Encumbrance). Although Actual Balances are available in GL_BALANCES table…
-
We need to find the BICC POV for the GL tables belowWe need to find the BICC POV for the tables below. • GL_COA_MAPPINGS • GL_ACCESS_SET_NORM_ASSIGN • GL_YEAR_END_BAL_GT • GL_YEAR_END_INC_STMT_GT • GL_ACCOUNT_GROUP_DETAILSDeepti Malvadkar 13 views 4 comments 0 points Most recent by Deepti Malvadkar General Ledger & Intercompany
-
How to refresh data in GL_FRC_REPORTS_BWe have requirement to fetch all the report details from given instance. Table Name : GL_FRC_REPORTS_B ( this table doesn't contain the updated data) What are the steps …
-
How to Find Table with Approver Details for General Ledger Lines.Summary I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this informatio…Dave Sherrard 549 views 9 comments 1 point Most recent by Deepak Kumar Dev-Oracle General Ledger & Intercompany
-
Ability to run trial balance report ESS jobSummary: Oracle fusion user should be able to run only trial balance report seeded ESS job through his login. Help me with all the required privileges I need to add to m…Aditi Agrawal2650 233 views 2 comments 0 points Most recent by Kumar 57 General Ledger & Intercompany
-
How the continuous transfer of budget balances to the budget cube affects tablesPlease tell me about the impact on tables of the ESS job "Continuous transfer of budget balances to budget cube: transfer schedule" being run. Currently, the BIP report …Akari Nuno 51 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to Extract the whole Transactional Data of Finance and ProcurementSummary: Want to extract the transactional data of Finance and Procurement which can be easily accessible and viewed via Excel. Content (please ensure you mask any confi…
-
Overlaps with updating GL tables and BIP executionSummary: Overlaps with updating GL tables and BIP execution Content (please ensure you mask any confidential information): I am developing a BIP that outputs balances fr… -
Account Analysis Report - The report columns are shuffled in CSV format outputIn Standard Account Analysis Report - The report columns are not in a proper order in CSV format output. for every different parameter the some columns are shuffled. Ple…Thanigainathan R 10 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…
-
Customization of Bank Statement ISO Processing Report (CE_ISO20022_2) CLOB FileSummary: Content (please ensure you mask any confidential information): We would like to customize the seeded bank statement template to include an additional attribute …
-
New record character in eText Template does not workI am creating a BIP report using etext template and filled in the format setup table in the template like the image below. (New record character: Carriage return) But wh…
-
How to change newline characters in BIP reportI have created a BIP report using RTF template. When exporting the report to CSV, the newline character is line feed, but I want to make it carriage return and line feed…
-
Creating ESS job set's to parameterSummary: Hi Everyone, I hope all doing well out there! I have a BIP report, using which team is extracting output for 9 countries. now user is asking to automate it to a…VasanthaFusion90 26 views 4 comments 0 points Most recent by VasanthaFusion90 General Ledger & Intercompany
-
From custom BI report Can we add 'From and To date' for seeing GL balances with backdated.Hi All, Business wanted to have one custom BI report for seeing GL balances and in that they want one parameter that is 'From and to date' to see the GL Balances with ba…Vasu N0897645321-Oracle 3 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Unable to find the Purge interface table import process nameHi Team, One user scheduled Purge Interface table ess program on weekly basis and the user was left the customer organization (User end dated) . Due to this the schedule…Somasekhar Basetty -Oracle 50 views 2 comments 0 points Most recent by Gianni Carrero General Ledger & Intercompany
-
GL Account Analysis ReportSummary: Can you please share the values to be passed for the table name parameters of the GL Account Analysis Report Content (please ensure you mask any confidential in…Aishwarya Penchala-Oracle 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Query to retrieve entity code and gl account code from oracle fusionI need to develop a query to retrieve both entity code and gl account code from oracle fusion tables. But unable to link both the tables. Can anyone please help in devel…
-
Custom ESS job is running long for one particular userWe have custom ESS job which is running long for one particular user. For other users it is completed in 3-5 mins for the same parameters.(Both users are having same set…Thanigainathan R 12 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Table to get Natural Account segment hierarchy in Oracle FusionSummary: Looking for Table to get Natural Account segment hierarchy in Oracle Fusion Content (required): I am trying to retrieve GL balances using SQL query in data mode…
-
What would cause a journal batch to go from STATUS_VERIFIED='Y' to STATUS_VERIFIED='N'Hi Guys We have a BIP report based on journal batches/headers/lines developed by an outside consultancy that has the filter below on it: GJB.STATUS_VERIFIED='Y' All good…
-
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 14 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Chart of Accounts Hierarchy Sort Order Field NameSummary: I'm building a custom BIP data model and report and I'm looking for the User-Defined hierarchy Sort Order field name info (table, field) schema = FUSION Content…Emile Helegbe 54 views 3 comments 0 points Most recent by Emile Helegbe General Ledger & Intercompany
-
How can we fetch the pdf output of the Journal Details Report using OICSummary: We are trying to send the pdf output of Journal Details report(report which gives detailed summary of FBDI load) using OIC. And as this ESS job output doesn't g…Abhinav Patil-Oracle 51 views 3 comments 0 points Most recent by Abhinav Patil-Oracle General Ledger & Intercompany
-
How to output GL Amount for two months with parameter?I need to output GL amount for two months with BIP. There should be one parameter for setting Period. Then I need to output GL Amount for the month set by the parameter …Ayumi 3 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany