Press a button in Forms Personalisation

Mimic/automate the press of a push button in the PO Summary form

Create a when-new-form-instance personalization and create following actions

1)

Type: Builtin

Builtin Type: DO_KEY

Argument: ENTER_QUERY

Create a WHEN NEW ITEM INSTANCE personalisation and create the following actions

1)

Type: Builtin

Builtin Type: GO_ITEM

Argument: PO_HEADERS.SEGMENT1

2)

Type: Property

Object Type: Item

Target Object: PO_HEADERS.SEGMENT1

Property Name: VALUE

Value :==:'PO_HEADER_ID'

3)

Type: Builtin

Builtin Type: DO_KEY

Argument: EXECUTE_QUERY

Here in the below mentioned step

Type: Property

Object Type: Item

Target Object: PO_HEADERS.SEGMENT1

Property Name: VALUE

Value =:253253

If I hard code the value 253253(which is the header_id for PO_NUMBER 10031791) in the field 'value' then the PO_NUMBER form works as expected(PO Form opens up in queried mode and all the data of the PO_NUMBER is pre-populated)

Refer: https://community.oracle.com/thread/2518602?start=0&tstart=0

EBS: ORACLE FINANCIALS FOR INDIA(OFI) – INDIA LOCALIZATION GST UPDATE

The EBS India GST Information Center is now available on My Oracle Support. This information center is the central source for EBS information on India GST including:

Documentation:

• Functional scope summary
• Order to Cash Setup
• Order to Cash User Guide
• Purchase to Pay Setup
• Purchase to Pay User Guide
• Early access — information on early access to phased software updates information on requirements, limitations and how to register to request access.

Troubleshooting guides and FAQs:  These will accumulate with time based on customer and partner interaction.

The EBS India GST Legislative Update document has also been updated to let customers and partners know the info center is now available.

You may please register your request for early access through  EBS India GST Information Center.

INDIA – GOODS AND SERVICES TAX(GST) OVERVIEW

Goods and Services Tax(GST) is a destination based tax applicable for supply of goods and services or both administered concurrently by the Center and State Governments through out the value chain except:

• Exempted goods and Services => Very few items with common list for CGST and SGST.

Find below the quick snapshot of the proposed GST Structure:

Following 3 new tax types got proposed in GST:

CGST (Central Goods and Services Tax)

SGST (State Goods and Services Tax)

IGST (Integrated Goods and Services Tax)

GST Rates are based on Revenue Neutral Rates. Following are the proposed rate types and the rates are not yet finalized as on the blog posted date:

1. Merit rate => For essential goods and services.

2. Standard rate => For goods and services in general.

3. Special rate => For precious metals and for specified goods and services.

4. Zero rate => For exports, supply to EOU/SEZ etc.

Goods and Services outside the purview of GST:

• Alcohol for Human consumption =>  will continue with State Excise and VAT
• Electricity => will continue with Electricity Duty
• Petroleum Products => will continue with the current tax structure, likely to be brought under GST regime later
• Tobacco products expected to be taxed under the GST regime along with Excise dutyGoods and Service Tax

GST is considered the largest indirect tax reform in India and will replace multiple indirect taxes that are administered by the Central and State Governments.

The Goods and Services Tax Network (GSTN), has been tasked by the Government of India with building and maintaining the centralized, national level government IT infrastructure required for GST.

In reference to the Government of India’s roll out of the Goods and Services Tax (GST) planned for April 2017, the Oracle E-Business Suite (EBS) team has already put a plan in place and the details of the same shall be shared shortly in the next post.

SMART VIEW SUPPORT MATRIX AND COMPATIBILITY

1. What is the current version of Smart View?

Current version of Smart View is 11.1.2.5.510, released in October 2015.

2. In the release compatibility tab of the support matrix, what does Smart View 11.1.2.5+ mean?

It means Smart View 11.1.2.5.000 and higher.  Any release of Smart View 11.1.2.5.000 or higher is supported with the data source provider mentioned in the release compatibility matrix.  The latest release on the code line is recommended for customers.

3. Does the latest version of Smart View support 11.1.1.x releases of EPM suite (Planning, HFM, etc.)?

