Skip to main content

Posts

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

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 outsid...

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...

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...

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 ...

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. Shutdown the Essbase Server service or process. 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 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 Save the modified  mod_wl_o...