oracle_ebs_interface

《oracle_ebs_interface》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Manufacturing&DistributionOpenInterfaceOpenInterfaceArchitectureThreedifferentmethodsforimportandexportdata(inboundandoutbound)InterfaceTables(In)InterfaceViews(Out)FunctionCallsorProgrammaticInterfaces(In/Out)InterfaceTablesRequiressomevalidationthroughaconcurrentprogramYoucanwritedirectlytot

2、hetablesifyouarefamiliarwiththemInterfaceViewsViewssimplifythedatarelationshipsforeasierprocessingEx:mtl_item_quantities_viewDefinedinTechnicalReferenceManualDynamicViewsforOracleQualityFunctionCallsTightintegrationwithoutaddingabatchprocesstomovedataEx:ECOAPIEx:POAPIInboundInterfaceModelSourc

3、eApplicationDestinationApplicationInterfaceTableorDatabaseViewErrorsTableLoadProcessValidateMaintainOpenInterfaceComponentsSourceApplicationDestinationApplicationInterfaceTableIdentifierColumnsControlColumnsDataColumnsRequiredColumnsDerivedColumnsOptionalColumnsErrorsTableDatabaseViewLoadFunct

4、ionsqlloadertotemptabletemptointerfaceValidateFunctionProcessFunctionMaintainFunctionEx:openinterfacewindowOpenInterfacesOracleInventoryItemImportTransactionInterfaceReplenishmentCross-ReferenceCycleCountKanbanLotReservationMoveOrderOraclePurchasingRequisitionInterfacePurchaseInterfaceReceivin

5、gInterfaceOracleBillofMaterialBOMImportRoutingImportSubstitutionImportDesignatorImportOpenInterfacesOracleWorkinProcessJobImportMoveTransactionResoruceTransactionOracleMasterSchedulingForecastImportMPS/MDSImportOracleEngineeringECOInterfaceOrderManagementOrderImportSalesOrderAPIOracleQualityRe

6、sultImportItemImportInterfaceTablemtl_system_items_interfaceUpdatedtablemtl_system_itemsConcurrentProgramImportItemsErrorsTablemtl_interface_errorsRequireddataitem_numberorganization_codedescriptionprocess_flag(1,Pending)transaction_type(CREATE)ItemTableRelationshipMTL_ITEM_CATALOG_GROUPSITEM_

7、CATALOG_GROUP_IDINVENTORY_ITEM_IDORGANIZATION_IDMTL_DESCRIPTIVE_ELEMENTSITEM_CATALOG_GROUP_IDELEMENT_NAMEMTL_ITEM_CATAGORIESCATEGORY_SET_IDINVENTORY_ITEM_IDORGANIZATION_IDCATEGORY_IDMTL_SYSTEM_ITEMSINVENTORY_ITEM_ID,ORGANIZATION_IDMTL_D