Smart View releases beginning with 11.1.2.5.000 support EPM 11.1.1.4.x.  Earlier versions of EPM are not supported.  Customers need to upgrade to a higher version of EPM suite, preferably 11.1.2.3.500, the latest.

4. Does Smart View support Internet Explorer 10?

Smart View 11.1.2.5.000 (and higher) supports IE10, as long as the underlying product or provider supports IE10.  For example, HFM 11.1.2.3.500 supports IE10 so Smart View supports IE10 in that context.  For older versions of HFM, IE10 support is not certified.

5. Does Smart View support Internet Explorer 11 against HFM?

IE11 is currently certified only with products in EPM System 11.1.2.4. In this release of EPM System you must use Smart View 11.1.2.5.400.

There is a limited support for IE11 with EPM 11.1.2.2.500 and 11.1.2.3.500.

6. Does Smart View Support Office 2013?

Yes.  Smart View Release 11.1.2.5.000 onwards supports Office 2013.

7. Does Smart View support Office 365?

Smart View is ONLY supported for Desktop versions of Excel, Word, PowerPoint and Outlook included in any Office 365 plan and which are locally installed on any supported Windows Operating System.

Office 365 is a subscription-based online office and software-plus-services suite which offers access to various services and software built around the Microsoft Office platform.  Other services include Lync web conferencing, Exchange online, Sharepoint, SkyDrive and Skype.  The licensing determines what component or service is included as part of a bundle.

Microsoft Office Web Apps are a part of most Office 365 plans. Office Web Apps allow users to open Word, Excel and PowerPoint documents, among others, using a web browser.  However Office 365 on the web is intended for reading (full fidelity) and limited editing.  Office Web Apps do not have extensibility (add-in) model and there are no plans for one. Smart View is NOT supported for Office Web Apps which are part of Office 365.

Office 365 was made available in 2011 when Microsoft Office 2010 was the latest Office Suite.  Smart View supports Microsoft Office 2010.  Microsoft Office 2013 is supported starting with Smart View Release 11.1.2.5.000.

8. Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support?

8. Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support?

	COMPATIBLE OBIEE SERVER RELEASE
SMART VIEW RELEASE	11.1.1.7.0	11.1.1.7.1 (NO PATCH)	11.1.1.7.10 (FA-REL8)	11.1.1.7.140527	11.1.1.7.150120	11.1.1.9.0
11.1.2.2.310	Yes	No	No	No	No	No
11.1.2.3.000	Yes	No	No	No	No	No
11.1.2.3.000 PSE_16909989	Yes	Yes	No	No	No	No
11.1.2.5.000	Yes	Yes	No	No	No	No
11.1.2.5.200	No	Yes	Yes	No	No	No
11.1.2.5.210	No	Yes	Yes	Yes	Yes	No
11.1.2.5.215	No	Yes	Yes	Yes	Yes	No
11.1.2.5.400	No	Yes	Yes	Yes	Yes	No
11.1.2.5.410	No	No	No	No	No	Yes
11.1.2.5.500	No	No	No	No	No	Yes
11.1.2.5.510	No	No	No	No	No	Yes

 9. Does Smart View Support Google Docs?

Smart View is a COM add-in for MS Office Suite of products and as such, cannot not have any integration, with Google docs.  Google Docs (includes Docs, Sheets, and Slides) is a free, web-based office suite offered by Google within its Google Drive service.

In order to provide functionality similar to Smart View a new application will have to be created possibly using Google Apps Script.  Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.

It is to be noted that Google docs does have limitations such as:

• Sheets – 200 sheets per workbook, with 400,000 cells in all
• Docs – 1,024,000 characters, regardless of the number of pages or font size
• Slides – Presentations created in Google Slides can be up to 50 MB – about 200 slides.

These are practical limitations for Smart View users who have a large number of cells in a typical workbook.  In some cases the number of sheets in a workbook does exceed 200 or documents can have more than 1,024,000 characters in a document, which is not allowed in Google Sheets and Google Docs respectively.

