BI Publisher
Discussion List
-
Whether increasing the maximum length of existing value set used for GL DFF cause any impact ?In Oracle Fusion Financials, can we increase the maximum length of existing value set used for GL DFF. Will there be any negative impact for this? -
The Conversion Rate Tolerance for user rate TypeSummary: Is there any Feature to Validate the User Conversion Rate entered by the user. Ex: Corporate: 3.673 Tolerance: 1% User: 3.764 (System Should through an warning …Rama Mohan ReddyB 19 views 3 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
How to default standard bip report output to excel?Summary: How to default standard bip report output to excel? Content (required): How to default standard bip report output to excel? Version (include the version you are…
-
Impact and considerations when the period name of the accounting calendar includes special characterContent (please ensure you mask any confidential information): There is a requirement that you want to include the deadline in the period name. Example: 6 month deadline…Yuyeon KIM-Oracle 3 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
sql query for description details in Manage description rules taskHi Team, Need the sql query for description details in Manage description rules task.Here we have attached the screenshot for your reference We are unable to find table …
-
How to Retrieve Batch Number Programmatically After Import for ESS Job "Create Accruals for ChannelSummary: Hi all, We’re creating supplier transactions accruals in CHRM via Import Management and then running the ESS job: "Create Accruals for Channel Batch", which req…
-
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under …
-
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 15 views 0 comments 0 points Started by marc.joed.de.guzman General Ledger & Intercompany
-
Fusion SQL Linking between GL Transactions and PA to obtain the expenditure item idI have been asked to update a BIP GL report to provide the expenditure item id, should it exist, from projects. I have done lots of searches and some AI. The responses s…
-
Is Reginal information for Mexico field stored in GL_INTERFACE Table?Summary: We have a requirement to upload journal lines under Reginal information for Mexico with UUID but we are unable find the exact column from GL interface, Is there…Sreenivasulu Donka 45 views 2 comments 0 points Most recent by User_CWYF6 General Ledger & Intercompany
-
options to pause GL posting during incremental GL balances extractsSummary: Oracle GL Cloud provides any built-in functionality to temporarily pause General Ledger (GL) posting, looking for a feature to temporarily pause or queue GL and…sateesh Polkampally 2 views 0 comments 0 points Started by sateesh Polkampally General Ledger & Intercompany
-
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 130 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 12 views 4 comments 0 points Most recent by Deepti Malvadkar General Ledger & Intercompany
-
How to get Request Id for Import Journals ESS Job using ImportBulkData Operation using REST API?I am invoking the importBulkData(Operation) REST API to run the Import Journals job for loading journal FBDI files. While I can retrieve the Request Id of the "Load Inte…Srinath Anbarasu 276 views 2 comments 0 points Most recent by User_QGID7 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 505 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 135 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 26 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How can I pull in all ledgers within one report regarding 'Subledger Period Close Exceptions Report'We have 20 + ledgers and have to run a report for each due to 'Ledger' as a required field. Does anyone have any workarounds if Oracle has not created another BIP report…
-
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 4 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…