| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||||
3 | Object : Supplier | |||||||||||||||||||||||||||
4 | Sr No | Sequence | Supplier Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ESS JOB for loading data into Interface tables | Standard ESS JOB for loading data from Interface tables to Base Tables along with parameters | Resource allocated to Technical Owner | Reviewers | |||||||||||||||
5 | 1 | 1 | Suppliers | POZ_SUPPLIERS | POZ_SUPPLIERS_INT | Create one supplier-POST-/fscmRestApi/resources/11.13.18.05/suppliers Get all suppliers-GET-/fscmRestApi/resources/11.13.18.05/suppliers Get one supplier-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId} Update one supplier-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierImportTemplate.xlsm | POZ_SUPPLIERS_INT | Import Suppliers | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
6 | 1 | 2 | Supplier Sites | POZ_SUPPLIER_SITES_ALL_M | POZ_SUPPLIER_SITES_INT, POZ_SUP_THIRDPARTY_INT | Create one site-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites Get all sites-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites Get one site-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites/{SupplierSiteId} Update one site-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites/{SupplierSiteId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierSiteImportTemplate.xlsm | POZ_SUPPLIER_SITES_INT | Import Supplier Sites | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
7 | 1 | 3 | Supplier Site Assignments | POZ_SITE_ASSIGNMENTS_ALL_M | POZ_SITE_ASSIGNMENTS_INT | Create one assignment-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites/{SupplierSiteId}/child/assignments Get all assignments-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites/{SupplierSiteId}/child/assignments Get one assignment-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites/{SupplierSiteId}/child/assignments/{AssignmentId} Update one assignment-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/sites/{SupplierSiteId}/child/assignments/{AssignmentId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierSiteAssignmentImportTemplate.xlsm | POZ_SITE_ASSIGNMENTS_INT | Import Supplier Site Assignments | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
8 | 1 | 7 | Supplier Products and Services Categories | POZ_SUP_PRODUCTS_SERVICES | POZ_SUP_PROD_SERV_INT | Create one product and service-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/productsAndServices Delete one product and service-DELETE-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/productsAndServices/{SupplierProductsServicesId} Get all products and services-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/productsAndServices Get one product and service-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/productsAndServices/{SupplierProductsServicesId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierProductsandServicesCategoryImportTemplate.xlsm | POZ_SUP_PROD_SERV_INT | Import Supplier Products and Services Categories | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
9 | 1 | 5 | Supplier Contacts | POZ_SUPPLIER_CONTACTS | POZ_SUP_CONTACTS_INT , POZ_SUP_CONTACT_ADDRESSES_INT | Create one contact-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts Get all contacts-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts Get one contact-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts/{SupplierContactId} Update one contact-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts/{SupplierContactId} Create one contact address-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts/{SupplierContactId}/child/addresses Delete one contact address-DELETE-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts/{SupplierContactId}/child/addresses/{SupplierContactAddressId} Get all contact addresses-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts/{SupplierContactId}/child/addresses Get one contact address-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/contacts/{SupplierContactId}/child/addresses/{SupplierContactAddressId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierContactImportTemplate.xlsm | POZ_SUP_CONTACTS, POZ_SUPP_CONTACT_ADDRESSES_INT | Import Supplier Contacts | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
10 | 1 | 6 | Supplier Business Classifications | POZ_BUS_CLASSIFICATIONS | POZ_SUP_BUS_CLASS_INT | Create one business classification-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/businessClassifications Get all business classifications-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/businessClassifications Get one business classification-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/businessClassifications/{ClassificationId} Update one business classification-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/businessClassifications/{ClassificationId} Delete one business classification-DELETE-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/businessClassifications/{ClassificationId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierBusinessClassificationImportTemplate.xlsm | POZ_SUP_BUS_CLASS_INT | Import Supplier Business Classifications | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
11 | 1 | 8 | Supplier Attachments | FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_TL | POZ_SUP_ATTACHMENTS_INT | Create an attachment-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/attachments Get all attachments-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/attachments Get an attachment-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/attachments/{attachmentsUniqID} Update an attachment-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/attachments/{attachmentsUniqID} Delete an attachment-DELETE-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/attachments/{attachmentsUniqID} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierAttachmentImportTemplate.xlsm | Supplier_Profile_Attachments, Supplier_Site_Attachments, Business_Class_Attachments | Import Supplier Attachments | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
12 | 1 | 4 | Supplier Addresses | HZ_PARTY_SITES, HZ_LOCATIONS | POZ_SUP_ADDRESSES_INT | Create one address-POST-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/addresses Get all addresses-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/addresses Get one address-GET-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/addresses/{SupplierAddressId} Update one address-PATCH-/fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/addresses/{SupplierAddressId} | https://servername/fscmService/SupplierServiceV2?WSDL | SupplierAddressImportTemplate.xlsm | POZ_SUPPLIER_ADDRESSES_INT | Import Supplier Addresses | Load Interface File for Import | Namratha | ALL others | |||||||||||||||
13 | ALL others | |||||||||||||||||||||||||||
14 | Object : Requisition | ALL others | ||||||||||||||||||||||||||
15 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
16 | 1 | 1 | Requisitions | POR_REQUISITION_HEADERS_ALL POR_REQUISITION_LINES_ALL POR_REQ_DISTRIBUTIONS_ALL | POR_REQ_DISTS_INTERFACE_ALL POR_REQ_HEADERS_INTERFACE_ALL POR_REQ_LINES_INTERFACE_ALL | fscmRestApi/resources/11.13.18.05/purchaseRequisitions | fscmService/PurchaseRequestService?WSDL | RequisitionImportTemplate.xlsm | POR_REQ_HEADERS_INTERFACE_ALL POR_REQ_LINES_INTERFACE_ALL POR_REQ_DISTS_INTERFACE_ALL | Import Requisitions | Load Interface File for Import | Raghavendra | ALL others | |||||||||||||||
17 | ALL others | |||||||||||||||||||||||||||
18 | Object : PO | ALL others | ||||||||||||||||||||||||||
19 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
20 | 1 | 1 | PURCHASE ORDER | PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_ALL | PO_DISTRIBUTIONS_INTERFACE PO_HEADERS_INTERFACE PO_LINES_INTERFACE | POST - /fscmRestApi/resources/11.13.18.05/purchaseOrders/{purchaseOrdersUniqID}/action/acknowledge CANCEL ONE PURCHASE ORDER - /fscmRestApi/resources/11.13.18.05/purchaseOrders/{purchaseOrdersUniqID}/action/cancel Close one purchase order - /fscmRestApi/resources/11.13.18.05/purchaseOrders/{purchaseOrdersUniqID}/action/close Duplicate one purchase order - /fscmRestApi/resources/11.13.18.05/purchaseOrders/{purchaseOrdersUniqID}/action/duplicate Get all purchase orders - /fscmRestApi/resources/11.13.18.05/purchaseOrders Get one purchase order - /fscmRestApi/resources/11.13.18.05/purchaseOrders/{purchaseOrdersUniqID} | https://docs.oracle.com/en/cloud/saas/procurement/26c/oeswp/get-purchase-order-34663.html | POPurchaseOrderImportTemplate.xlsm | PO_HEADERS_INTERFACE , PO_DISTRIBUTIONS_INTERFACE PO_LINES_INTERFACE PO_LINE_LOCATIONS_INTERFACE | Import Orders | Load Interface File for Import | Nandini | ALL others | |||||||||||||||
21 | Nandini | ALL others | ||||||||||||||||||||||||||
22 | Nandini | ALL others | ||||||||||||||||||||||||||
23 | ALL others | |||||||||||||||||||||||||||
24 | ALL others | |||||||||||||||||||||||||||
25 | OBJ : PO Receipt-GRN | ALL others | ||||||||||||||||||||||||||
26 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
27 | 1 | 1 | Receiving Receipt | RCV_SHIPMENT_HEADERS RCV_SHIPMENT_LINES RCV_TRANSACTIONS | INV_LPN_INTERFACE INV_SERIAL_NUMBERS_INTERFACE INV_TRANSACTION_LOTS_INTERFACE RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE | Create a standard receipt - /fscmRestApi/resources/11.13.18.05/standardReceipts Delete a standard receipt - /fscmRestApi/resources/11.13.18.05/standardReceipts/{StandardReceiptId} Get a standard receipt - /fscmRestApi/resources/11.13.18.05/standardReceipts/{StandardReceiptId} Get all standard receipts - /fscmRestApi/resources/11.13.18.05/standardReceipts Update a standard receipt - /fscmRestApi/resources/11.13.18.05/standardReceipts/{StandardReceiptId} | https://servername/fscmService/CreateAndApplyReceiptService?WSDL | ReceivingReceiptImportTemplate.xlsm | RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE INV_TRANSACTION_LOTS_INTERFACE INV_SERIAL_NUMBERS_INTERFACE INV_LPN_INTERFACE | Manage Receiving Transactions | Load Interface File for Import | Sushmitha | ALL others | |||||||||||||||
28 | Sushmitha | ALL others | ||||||||||||||||||||||||||
29 | ALL others | |||||||||||||||||||||||||||
30 | ALL others | |||||||||||||||||||||||||||
31 | Object : AP Invoice | ALL others | ||||||||||||||||||||||||||
32 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
33 | 1 | 1 | Payables Standard Invoice | AP_INVOICES_ALL AP_INVOICE_LINES_ALL AP_INVOICE_DISTRIBUTIONS_ALL | AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE | fscmRestApi/resources/11.13.18.05/invoices | fscmService/InvoiceInterfaceService?WSDL | PayablesStandardInvoiceImportTemplate.xlsm | AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE | Import Payables Invoices | Load Interface File for Import | Rajesh | ALL others | |||||||||||||||
34 | 2 | Payables Payment Request | AP_INVOICES_ALL AP_INVOICE_LINES_ALL AP_INVOICE_DISTRIBUTIONS_ALL | AP_PAYMENT_REQUESTS_INT | /fscmRestApi/resources/11.13.18.05/payablesPayments | fscmService/PayablesPaymentRequestService?WSDL | PayablesPaymentRequestImportTemplate.xlsm | AP_PAYMENT_REQUESTS_INT | Import Payables Payment Request | Load Interface File for Import | Rajesh | ALL others | ||||||||||||||||
35 | ALL others | |||||||||||||||||||||||||||
36 | ALL others | |||||||||||||||||||||||||||
37 | ALL others | |||||||||||||||||||||||||||
38 | Object : AP Payments | ALL others | ||||||||||||||||||||||||||
39 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
40 | 1 | 1 | Import Legacy Credit Cards | IBY_CREDITCARDS IBY_CREDITCARD_H IBY_PMT_INSTR_USES_ALL IBY_EXTERNAL_PAYERS_ALL | Create a payment(Post):- /fscmRestApi/resources/11.13.18.05/payablesPayments Get a payment(Get) :- /fscmRestApi/resources/11.13.18.05/payablesPayments/{CheckId} Get all payments(Get all) :- /fscmRestApi/resources/11.13.18.05/payablesPayments Update a payment(Patch):- /fscmRestApi/resources/11.13.18.05/payablesPayments/{CheckId} | IbyLegacyCreditCardImportTemplate.xlsm | TokenizedCreditCardDetails | Import Legacy Credit Cards | Load Interface File for Import | Poornima/ | ALL others | |||||||||||||||||
41 | 2 | Supplier Bank Account Import | IBY_TEMP_EXT_BANK_ACCTS IBY_EXT_BANK_ACCOUNTS IBY_EXTERNAL_PAYEES_ALL IBY_PMT_INSTR_USES_ALL | IBY_TEMP_EXT_BANK_ACCTS IBY_TEMP_EXT_PAYEES IBY_TEMP_PMT_INSTR_USES | SupplierBankAccountImportTemplate.xlsm | IBY_TEMP_EXT_PAYEES IBY_TEMP_EXT_BANK_ACCTS IBY_TEMP_PMT_INSTR_USES | Import Supplier Bank Accounts | Load Interface File for Import | Poornima | ALL others | ||||||||||||||||||
42 | Poornima | ALL others | ||||||||||||||||||||||||||
43 | ALL others | |||||||||||||||||||||||||||
44 | ALL others | |||||||||||||||||||||||||||
45 | Object : Accounting | ALL others | ||||||||||||||||||||||||||
46 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
47 | 1 | 1 | SubledgerAccounting | XLA_TRANSACTION_ENTITIES,XLA_EVENTS,XLA_AE_HEADERS,XLA_AE_LINES | XLA_MAPPING_SET_VALUES_INT | XlaMappingsImportTemplate.xlsm | Mappings | Load Interface File for Import | Import Accounting Setup | Bhavyasri | ALL others | |||||||||||||||||
48 | Bhavyasri | ALL others | ||||||||||||||||||||||||||
49 | Bhavyasri | ALL others | ||||||||||||||||||||||||||
50 | ALL others | |||||||||||||||||||||||||||
51 | Object : Journals | ALL others | ||||||||||||||||||||||||||
52 | Sr No | Sequence | Entities | Base table | Interface table | Rest API | Soap Service | FBDI Template | FBDI Sheet Name | ALL others | ||||||||||||||||||
53 | 1 | 1 | Journal Import | GL_JE_BATCHES GL_JE_HEADERS GL_JE_LINES | GL_INTERFACE | /fscmRestApi/resources/latest/journalBatches/{JournalBatchId} | /fscmService/JournalImportService?WSDL | JournalImportTemplate.xlsm | GL_INTERFACE | Import Journals | Load Interface File for Import | Abhilash | ALL others | |||||||||||||||
54 | ||||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||||
56 | ||||||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||||