Posts

MATERIALS TO GET

Image
1z1-961  - Oracle Financials Cloud: Payables 2017 Implementation Essentials    $45.00    1z0-961  - Oracle Financials Cloud: Payables 2017 Implementation Essentials    $45.00    1z1-960  - Oracle Financials Cloud: General Ledger 2017 Implementation Essentials    $45.00    1z0-960  - Oracle Financials Cloud: General Ledger 2017 Implementation Essentials    $45.00    1z1-335  - Oracle Financials Cloud: Receivables 2016 Implementation Essentials    $45.00    1z0-335  - Oracle Financials Cloud: Receivables 2016 Implementation Essentials

How To Identify Where An Expense Report Is In the Process

How To Identify Where An Expense Report Is In the Process You wish to identify where in the Expenses Process an Expense Report is by looking at the EXPENSE_STATUS_CODE in the table ap_expense_report_headers_all The values for the column EXPENSE_STATUS_CODE in the table ap_expense_report_headers_all come from the Payables Lookup Code EXPENSE REPORT STATUS Code Lookup Code Meaning CANCELLED Cancelled EMPAPPR Pending Individual’s Approval ERROR Pending System Administrator Action HOLD_PENDING_RECEIPTS Hold Pending Receipts INPROGRESS In Progress INVOICED Ready for Payment MGRAPPR Pending Payables Approval MGRPAYAPPR Ready for Invoicing PAID Paid PARPAID Partially Paid PAYAPPR Payables Approved PENDMGR Pending Manager Approval PEND_HOLDS_CLEARANCE Pending Payment Verification REJECTED Rejected RESOLUTN Pending Your Resolution RETURNED Returned SAVED Saved SUBMITTED Submitted UNUSED

Oracle AP to FA – Mass Addition Create

Oracle AP to FA – Mass Addition Create Overview of the Mass Additions Create Process in Payables The Mass Additions Create process is used to transfer invoice distributions in Payables to Fixed Assets for tracking as an expensed asset, a CIP asset, or a capitalized asset. Costs are also sent directly to Fixed Assets from Oracle Projects using the PRC: Interface Assets to Oracle Assets.  Any invoice distribution line charged to a capital project must be transferred from Oracle Projects. The Mass Additions Create Program (APMACR) is submitted from an Accounts Payable (AP) responsibility. The purpose of the program is to interface the costs of purchased items that meet the criteria to become an asset. It also interfaces adjustments to the invoice cost and discounts taken when the invoice is paid for assets that have already been interfaced. There are three types of assets: capitalized construction-in-process (CIP) expensed Which type of asset an invoice distribution be

How to use in Oracle – Output files -Comma, Pipe, or Tab Delimited Output

How to use in Oracle – Output files -Comma, Pipe, or Tab Delimited Output To generate comma or pipe delimited output for tools such as Excel, Access, and so on while spooling from SQL*Plus, use settings from SQL*Plus such as: SET COLSEP , Or SET COLSEP | Example: set pages 0 feed off set colsep , select object_name, object_type, status, created from all_objects where owner='PUBLIC' and rownum < 10 /* 9 rows for Sample Output */ ; Output: ALL_ALL_TABLES ,SYNONYM ,VALID ,01-APR-2004 ALL_ARGUMENTS ,SYNONYM ,VALID ,01-APR-2004 ALL_ASSOCIATIONS ,SYNONYM ,VALID ,01-APR-2004 ALL_CATALOG ,SYNONYM ,VALID ,01-APR-2004 ALL_CLUSTERS ,SYNONYM ,VALID ,01-APR-2004 ALL_CLUSTER_HASH_EXPRESSIONS ,SYNONYM ,VALID ,01-APR-2004 ALL_COLL_TYPES ,SYNONYM ,VALID ,01-APR-2004 ALL_COL_COMMENTS ,SYNONYM ,VALID ,01-APR-2004 ALL_COL_PRIVS ,SYNONYM ,VALID ,01-APR-2004 For pipe delimited output: set colsep | select object_name, object_type, status, created from all_objects where owner=&

Oracle Technical : How to find Files Versions and Locations

Oracle Technical : How to find Files Versions and Locations 1) To find the patch set level of an application (module): 1. Get the application ID select application_id , application_name from fnd_application_tl where application_name like <application_name> for eg. if Application Name is ‘Oracle Quoting’ select * from fnd_application_tl where application_name like ‘%Oracle Quoting%’ 2. Get the Patch Set Level for the application (field: PATCH_LEVEL). Select * from fnd_product_installations where application_id = <application_id> For e.g. Application_id of Oracle Quoting is 880 Select * from fnd_product_installations where application_id = 880 2) Finding all installed applications The query to be used for obtaining this information is as follows: SELECT application_name, application_short_name, decode (status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘Not Installed’) status, a.application_id FROM fnd_application_all_view a, fnd_product_installations i WHERE

R12 Oracle Project Accounting: Few Basic Concepts

R12 Oracle Project Accounting: Few Basic Concepts Once we understand the basic terminologies of PA it would be easier to move ahead with the process. Project : A project is a primary unit of work that can be broken down into one or more tasks. Task : It is the small unit of work created under the project against which transaction can be created. Note: we cannot create transaction/expenditure items directly on the project, hence it is mandatory for each project to have at least one task.   Project Classes: Oracle PA has provided three pre defined project classes. Indirect projects –  Track overhead activities and costs of the organization.  Note: Does not generate revenue and invoicing process. Capital projects –  Track asset development activities and costs, and costs are capitalized as one or more assets. Contract projects –  Contract projects created with external customer to track cost, revenue, and billing.   Project Type : The project type controls how Orac