Once these limitations are addressed and if Google Apps Script (or newer technology) is able to provide the same rich functionality that COM add-ins such as Smart View provide, Oracle will re-visit this topic for consideration.

Mass Additions Create program Validation Steps with sequence

Integration between AP and Fixed assets through asset clearing account and mass additions create Program.

Mass Additions Create program running from AP followed steps in the 
sequence explained here: 

*1.**) *Picks up all AP invoice distribution lines and verifies the line 
has been attempted by earlier process or not. Conditions to pickup data 
from invoice distributions are: 

Condition Number 1 : ASSETS_ADDITION_FLAG should be "N" 
Condition Number 2 : ASSETS_TRACKING_FLAG should be "Y" 
Condition Number 3 : Invoice should be validated 

Distributions lines are filtered with above conditions 

*2.) * After above filteration, program verifies the NATURAL ACCOUNT in 
invoice distribution code combination is matching with account codes 
defined in FA BOOKS definition for Cost Clearing. If matching, the line 
will be transferred to FA 

*3.) *If not matching, program looks in to tagged 
RCV_TRANSACTION_ID(material receipt) & PO_DISTRIBUTION_ID. If available, 
verifies the NATURAL ACCOUNT in PO Distributions matching with account 
codes defined in FA BOOKS definition for Cost Clearing. If matching, 
transfer distribution line along with invoice information and PO 
distribution account code combination 

*4.) *Updates ASSETS_ADDITION_FLAG in invoice distributions as "U" if any 
of above conditions satisfied, update with "Y" if conditions matched and 
transferred to FA module 

Hope you may clear with this and helps you 

Oracle AP and Purchasing : Debit Memo

 I seen “Debit Memo” is one of the generic word which get confused many a time by developer and functional people as well. here trying to make it simpler.

What is a Debit Memo Invoice?

A: Negative amount invoice which is created and sent to a supplier to notify the Supplier of a credit you are recording.

When should a Debit Memo be created?

A: To correct over billing errors, we create a Debit Memo by doing a Return To Supplier transaction for the extra quantity that got invoiced.

How does Create Debit Memo from RTS Functionality Work?

A: Steps to Create a Debit Memo via RTS:
1. Create a PO with supplier and supplier site.
2. Receive the goods using Enter Receipts Form.
3. Create an Invoice. If Pay on Receipt is used to create then Invoice then set “Pay on” as Receipt and “Invoice Summary Level” as Receipt in Supplier sites window under purchasing tab.
4. Do a Return To Supplier (RTS) transaction for some of the goods using Returns form.
5. Make sure the check Box ‘Create Debit Memo’ is checked in the Return line while doing the RTS transaction.
6. This will automatically create a Debit Memo invoice in AP.

Depending on how the RCV: Processing Mode Profile option, Receiving Transaction Processor will be kicked off as soon as Receipt/Return transaction is saved.
If profile option RCV: Processing Mode = Batch, then user has to go and manually launch Receiving Transaction Processor concurrent request.
If profile option RCV: Processing Mode = Immediate, then Receiving Transaction Processor concurrent request will be launched and runs in the background. In this case control comes back to user and he can do his operations.
If profile option RCV: Processing Mode = Online, then Receiving Transaction Processor concurrent request will be launched. In this case control will not come back to user until processor completes processing.

 What setup is required to create a Debit Memo?

A: Navigate: Supply Base -> Suppliers -> Query on supplier -> Sites -> Query on site -> Purchasing tab -> Check the box for Create Debit Memo from RTS Transaction. Make sure the check Box ‘Create Debit Memo’ is checked in the Return line while doing the RTS Transaction.

Under what Conditions a Debit Memo can be created?

A: Automatic Debit Memo will be created only when billed quantity of Purchase Order is greater than or equal to Returned Quantity. Return To Supplier reduces the PO billed quantity by the returned quantity but in any case PO billed quantity will never go below zero.

SMART VIEW ERROR “CANNOT CONNECT TO THE PROVIDER. MAKE SURE IT IS RUNNING IN THE SPECIFIED HOST/PORT. ERROR(503) ” WHEN OPENING HYPERION PLANNING CONNECTION.

