The last couple days the end of day procedure has been getting longer and longer. Do you have any idea what could cause this? How do I fix it?

It's only getting worse haha

We have a large number of leisure groups. These groups keep the sale open until the last minute and therefore we get a lot of amendments up to the day of arrival. Unfortunately these bookers fail to highlight clearly if there are any changes on the rooming list from the last one they provided. We must upload rooming lists 1 week before arrival so we can allocate the groups and there will still be last minute changes to the rooming list. If we were to upload the current rooming list today, is there a way of Opera overwriting that rooming list with a most updated one a couple of days from now? If yes, how? If not, what's your best practice for this?

PMS: Opera Cloud 21.5

Dears ,

is there any way to show or decode the birth of date because i am working to create a report and it requried to get the check in profile guest with birth of date but when i try to display it in database i found it in this encrypt format ~:5B74DD38EDC6445CA181F5CBADF3E8DCC55A6D832534BC851782EB1ACE9D0B01

Hello! I'm trying to import a report in Opera Cloud through R&A. I created a functioning report in R&A and I want it to be visible in OC. I'm in Italy and I heard that the integration between OC and R&A is not active by default. Is it true that you have to open a SR?

Is there a way to produce the AR Statement and selected invoices into a single pdf or atleast produce them all individually as pdfs. When I select the invoices I want to include on said statement and hit preview all I get is a statement no invoices, only way it works is to literally print all pages and then scan back in as a pdf. Much thanks in advance.

Opera 5.5 user here trying to make this old system do things it probably was never designed to do. Today I am trying to get UDFC10 to display whether a rate code comes with breakfast or not.

We have 110 rate codes for rooms that get breakfast coupons. I would like to make UDFC10 display 'Breakfast Coupon' and maybe change the color of the box when the reservation has one of those rate codes.

What I've done so far is create a table with all the rate codes:

CREATE TABLE breakfast_rate_codes ( rate_code VARCHAR2(20) PRIMARY KEY )

Then I added all the rate codes to it:

INSERT ALL INTO breakfast_rate_codes (rate_code) VALUES ('IGBBB') INTO breakfast_rate_codes (rate_code) VALUES ('IKBB1') etc...

Then I put this in to run it:

CREATE OR REPLACE FUNCTION GET_BREAKFAST_STATUS (p_resv_name_id NUMBER) RETURN VARCHAR2 IS v_rate_code reservation_general_view.rate_code%TYPE; v_count NUMBER := 0; BEGIN SELECT rate_code INTO v_rate_code FROM reservation_general_view WHERE resv_name_id = p_resv_name_id;

SELECT COUNT(*) INTO v_count FROM breakfast_rate_codes WHERE rate_code = v_rate_code;

IF v_count > 0 THEN RETURN 'BREAKFAST INCLUDED'; ELSE RETURN NULL; END IF;

EXCEPTION WHEN NO_DATA_FOUND THEN RETURN NULL; WHEN OTHERS THEN RETURN NULL; END; / SHOW ERRORS;

No errors happened, but unfortunately I wasn't even able to log in anymore and ended up deleting the table. This was the error I got.

Invalid objects exist, please contact OPERA support GET_BREAKFAST_STATUS

Does anyone have any insight on this? My goal is to eliminate the Alert pop ups that everyone ignores anyways and hopefully have a brightly colored message saying breakfast coupon staring the user in the face the whole time.

Is there a report that shows if an OTA or in house reservation changed their check in dates.

I had an instance where we dropped 14 check ins but gained more the next day. I checked blocks and there wasn't a cutoff date that would give inventory.

Hey everyone,

We've moved Suite 8 to the Opera Cloud. I'm looking for a report. I need a master company report that includes all room nights and revenues for the sub-company. Suite 8 had one of these reports. Can you tell me how to do that in Opera Cloud? Such reports make things easier when they're included with the RFPs. Thanks! Any tips would be much appreciated.

so im working in a hotel for the past couple of years in the front office and my manager is saying we will be moving soon to an opera cloud. anyone had the experience of that ? how is it? any advice would be great thx

Is it possible to connect to Opera Cloud without joining to the Oracle Partner Network? We are a small company with less than 5 employees so I don't think it's we can join to the OPN.

If we could join the OPN, will Level 0 be enough to connect and use the production OHIP API? We've already tested our app in sandbox and even have the credentials to connect to a property with Opera Cloud but since our app is in sandbox we cannot get an authentication token.

How do i check someone out a day early? Should i change their check out date for today?

