BI Publisher
Discussion List
-
Display Invoice Retainage details on the Payment Template and SRAHi Experts, Would like to know if we can populate the Retainage amount/details available on the Invoice into the payment template. Currently, the payment xml does not in…asurnilla 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…Ankit_Bhadja 81 views 1 comment 0 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
How to setup FTP server on PDH and send files from PDH to PDH FTP serverSummary: We have a requirement of sending Item and Cost master information from PDH to CPQ via SOA middleware. We need to enable and setup FTP server on PDH so that SOA …Kajal Dhawral 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM -
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte…
-
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Need a SQL query to fetch CIP asset and Capitalized assets separatelyHi All, We need a sql query to fetch details of CIP assets columns are Asset number, asset type, period name, asset id, cost Capitalized asset columns Asset number, asse…
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 21 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 61 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 22 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Store signature in cloud (employee DOR or somewhere) to be used in the reportSummary: In EBS we used to be able to store the employee signature in the DOR, then we used the image in the PDF reports (like tax certification). We wanted to do the sa…
-
Invoice Amount Calculation on Agreement Life CycleSummary: Does anyone know how the invoice amount on the Agreement Life Cycle is calculated? Content (please ensure you mask any confidential information): I am using the…Jill Larson 21 views 2 comments 0 points Most recent by Glen/Oracle Support-Oracle Payables, Payments & Cash Management
-
Fixed Assets - Report to Find if Assets have "Amortize Adjustment" flag checkedWe are creating a +$0.01 adjustment followed by a -$0.01 adjustment in the fixed assets module for every asset in order to have the “amortize adjustment” flag checked wi…
-
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 453 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Ability to run “Print Receivables Transactions” program based on “real” from/to print dateSummary: Usecase: We usually re-printed some transactions when our customers request a copy of the initial printed transactions with a label saying that it is the exact …
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 22 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to use an SQL query to select records of elements whose value was changed by CORRECT?Hello everyone, How to retrieve with an SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS ta…Alex_Balanovsky 81 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to establish a connection from Oracle Cloud to Local printer to print chequesHow to establish a connection from Oracle Cloud to Local printer to print cheques Hi all, We are trying to establish a connection between Oracle Cloud and a local printe…Daniel Ackland 91 views 5 comments 0 points Most recent by Joseph Terry Payables, Payments & Cash Management
-
Query to get payment description from payable payment pageSummary: Hi everyone, I am building up a query for extracting all payable payment informations. I cannot find the payment description that I am able to see on the web pa…GNCC33 103 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
debugging an errorSummary: debugging an error Content (please ensure you mask any confidential information): Hello everyone, I am getting this error when running a report in PROD but not …
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…Seema Kalantri 32 views 3 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h… -
How to distinguish the output file basing on the scheduling dateSummary: How to distinguish the output file basing on the scheduling date Content (please ensure you mask any confidential information): Hi, we created a BI report; the …
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…Charan Kollipara 806 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Error while loading LearningRecord.dat fileHi Team, While loading the below HDL, I'm getting the following error:…Saurav R-Oracle 13 views 3 comments 0 points Most recent by Keerthi Masireddy-Support-Oracle Learning
-
Is there a way to get new and old value for an object in OTBI without logical SQL?is there a subject area that inherently stores old and new values of objects like department lAloka Bhattacharya 51 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…