CERTIFICATIONS

COMING SOON....!

Comments

Post a Comment

Popular posts from this blog

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 distri...
Read more

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 UNUS...
Read more

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=...
Read more