BI Publisher
Discussion List
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i… -
HCM Alerts Composer: Not able to loop the comma-separated data to one below the other inside a TableSummary: We are looking for a way to get the comma-separated values one below the other. Content (please ensure you mask any confidential information): Version (include …
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
Table to identify password updateSummary: Is there a table that tracks the password updates? We have a scenario where the password of a service account stopped working all of a sudden. I have run the pa… -
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…Dario_DiFranceschi 1 view 0 comments 0 points Started by Dario_DiFranceschi Reporting and Analytics for HCM
-
What's wrong in this bursting?Summary: Content (please ensure you mask any confidential information): I have this template and this bursting query: Report works fine: Why do I get an empty output whe…Stefano_Mazzocca 22 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Seeded Asset Additions Report: YTD Depreciation showing zero for legacy assetsSummary: On the seeded Asset Additions Report, why is the YTD Depreciation column showing 0.00 while initial depreciation field has value. Content (please ensure you mas… -
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 11 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…Rohit Soni-259808 223 views 5 comments 1 point Most recent by Dpalmborg-Amica Reporting and Analytics for ERP
-
SQL query to get Manage Withholding Tax Classifications setup dataSummary: Hi Team, We need a table where the information of Manage Withholding Tax Classifications setup data. The table ZX_ID_TCC_MAPPING_ALL have the classification cod…
-
TransactionDocumentExtractDm data model used for Disbursement Payment File FormatsHi Guys Does anyone know of the existence of comprehensive documentation around the set of fields that are available to be used in a new "Disbursement Payment File Forma…
-
Suggestion Needed: Removal of special characters at the XSL template level for Payment OutboundsHi Oracle Cloud Community, I hope this message finds you well. We are working on a project where our client requires payment outbound files generated in oracle cloud whi…Subhranil Maitra 41 views 2 comments 1 point Most recent by Vaikunth Talaulikar Payables, Payments & Cash Management
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 31 views 2 comments 0 points Most recent by Deputy Birara-Oracle Reporting and Analytics for ERP
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…Rama Mohan ReddyB 21 views 1 comment 0 points Most recent by Rama Mohan ReddyB General Ledger & Intercompany
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
How to customize Disbursement Payment File FormatSummary: How to customize Disbursement Payment File Format Content (please ensure you mask any confidential information): We are looking to implement a new electronic pa…
-
Where is the justification for a budget override request stored?Whenever a user creates a budget override request, he/she needs to enter a justification or reason for the override. The name of the field depends on the transaction for…
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
LACLS It is possible that DDF used in localization can be defined at the global attributes level?We are configuring the localization for Peru and have found that many of the descriptive fields are already in use by other companies operating in the system, so we have…Cristian Gonzalez S 1 view 0 comments 0 points Started by Cristian Gonzalez S Reporting and Analytics for ERP
-
BI Security using Secured View in Fusion HCM Release 9.2Summary BI Security using Secured ViewsContent Regarding BI Security the MOS ID (Doc ID 1533659.1) talks about : PER_POSITION_SECURED_LIST_V PER_PUB_PERS_SECURED_LIST_V …AshishERPCloud 314 views 6 comments 2 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b…Consultant Ian 3 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
YTD Depreciation is not showing correct value in Fixed AssetsHi I am using below tables in my query and i am pulling YTD Depreciation from Fa_Deprn_detail table. it is not pulling the record which has deprn_source_code='B' from th…
-
Ship-To Customer Information in Invoice LinesHello. Does anyone have any idea on what table to use to find this information? Is the SHIP_TO_PARTY_SITE_USE_ID the correct table to use for this and how to connect thi… -
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 141 views 2 comments 0 points Most recent by Chaunae Walton Payables, Payments & Cash Management
-
Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though whenSummary: Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though when our Payment process automatically transmits from Oracle Clo…Danny P Smith 31 views 3 comments 0 points Most recent by Stephanie Turner Payables, Payments & Cash Management