My Portfolio

OPEN PROJECTS SELECT PROJECT_TYPE,SEGMENT1, NAME,PROJECT_STATUS_CODE,START_DATE,COMPLETION_DATE,BASELINE_FUNDING_FLAG,CARRYING_OUT_ORGANIZATION_ID,PROJECT_LEVEL_FUNDING_FLAG   FROM PA_PROJECTS_ALL WHERE ORG_ID = '1062' AND TEMPLATE_FLAG = 'N' EVENTS SELECT A.SEGMENT1,B.COMPLETION_DATE,B.EVENT_TYPE,B.DESCRIPTION,B.BILL_AMOUNT,B.BILL_HOLD_FLAG,B.BILL_TRANS_REV_AMOUNT,   B.PROJECT_CURRENCY_CODE,A.ORG_ID,C.NAME   FROM PA_EVENTS B,PA_PROJECTS_ALL A,HR_ORGANIZATION_UNITS C   WHERE A.PROJECT_ID = B.PROJECT_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND ORG_ID = '1062' REVENUE EVENTS SELECT A.SEGMENT1,B.COMPLETION_DATE,B.EVENT_TYPE,B.DESCRIPTION,B.BILL_TRANS_REV_AMOUNT,   B.PROJECT_CURRENCY_CODE,A.ORG_ID,C.NAME   FROM PA_EVENTS B,PA_PROJECTS_ALL A,HR_ORGANIZATION_UNITS C   WHERE A.PROJECT_ID = B.PROJECT_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND ORG_ID = '1062' AND EVENT_TYPE LIKE 'REVENUE%'   BILLING EVENTS   SELECT A.SEGMENT1,B.COMPLETION_D...

Troubleshooting Fund Check/Budgetary Control Guide -Part 1 Troubleshooting Details A)  Common Setup Profile Options PA: Enable Budgetary Controls PA: Allow Override of Budget Accounts PA: Days to Maintain BC Packets PSA: Budgetary Control Report Template (R12) i)Bottom-Up Budgeting Setup/Processing Steps Perform the following tasks to implement Bottom-Up Budgeting: 1. Define the Project Budget Account Workflow process 2. Define the Allow Override of Budget Accounts profile option 3. Define the Enable Budgetary Controls profile option 4. Define the GL budget 5. Define Integration for the Project Type/Project 6. Define the Project Budget 7. Generate accounting information for each budget line 8. Optionally, override the generated account for specific budget lines 9. Baseline the Project Budget 10. Run the Program: Create Journals process 11. Post the GL journal batches ii)Bottom-Up Budgeting Integration Definition Field Descriptions: Allow Override at Project Level - Default or Dicta...

Item Cross References in Oracle Apps R12     This post talks about the Front end navigations related to Item Cross References. How to create a cross reference type? Which form is used to assign the Item cross reference type and Items? How to define cross reference name for an item? Is there a standard report to show the list of cross references? 1.       How to create a cross reference type? Cross Reference  : This form can be used to capture the reference information pertaining to an item, like drawing number, vendor part number, etc. This is available at  Inventory >> Items >> Cross References                        In this form, user can define the list of cross references applicable for the Items. This list will be available at the Item master.              ...

Oracle Apps Credit Card: Process in iExpense and Payables Tables ap_credit_card_trxns_all ap_card_programs_all ap_cards_all AP_EXPENSE_FEED_LINES AP_EXPENSE_FEED_DISTS Credit Card setups: 1. Credit Card Code Sets window: create credit card code sets. 2. Credit Card Programs window: define your credit card program, including the card issuer, card type, and credit card code set. 3. Credit Card GL Sets window: define GL account sets 4. Credit Card Profiles window: define credit card profiles that you assign to credit cards. Attributes of a credit card profile include credit card program, GL account set, default GL account, exception clearing account, employee verification options, and manager approval options. 5. Credit Cards window: assign a card to a card holder and assign a credit card profile to the card Steps to process credit card transactions: Procure to Pay process: You can streamline your procure-to-pay process by implementing a procurement card program in which your employees pu...

Credit Card Setup How to setup Credit Cards Process in Oracle, below note id's will give detailed explanation Credit Card Payments, Refunds and Chargebacks: Overview and Setup for Oracle Receivables Release 12 [ID 1357967.1] Oracle Payments Minimum/Dummy Setup For Credit Card/Purchase Card Funds Capture Processing [ID 553614.1]

P-CARD (Procurement Card) SETUP AND TRANSACTION FLOW STEPS P-CARD SETUP AND FLOW STEPS PREREQUISITE   : 1)I-Procurement setup should exist in the Instance                                      I-Procurement Set-Up Docs STEP 1: Create a SQL*Loader program that uses the flat file provided by the card issuer containing         the credit card transaction details you want to transfer into the  AP_EXPENSE_FEED_LINES_ALL table. STEP 2: Define the card issuer as a supplier.               Navigation: Oracle Payable Super User--> Suppliers--> Entry. STEP 3: Create Credit Card Code               Navigation: Oracle Payable Super User--> Setup--> Credit Cards--> Procurement Card-->   Code Sets . STEP 4: Define Credit Card Programs                ...