WHEN ATTEMPTING TO CONNECT FROM SMART VIEW TO HYPERION PLANNING THE FOLLOWING ERROR MESSAGE IS DISPLAYED:

Cannot connect to the provider. Make sure it is running in the specified host/port. Error(503)

This occurs due to The OHS server Timeout for APS is set too low. In configuration file mod_wl_ohs.conf the values for  “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” are too low and the connection to Smart View is timing out.

1. Shutdown the Essbase Server service or process.
2. Backup the mod_wl_ohs.conf configuration file. The file is found in the following location on your APS server:
   C:\Oracle\Middleware\user_projects\epmsystem\httpConfig\ohs\config\OHS\ohs_component
3. In mod_wl_ohs.conf increase the timeout in seconds for the “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” properties within the location section for APS:
   SetHandler weblogic-handler
   WeblogicCluster :13080
   WLIOTimeoutSecs 1800
   WLSocketTimeoutSecs 1800
4. Save the modified mod_wl_ohs.conf file.
5. Restart the Oracle HTTP Server and the WebLogic Managed server service or process for APS.

Accounts Payable Package Requirements Questionnaire

This template provides a starting point for determining customer requirements within a specific application area. Customize the template with project specific questions.

1. Vendors

1.1. How many vendors are there in total?

1.2. Is the same vendor listed in your files multiple times?

1.3. Do legal entities share vendors? If not, is there a reason why they can not?

1.4. Do you record multiple addresses for each vendor?

1.5. Do you keep track of vendor contacts?

1.6. What information do you record for vendors:

1.6.1. Basic information (name, address, number, payment terms, type)?

1.6.2. Other - what information do you record that might be considered out of the ordinary?

1.6.3. What vendor information gets defaulted to purchase orders (POs) and / or invoices?

1.7. Do you record tax types charged by vendors?

1.7.1. sales tax?

1.7.2. VAT (Value Added Tax)?

1.7.3. GST (Goods and Services Tax)?

1.7.4. other?

1.8. What other tax information do you record for vendors:

1.8.1. 1099 (U.S. tax information)?

1.8.2. tax exempt numbers?

1.8.3. other?

1.9. Do you categorize vendors into types or groups?

1.10. Do you manually assign a number to your vendors or are numbers defaulted by the system? If manual, what numbering scheme do you use?

1.11. Do you enter employees as vendors in order to pay employee expenses? If so, what information do you record:

1.11.1. department?

1.11.2. location?

1.11.3. other?

1.12. Do you assign the same accounting distributions on the majority of invoices for the same vendor?

2. Invoicing

2.1. Describe your invoice entry process.

2.1.1. Who enters invoices and how many are entered on average per day, week or month?

2.1.2. Are invoices received at a central location?

2.1.3. How are invoices approved? Are there levels of approval?

2.1.4. What is the cycle time for the process (i.e., enter, confirm, approve, pay)?

2.2. Do you enter invoices by batches? If yes, why (e.g., control total purposes)?

2.3. Do you use multiple currencies for invoice entry?

2.4. What type of invoices do you use? How many of each type do you enter per period?

2.4.1. regular,

2.4.2. recurring,

2.4.3. prepayments,

2.4.4. credit memos,

2.4.5. debit memos,

2.4.6. expense reports,

2.4.7. employee advances.

2.5. Matching requirements, which do you use:

2.5.1. two way matching (to PO price and quantity)?

2.5.2. three way matching (to PO and to receiving)?

2.5.3. four way matching (to PO, receiving and inspection)?

2.5.4. what tolerances are allowed for variance between invoice, purchase order, receipt and tax information during invoice matching?

2.6. What information do you record for invoices? Do you record any information that may be considered out of the ordinary (such as payment authorization numbers)?

2.7. Discuss default information provided on invoices based on vendor.

2.8. Do you enter financial coding from different legal entities (companies) to distribution lines on the same invoice? Do you require automatic generation of intercompany entries to the general ledger?

2.9. Are invoices billed to distinct companies or cost centers?

2.10. Describe the types of invoices that are placed on hold and the mechanism used to release holds.

2.11. What type of taxes do you record on invoices?

