Archive


Category: OracleSaaS

  • Oracle Cloud ERP – Contract Purchase Agreement Import (FBDI

    Docs : https://docs.oracle.com/en/cloud/saas/procurement/21a/oefbp/purchasing.html#contractpurchaseagreementsimport-3210 Scheduled processImport Contract Purchase Agreements *** Import Contract Agreements Interface Tables PO_GA_ORG_ASSIGN_INTERFACE —> Interface Table For Org AssignmentsPO_HEADERS_INTERFACE –> is the interface table that holds header information for the PDOI program to create standard/blanket purchase orders/cpa and catalog quotations. Error Table PO_INTERFACE_ERRORS select * from PO_INTERFACE_ERRORS order by creation_date desc Base Table […]

  • Oracle Cloud – General Ledger Journal FBDI Interface, Error and Base Tables

    Entity UCM Import Process Interface Table Base Table/View Batches fin/generalLedger/import Import Journals GL_INTERFACE GL_JE_BATCHES   Headers fin/generalLedger/import Import Journals GL_INTERFACE GL_JE_HEADERS   Lines fin/generalLedger/import Import Journals GL_INTERFACE GL_JE_LINES   Error Codes       GL_JE_ERROR_CODES  

  • Oracle Cloud – Payable Invoice FBDI Interface , Error and Base Tables

    Entity UCM Import Process Interface Table Base Table/View Headers fin/payables/import Import Payables Invoices AP_INVOICES_INTERFACE   AP_INVOICES_ALL   Lines fin/payables/import Import Payables Invoices AP_INVOICE_LINES_INTERFACE   AP_INVOICE_LINES_ALL         *Interface table not there** AP_INVOICE_DISTRIBUTIONS_ALL   Error Table       AP_INTERFACE_REJECTIONS  

  • Oracle Cloud – Supplier FBDI Interface, Base Table, Error Table Details

    Entity UCM Import Process Interface Table Base Table/View Suppliers prc/supplier/import Import Suppliers POZ_SUPPLIERS_INT POZ_SUPPLIERS Supplier Addresses prc/supplier/import Import Supplier Addresses POZ_SUP_ADDRESSES_INT POZ_SUPPLIER_ADDRESS_V Supplier Site Import prc/supplier/import Import Supplier Sites POZ_SUPPLIER_SITES_INT POZ_SUPPLIER_SITES_ALL_M Supplier Site Assignments prc/supplier/import Import Supplier Site Assignments POZ_SITE_ASSIGNMENTS_INT poz_site_assignments_all_m Supplier Contacts prc/supplier/import Import Supplier Contacts POZ_SUP_CONTACTS_INT POZ_SUP_CONTACT_ADDRESSES_INT poz_supplier_contacts Error Table : POZ_SUPPLIER_INT_REJECTIONS

  • Oracle Cloud – Flexfields

    A flexfield is a set of placeholder fields associated with business objects and placed on the application pages to contain additional data. You can use flexfields to modify the business objects and meet enterprise data management requirements without changing the data model or performing any database programming. Flexfields help you to capture different data on the same […]

  • Oracle Cloud – ValueSet

    A value set is a group of valid values that you assign to a flexfield segment to control the values that are stored for business object attributes. A user enters a value for an attribute of a business object while using the application. The flexfield validates the value against the set of valid values that you configured as a value set […]

  • Oracle Cloud – Lookups

    Lookups are lists of values in applications. You define a list of values as a lookup type consisting of a set of lookup codes, each code’s translated meaning, and optionally a tag. End users see the list of translated meanings as the available values for an object. Lookups provide a means of validation and lists of values where […]

  • Oracle Cloud ERP – Messages

    Messages provide users with information about business or application errors or warnings. Typically, messages inform the users about the following: Missing or incorrect data Status of an application, page, or a business object Status of an ongoing process Result of a user action Besides notifying users about the problem, messages provide guidance to users on […]

  • Oracle Cloud ERP – Profile Options

    Profile options are a set of preferences that you use to centrally manage the user interface settings and application behavior. You can use the profile options to manage, for example: User preferences to specify language or currency. Configuration choices to change the user interface skin or appearance of fonts. Processing options to determine how much […]

  • OTBI Report – As a Data Model to BI For Bursting and ESS Job

    Req: BI Report based on the OTBI data model to use bursting for sending email Design OTBI Report – Get the Query from Advance Tab Design BI Data Model based on the above query Also add Bursting Query Design BI Report & Template based on the above BI Data Model Create ESS Job , based […]