You are browsing the archive for Oracle Customer Care.

Relationship Plan Assignment Engine

 

NAME: Relationship Plan Assignment Engine
SHORT CODE: CSCRSPEN
MODULE: Oracle Customer Care

Description: Plan assignment / de-assignment engine.
Navigation: Oracle Customer Care Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_PLAN_ID : References Plan_Id in Csc_Plan_Headers_B
  • P_CHECK_ID : References Check_Id in Csc_Prof_Checks_B
  • P_PARTY_ID : References Party_Id in Hz_Parties
  • P_CUST_ACCOUNT_ID : References Cust_Account_Id in Hz_Cust_Accounts

 

Customer Profile Engine

 

NAME: Customer Profile Engine
SHORT CODE: CSCPRFEN
MODULE: Oracle Customer Care

Description: Customer Profile Engine – Computes profile check results for customers.
Navigation: Oracle Customer Care Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_PARTY_TYPE : References Party Type
  • P_PARTY_ID : References Party_Id
  • P_GROUP_ID : References Group_Id in Csc_Prof_Groups_B

 

Oracle Customer Care Tables

Oracle Customer Care module database tables:

  • CSC_COLOR_CODES
  • CSC_CUSTOMERS
  • CSC_CUSTOMERS_AUDIT_HIST
  • CSC_CUSTOMIZED_PLANS
  • CSC_CUST_PLANS
  • CSC_CUST_PLANS_AUDIT
  • CSC_PLAN_ENABLE_SETUP
  • CSC_PLAN_HEADERS_B
  • CSC_PLAN_HEADERS_TL
  • CSC_PLAN_LINES
  • CSC_PROF_BLOCKS_B
  • CSC_PROF_BLOCKS_TL
  • CSC_PROF_BLOCK_RESULTS
  • CSC_PROF_CHECKS_B
  • CSC_PROF_CHECKS_TL
  • CSC_PROF_CHECK_RATINGS
  • CSC_PROF_CHECK_RESULTS
  • CSC_PROF_CHECK_RULES_B
  • CSC_PROF_CHECK_RULES_TL
  • CSC_PROF_DRILLDOWN
  • CSC_PROF_GROUPS_B
  • CSC_PROF_GROUPS_TL
  • CSC_PROF_GROUP_CATEGORIES
  • CSC_PROF_GROUP_CHECKS
  • CSC_PROF_MODULE_GROUPS
  • CSC_PROF_TABLE_COLUMNS_B
  • CSC_PROF_TABLE_COLUMNS_TL