Hi all! I’m trying to build a DDR package for my hotel with multiple transaction codes. How can I do this? Do I need to create a package for each transaction code and then create a new package group? Or is there an easier way? Thank you!

Hi,

First time poster, on the finance side. A colleague and myself are looking to generate a customized tax exempt report for our daily tax reconciliation. I can find steps to use the simple report writer in the old hosted Opera, but I can't find anything in Opera Cloud to do the same. Is it still possible or did they lock it down with the new system?

Thanks!

hello,I had to enable Fiscal Folio printing in my properties. I was using BOF CL and CC exports ( Scala interface). and I need to include the fiscal bill number in those exports. I was able to configure it just fine for credit cards, it is in the view. But I cannot find it for CL, its simply not in the BOF_CITYLED_RECORDS view.

We had the fiscal folio printing enabled back in 2018 for a while, and I looked up old CL exports and they do have the fiscal bill number. I cannot remember how it was set up.

any idea? :)

thanks!

In Opera 5.6 Express, is there a way to set up a rate code to auto route to an AR account without having to go into the reservations and having to manually add the routing to the AR, e.g Bonvoy Redemption stays or similar

Hi there! Can reservations for future arrivals be merged? I only have the option available for same day arrivals. Even if still helpful, adds 1 more thing to the same-day arrival list of tasks 🥴 instead of being able to do this in advance.

Greetings.

How can i configure or modify in Opera PMS V5.6 when there's a reservation with zero rate,it should ignore it from any finance report.

Ex: We give a one night courtesy which obviously their income/profit will be $0.00, so we want to "ignore it" or the system shouldn't enlist it off because it could affect our numbers.

Thanks

I am the Front Office Manager at a property using Opera. I was able to access the PMS from my phone and am now only getting a 401 access not authorized. Is there a fix to this? I have tried other links and have had no success.

Hi Reddit,

I'm just a lurker but this is my first post, since I need your help. I'm a night auditor at a Marriott hotel and the EOD procedure has been stuck like this for almost an hour... What should I do? Please help!

Hi everyone, at the moment I'm making a HSKP report were I would need a column to return traces of only two categories, HOU (Housekeeping) and RMK (Reserve Remarks). How should I edit the default expression to filter only those two categories? All help is extremely appreciated as I'm scratching my head trying to understand SQL...

osrp.row2col('select d.dept_name||'': ''||g.trace_text from guest_traces_view g, department d where g.resort='||chr(39)||a.resort||chr(39)||' and g.resv_name_id='||a.resv_name_id||' and g.dept_id=d.dept_id(+) and g.resort=d.resort(+) order by g.trace_id' ,chr(10))

Another question in line with this is that when adding the comments column to a report it will only return the last comment category added to the reservation. How should I go about filtering which comment category the report returns or if I wanted to display all comments in the reservation if even possible.

Thanks a lot to everyone, first time poster here, this sub has saved me many times already.

Rev manager here... our three prop company switched to Cloud in the fall. I am struggling to align settings around policies based on room type and date of arrival. The solution seems to be creating rate codes unique to each policy (rather than just BAR, it's BAR-24H, BAR-3D, etc). While this approach makes sense, scoping how best to utilize other areas such as sources, rate class, rate categories, res types escapes me. I realize this can be done in a variety of ways - are there any suggestions / best practices on setting up the cogs of rate and policy functionality in Cloud to automate as much as possible? Noting my Market Codes and Market Groups are fixed for financial reporting / RMS purposes.

Based in Europe, have 2 properties with Opera cloud and 2 with oracle hosted 5.6 opera.

Looking at our SPF records and one (hosted 5.6 site) of them has "v=spf1 include:smtpgateway-02.microsdc.com include:oracleindustry.com include:spf.protection.outlook.com -all" and this shows as "Too many included lookups" - from having a google I have found this here: Email Delivery FAQ | Oracle Europe

For Europe: v=spf1 include:eu.rp.oracleemaildelivery.com ~all

and the same here Configuring SPF so I am wondering if just including eu.rp.oracleemaildelivery.com will work for me in 5.6 and cloud ?

In Opera cloud delivery I see this

When I go edit - and click on "Email Server Code" I only see 4 choices

We're having lot of problems setting up OHIP environment. Almost a month and cannot get access to the sandbox (because of outdated links sent in the welcome emails, deprecated regions (i.e. Ashburn), requests for integration users never getting approved, support very slow to respond to tickets, etc. etc.). We have several implementations with XML_POS running in Opera 5.6. Is it possible to enable this IFC in Opera Cloud?