|
by oracleguru
NAME: Load DUNS Dimension
SHORT CODE: EDW_DUNS_M_T
MODULE: Oracle Purchasing Intelligence
Description: Load DUNS Dimension
Navigation: Oracle Purchasing Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.
Report Parameters:
by oracleguru
Oracle Purchasing Intelligence Tables:
| EDW_PO_VENDOR_HIERARCHIES |
| FND_FUNCTION_PARAMETER_MAP |
| FND_NOTIFICATIONS |
| POA_BIS_SAVINGS |
| POA_BIS_SAVINGS_EFC |
| POA_BIS_SAVINGS_RPT |
| POA_BIS_SAVINGS_RPT_EFC |
| POA_BIS_SUPPLIER_PERFORMANCE |
| POA_BIS_SUPPLIER_PERFORMAN_EFC |
| POA_CM_DISTRIBUTIONS |
| POA_CM_EVALUATION |
| POA_CM_EVAL_SCORES |
| PO_ACCEPTANCES |
| PO_ACCRUAL_ACCOUNTS_TEMP_ALL |
| PO_ACCRUAL_RECONCILE_TEMP_ALL |
| PO_ACCRUAL_WRITE_OFFS_ALL |
| PO_ACCRUAL_WRITE_OFFS_ALL_EFC |
| PO_ACTION_HISTORY |
| PO_AGENTS |
| PO_APPROVAL_LIST_HEADERS |
| PO_APPROVAL_LIST_LINES |
| PO_APPROVED_SUPPLIER_LIST |
| PO_ASL_ATTRIBUTES |
| PO_ASL_DOCUMENTS |
| PO_ASL_STATUSES |
| PO_ASL_STATUS_RULES |
| PO_ATT_TMP_RECORDS |
| PO_AUTOSOURCE_DOCUMENTS_ALL |
| PO_AUTOSOURCE_RULES |
| PO_AUTOSOURCE_VENDORS |
| PO_CHANGE_REQUESTS |
| PO_COMMODITIES_B |
| PO_COMMODITIES_TL |
| PO_COMMODITY_CATEGORIES |
| PO_COMMODITY_GRANTS |
| PO_CONTROL_FUNCTIONS |
| PO_CONTROL_GROUPS_ALL |
| PO_CONTROL_RULES |
| PO_CONTROL_RULES_EFC |
| PO_DISTRIBUTIONS_ALL |
| PO_DISTRIBUTIONS_ALL_EBS |
| PO_DISTRIBUTIONS_ARCHIVE_ALL |
| PO_DISTRIBUTIONS_INTERFACE |
| PO_DOCUMENT_TOTALS_GT |
| PO_DOCUMENT_TYPES_ALL_B |
| PO_DOCUMENT_TYPES_ALL_TL |
| PO_EMPLOYEE_HIERARCHIES_ALL |
| PO_ENCUMBRANCE_GT |
| PO_GA_ORG_ASSIGNMENTS |
| PO_GA_ORG_ASSIGNMENTS_ARCHIVE |
| PO_HAZARD_CLASSES_B |
| PO_HAZARD_CLASSES_TL |
| PO_HEADERS_ALL |
| PO_HEADERS_ALL_EBS |
| PO_HEADERS_ARCHIVE_ALL |
| PO_HEADERS_INTERFACE |
| PO_HISTORY_POS_ALL |
| PO_HISTORY_RECEIPTS |
| PO_HISTORY_REQUISITIONS_ALL |
| PO_HISTORY_VENDORS |
| PO_INTERFACE_ERRORS |
| PO_JOB_ASSOCIATIONS_B |
| PO_JOB_ASSOCIATIONS_TL |
| PO_LINES_ALL |
| PO_LINES_ALL_EBS |
| PO_LINES_ARCHIVE_ALL |
| PO_LINES_INTERFACE |
| PO_LINE_LOCATIONS_ALL |
| PO_LINE_LOCATIONS_ALL_EBS |
| PO_LINE_LOCATIONS_ARCHIVE_ALL |
| PO_LINE_LOCATIONS_GT |
| PO_LINE_TYPES_B |
| PO_LINE_TYPES_TL |
| PO_LOCATION_ASSOCIATIONS |
| PO_LOCATION_ASSOCIATIONS_ALL |
| PO_MASSCANCEL_INCLUDES_ALL |
| PO_MASSCANCEL_INTERIM |
| PO_MC_DISTRIBUTIONS |
| PO_MC_HEADERS |
| PO_NOTES |
| PO_NOTE_ATTRIBUTES |
| PO_NOTE_REFERENCES |
| PO_NOTIFICATIONS_ALL |
| PO_NOTIFICATION_CONTROLS |
| PO_ONLINE_REPORT_TEXT |
| PO_POSITION_CONTROLS_ALL |
| PO_PRICE_DIFFERENTIALS |
| PO_PRICE_DIFFERENTIALS_ARCHIVE |
| PO_PRICE_DIFF_INTERFACE |
| PO_PURGE_PO_LIST |
| PO_PURGE_RECEIPT_LIST |
| PO_PURGE_REQ_LIST |
| PO_PURGE_VENDOR_LIST |
| PO_QUALITY_CODES |
| PO_QUOTATION_APPROVALS_ALL |
| PO_RELATED_TEMPLATES |
| PO_RELEASES_ALL |
| PO_RELEASES_ALL_EBS |
| PO_RELEASES_ARCHIVE_ALL |
| PO_REQEXPRESS_HEADERS_ALL |
| PO_REQEXPRESS_LINES_ALL |
| PO_REQUISITIONS_INTERFACE_ALL |
| PO_REQUISITIONS_INT_ALL_EFC |
| PO_REQUISITION_HEADERS_ALL |
| PO_REQUISITION_LINES_ALL |
| PO_REQUISITION_LINES_ALL_EFC |
| PO_REQUISITION_SUPPLIERS |
| PO_REQ_DISTRIBUTIONS_ALL |
| PO_REQ_DISTRIBUTIONS_ALL_EFC |
| PO_REQ_DIST_INTERFACE_ALL |
| PO_RESCHEDULE_INTERFACE |
| PO_RETRIEVED_TIMECARDS |
| PO_RFQ_VENDORS |
| PO_RULE_EXPENSE_ACCOUNTS |
| PO_SUPPLIER_ITEM_CAPACITY |
| PO_SUPPLIER_ITEM_TOLERANCE |
| PO_SYSTEM_PARAMETERS_ALL |
| PO_UNIQUE_IDENTIFIER_CONT_ALL |
| PO_UN_NUMBERS_B |
| PO_UN_NUMBERS_TL |
| PO_USAGES |
| PO_USAGE_ATTRIBUTES |
| PO_VALIDATION_RESULTS_GT |
| PO_VENDORS |
| PO_VENDORS_EBS |
| PO_VENDOR_CONTACTS |
| PO_VENDOR_LIST_ENTRIES |
| PO_VENDOR_LIST_HEADERS |
| PO_VENDOR_SITES_ALL |
| PO_VENDOR_SITES_ALL_EBS |
| PO_WF_CANDIDATE_REQ_LINES_TEMP |
| PO_WF_DEBUG |
| PO_WF_USER_TMP |
| RCV_ACCOUNTING_EVENTS |
| RCV_ACCOUNTING_EVENT_TYPES |
| RCV_FTE_TRANSACTION_LINES |
| RCV_GAPLESS_INVOICE_NUMBERS |
| RCV_HEADERS_INTERFACE |
| RCV_LOTS_INTERFACE |
| RCV_LOTS_SUPPLY |
| RCV_LOT_TRANSACTIONS |
| RCV_MC_REC_SUB_LEDGER |
| RCV_MC_SHIPMENT_HEADERS |
| RCV_MC_SHIPMENT_LINES |
| RCV_MC_SUB_LEDGER_DETAILS |
| RCV_MC_TRANSACTIONS |
| RCV_PARAMETERS |
| RCV_RECEIVING_SUB_LEDGER |
| RCV_ROUTING_HEADERS |
| RCV_ROUTING_HEADERS_OLD |
| RCV_ROUTING_STEPS |
| RCV_SERIALS_INTERFACE |
| RCV_SERIALS_SUPPLY |
| RCV_SERIAL_TRANSACTIONS |
| RCV_SHIPMENT_HEADERS |
| RCV_SHIPMENT_LINES |
| RCV_SHIPMENT_LINES_EFC |
| RCV_SUB_LEDGER_DETAILS |
| RCV_SUPPLY |
| RCV_TRANSACTIONS |
| RCV_TRANSACTIONS_INTERFACE |
| RCV_UPGRADE_STEPS |
by oracleguru
Oracle Purchasing Intelligence Profile Options
| PROFILE OPTION SHORT CODE | PROFILE OPTION NAME |
| POA_DNB_HOOKS | POA: Duns and UNSPSC Hooks |
| POA_COLLECTION_BATCH_SIZE | POA: Collection Batch Size |
| POA_TRACE | POA: Trace Mode |
| POA_DEBUG | POA: Debug Mode |
| DEFAULT_COST_OF_CAPITAL | POA: Default Cost of Capital |
| SCORE_CARD_PRICE_WEIGHT | POA: Score Card Weight – Price |
| SCORE_CARD_CUST_SATISFACTION_WEIGHT | POA: Score Card Weight – Customer Satisfaction |
| SCORE_CARD_QUALITY_WEIGHT | POA: Score Card Weight – Quality |
| SCORE_CARD_DELIVERY_WEIGHT | POA: Score Card Weight – Delivery |
| POA_TARGET_PRICE_TXN | POA: Calculate Target Price in Source |
| POA_POPULATE_SAVINGS_TXN | POA: Calculate Savings in Source |
| POA_FIXED_DATE | POA: Fixed System Date |
| POA_PERIOD_NAME | POA: Global Calender Name |
| POA_PERIOD_TYPE | POA: Global Period Type |
| POA_CURRENCY_CODE | POA: Global Currency Code |
| POA_CURRENCY_RATE_TYPE | POA: Global Rate Type |
| POA_DBI_IMPLEMENTATION | POA: DBI Implementation |