Arris RTM Otbi I2c p3 Reportstotest 09sep2018
Arris RTM Otbi I2c p3 Reportstotest 09sep2018
Arris RTM Otbi I2c p3 Reportstotest 09sep2018
Reporting I2C.088
Reporting I2C.091
Reporting I2C.494
Staged Orders
Account Receivable - Real
Time - Chas Received - By
Customer
AR - Aging Details by
Collector and Customer with
Credit Limit
AR - Aging Details by
Collector and Customer with
Credit Limit (With Entered
Currency)
AR - Aging Details by
Customer Class (Corporate
ID)
AR - Aging Details by
Operating Unit and
Customer
AR - Aging Snapshot Details
by Customer and Collector
Requirement Owner/
Requirement Type Contact Requirement Date
Business Carlos 11.15.17
Lori Hicks
Rachel Bornstein
Carlos Vianna
Business Nancy
Lewallen/Rachel/Charlotte
Business Nancy Lewallen
Daily Aging
MUST HAVE
MUST HAVE
MUST HAVE
MUST HAVE
MUST HAVE
MUST HAVE
MUST HAVE
MUST HAVE
MUST HAVE
Requirement Review Status Fit / Gap Enabling Technology
Accepted Oracle Finance Cloud
Gap
Gap
Gap
SAME AS - NA NA
I2C.AR/Oracle.0744
NA NA
NOT NEEDED - Carlos
Vianna 03/14
Gap Resolution
Gap Resolution Type Application/Module Gap Review Owner
Technical – Report AR Carlos Vianna
NA Carlos Vianna
NA Carlos Vianna
Fit / Gap Completion Date RICEWF# Test Case #
12/13/2017
2.12.18
12.13.17
2.14.18
11.14.17
OTBI Analysis or BI
Planning Testing Cycle BI Team Comment Publisher?
P3
BI Publisher Report/ AR
AR Aging Dashboard
AR Aging Dashboard
AR Aging Dashboard
AR Aging Dashboard
12
Inquiry to Cash (I2C) I2C.RPT.0108 New Vendor On-Boarding Form
13 Repository
Inquiry to Cash (I2C) I2C.RPT.0109 Marketing Identifier List
14
31
35
37
43
Inquiry to Cash (I2C) I2C.RPT.0028 SSD Audit Open Orders and Picks
44
54 I2C.RPT.0007 IR reports
71
79
Business Requirement Description Question Raised By
Workflow approval details for all How are workflows handled in Oracle Cloud Satya
levels of the approval process for a
single workflow. (multiple detail
lines for a single workflow)
Entered Status with Ship Set How are we handling Shipset in Oracle Cloud Satya
Audit requirement that orders > Will second review notes be available in Fusion cloud? If Satya
$100K must have a second review not, how are we handling the second review method
prior to booking. This report
identifies those orders that were
not second reviewed.
Identifies approval path of order How are workflows handled in Oracle Cloud Satya
validation workflows and final
status and wf cycle time. One line
per workflow.
Price List Dashboard Will the Price list data be avilable in OM data or CPQ Satya
Cloud
Orders with Trial Info Shipped Last Will we continue to have SOA acknowledgements in Satya
Month Open - Trial & IR Finance cloud. If yes, how is this being handled
Reports
Identifies pending IR approvals Where will the contract data be available in cloud. Will it Satya
be under service contracts module or Salesforce
Oracle Report - Manual Custom Will we continue to have SOA acknowledgements in Satya
SOA cloud. If yes, how is this being handled
User created shared report - list of Where will Marketing contract data reside? Satya
Marketing Contracts
Open Marketing Pos Need more details and sample report for this Satya
Checks on status of inv/pymt Not a Reporting requirement Satya
Codes specificed by Finance Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Email delivery, opens, click throughs Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Email delivery, opens, click throughs Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Library of reports on Flightdeck Who will be handling these reports, previouly marketing Satya
usage reports were not being handled by BI Team
Reporting on status of content Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Consumer review tracker Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Dashboard for various systems Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Monitors social media Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Website statistics Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Survey tool Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Website vulnerability scanner Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Website application security tool Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Website tag management Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Governance and accessibility checks Who will be handling these reports, previouly marketing Satya
for ARRIS web properties reports were not being handled by BI Team
Search engine optimization for Who will be handling these reports, previouly marketing Satya
ARRIS web properties reports were not being handled by BI Team
Website monitoring tool Who will be handling these reports, previouly marketing Satya
reports were not being handled by BI Team
Open Workflow notification report
pending by approver
Abhishek
Ability to replicate L-Pace baseline Need a sample report
report Abhishek
Ability to have an automated cash
forecast report How we are calculating Cash forecasting Abhishek
Ability to run reports on data and Need more details
track metrics
Abhishek
Ability to have a report for AR Aging
by Collector Pending Oracle SR Abhishek
Ability to identify aging items
Pending Oracle SR Abhishek
Orders in Entered status that can
not be booked. Awaiting on part
number, offer approval, etc
Should this report be on CPQ or OM? What is Staged
Order? Abhishek
Tracks SSD changes on open sales
order lines
Venkat
RT AR - All VAR Sample Data required? What is VAR? Need more details oVenkat
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
SFDC
Abhishek
Need More details on Requirement.
Abhishek
Need More details on Requirement.
Abhishek
Need More details on Requirement.
Abhishek
Report used for Service Contract Where will the Service Contract lines be invoiced - Oracle
Invoice Lines Service Contract Cloud or Peoplesoft? Venkat
Retail Returns Where will find the Retail related data?
Venkat
Venkat
Need more details on Requirement and Sample Data. Venkat
Ability to track write-off by reason Where will the write - off transactions will be created? Satya
code Directly in GL or subledger?
Ability to generate pro-forma
invoice with correct information Need more details and sample report required Satya
Ability to have reporting in central Abhishek
location Need more details and sample report required
Ability to have report on Abhishek
customer demand Need more details and sample report required
Ability to report on spare part Abhishek
orders Need more details and sample report required
Ability to report on ship Abhishek
complaints Need more details and sample report required
Ability to have contract Abhishek
information for CI docs Need more details and sample report required
Ability to identify and report on Abhishek
EMS customer shipments to
manage Deferred margins
Need more details and sample report required
Assigned To Status Remarks
Yannick ON HOLD We have Business Process
Management(BPM) in Cloud and need to
explore under Business Process
Execution Language - BPEL workflows.
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick Open
Yannick OUT OF
SCOPE
Yannick Pending Related to Marketing Contracts and it's
available in Salesforce.
Yannick Open
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick OUT OF
SCOPE
Yannick ON HOLD We have Business Process
Management(BPM) in Cloud and need to
explore under Business Process
Execution Language - BPEL workflows.
Yannick Closed
Need to check with workstream configurati
Yannick Closed
Need to check with workstream configurati
Yannick Closed
Need to check with workstream configurati
Yannick Closed
Yannick OUT OF
SCOPE
Yannick Closed
Yannick Closed
Yannick ON HOLD
It belongs to Order Management. Booked
Orders those are not dispatched. Need to
check with OMSC Team to identify these
staged orders.
Yannick OUT OF
SCOPE
Yannick Closed
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Yannick Pending
Need to check with OMSC Team - Gopal
Yannick Pending
Need to check with OMSC Team - Gopal
Yannick Pending
Need to check with OMSC Team - Gopal
Yannick Open
Yannick Open
Yannick Pending
Yannick Open
Yannick Closed
Only active items are considered for
Transactions and we can find
Yannick Closed Open/closed throough Transaction
status. For all Items, whose Item status =
'NULL', those items are not avialable in
11i system.
Yannick Closed
Yannick Open
Yannick Open
Yannick Open
Yannick Open
Yannick Open
Yannick Open
Yannick Open
I2C comments Additional Comments
Reporting on NDA's = SF
Decision to move to Enterprise Contracts is on hold.
Data will stay in Contrtact Central until EC decision is Dropped a mail to Bridget and awaiting
made. for her response.
Is this a S2P Vendor requirement of I2C customer
requirement? Need to check with Yannick
Would be great if the identifiers could be a field in
SMART. I don’t think this is a BI issue, but a SMART
request.
Same as a above
The criteria is all invoices that 365+ past due. We run 3 Obiee reports ( email attached)
We use Class Code, we run an aging and sort. Work in Progress
Carlos Viana, J Vinodh : We have a customize out of 11i
option for reports. Statements is based on Aging
bucket. Refer Custom statements report in 11i. Work in Progress
The criteria is all invoices that 365+ past due. We run 3 Obiee reports ( email attached)
The criteria is all invoices that 365+ past due. We run 3 Obiee reports ( email attached)