2.12. Describe the payment terms you use:

2.12.1. immediate?

2.12.2. 30 days?

2.12.3. 1/10 net 30?

2.12.4. proxima (terms which specify payment on a certain day of the month)?

2.12.5. other?

2.13. How do you check for duplicate invoice entry?

3. Bank/Cash Accounts

3.1. How many bank accounts do you have?

3.2. Do multiple companies share bank accounts?

3.3. How many general ledger cash accounts do you use per company?

3.4. Do you use more than one liability account on a single invoice?

4. Payment Process

4.1. How often do you run checks?

4.2. How many checks are generated in each run on average?

4.3. Do you pay all invoices due or do you prioritize payments - how?

4.4. How are payments scheduled?

4.5. How are invoices selected for payment?

4.6. Do you prioritize payments - how?

4.7. Do you make partial payments?

4.8. What payment methods do you use?

4.8.1. checks?

4.8.2. wire transfers?

4.8.3. electronic file transfers (EFTs)?

4.8.4. other?

4.9. Do you require manual check generation outside the normal check run cycle (for example, emergency payments)?

4.10. What type of printers are used to print checks - impact or laser?

4.10.1. If impact printers are used, have you considered using laser printers?

4.10.2. Does the check stock include MICR numbers? Signature?

4.11. How are checks sorted:

4.11.1. payment amount?

4.11.2. vendor number?

4.11.3. vendor name?

4.11.4. other?

4.12. Do you have low and high limits on check amounts?

4.13. When you void a payment, do you want to have the option to void or reinstate the invoice? What is your policy for check cancellation?

4.14. Do you always take discount? Is this done on a vendor by vendor basis?

5. Check Reconciliation

5.1. How is check reconciliation performed - do you receive a tape from the bank to facilitate automatic reconciliation?

5.2. Do you send a tape to the bank as part of the reconciliation process?

6. Posting / Closing

6.1. Describe your current closing schedule for accounts payable.

6.1.1. Is there anything special done at month end?

6.1.2. Do you need to enter invoices for more than one period at a time?

6.2. At what frequency do you post from the accounts payable subledger to the general ledger?

6.3. Do you post to the general ledger at the detail or summary level?

7. Inquiries

7.1. What types of on-line inquiries are required?

7.1.1. display all invoices related to a vendor name / number?

7.1.2. display all invoices related to a payment number?

7.1.3. display all invoices related to a purchase order?

7.1.4. other?

8. Reports

8.1. What standard reports do you use:

8.1.1. check register?

8.1.2. invoice register (new, open)?

8.1.3. outstanding check register?

8.1.4. void check register?

8.1.5. cash requirements?

8.1.6. vendor master?

8.1.7. aging reports?

8.1.8. other?

8.2. Are there any special reporting requirements?

9. Interfaces

9.1. What internal systems are interfaced with accounts payable:

9.1.1. purchasing?

9.1.2. payroll?

9.1.3. fixed assets?

9.1.4. general ledger?

9.1.5. human resources?

9.1.6. other?

9.2. Are there interfaces with any external systems?

9.2.1. EDI?

9.2.2. 1099 (U.S. tax information)?

9.2.3. banks (reconciliation)?

9.2.4. other?

10. Security

10.1. Describe duty separation requirements.

10.2. Are there any restrictions on invoice entry by company or cost center?

11. Other

11.1. Which accounting method do you use - cash or accrual basis accounting?

11.2. At what point do you identify a purchased item as a fixed asset - at requisitioning, purchasing, invoicing, receipt, payment or other?

11.3. List up to five best features of the current system.

11.4. List up to five deficiencies of the current system.

11.5. Are they any other special requirements that have not been discussed?

12. Volumes

12.1. How many vendor records are there in total?

12.2. How many unique vendors are there?

12.3. How many vendor records are added per period?

12.4. How often are vendor records purged and how many records are purged at a time? What is the purge criteria?

12.5. How many sites enter invoices?

12.6. How many invoices are entered per day, week, period?

12.7. How many expense reports are entered per week?

12.8. How often are checks generated?

12.9. How many checks are generated per day, week, period?