ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 772413F8A75C441B81F6BE9551368A81Y select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, haouv.name operating_unit, okhab.contract_number, osv.meaning contract_status, xxen_util.meaning(okh.deal_type,'OKL_BOOK_CLASS',0) deal_type, okhab.currency_code, okhab.start_date contract_start_date, okhab.end_date contract_end_date, hca.account_number bill_to_customer_account, hp.party_name bill_to_customer_name, hcsua.location bill_to_site, hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.postal_code,' '||hl.postal_code,null) bill_to_address, to_char(okhab.id) chr_id, null upload_row from okc_k_headers_all_b okhab, okl_k_headers okh, hr_all_organization_units_vl haouv, okc_statuses_v osv, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl where 1=1 and okhab.scs_code='LEASE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okh.id and okhab.authoring_org_id=haouv.organization_id and okhab.sts_code=osv.code and okhab.cust_acct_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and okhab.bill_to_site_use_id=hcsua.site_use_id(+) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and hcasa.party_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) Initial version. Lease contract bill to customer account and site update via okl_contract_pub. U A xxen_okl_upload.update_lease_contract US OKL Lease Contract Update Upload Changes the bill to customer account and bill to site of Lease Management contracts through the Oracle public API okl_contract_pub.update_contract_header - the Bill To of the Lease Contract header. One row per contract. Enter the Bill To Customer Account, the Bill To Site, or both; everything else on the row is context and is read only. A site that does not belong to the Bill To Customer Account on the row is rejected, so change both together when the account changes too. A bill to change does not require a rebook: it was verified against Booked, Evergreen, Passed and Incomplete contracts. Rebook remains necessary for the financial terms this upload does not touch. Run it under a Lease Management responsibility. Under an unrelated responsibility Oracle refuses the update with its own privilege message. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name US Operating Unit 3 30 1=1 okhab.contract_number=:contract_number LOV custom Y Y select okhab.contract_number value, okht.short_description description from okc_k_headers_all_b okhab, okc_k_headers_tl okht where okhab.scs_code='LEASE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okht.id and okht.language=userenv('lang') order by okhab.contract_number US Contract Number 4 40 1=1 okhab.sts_code=:contract_status LOV custom Y select osv.code id, osv.meaning value, null description from okc_statuses_v osv order by osv.meaning US Contract Status 5 50 1=1 okh.deal_type=:deal_type LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='OKL_BOOK_CLASS' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning US Deal Type 6 60 1=1 okhab.cust_acct_id=:bill_to_customer_account LOV custom Y Y select hca.cust_account_id id, hca.account_number value, hp.party_name description from hz_cust_accounts hca, hz_parties hp where hca.status='A' and hca.party_id=hp.party_id and hca.cust_account_id in ( select hcasa.cust_account_id from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa where hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.Operating_Unit) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.status='A' ) order by hca.account_number US Bill To Customer Account 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT Char varchar2 select haouv.name from okc_k_headers_all_b okhab, hr_all_organization_units_vl haouv where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' and okhab.authoring_org_id=haouv.organization_id Y 6 CONTRACT_NUMBER LOV custom varchar2 Y Y select okhab.contract_number value, okht.short_description description from okc_k_headers_all_b okhab, okc_k_headers_tl okht where okhab.scs_code='LEASE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okht.id and okht.language=userenv('lang') order by okhab.contract_number Y Y 7 CONTRACT_STATUS Char varchar2 select osv.meaning from okc_k_headers_all_b okhab, okc_statuses_v osv where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' and okhab.sts_code=osv.code Y 8 DEAL_TYPE Char varchar2 select xxen_util.meaning(okh.deal_type,'OKL_BOOK_CLASS',0) from okc_k_headers_all_b okhab, okl_k_headers okh where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' and okhab.id=okh.id Y 9 CURRENCY_CODE Char varchar2 select okhab.currency_code from okc_k_headers_all_b okhab where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' Y 10 CONTRACT_START_DATE Date date select okhab.start_date from okc_k_headers_all_b okhab where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' Y 11 CONTRACT_END_DATE Date date select okhab.end_date from okc_k_headers_all_b okhab where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' Y 12 BILL_TO_CUSTOMER_ACCOUNT LOV custom varchar2 Y Y select hca.cust_account_id id, hca.account_number value, hp.party_name description from hz_cust_accounts hca, hz_parties hp where hca.status='A' and hca.party_id=hp.party_id and hca.cust_account_id in ( select hcasa.cust_account_id from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa where hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.status='A' ) order by hca.account_number select hca.account_number from okc_k_headers_all_b okhab, hz_cust_accounts hca where okhab.contract_number=:$column$.contract_number and okhab.scs_code='LEASE' and okhab.cust_acct_id=hca.cust_account_id and :$column$.chr_id is null The customer account the contract is billed to. It defaults from the contract, so a row pasted with only the contract number can still pick a site. Leave it as it is to change only the site. 13 BILL_TO_CUSTOMER_NAME Char varchar2 select hp.party_name from hz_cust_accounts hca, hz_parties hp where hca.account_number=:$column$.bill_to_customer_account and hca.party_id=hp.party_id Defaults from the Bill To Customer Account. Y 14 BILL_TO_SITE LOV custom varchar2 Y select hcsua.site_use_id id, hcsua.location value, hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.postal_code,' '||hl.postal_code,null) description from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl where hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.status='A' and hcasa.cust_account_id=(select hca.cust_account_id from hz_cust_accounts hca where hca.account_number=:$column$.bill_to_customer_account) and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id order by hcsua.location A bill to site of the Bill To Customer Account. Enter the account first: the list shows that account's active bill to sites in the operating unit. 15 BILL_TO_ADDRESS Char varchar2 select hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.postal_code,' '||hl.postal_code,null) from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl where hcsua.location=:$column$.bill_to_site and hcsua.site_use_code='BILL_TO' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.cust_account_id=(select hca.cust_account_id from hz_cust_accounts hca where hca.account_number=:$column$.bill_to_customer_account) and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id Defaults from the Bill To Site. Y 16 CHR_ID Char varchar2 Y 17 UPLOAD_ROW Char varchar2 Y U 10 p_contract_number in Char CONTRACT_NUMBER U 20 p_bill_to_customer_account in Number BILL_TO_CUSTOMER_ACCOUNT U 30 p_bill_to_site in Number BILL_TO_SITE U 40 p_chr_id in Char CHR_ID U 50 status_ out Char STATUS_CODE_ U 60 message_ out Char MESSAGE_ Error SQL Order By upload_row, contract_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(haouv.name,xu.operating_unit) operating_unit, xu.contract_number, nvl(osv.meaning,xu.contract_status) contract_status, nvl(xxen_util.meaning(okh.deal_type,'OKL_BOOK_CLASS',0),xu.deal_type) deal_type, nvl(okhab.currency_code,xu.currency_code) currency_code, nvl(okhab.start_date,xu.contract_start_date) contract_start_date, nvl(okhab.end_date,xu.contract_end_date) contract_end_date, nvl(hca.account_number,xu.bill_to_customer_account) bill_to_customer_account, nvl(hp.party_name,xu.bill_to_customer_name) bill_to_customer_name, nvl(hcsua.location,xu.bill_to_site) bill_to_site, nvl(hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.postal_code,' '||hl.postal_code,null),xu.bill_to_address) bill_to_address, xu.chr_id, xu.upload_row from xxen_okl_lease_contract_5123_u xu, okc_k_headers_all_b okhab, okl_k_headers okh, hr_all_organization_units_vl haouv, okc_statuses_v osv, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl where xu.status_code_=xxen_upload.status_success and xu.contract_number=okhab.contract_number(+) and nvl(okhab.scs_code,'LEASE')='LEASE' and okhab.id=okh.id(+) and okhab.authoring_org_id=haouv.organization_id(+) and okhab.sts_code=osv.code(+) and okhab.cust_acct_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and okhab.bill_to_site_use_id=hcsua.site_use_id(+) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and hcasa.party_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+)