desktop integrators – you mean i can load data straight from a...
TRANSCRIPT
![Page 1: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/1.jpg)
DesktopIntegrators–YouMeanICanLoadDataStraightFromaSpreadsheet?
LeeBriggsDirector,FinancialsPrac@ce
![Page 2: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/2.jpg)
Agenda• Introduc@ons• Applica@onDesktopIntegratorandWeb-ADI• R12–NewFunc@onality• Crea@ngaCustomIntegrator-Prepara@on• CreatetheIntegrator• DefinetheLayout• StartLoadingData• MorethantheBasics–ListsofValues• Q&A
![Page 3: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/3.jpg)
AboutLeeBriggsDirector,FinancePrac@cewithBizTech
• 10YearsofOracleApplica@onimplementa@onexperience• FinancialsandSupplyChainfrom11.5.3throughR12.1.3• CustomRepor@ngusingFSGs,OBIEE,andBIPublisher• Experiencewithclientsacrossallindustries,withafocus
onBusinessServices,ProfessionalServicesandBankingindustries
• ChairoftheADISIG• OracleCer@fiedSpecialistinGeneralLedgerandPayables
![Page 4: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/4.jpg)
AboutBizTech• LeadingMid-Atlan@cOraclePla@numPartnerandITServices
firmfocusedonOracleApplica@onsandTechnologysolu@ons– Over400successfulOracleimplementa@onsoverthepast15years
– BasedinKingofPrussia,PAwithofficesinNewJersey,NewYorkCityandWashingtonDC
• ServiceFortune500companies,organiza@onsandgovernmentagencies
• 100+Oraclecer@fiedandexperiencedconsultants
![Page 5: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/5.jpg)
OracleSo*wareProvider
OracleTechnologyandBusinessIntelligence-EndtoendserviceofferinginBIandEPM-FullystaffedteamofDataArchitectsandDBAs-SolidexperienceinRAC,HAandHSdesigns- UnderstandfullOracletechnologystack
Clients
Client-CentricPracKceAreasOracleApplicaKons-FullPorLolioofOracleApplicaKonsSoluKons- ImplementaKon,Upgrade,MigraKon- Since1990MPL6toR12Experience-Over400successfulimplementaKonstodate
ManagedServicesandITOutsource-RemoteorOnsiteservices-FullporLolioofOracleApplicaKonsandTechnologies-World-ClassDataCenterwith24x7Support-Instantcapacity,operaKonalfocusedbusinessmodel
OracleSo*wareProvider- FullPorLolioofOracleLicenseResell- HelpClientsOpKmizeLicensemodels- RapidAppBISo*warefortheagileenterprise-RapidAppAuditortomanagechangeandGRC
OracleApplicaKons
ManagedServicesITO
OracleTechnologyBI/EPM
![Page 6: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/6.jpg)
OracleApplica@onDesktopIntegrator(ADI)• IntegralpartofOracleFinancialApplica@ons• Ini@allyreleasedasastand-aloneapplica@oninstalledonaclientpc
• Spreadsheet-basedextensionofGeneralLedgerandAssets
• Enablesuserstocreatebudgets,recordfinancialtransac@onsandrunfinancialreportsinMicrosocExcel
![Page 7: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/7.jpg)
OracleApplica@onDesktopIntegrator(ADI)• Enablesusertorevisebudgets,createjournalentriesanddefinefinancialreportsfromanyloca@onwithoutbeingconnectedtotheserver
• RequiredtobeconnectedtotransferdatatoorfromOracleApplica@ons
![Page 8: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/8.jpg)
Applica@onDesktopIntegrator–FullFeatures
• Journals• Budge@ng• ReportDefini@on• ReportPublishing• FormafngReports• ReportDrilldown• CreateAssets• PhysicalInventory• Diagnos@cs
![Page 9: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/9.jpg)
WebADI• Fromrelease11.5.9,OraclebegantomigratetowardsWebADI
• UsesInternetcomputerarchitecturetolowerthecostofownershipbyhavingtheproductcentrallyinstalledandmaintained
• Noclientinstalla@onisrequired• Providessuperiorperformance
![Page 10: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/10.jpg)
WebADI• Ini@allyajournals-onlysolu@on
• Addi@onalfunc@onalitygraduallyreleased
![Page 11: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/11.jpg)
R12–ClientADIisDe-Supported• OracleSupportNote377640.1advisesthatClient/ServerADIisnotsupportedforR12
• AllFSGrepor@ngwithinOracleApplica@onsisbeingmovedtoBIPublisherandReportManager
• 11.5.10Documenta@onforGeneralLedgernolongerreferstoClientADI,butinsteaddirectsuserstousepreconfiguredWeb-ADIsolu@onsforJournalUploads,BudgetUploads.
![Page 12: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/12.jpg)
R12–NewFunc@onality• WebADIisrepackagedas“DesktopIntegrator”
• Aswellaspre-packagedintegrators,providesfunc@onalitytonowbuildcustomintegratorstoloaddatatoANYinterfacetableorAPI
![Page 13: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/13.jpg)
Crea@ngaCustomIntegrator:Prepara@on• “BNE%”ProfileOp@onsProfileName Value
BNEServerLogLevel Trace
BNEServerLogPath $BNE_TOP/log
BNEServletPath /oa_servlets/
BNEUIXBasePath /OA_HTML/cabo
BNEUIXPhysicalDirectory $COMMON_TOP/webapps/oacore/html/cabo/
BNEUploadImportDirectory $BNE_TOP/upload/import
BNEUploadStagingDirectory $BNE_TOP/upload
BNEUploadTextDirectory $BNE_TOP/upload
![Page 14: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/14.jpg)
Crea@ngaCustomIntegrator:Prepara@on• Replace$BNE_TOPand$COMMON_TOPwiththeactualvalues
• WithDBAassistance,checkthefollowingdirectoriesexistwith777permissions– $BNE_TOP/log– $COMMON_TOP/webapps/oacore/html/cabo– $BNE_TOP/upload/import– $BNE_TOP/upload
![Page 15: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/15.jpg)
Crea@ngaCustomIntegrator:Prepara@on• Mostimportantprepara@on@p– Oncetheseprofileop@onshavebeenupdated,bouncetheENTIREinstance
• Assignyourusertworesponsibili@es– DesktopIntegra@onManager– DesktopIntegra@on
![Page 16: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/16.jpg)
Crea@ngaCustomIntegrator:Prepara@on• MicrosocExcelsetup– Youmust“TrustAccesstoVisualBasicProject”– YoumustallowMacrostorun
![Page 17: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/17.jpg)
Crea@ngaSimpleCustomIntegrator• Novalida@onofdataintheintegrator• Nolook-ups• Nocontent• Nocustomuploadparameters• UserentersALLdata
![Page 18: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/18.jpg)
Crea@ngaSimpleCustomIntegrator1. CreatetheIntegrator2. DefinetheIntegratorLayout3. StartLoadingData
![Page 19: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/19.jpg)
CreatetheIntegrator• Responsibility:DesktopIntegra@onManager• Naviga@on:CreateIntegrator
![Page 20: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/20.jpg)
EnterIntegratorInforma@on
![Page 21: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/21.jpg)
EnterIntegratorInforma@on
• IntegratorName– Thenameoftheintegratorastheuserwillseeit
• InternalName– Thenameoftheintegratorasthesystemseesit
• Applica@on– Thenameofthemodulethat“owns”theinterfacetable
![Page 22: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/22.jpg)
SecurityRules
• First“Gotcha”(Nomen@onofSecurityRulesinImplementa@onandAdministra@onManual)
• AddtwoSecurityFunc@ons– DesktopIntegra@on–CreateDocument(Code:BNE_ADI_CREATE_DOCUMENT)
– CreateDocument(Code:BNE_CREATE_DOCUMENT)
![Page 23: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/23.jpg)
CreatetheInterface
![Page 24: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/24.jpg)
CreatetheInterface
• InterfaceName– Whatyouwillrefertotheinterfacenameas
• InterfaceType– SelectfromTable,APIProcedure,APIFunc@on
• TableName– SelecttheTableNameyouwillbepopula@ngdata
• GOTCHA#2…ClickonAPPLY!
![Page 25: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/25.jpg)
CreatetheInterface
![Page 26: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/26.jpg)
CreatetheInterface• Onceyou’veclickedon“Apply”,everycolumnfromthetablewillbedisplayedhere
• BestPracKce–Useformspersonaliza@ontoincreasenumberofrowsreturned(25perpagebydefault!)
• BestPracKce–Iden@fytheRequiredFields,andthefieldsyouwant.
• BestPracKce–Seteveryotherfieldlistedtonotdisplay
![Page 27: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/27.jpg)
CreateContent
![Page 28: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/28.jpg)
CreateUploaderList
![Page 29: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/29.jpg)
CreateUploaderList
• UploaderList(newinR12.1.3)allowsyoutospecifywhatop@onsareavailabletotheuseruponupload– Whatrowstoupload(all,flagged,etc)– Howtherowsarevalidated– Whethertoinvokeanimportprocessautoma@cally
![Page 30: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/30.jpg)
DefineImporterList
![Page 31: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/31.jpg)
DefineImporterList
• ImporterListallowsyoutospecifyhowtomoveuploadeddatafrominterfacetablestobasetables
• Allowsyoutoapplyvalida@onrulestoapplybeforeimporttobasetables
![Page 32: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/32.jpg)
DefinetheLayout• Responsibility:DesktopIntegra@onManager• Naviga@on:DefineLayout
![Page 33: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/33.jpg)
DefinetheLayout
![Page 34: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/34.jpg)
DefinetheLayout• SelecttheIntegratorforwhichyouaredefiningthelayout
• Over225seededintegratorswillalsoshowinthislist
![Page 35: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/35.jpg)
CreatetheLayout
![Page 36: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/36.jpg)
CreatetheLayout• LayoutName– Youcanhavemul@pleDesktopLayoutsforthesameintegrator
• NumberofHeaderRecords– Dependentonwhatyou’retryingtoaccomplishwiththedatayou’reloading
![Page 37: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/37.jpg)
CreatetheLayout
![Page 38: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/38.jpg)
CreatetheLayout• Here,youcancontrolwherefieldsappear(Headerorlines)
• Example– APInvoiceHeadersimport
• Opera@ngUnitcouldbethesameforallinvoiceheaders• InvoiceCurrencycouldbethesameforallinvoiceheaders• Vendorwouldbedifferentforeachinvoiceheader
![Page 39: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/39.jpg)
CreatetheLayout• Youcanalsodefaultinforma@oninhere,whetherit’sconstant,derivedbySQL,onanenvironmentvariable– DefaultInvoicecurrencyto“USD”– Default“User”informa@on
• CreatedBy:FND_GLOBAL.USER_ID• LastUpdatedBy:FND_GLOBAL_ID• LastUpdateLogin:FND_GLOBAL.LOGIN_ID• Crea@onDate:SYSDATE• LastUpdateDate:SYSDATE
![Page 40: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/40.jpg)
CreatetheLayout• GOTCHA#3• Updatestothelayoutandintegratorswillnotalwaysshowuponceyou’vesavedanre-queriedthelayout
• DBA’swillneedtoclearJavacacheontheinstanceacerEVERYchange,orassignyourself“Func@onalAdministrator”responsibility,andcleartheCacheyourself!!
![Page 41: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/41.jpg)
StartLoadingData!• Responsibility:DesktopIntegra@on• Naviga@on:CreateDocument
![Page 42: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/42.jpg)
StartLoadingData-SelecttheIntegrator
![Page 43: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/43.jpg)
StartLoadingData-SelecttheViewer
![Page 44: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/44.jpg)
StartLoadingData-SelecttheViewer
• Viewersincludevariousversionsof:– MicrosocExcel– MicrosocProject– MicrosocWord– MobileSalesDeploymentforWindows
![Page 45: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/45.jpg)
StartLoadingData-SelecttheLayout
![Page 46: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/46.jpg)
StartLoadingData–ReviewyourCriteria
![Page 47: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/47.jpg)
StartLoadingData
![Page 48: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/48.jpg)
MorethantheBasics–ListofValues• Component– Componentsallowyoutoreturnlistofvaluesforafield• Example–LetmepresentalistofallmyAPInvoiceTypessoIcanpickfromthem,ratherthanhavingtotypetheInvoiceType(andgetitexactlyright)
![Page 49: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/49.jpg)
MorethantheBasics–ListofValues• Responsibility–DesktopIntegra@onManager• Naviga@on–ManageComponents
![Page 50: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/50.jpg)
MorethantheBasics–ListofValues
![Page 51: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/51.jpg)
MorethantheBasics–ListofValuesParameterName ParameterValue
Table-column-alias INVOICE_TYPE_LOOKUP_CODE
Table-column-sort ASCENDING
Table-columns LOOKUP_CODE,MEANING,DESCRIPTION
Table-headers LookupCode,Meaning,Descrip@on
Table-select-column INVOICE_TYPE_LOOKUP_CODE
Window-cap@on LookupCode,Meaning,Descrip@on
Window-height 500
Window-width 400
![Page 52: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/52.jpg)
MorethantheBasics–ListofValues• Naviga@on–ManageIntegrators– SelecttheIntegrator– SelecttheInterfacePage– UpdatetheaxributeforListofValues
![Page 53: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/53.jpg)
MorethantheBasics–ListofValues
![Page 54: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/54.jpg)
MorethantheBasics–ListofValuesLabel Value
Valida@onType Table
IDColumn LOOKUP_CODE
MeaningColumn LOOKUP_CODE
DescColumn DESCRIPTION
Valida@onEn@ty FND_LOOKUP_VALUES_VL
WhereClause (Nvl('',Territory_Code)=Territory_CodeOrTerritory_CodeIsNull)AndLookup_Type='INVOICETYPE'And(Lookup_Type='INVOICETYPE')And(View_Applica@on_Id=200)And(Security_Group_Id=0)AndEnabled_Flag='Y'
ComponentName XXPCAPInvoiceType
LOVType Standard
![Page 55: Desktop Integrators – You Mean I Can Load Data Straight From a Spreadsheet?adisig.communities.oaug.org/multisites/adisig/media/Documents/... · Desktop Integrators – You Mean](https://reader031.vdocuments.us/reader031/viewer/2022030509/5ab88e9e7f8b9ab62f8cc219/html5/thumbnails/55.jpg)
MorethantheBasics–ListofValues