What is the the Oracle cloud table for Sales Agreements, We need the Agreements name,Effective Start and End date ,signed date, sales rep and price list etc In R12 we have oe_agreements_b and oe_agreements_tl etc..
Hi @Binu S
Can you refer Data-lineage -
https://docs.oracle.com/en/cloud/saas/analytics/24r2/fascm/chapter-data-lineage.html
Regards,
Arjun
@Binu S The FDI sales agreement table is DW_AGREEMENT_CF. Can you please check the same and confirm if this is the table you are looking for?
In Oracle Cloud, sales agreements information is typically found in the DOO (Distributed Order Orchestration) and Order Management modules. Some relevant tables for sales agreements include:
header_id
agreement_name
start_date
end_date
signed_date
For fields like the agreement name, effective start/end dates, signed date, sales rep, and price list, you can join these tables based on header_id or party_id where applicable.
party_id
An example query:
sqlCopy codeSELECT d.header_id, d.agreement_name, d.effective_start_date, d.effective_end_date, d.signed_date, hz.party_name AS sales_rep, ql.price_list_nameFROM DOO_HEADERS_ALL dJOIN HZ_PARTIES hz ON d.sales_rep_id = hz.party_idJOIN QP_LIST_HEADERS_B ql ON d.price_list_id = ql.list_header_id;
This retrieves key details like agreement names, dates, and associated sales reps and price lists.
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
Hello, I'm looking for some guidance on adding Extensible Flexfields (EFFs) into FDI. I'm particularly looking to add fields from the Additional Assignment Info area (PER_ASSIGNMENT_EXTRA_INFO_M). Has anyone done this and have any guidance to share? The documentation I have found to date has not been very insightful. Thank…
Hello, Am new to FDI but learning. I know that we can access the FDI Workbook (which you normally see in Oracle Analytics - see below) from the Fusion landing page, as demo-ed by one of our consultants. However, how do we do this? I know that in Fusion Security Console, you need to add several application roles in order to…
I want to know how PaaS data can be brought into FDI. Ex : Some customer related information is on PaaS. I want to bring it in FDI to join it with customer data coming from oracle fusion and then build an overall report.
